📄 discuss.cs
字号:
Sql = "delete " + Pre + "User_DiscussTopic where DtID=@ID and UserNum='" + NetCMS.Global.Current.UserNum + "'";
}
return (int)DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
public int update_discussInfo(DateTime tm, string hidd,int flag)
{
#region
string Sql = null;
if (flag == 0)//discussTopi_commentary.aspx
{
Sql = "update " + Pre + "User_Vote set CreaTime='" + tm + "' where VoteID in (" + hidd + ")";
}
else if (flag == 1)
{
SqlParameter param = new SqlParameter("@VoteID", hidd);
Sql = "update " + Pre + "User_Vote set CreaTime='" + tm + "' where VoteID=@VoteID";
}
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
#endregion
}
public int update_sysUserInfo(int cPoint2, int aPoint2, string UserNum, int flag)
{
#region
string Sql = null;
if (flag == 0)//add_discussManage.aspx
{
Sql = "update " + Pre + "sys_User set cPoint='" + cPoint2 + "',aPoint='" + aPoint2 + "' where UserNum='" + UserNum + "'";
}
else if (flag == 1)//discuss_Manageadd.aspx
{
SqlParameter param = new SqlParameter("@UserNum", UserNum);
Sql = "update " + Pre + "sys_User set iPoint=iPoint-" + cPoint2 + ",gPoint=gPoint-" + aPoint2 + " where UserNum=@UserNum";
}
else if (flag == 2)
{
SqlParameter param = new SqlParameter("@UserNum", UserNum);
Sql = "update " + Pre + "sys_User set iPoint=iPoint-" + cPoint2 + ",gPoint=gPoint-" + aPoint2 + " where UserNum=@UserNum";
}
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
#endregion
}
public int sel_disInfo(string UserNum, string DisID,int flag)
{
#region
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserNum", UserNum), new SqlParameter("@DisID", DisID) };
string Sql = null;
if (flag == 0)
{
Sql = "select count(*) from " + Pre + "User_DiscussMember where UserNum=@UserNum and DisID=@DisID";
}
else if (flag == 1)//discussphotoclass.aspx
{
Sql = "select count(UserName) from " + Pre + "User_PhotoalbumClass where UserName=@UserNum and ClassID=@DisID";
}
return (int)DbHelper.ExecuteScalar(CommandType.Text, Sql, param);
#endregion
}
public int update_userDis(string Fundwarehouse1, string DisID)
{
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Fundwarehouse", Fundwarehouse1), new SqlParameter("@DisID", DisID) };
string Sql = "update " + Pre + "user_Discuss set Fundwarehouse=@Fundwarehouse where DisID=@DisID";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
public int add_discussInfo(STDiscuss DIS)
{
string Sql = "insert into " + Pre + "user_Discuss(DisID,Cname,Authority,Authoritymoney,UserName,Browsenumber,D_Content,D_anno,Creatime,ClassID,Fundwarehouse,GroupSize,GroupPerNum,SiteID) values(@DisID,@Cname,@Authority,@Authoritymoney,@UserName,0,@D_Content,@D_anno,@Creatime,@ClassID,@Fundwarehouse,@GroupSize,@GroupPerNum,@SiteID)";
SqlParameter[] parm = selDiscuss(DIS);
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
}
public string sel_discussStr()
{
string Sql= "select AId from " + Pre + "user_DiscussActive";
return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, null));
}
#region message_discussacti.aspx
public int add_userDiscuss(STDiscussActive DA)
{
string Sql ="Insert Into " + Pre + "user_DiscussActive(Activesubject,ActivePlace,ActiveExpense,Anum,ActivePlan,Contactmethod,Cutofftime,CreaTime,AId,UserName,ALabel,siteID) values(@Activesubject,@ActivePlace,@ActiveExpense,@Anum,@ActivePlan,@Contactmethod,@Cutofftime,@CreaTime,@AId,@UserName1,@ALabel,@siteID)";
SqlParameter[] parm = GetDiscussActive(DA);
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
}
private SqlParameter[] GetDiscussActive(STDiscussActive DA)
{
#region
SqlParameter[] parm = new SqlParameter[12];
parm[0] = new SqlParameter("@Activesubject", SqlDbType.NVarChar, 50);
parm[0].Value = DA.Activesubject;
parm[1] = new SqlParameter("@ActivePlace", SqlDbType.NVarChar, 200);
parm[1].Value = DA.ActivePlace;
parm[2] = new SqlParameter("@ActiveExpense", SqlDbType.NVarChar, 50);
parm[2].Value = DA.ActiveExpense;
parm[3] = new SqlParameter("@Anum", SqlDbType.Int, 4);
parm[3].Value = DA.Anum;
parm[4] = new SqlParameter("@ActivePlan", SqlDbType.NVarChar, 50);
parm[4].Value = DA.ActivePlan;
parm[5] = new SqlParameter("@Contactmethod", SqlDbType.NVarChar, 50);
parm[5].Value = DA.Contactmethod;
parm[6] = new SqlParameter("@Cutofftime", SqlDbType.DateTime);
parm[6].Value = DA.Cutofftime;
parm[7] = new SqlParameter("@CreaTime", SqlDbType.DateTime);
parm[7].Value = DA.CreaTime;
parm[8] = new SqlParameter("@AId", SqlDbType.NVarChar, 18);
parm[8].Value = DA.AId;
parm[9] = new SqlParameter("@UserName1", SqlDbType.NVarChar, 50);
parm[9].Value = DA.UserName;
parm[10] = new SqlParameter("@ALabel", SqlDbType.Int, 4);
parm[10].Value = DA.ALabel;
parm[11] = new SqlParameter("@siteID", SqlDbType.NVarChar, 50);
parm[11].Value = DA.siteID;
return parm;
#endregion
}
#endregion
#region message_discussacti_list.aspx
public int Delete(string ID, string SiteID)
{
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@ID", ID), new SqlParameter("@SiteID", SiteID) };
string Sql = " delete " + Pre + "user_DiscussActive where AId=@ID and SiteID=@SiteID";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
#endregion
#region message_discussclass_add.aspx
public int add_disClass(string DcID, string Cname, string Content, string indexnumber, string SiteID)
{
#region
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@DcID", SqlDbType.NVarChar, 50);
param[0].Value = DcID;
param[1] = new SqlParameter("@Cname", SqlDbType.NVarChar, 50);
param[1].Value = Cname;
param[2] = new SqlParameter("@Content", SqlDbType.NVarChar, 200);
param[2].Value = Content;
param[3] = new SqlParameter("@indexnumber", SqlDbType.NVarChar, 50);
param[3].Value = indexnumber;
param[4] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
param[4].Value = SiteID;
string Sql = "insert into " + Pre + "User_DiscussClass(DcID,Cname,Content,indexnumber,SiteID) values(@DcID,@Cname,@Content,@indexnumber,@SiteID)";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
#endregion
public void getsClassDel(string ID,int flag)
{
#region
SqlParameter param = new SqlParameter("@DcID", ID);
string Sql = null;
if (flag == 0)
{
Sql = "delete from " + Pre + "user_DiscussClass where UserNum='" + NetCMS.Global.Current.UserNum + "' and DcID=@DcID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
}
else if(flag==1)
{
Sql = "update " + Pre + "User_Discuss set Browsenumber=Browsenumber+1 where DisID=@DcID";
}
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
private SqlParameter[] selDiscuss(STDiscuss DIS)
{
#region
SqlParameter[] parm = new SqlParameter[13];
parm[0] = new SqlParameter("@DisID", SqlDbType.NVarChar, 12);
parm[0].Value = DIS.DisID;
parm[1] = new SqlParameter("@Cname", SqlDbType.NVarChar, 100);
parm[1].Value = DIS.Cname;
parm[2] = new SqlParameter("@Authority", SqlDbType.NVarChar, 12);
parm[2].Value = DIS.Authority;
parm[3] = new SqlParameter("@Authoritymoney", SqlDbType.NVarChar, 12);
parm[3].Value = DIS.Authoritymoney;
parm[4] = new SqlParameter("@UserName", SqlDbType.NVarChar, 15);
parm[4].Value = DIS.UserNames;
parm[5] = new SqlParameter("@D_Content", SqlDbType.NVarChar, 200);
parm[5].Value = DIS.D_Content;
parm[6] = new SqlParameter("@D_anno", SqlDbType.NVarChar, 200);
parm[6].Value = DIS.D_anno;
parm[7] = new SqlParameter("@Creatime", SqlDbType.DateTime, 8);
parm[7].Value = DIS.Creatimes;
parm[8] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 50);
parm[8].Value = DIS.ClassID;
parm[9] = new SqlParameter("@Fundwarehouse", SqlDbType.NVarChar, 50);
parm[9].Value = DIS.Fundwarehouse;
parm[10] = new SqlParameter("@GroupSize", SqlDbType.Int, 4);
parm[10].Value = DIS.GroupSize;
parm[11] = new SqlParameter("@GroupPerNum", SqlDbType.Int, 4);
parm[11].Value = DIS.GroupPerNum;
parm[12] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
parm[12].Value = DIS.SiteID;
return parm;
#endregion
}
public int add_Ghistory(string GhID, string UserNum, int Authority3, int Authority2, DateTime Creatime)
{
#region
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@GhID", SqlDbType.NVarChar, 12);
param[0].Value = GhID;
param[1] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 15);
param[1].Value = UserNum;
string Sql = "insert into " + Pre + "User_Ghistory(GhID,UserNUM,Gpoint,iPoint,ghtype,Money,CreatTime) values(@GhID,@UserNum," + Authority3 + "," + Authority2 + ",0,0,'" + Creatime + "')";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
public int add_disMember(string Member, string DisID, string UserNum, DateTime Creatime)
{
#region
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@Member",SqlDbType.NVarChar,12);
param[0].Value = Member;
param[1] = new SqlParameter("@DisID", SqlDbType.NVarChar,12);
param[1].Value = DisID;
param[2] = new SqlParameter("@UserNum" ,SqlDbType.NVarChar,12);
param[2].Value = UserNum;
string Sql = "insert into " + Pre + "User_DiscussMember(Member,DisID,UserNum,Creatime) values(@Member,@DisID,@UserNum,'" + Creatime + "')";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
#region discussacti_add.aspx(CommandType.Text, Sql, param);
public int add_disActiveMember(string Telephone, int ParticipationNum, int isCompanion, string UserNum, string AIds, string PId, DateTime CreaTime)
{
#region
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@Telephone", SqlDbType.NVarChar, 18);
param[0].Value = Telephone;
param[1] = new SqlParameter("@ParticipationNum", SqlDbType.Int, 4);
param[1].Value = ParticipationNum;
param[2] = new SqlParameter("@isCompanion", SqlDbType.Int, 4);
param[2].Value = isCompanion;
param[3] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 18);
param[3].Value = UserNum;
param[4] = new SqlParameter("@AIds", SqlDbType.NVarChar, 18);
param[4].Value = AIds;
param[5] = new SqlParameter("@PId", SqlDbType.NVarChar, 18);
param[5].Value = PId;
param[6] = new SqlParameter("@CreaTime", SqlDbType.DateTime);
param[6].Value = CreaTime;
string Sql = "Insert Into " + Pre + "user_DiscussActiveMember(Telephone,ParticipationNum,isCompanion,UserNum,AId,PId,CreaTime) values(@Telephone,@ParticipationNum,@isCompanion,@UserNum,@AIds,@PId,@CreaTime)";
return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
#endregion
}
#endregion
#region discussacti_up.aspx
public int update_disActive(string Activesubject, string ActivePlace, string ActiveExpense, int Anum, string ActivePlan, string Contactmethod, DateTime Cutofftime, DateTime CreaTime, int ALabel, string AIds)
{
#region
SqlParameter[] param = new SqlParameter[10];
param[0] = new SqlParameter("@Activesubject", SqlDbType.NVarChar, 50);
param[0].Value = Activesubject;
param[1] = new SqlParameter("@ActivePlace", SqlDbType.NVarChar, 50);
param[1].Value = ActivePlace;
param[2] = new SqlParameter("@ActiveExpense", SqlDbType.NVarChar, 50);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -