📄 sys.cs
字号:
parm[4].Value = GID;
string Sql = "Update " + Pre + "news_Gen Set gType=@_Sel_Type,Cname=@_Name,EmailURL=@_Email,URL=@_LinkUrl where id=@GID and SiteID = " + NetCMS.Global.Current.SiteID + "";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
}
/// <summary>
/// 获取某个常规管理的记录
/// </summary>
/// <param name="GID"></param>
/// <returns></returns>
public DataTable getGeneralIdInfo(int GID)
{
SqlParameter param = new SqlParameter("@GID",GID);
string Sql = "Select id,Cname,gType,URL,EmailURL From " + Pre + "news_Gen where id=@GID";
DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
return rdr;
}
#endregion 常规管理
#region 参数设置
#region 初始参数设置初始化
public DataTable UserGroup()//取会员组
{
string Sql = "Select GroupNumber,GroupName From " + Pre + "user_Group";
return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
}
public DataTable UserReg()//会员注册
{
string Str_CheckSql = "Select regItem,returnemail,returnmobile From " + Pre + "sys_PramUser";
return DbHelper.ExecuteTable(CommandType.Text, Str_CheckSql, null);
}
public DataTable BasePramStart()//初始基本参数设置
{
string Str_StartSql = "Select * From " + Pre + "Sys_Param";
return DbHelper.ExecuteTable(CommandType.Text, Str_StartSql, null);
}
public DataTable FtpRss()//FTP，RSS初始化
{
string Str_StartSql = "Select * From " + Pre + "sys_Pramother";
return DbHelper.ExecuteTable(CommandType.Text, Str_StartSql, null);
}
public DataTable UserPram()//会员参数基本设置
{
string Str_StartSql = "Select * From " + Pre + "Sys_PramUser";
return DbHelper.ExecuteTable(CommandType.Text, Str_StartSql, null);
}
public DataTable UserLeavel()//会员等级设置
{
string Str_LeavlStartSql = "Select * From " + Pre + "Sys_UserLevel";
return DbHelper.ExecuteTable(CommandType.Text, Str_LeavlStartSql, null);
}
public DataTable WaterStart()//水印参数初始化
{
string Str_StartSql = "Select * From " + Pre + "Sys_ParmPrint";
return DbHelper.ExecuteTable(CommandType.Text, Str_StartSql, null);
}
#endregion
#region 更新参数表
public int Update_BaseInfo(SysParamInfo sys)//保存基本参数设置
{
string Str_InSql = "Update " + Pre + "Sys_Param Set SiteName=@Str_SiteName ,SiteDomain=@Str_SiteDomain,IndexTemplet=@Str_IndexTemplet,IndexFileName=@Str_Txt_IndexFileName,FileEXName=@Str_FileEXName,ReadNewsTemplet=@Str_ReadNewsTemplet,ClassListTemplet=@Str_ClassListTemplet,SpecialTemplet=@Str_SpecialTemplet,ReadType=@readtypef,LoginTimeOut=@Str_LoginTimeOut,Email=@Str_Email,LinkType=@linktypef,CopyRight=@Str_BaseCopyRight,CheckInt=@Str_CheckInt,UnLinkTF=@picc,LenSearch=@Str_LenSearch,CheckNewsTitle=@chetitle,CollectTF=@collect,SaveClassFilePath=@Str_SaveClassFilePath,SaveIndexPage=@Str_SaveIndexPage,SaveNewsFilePath=@Str_SaveNewsFilePath,SaveNewsDirPath=@Str_SaveNewsDirPath,Pram_Index=@Str_Pram_Index,InsertPicPosition=@InsertPicPosition,HistoryNum=@HistoryNum";
SqlParameter[] parm = GetBaseInfo(sys);
return DbHelper.ExecuteNonQuery(CommandType.Text, Str_InSql, parm);
}
private SqlParameter[] GetBaseInfo(SysParamInfo sys)
{
SqlParameter[] parm = new SqlParameter[25];
parm[0] = new SqlParameter("@Str_SiteName", SqlDbType.NVarChar, 50);
parm[0].Value = sys.Str_SiteName;
parm[1] = new SqlParameter("@Str_SiteDomain", SqlDbType.NVarChar, 100);
parm[1].Value = sys.Str_SiteDomain;
parm[2] = new SqlParameter("@Str_IndexTemplet", SqlDbType.NVarChar, 200);
parm[2].Value = sys.Str_IndexTemplet;
parm[3] = new SqlParameter("@Str_Txt_IndexFileName", SqlDbType.NVarChar, 20);
parm[3].Value = sys.Str_Txt_IndexFileName;
parm[4] = new SqlParameter("@Str_FileEXName", SqlDbType.NVarChar, 30);
parm[4].Value = sys.Str_FileEXName;
parm[5] = new SqlParameter("@Str_ReadNewsTemplet", SqlDbType.NVarChar, 200);
parm[5].Value = sys.Str_ReadNewsTemplet;
parm[6] = new SqlParameter("@Str_ClassListTemplet", SqlDbType.NVarChar, 200);
parm[6].Value = sys.Str_ClassListTemplet;
parm[7] = new SqlParameter("@Str_SpecialTemplet", SqlDbType.NVarChar, 200);
parm[7].Value = sys.Str_SpecialTemplet;
parm[8] = new SqlParameter("@readtypef", SqlDbType.TinyInt);
parm[8].Value = sys.readtypef;
parm[9] = new SqlParameter("@Str_LoginTimeOut", SqlDbType.Int, 4);
parm[9].Value = sys.Str_LoginTimeOut;
parm[10] = new SqlParameter("@Str_Email", SqlDbType.NVarChar, 150);
parm[10].Value = sys.Str_Email;
parm[11] = new SqlParameter("@linktypef", SqlDbType.TinyInt);
parm[11].Value = sys.linktypef;
parm[12] = new SqlParameter("@Str_BaseCopyRight", SqlDbType.NText);
parm[12].Value = sys.Str_BaseCopyRight;
parm[13] = new SqlParameter("@Str_CheckInt", SqlDbType.TinyInt);
parm[13].Value = sys.Str_CheckInt;
parm[14] = new SqlParameter("@picc", SqlDbType.TinyInt);
parm[14].Value = sys.picc;
parm[15] = new SqlParameter("@Str_LenSearch", SqlDbType.NVarChar, 8);
parm[15].Value = sys.Str_LenSearch;
parm[16] = new SqlParameter("@chetitle", SqlDbType.TinyInt);
parm[16].Value = sys.chetitle;
parm[17] = new SqlParameter("@collect", SqlDbType.TinyInt);
parm[17].Value = sys.collect;
parm[18] = new SqlParameter("@Str_SaveClassFilePath", SqlDbType.NVarChar, 200);
parm[18].Value = sys.Str_SaveClassFilePath;
parm[19] = new SqlParameter("@Str_SaveIndexPage", SqlDbType.NVarChar, 100);
parm[19].Value = sys.Str_SaveIndexPage;
parm[20] = new SqlParameter("@Str_SaveNewsFilePath", SqlDbType.NVarChar, 200);
parm[20].Value = sys.Str_SaveNewsFilePath;
parm[21] = new SqlParameter("@Str_SaveNewsDirPath", SqlDbType.NVarChar, 100);
parm[21].Value = sys.Str_SaveNewsDirPath;
parm[22] = new SqlParameter("@Str_Pram_Index", SqlDbType.Int, 4);
parm[22].Value = sys.Str_Pram_Index;
parm[23] = new SqlParameter("@InsertPicPosition", SqlDbType.NVarChar, 20);
parm[23].Value = sys.InsertPicPosition;
parm[24] = new SqlParameter("@HistoryNum", SqlDbType.Int, 4);
parm[24].Value = sys.HistoryNum;
return parm;
}
#endregion
#region 更新会员参数表
#region 会员注册参数SQL语句
public int Update_UserRegInfo(SysParamInfo sys)//保存基本参数设置
{
string SQL = "update " + Pre + "sys_PramUser set regItem=@strContent,returnemail=@returnemail,returnmobile=@returnmobile";
SqlParameter[] parm = GetUserRegInfo(sys);
return DbHelper.ExecuteNonQuery(CommandType.Text, SQL, parm);
}
private SqlParameter[] GetUserRegInfo(SysParamInfo sys)
{
SqlParameter[] parm = new SqlParameter[3];
parm[0] = new SqlParameter("@strContent", SqlDbType.NText);
parm[0].Value = sys.strContent;
parm[1] = new SqlParameter("@returnemail", SqlDbType.TinyInt);
parm[1].Value = sys.returnemail;
parm[2] = new SqlParameter("@returnmobile", SqlDbType.TinyInt);
parm[2].Value = sys.returnmobile;
return parm;
}
#endregion
#region 会员基本参数设置
public int Update_UserInfo(SysParamInfo sys)//保存基本参数设置
{
string Str_InSql = "Update " + Pre + "Sys_PramUser Set RegGroupNumber=@Str_RegGroupNumber,ConstrTF=@constrr,RegTF=@reg,UserLoginCodeTF=@code,CommCodeTF=@diss,SendMessageTF=@senemessage,UnRegCommTF=@n,CommHTMLLoad=@htmls,Commfiltrchar=@Str_Commfiltrchar,IPLimt=@Str_IPLimt,GpointName=@Str_GpointName,LoginLock=@Str_LoginLock,setPoint=@Str_setPoint,RegContent=@Str_RegContent,GhClass=@ghclass,cPointParam=@Str_cPointParam,aPointparam=@Str_aPointparam,CommCheck=@CommCheck";
SqlParameter[] parm = GetUserInfo(sys);
return DbHelper.ExecuteNonQuery(CommandType.Text, Str_InSql, parm);
}
private SqlParameter[] GetUserInfo(SysParamInfo sys)
{
SqlParameter[] parm = new SqlParameter[18];
parm[0] = new SqlParameter("@Str_RegGroupNumber", SqlDbType.NVarChar, 20);
parm[0].Value = sys.Str_RegGroupNumber;
parm[1] = new SqlParameter("@constrr", SqlDbType.TinyInt);
parm[1].Value = sys.constrr;
parm[2] = new SqlParameter("@reg", SqlDbType.TinyInt);
parm[2].Value = sys.reg;
parm[3] = new SqlParameter("@code", SqlDbType.TinyInt);
parm[3].Value = sys.code;
parm[4] = new SqlParameter("@diss", SqlDbType.TinyInt);
parm[4].Value = sys.diss;
parm[5] = new SqlParameter("@senemessage", SqlDbType.TinyInt);
parm[5].Value = sys.senemessage;
parm[6] = new SqlParameter("@n", SqlDbType.TinyInt);
parm[6].Value = sys.n;
parm[7] = new SqlParameter("@htmls", SqlDbType.TinyInt);
parm[7].Value = sys.htmls;
parm[8] = new SqlParameter("@Str_Commfiltrchar", SqlDbType.NText);
parm[8].Value = sys.Str_Commfiltrchar;
parm[9] = new SqlParameter("@Str_IPLimt", SqlDbType.NText);
parm[9].Value = sys.Str_IPLimt;
parm[10] = new SqlParameter("@Str_GpointName", SqlDbType.NVarChar, 10);
parm[10].Value = sys.Str_GpointName;
parm[11] = new SqlParameter("@Str_LoginLock", SqlDbType.NVarChar, 10);
parm[11].Value = sys.Str_LoginLock;
parm[12] = new SqlParameter("@Str_setPoint", SqlDbType.NVarChar, 20);
parm[12].Value = sys.Str_setPoint;
parm[13] = new SqlParameter("@Str_RegContent", SqlDbType.NText);
parm[13].Value = sys.Str_RegContent;
parm[14] = new SqlParameter("@ghclass", SqlDbType.TinyInt);
parm[14].Value = sys.ghclass;
parm[15] = new SqlParameter("@Str_cPointParam", SqlDbType.NVarChar, 30);
parm[15].Value = sys.Str_cPointParam;
parm[16] = new SqlParameter("@Str_aPointparam", SqlDbType.NVarChar, 30);
parm[16].Value = sys.Str_aPointparam;
parm[17] = new SqlParameter("@CommCheck", SqlDbType.TinyInt, 1);
parm[17].Value = sys.CommCheck;
return parm;
}
#endregion
#region 会员等级设置
public int Update_Leavel(SysParamInfo sys, int k)//保存等级设置
{
string Str_InSqlLeavel = "Update " + Pre + "Sys_UserLevel Set LTitle=@Str_LtitleArr,Lpicurl=@Str_LpicurlArr,iPoint=@Str_iPointArr where id=" + k + "";
SqlParameter[] parm = GetUserleavelInfo(sys, k);
return DbHelper.ExecuteNonQuery(CommandType.Text, Str_InSqlLeavel, parm);
}
private SqlParameter[] GetUserleavelInfo(SysParamInfo sys, int k)
{
SqlParameter[] parm = new SqlParameter[3];
parm[0] = new SqlParameter("@Str_LtitleArr", SqlDbType.NVarChar, 50);
parm[0].Value = sys.Str_LtitleArr[k];
parm[1] = new SqlParameter("@Str_LpicurlArr", SqlDbType.NVarChar, 200);
parm[1].Value = sys.Str_LpicurlArr[k];
parm[2] = new SqlParameter("@Str_iPointArr", SqlDbType.Int, 4);
parm[2].Value = sys.Str_iPointArr[k];
return parm;
}
#endregion
#endregion
#region 更新上传
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -