|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/cae6aa2e/15328683/ |
?#pragma checksum "D:\wwwroot\anlian2025\wwwroot\App_Code\Skin.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "23A490EDEFE5C4F655CE493560066F977EAC094C"
#line 1 "D:\wwwroot\anlian2025\wwwroot\App_Code\Skin.cs"
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace WebApp.Components
{
/// <summary>
/// 网站风格设置
/// </summary>
public class Skin
{
/// <summary>
/// 获取所有风格
/// </summary>
/// <returns></returns>
public SqlDataReader GetSkin()
{
Database db = new Database();
SqlDataReader dr = null;
db.RunProc("Pr_GetSkin", out dr);
return (dr);
}
/// <summary>
/// 获取单条数据
/// </summary>
/// <param name="intID"></param>
/// <returns></returns>
public SqlDataReader GetSingleSkin(int intID)
{
Database db = new Database();
SqlDataReader dr = null;
SqlParameter[] param = { db.CreateInParam("@ID", SqlDbType.Int, 4, intID) };
db.RunProc("Pr_GetSingleSkin", param, out dr);
return (dr);
}
/// <summary>
/// 删除单条数据
/// </summary>
/// <param name="intID"></param>
public int DeleteSingleSkin(int intID)
{
Database db = new Database();
SqlParameter[] param = { db.CreateInParam("@ID", SqlDbType.Int, 4, intID) };
return (db.RunProc("Pr_DeleteSingleSkin", param));
}
/// <summary>
/// 更新单条数据
/// </summary>
/// <param name="intID"></param>
/// <param name="strStyleName"></param>
/// <param name="strStyleUrl"></param>
/// <param name="intState"></param>
/// <returns></returns>
public int UpdateSingleSkin(int intID, string strStyleName, string strStyleUrl)
{
Database db = new Database();
SqlParameter[] param = {
db.CreateInParam("@ID", SqlDbType.Int, 4, intID),
db.CreateInParam("@StyleName", SqlDbType.NVarChar, 25, strStyleName),
db.CreateInParam("@StyleUrl", SqlDbType.NVarChar, 255, strStyleUrl)
};
return (db.RunProc("Pr_UpdateSingleSkin", param));
}
/// <summary>
/// 增长新数据
/// </summary>
/// <param name="strStyleName"></param>
/// <param name="strStyleUrl"></param>
/// <param name="intState"></param>
/// <returns></returns>
public int AddSingleSkin(string strStyleName, string strStyleUrl)
{
Database db = new Database();
SqlParameter[] param = {
db.CreateInParam("@StyleName", SqlDbType.NVarChar, 25, strStyleName),
db.CreateInParam("@StyleUrl", SqlDbType.NVarChar, 255, strStyleUrl)
};
///返回最新ID
return (db.RunProc("Pr_AddSingleSkin", param));
}
/// <summary>
/// 设置皮肤
/// </summary>
/// <param name="intID"></param>
/// <returns></returns>
public int SetSkin(int intID)
{
Database db = new Database();
SqlParameter[] param = {
db.CreateInParam("@ID", SqlDbType.Int, 4, intID)
};
///返回受影响的行数
return (db.RunProc("Pr_SetSkin", param));
}
/// <summary>
/// 获取设置的前台CSS形状
/// </summary>
/// <returns></returns>
public SqlDataReader GetStateSkin()
{
Database db = new Database();
SqlDataReader dr = null;
db.RunProc("Pr_GetStateSkin", out dr);
return (dr);
}
}
}
#line default
#line hidden