📄 constr.cs
字号:
public int add_conStrClass(STConstrClass Con, string Ccid, string UserNum)
{
#region
string Sql = "insert into " + Pre + "user_ConstrClass(Ccid,UserNum,cName,Content,creatTime) values(@Ccid,@UserNum,@cName,@Content,@creatTime)";
SqlParameter[] parm = GetConstrClass(Con);
int i_length = parm.Length;
Array.Resize<SqlParameter>(ref parm, i_length + 3);
parm[i_length + 1] = new SqlParameter("@Ccid", Ccid);
parm[i_length + 2] = new SqlParameter("@UserNum", UserNum);
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
#endregion
}
public string ConstrTF()
{
string Sql = "select ConstrTF from " + Pre + "sys_PramUser where SiteID = '" + NetCMS.Global.Current.SiteID + "'";
return DbHelper.ExecuteScalar(CommandType.Text, Sql, null).ToString();
}
#region ConstrClass_up.aspx
public int update_conStrClass(STConstrClass Con, string Ccid)
{
#region
string Sql = "update " + Pre + "user_ConstrClass set cName=@cName,Content=@Content where Ccid=@Ccid";
SqlParameter[] parm = GetConstrClass(Con);
int i_length = parm.Length;
Array.Resize<SqlParameter>(ref parm, i_length + 2);
parm[i_length + 1] = new SqlParameter("@Ccid", Ccid);
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
#endregion
}
#endregion
private SqlParameter[] GetConstrClass(STConstrClass Con)
{
#region
SqlParameter[] parm = new SqlParameter[3];
parm[0] = new SqlParameter("@cName", SqlDbType.NVarChar, 100);
parm[0].Value = Con.cName;
parm[1] = new SqlParameter("@Content", SqlDbType.NVarChar, 20);
parm[1].Value = Con.Content;
parm[2] = new SqlParameter("@creatTime", SqlDbType.DateTime);
parm[2].Value = DateTime.Now;
return parm;
#endregion
}
#region Constrlist.aspx
public int update_UserInfos(string tagsd, string ID, int flag)
{
#region
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 12);
param[0].Value = ID;
string Sql = null;
if (flag == 0)
{
param[1] = new SqlParameter("@tagsd", SqlDbType.NVarChar, 10);
param[1].Value = tagsd;
Sql = "Update " + Pre + "user_Constr Set Contrflg=@tagsd where ConID=@ID";
}
else if (flag == 1)//Constr_Return.aspx
{
param[1] = new SqlParameter("@passcontent", SqlDbType.NText);
param[1].Value = tagsd;
Sql = "update " + Pre + "User_Constr set ispass='1',passcontent=@passcontent where ConID=@ID ";
}
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
public DataTable GetPage(string UserNum, string ClassID, int PageIndex, int PageSize, out int RecordCount, out int PageCount, params SQLConditionInfo[] SqlCondition)
{
#region
string Sql = "";
if (UserNum != null && UserNum != "")
{
Sql += " where UserNum=@UserNum";
}
if (ClassID != null && !ClassID.Equals(""))
{
Sql += " and ClassID=@ClassID";
}
string AllFields = "ConID,Title,creatTime,ClassID,isCheck,Contrflg,ispass,UserNum";
string Condition = "" + Pre + "user_Constr " + Sql + "";
string IndexField = "id";
string OrderFields = "order by Id desc";
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserNum", UserNum), new SqlParameter("@ClassID", ClassID) };
return DbHelper.ExecutePage(AllFields, Condition, IndexField, OrderFields, PageIndex, PageSize, out RecordCount, out PageCount, param);
#endregion
}
public DataTable sel_getUserConStr(int PageIndex, int PageSize, out int RecordCount, out int PageCount, params SQLConditionInfo[] SqlCondition)
{
string AllFields = "UserNum";
string Condition = "(select DISTINCT UserNum from " + Pre + "user_Constr where substring(Contrflg,3,1) = '1' and SiteID='" + NetCMS.Global.Current.SiteID + "') UserNum1";
string IndexField = "UserNum";
string OrderFields = "order by UserNum desc";
return DbHelper.ExecutePage(AllFields, Condition, IndexField, OrderFields, PageIndex, PageSize, out RecordCount, out PageCount, null);
}
#endregion
#endregion
#region 后台
#region Constr_chicklist.aspx
public int update_conStrInfo(string ID, int flag)
{
#region
SqlParameter param = new SqlParameter("@ConID", ID);
string Sql = null;
if (flag == 0)
{
Sql = "update " + Pre + "user_Constr set isadmidel=1 where ConID=@ConID";
}
else if (flag == 1)
{
Sql = "update " + Pre + "User_Constr set isCheck=1 where ConID=@ConID";
}
else if (flag == 2)
{
Sql = "update " + Pre + "sys_user set ParmConstrNum=0 where UserNum=@ConID";
}
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
#endregion
#region Constr_Edit.aspx
public int add_conStrEdit(string NewsID, string Title, string PicURL, string ClassID, string Author, string UserNum, string Source, string Contents, string creatTime, string SiteID, string Tags, string DataLib, string NewsTemplet, string strSavePath, string strfileName, string strfileexName, string strCheckInt)
{
#region
SqlParameter[] param = new SqlParameter[17];
param[0] = new SqlParameter("@NewsID", SqlDbType.NVarChar, 12);
param[0].Value = NewsID;
param[1] = new SqlParameter("@Title", SqlDbType.NVarChar, 100);
param[1].Value = Title;
param[2] = new SqlParameter("@PicURL", SqlDbType.NVarChar, 200);
param[2].Value = PicURL;
param[3] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 12);
param[3].Value = ClassID;
param[4] = new SqlParameter("@Author", SqlDbType.NVarChar, 100);
param[4].Value = Author;
param[5] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 18);
param[5].Value = UserNum;
param[6] = new SqlParameter("@Source", SqlDbType.NVarChar, 100);
param[6].Value = Source;
param[7] = new SqlParameter("@Contents", SqlDbType.NText);
param[7].Value = Contents;
param[8] = new SqlParameter("@creatTime", SqlDbType.DateTime, 8);
param[8].Value = DateTime.Now;
param[9] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
param[9].Value = SiteID;
param[10] = new SqlParameter("@Tags", SqlDbType.NVarChar, 100);
param[10].Value = Tags;
param[11] = new SqlParameter("@DataLib", SqlDbType.NVarChar, 20);
param[11].Value = DataLib;
param[12] = new SqlParameter("@NewsTemplet", SqlDbType.NVarChar, 200);
param[12].Value = NewsTemplet;
param[13] = new SqlParameter("@strSavePath", SqlDbType.NVarChar, 200);
param[13].Value = strSavePath;
param[14] = new SqlParameter("@strfileName", SqlDbType.NVarChar, 100);
param[14].Value = strfileName;
param[15] = new SqlParameter("@strfileexName", SqlDbType.NVarChar, 6);
param[15].Value = strfileexName;
param[16] = new SqlParameter("@strCheckInt", SqlDbType.NVarChar, 10);
param[16].Value = strCheckInt;
string Sql = "insert into " + DataLib + "(NewsID,NewsType,NewsTitle,TitleITF,PicURL,ClassID,Author,Editor,Souce," +
"Content,CreatTime,SiteID,Tags,OrderID,CommlinkTF,SubNewsTF,NewsProperty,newspictopline,templet,click," +
"savepath,fileName,fileEXName,isDelPoint,gPoint,ipoint,groupNumber,ContentPicTF,CommTF,DiscussTF,topnum," +
"voteTF,checkstat,islock,isRecyle,isVoteTF,isHTML,DataLib,isConstr,DefineID) values(@NewsID,0,@Title,0,@PicURL," +
"@ClassID,@Author,@UserNum,@Source,@Contents,@creatTime,@SiteID,@Tags,0,0,0,'0,0,0,0,0,0,0,0'," +
"0,@NewsTemplet,0,@strSavePath,@strfileName,@strfileexName,0,0,0,'',0,1,1,0,0,@strCheckInt,0,0,0,0,@DataLib,1,0)";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
public void updateConstrStrat(string ConID)
{
SqlParameter param = new SqlParameter("@ConID", ConID);
string Sql = "update " + Pre + "User_Constr set isCheck=1 where ConID=@ConID";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
public int add_userGhistory(string NewsID, int gPoint, int iPoint, int Money1, DateTime CreatTime1, string UserNum, string content4)
{
#region
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@NewsID", SqlDbType.NVarChar, 12);
param[0].Value = NewsID;
param[1] = new SqlParameter("@gPoint", SqlDbType.Int, 4);
param[1].Value = gPoint;
param[2] = new SqlParameter("@iPoint", SqlDbType.Int, 4);
param[2].Value = iPoint;
param[3] = new SqlParameter("@Money1", SqlDbType.Int, 4);
param[3].Value = Money1;
param[4] = new SqlParameter("@CreatTime1", SqlDbType.DateTime, 8);
param[4].Value = CreatTime1;
param[5] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 12);
param[5].Value = UserNum;
param[6] = new SqlParameter("@content4", SqlDbType.NText);
param[6].Value = content4;
string Sql = "insert into " + Pre + "User_Ghistory(GhID,ghtype,Gpoint,iPoint,Money,CreatTime,UserNUM,gtype,content,siteID) values(@NewsID,1,@gPoint,@iPoint,@Money1,@CreatTime1,@UserNum,4,@content4,'" + NetCMS.Global.Current.SiteID + "')";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
public int update_sysUser(int iPoint2, int gPoint2, Decimal Money3, int cPoint2, int aPoint2, string UserNum)
{
SqlParameter param = new SqlParameter("@UserNum", UserNum);
string Sql = "update " + Pre + "sys_User set iPoint='" + iPoint2 + "',gPoint='" + gPoint2 + "',ParmConstrNum=" + Money3 + ",cPoint='" + cPoint2 + "',aPoint='" + aPoint2 + "' where UserNum=@UserNum";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
public string sel_newsClass(string ClassID)
{
#region
SqlParameter param = new SqlParameter("@ClassID", ClassID);
string _tb = Pre + "news";
string Sql = "select DataLib from " + Pre + "news_Class where ClassID=@ClassID";
DataTable dt = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
if (dt != null)
{
if (dt.Rows.Count > 0) { _tb = dt.Rows[0]["DataLib"].ToString(); }
dt.Clear(); dt.Dispose();
}
return _tb;
#endregion
}
#endregion
#region Constr_Pay.aspx
public int add_userConstrPay(string UserNum1, int ParmConstrNums, DateTime payTime, string constrPayID)
{
#region
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@userNum", SqlDbType.NVarChar, 12);
param[0].Value = UserNum1;
param[1] = new SqlParameter("@ParmConstrNums", SqlDbType.Int, 4);
param[1].Value = ParmConstrNums;
param[2] = new SqlParameter("@payTime", SqlDbType.DateTime, 8);
param[2].Value = payTime;
param[3] = new SqlParameter("@constrPayID", SqlDbType.NVarChar, 12);
param[3].Value = constrPayID;
string Sql = "insert into " + Pre + "user_constrPay(userNum,Money,payTime,constrPayID,SiteID,PayAdmin) values(@userNum,@ParmConstrNums,@payTime,@constrPayID,'" + NetCMS.Global.Current.SiteID + "','" + NetCMS.Global.Current.UserName + "')";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
#endregion
#region Constr_SetParam.aspx
public int add_sysParmConstr(string PCId, string ConstrPayName, string gpoint, string ipoint, int moneys1, string Gunit)
{
#region
string CSql = "select count(id) from " + Pre + "sys_ParmConstr where ConstrPayName='" + ConstrPayName + "'";
int CCount = Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, CSql, null));
if (CCount > 0)
{
return 0;
}
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@PCId", SqlDbType.NVarChar, 18);
param[0].Value = PCId;
param[1] = new SqlParameter("@ConstrPayName", SqlDbType.NVarChar, 20);
param[1].Value = ConstrPayName;
param[2] = new SqlParameter("@gpoint", SqlDbType.Int, 4);
param[2].Value = gpoint;
param[3] = new SqlParameter("@ipoint", SqlDbType.Int, 4);
param[3].Value = ipoint;
param[4] = new SqlParameter("@moneys1", SqlDbType.Int, 4);
param[4].Value = moneys1;
param[5] = new SqlParameter("@Gunit", SqlDbType.NVarChar, 10);
param[5].Value = Gunit;
string Sql = "insert into " + Pre + "sys_ParmConstr(PCId,ConstrPayName,gPoint,iPoint,money,Gunit,SiteID) values(@PCId,@ConstrPayName,@gpoint,@ipoint,@moneys1,@Gunit,'" + NetCMS.Global.Current.SiteID + "')";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
#endregion
#region Constr_SetParamup.aspx
public int update_sysParmConstr(string ConstrPayName, string gpoint, string ipoint, int moneys1, string Gunit, string PCIdup)
{
#region
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@PCId", SqlDbType.NVarChar, 18);
param[0].Value = PCIdup;
param[1] = new SqlParameter("@ConstrPayName", SqlDbType.NVarChar, 20);
param[1].Value = ConstrPayName;
param[2] = new SqlParameter("@gpoint", SqlDbType.Int, 4);
param[2].Value = gpoint;
param[3] = new SqlParameter("@ipoint", SqlDbType.Int, 4);
param[3].Value = ipoint;
param[4] = new SqlParameter("@moneys1", SqlDbType.Int, 4);
param[4].Value = moneys1;
param[5] = new SqlParameter("@Gunit", SqlDbType.NVarChar, 10);
param[5].Value = Gunit;
string Sql = "update " + Pre + "sys_ParmConstr set ConstrPayName=@ConstrPayName,gPoint=@gPoint,iPoint=@iPoint,money=@moneys1,Gunit=@Gunit where PCId=@PCId";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
#endregion
#region Constr_Stat.aspx
public int sel_userConstrCount(string UserNum, int m1)
{
SqlParameter param = new SqlParameter("@UserNum", UserNum);
string Sql = "select count(Id) from " + Pre + "User_Constr where UserNum=@UserNum and Month(creatTime)= '" + m1 + "' and substring(Contrflg,3,1) = '1' and isadmidel=0 and ispass=0";
return (int)DbHelper.ExecuteScalar(CommandType.Text, Sql, param);
}
#endregion
#endregion
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -