usermisc.cs

最好用的站点内容管理系统 全部源代码都有

        /// </summary>
        /// <param name="uc2"></param>
        public void addUpdate_Group(NetCMS.Model.UserInfo4 uc2,bool flag)
        {
            #region
            string Sql = null;
            if (flag)
            {
                Sql = "Insert Into " + Pre + "user_Group(GroupNumber,GroupName,iPoint,Gpoint,Rtime,LenCommContent,CommCheckTF,PostCommTime,upfileType,upfileNum,upfileSize,DayUpfilenum,ContrNum,DicussTF,PostTitle,ReadUser,MessageNum,MessageGroupNum,IsCert,CharTF,CharHTML,CharLenContent,RegMinute,PostTitleHTML,DelSelfTitle,DelOTitle,EditSelfTitle,EditOtitle,ReadTitle,MoveSelfTitle,MoveOTitle,TopTitle,GoodTitle,LockUser,UserFlag,CheckTtile,IPTF,EncUser,OCTF,StyleTF,UpfaceSize,GIChange,GTChageRate,LoginPoint,RegPoint,GroupTF,GroupSize,GroupPerNum,GroupCreatNum,CreatTime,siteID,Discount";
                Sql += ") Values(";
                Sql += "@GroupNumber,@GroupName,@iPoint,@Gpoint,@Rtime,@LenCommContent,@CommCheckTF,@PostCommTime,@upfileType,@upfileNum,@upfileSize,@DayUpfilenum,@ContrNum,@DicussTF,@PostTitle,@ReadUser,@MessageNum,@MessageGroupNum,@IsCert,@CharTF,@CharHTML,@CharLenContent,@RegMinute,@PostTitleHTML,@DelSelfTitle,@DelOTitle,@EditSelfTitle,@EditOtitle,@ReadTitle,@MoveSelfTitle,@MoveOTitle,@TopTitle,@GoodTitle,@LockUser,@UserFlag,@CheckTtile,@IPTF,@EncUser,@OCTF,@StyleTF,@UpfaceSize,@GIChange,@GTChageRate,@LoginPoint,@RegPoint,@GroupTF,@GroupSize,@GroupPerNum,@GroupCreatNum,@CreatTime,@siteID,@Discount)";
            }
            else
            {
                Sql = "Update " + Pre + "user_Group set GroupName=@GroupName,iPoint=@iPoint,Gpoint=@Gpoint,Rtime=@Rtime,LenCommContent=@LenCommContent,CommCheckTF=@CommCheckTF,PostCommTime=@PostCommTime,upfileType=@upfileType,upfileNum=@upfileNum,upfileSize=@upfileSize,DayUpfilenum=@DayUpfilenum,ContrNum=@ContrNum,DicussTF=@DicussTF,PostTitle=@PostTitle,ReadUser=@ReadUser,MessageNum=@MessageNum,MessageGroupNum=@MessageGroupNum,IsCert=@IsCert,CharTF=@CharTF,CharHTML=@CharHTML,CharLenContent=@CharLenContent,RegMinute=@RegMinute,PostTitleHTML=@PostTitleHTML,DelSelfTitle=@DelSelfTitle,DelOTitle=@DelOTitle,EditSelfTitle=@EditSelfTitle,EditOtitle=@EditOtitle,ReadTitle=@ReadTitle,MoveSelfTitle=@MoveSelfTitle,MoveOTitle=@MoveOTitle,TopTitle=@TopTitle,GoodTitle=@GoodTitle,LockUser=@LockUser,UserFlag=@UserFlag,CheckTtile=@CheckTtile,IPTF=@IPTF,EncUser=@EncUser,OCTF=@OCTF,StyleTF=@StyleTF,UpfaceSize=@UpfaceSize,GIChange=@GIChange,GTChageRate=@GTChageRate,LoginPoint=@LoginPoint,RegPoint=@RegPoint,GroupTF=@GroupTF,GroupSize=@GroupSize,GroupPerNum=@GroupPerNum,GroupCreatNum=@GroupCreatNum,Discount=@Discount where id=" + uc2.gID + "";
            }
            SqlParameter[] parm = InsertGroupParameters(uc2);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
            #endregion
        }

        /// <summary>
        /// 获取UserInfo4构造
        /// </summary>
        /// <param name="uc1"></param>
        /// <returns></returns>
        private SqlParameter[] InsertGroupParameters(NetCMS.Model.UserInfo4 uc1)
        {
            #region
            SqlParameter[] param = new SqlParameter[52];
            param[0] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
            param[0].Value = uc1.SiteID;
            param[1] = new SqlParameter("@GroupNumber", SqlDbType.NVarChar, 12);
            param[1].Value = uc1.GroupNumber;
            param[2] = new SqlParameter("@GroupName", SqlDbType.NVarChar, 50);
            param[2].Value = uc1.GroupName;
            param[3] = new SqlParameter("@iPoint", SqlDbType.Int, 4);
            param[3].Value = uc1.iPoint;
            param[4] = new SqlParameter("@Gpoint", SqlDbType.Int, 4);
            param[4].Value = uc1.Gpoint;
            param[5] = new SqlParameter("@Rtime", SqlDbType.Int, 4);
            param[5].Value = uc1.Rtime;
            param[6] = new SqlParameter("@LenCommContent", SqlDbType.Int, 4);
            param[6].Value = uc1.LenCommContent;
            param[7] = new SqlParameter("@CommCheckTF", SqlDbType.TinyInt, 1);
            param[7].Value = uc1.CommCheckTF;
            param[8] = new SqlParameter("@PostCommTime", SqlDbType.Int, 4);
            param[8].Value = uc1.PostCommTime;
            param[9] = new SqlParameter("@upfileType", SqlDbType.NVarChar, 200);
            param[9].Value = uc1.upfileType;
            param[10] = new SqlParameter("@upfileNum", SqlDbType.Int, 4);
            param[10].Value = uc1.upfileNum;
            param[11] = new SqlParameter("@upfileSize", SqlDbType.Int, 4);
            param[11].Value = uc1.upfileSize;
            param[12] = new SqlParameter("@DayUpfilenum", SqlDbType.Int, 4);
            param[12].Value = uc1.DayUpfilenum;
            param[13] = new SqlParameter("@ContrNum", SqlDbType.Int, 4);
            param[13].Value = uc1.ContrNum;
            param[14] = new SqlParameter("@DicussTF", SqlDbType.TinyInt, 1);
            param[14].Value = uc1.DicussTF;
            param[15] = new SqlParameter("@PostTitle", SqlDbType.TinyInt, 1);
            param[15].Value = uc1.PostTitle;
            param[16] = new SqlParameter("@ReadUser", SqlDbType.TinyInt, 1);
            param[16].Value = uc1.ReadUser;
            param[17] = new SqlParameter("@MessageNum", SqlDbType.Int, 4);
            param[17].Value = uc1.MessageNum;
            param[18] = new SqlParameter("@MessageGroupNum", SqlDbType.NVarChar, 15);
            param[18].Value = uc1.MessageGroupNum;
            param[19] = new SqlParameter("@IsCert", SqlDbType.TinyInt, 1);
            param[19].Value = uc1.IsCert;
            param[20] = new SqlParameter("@CharTF", SqlDbType.TinyInt, 1);
            param[20].Value = uc1.CharTF;
            param[21] = new SqlParameter("@CharHTML", SqlDbType.TinyInt, 1);
            param[21].Value = uc1.CharHTML;
            param[22] = new SqlParameter("@CharLenContent", SqlDbType.Int, 4);
            param[22].Value = uc1.CharLenContent;
            param[23] = new SqlParameter("@RegMinute", SqlDbType.Int, 4);
            param[23].Value = uc1.RegMinute;
            param[24] = new SqlParameter("@PostTitleHTML", SqlDbType.TinyInt, 1);
            param[24].Value = uc1.PostTitleHTML;
            param[25] = new SqlParameter("@DelSelfTitle", SqlDbType.TinyInt, 1);
            param[25].Value = uc1.DelSelfTitle;
            param[26] = new SqlParameter("@DelOTitle", SqlDbType.TinyInt, 1);
            param[26].Value = uc1.DelOTitle;
            param[27] = new SqlParameter("@EditSelfTitle", SqlDbType.TinyInt, 1);
            param[27].Value = uc1.EditSelfTitle;
            param[28] = new SqlParameter("@EditOtitle", SqlDbType.TinyInt, 1);
            param[28].Value = uc1.EditOtitle;
            param[29] = new SqlParameter("@ReadTitle", SqlDbType.TinyInt, 1);
            param[29].Value = uc1.ReadTitle;
            param[30] = new SqlParameter("@MoveSelfTitle", SqlDbType.TinyInt, 1);
            param[30].Value = uc1.MoveSelfTitle;
            param[31] = new SqlParameter("@MoveOTitle", SqlDbType.TinyInt, 1);
            param[31].Value = uc1.MoveOTitle;
            param[32] = new SqlParameter("@TopTitle", SqlDbType.TinyInt, 1);
            param[32].Value = uc1.TopTitle;
            param[33] = new SqlParameter("@GoodTitle", SqlDbType.TinyInt, 1);
            param[33].Value = uc1.GoodTitle;
            param[34] = new SqlParameter("@LockUser", SqlDbType.TinyInt, 1);
            param[34].Value = uc1.LockUser;

            param[35] = new SqlParameter("@UserFlag", SqlDbType.NVarChar, 100);
            param[35].Value = uc1.UserFlag;
            param[36] = new SqlParameter("@CheckTtile", SqlDbType.TinyInt, 1);
            param[36].Value = uc1.CheckTtile;
            param[37] = new SqlParameter("@IPTF", SqlDbType.TinyInt, 1);
            param[37].Value = uc1.IPTF;
            param[38] = new SqlParameter("@EncUser", SqlDbType.TinyInt, 1);
            param[38].Value = uc1.EncUser;
            param[39] = new SqlParameter("@OCTF", SqlDbType.TinyInt, 1);
            param[39].Value = uc1.OCTF;
            param[40] = new SqlParameter("@StyleTF", SqlDbType.TinyInt, 1);
            param[40].Value = uc1.StyleTF;
            param[41] = new SqlParameter("@UpfaceSize", SqlDbType.Int, 4);
            param[41].Value = uc1.UpfaceSize;


            param[42] = new SqlParameter("@GIChange", SqlDbType.NVarChar, 10);
            param[42].Value = uc1.GIChange;
            param[43] = new SqlParameter("@GTChageRate", SqlDbType.NVarChar, 30);
            param[43].Value = uc1.GTChageRate;
            param[44] = new SqlParameter("@LoginPoint", SqlDbType.NVarChar, 20);
            param[44].Value = uc1.LoginPoint;
            param[45] = new SqlParameter("@RegPoint", SqlDbType.NVarChar, 20);
            param[45].Value = uc1.RegPoint;
            param[46] = new SqlParameter("@GroupTF", SqlDbType.TinyInt, 1);
            param[46].Value = uc1.GroupTF;


            param[47] = new SqlParameter("@GroupSize", SqlDbType.Int, 4);
            param[47].Value = uc1.GroupSize;
            param[48] = new SqlParameter("@GroupPerNum", SqlDbType.Int, 4);
            param[48].Value = uc1.GroupPerNum;
            param[49] = new SqlParameter("@GroupCreatNum", SqlDbType.Int, 4);
            param[49].Value = uc1.GroupCreatNum;
            param[50] = new SqlParameter("@CreatTime", SqlDbType.DateTime, 8);
            param[50].Value = uc1.CreatTime;
            param[51] = new SqlParameter("@Discount", SqlDbType.Float, 8);
            param[51].Value = uc1.Discount;

            return param;
            #endregion
        }

        /// <summary>
        /// 获取UserInfo4构造
        /// </summary>
        /// <param name="uc1"></param>
        /// <returns></returns>
        private SqlParameter[] updateGroupEditParameters(NetCMS.Model.UserInfo4 uc1)
        {
            #region
            SqlParameter[] param = new SqlParameter[50];
            param[0] = new SqlParameter("@gID", SqlDbType.Int, 4);
            param[0].Value = uc1.gID;
            param[1] = new SqlParameter("@GroupCreatNum", SqlDbType.Int, 4);
            param[1].Value = uc1.GroupCreatNum;
            param[2] = new SqlParameter("@GroupName", SqlDbType.NVarChar, 50);
            param[2].Value = uc1.GroupName;
            param[3] = new SqlParameter("@iPoint", SqlDbType.Int, 4);
            param[3].Value = uc1.iPoint;
            param[4] = new SqlParameter("@Gpoint", SqlDbType.Int, 4);
            param[4].Value = uc1.Gpoint;
            param[5] = new SqlParameter("@Rtime", SqlDbType.Int, 4);
            param[5].Value = uc1.Rtime;
            param[6] = new SqlParameter("@LenCommContent", SqlDbType.Int, 4);
            param[6].Value = uc1.LenCommContent;
            param[7] = new SqlParameter("@CommCheckTF", SqlDbType.TinyInt, 1);
            param[7].Value = uc1.CommCheckTF;
            param[8] = new SqlParameter("@PostCommTime", SqlDbType.Int, 4);
            param[8].Value = uc1.PostCommTime;
            param[9] = new SqlParameter("@upfileType", SqlDbType.NVarChar, 200);
            param[9].Value = uc1.upfileType;
            param[10] = new SqlParameter("@upfileNum", SqlDbType.Int, 4);
            param[10].Value = uc1.upfileNum;
            param[11] = new SqlParameter("@upfileSize", SqlDbType.Int, 4);
            param[11].Value = uc1.upfileSize;
            param[12] = new SqlParameter("@DayUpfilenum", SqlDbType.Int, 4);
            param[12].Value = uc1.DayUpfilenum;
            param[13] = new SqlParameter("@ContrNum", SqlDbType.Int, 4);
            param[13].Value = uc1.ContrNum;
            param[14] = new SqlParameter("@DicussTF", SqlDbType.TinyInt, 1);
            param[14].Value = uc1.DicussTF;
            param[15] = new SqlParameter("@PostTitle", SqlDbType.TinyInt, 1);
            param[15].Value = uc1.PostTitle;
            param[16] = new SqlParameter("@ReadUser", SqlDbType.TinyInt, 1);
            param[16].Value = uc1.ReadUser;
            param[17] = new SqlParameter("@MessageNum", SqlDbType.Int, 4);
            param[17].Value = uc1.MessageNum;
            param[18] = new SqlParameter("@MessageGroupNum", SqlDbType.NVarChar, 15);
            param[18].Value = uc1.MessageGroupNum;
            param[19] = new SqlParameter("@IsCert", SqlDbType.TinyInt, 1);
            param[19].Value = uc1.IsCert;
            param[20] = new SqlParameter("@CharTF", SqlDbType.TinyInt, 1);
            param[20].Value = uc1.CharTF;
            param[21] = new SqlParameter("@CharHTML", SqlDbType.TinyInt, 1);
            param[21].Value = uc1.CharHTML;
            param[22] = new SqlParameter("@CharLenContent", SqlDbType.Int, 4);
            param[22].Value = uc1.CharLenContent;
            param[23] = new SqlParameter("@RegMinute", SqlDbType.Int, 4);
            param[23].Value = uc1.RegMinute;
            param[24] = new SqlParameter("@PostTitleHTML", SqlDbType.TinyInt, 1);
            param[24].Value = uc1.PostTitleHTML;
            param[25] = new SqlParameter("@DelSelfTitle", SqlDbType.TinyInt, 1);
            param[25].Value = uc1.DelSelfTitle;
            param[26] = new SqlParameter("@DelOTitle", SqlDbType.TinyInt, 1);
            param[26].Value = uc1.DelOTitle;
            param[27] = new SqlParameter("@EditSelfTitle", SqlDbType.TinyInt, 1);
            param[27].Value = uc1.EditSelfTitle;
            param[28] = new SqlParameter("@EditOtitle", SqlDbType.TinyInt, 1);
            param[28].Value = uc1.EditOtitle;
            param[29] = new SqlParameter("@ReadTitle", SqlDbType.TinyInt, 1);
            param[29].Value = uc1.ReadTitle;
            param[30] = new SqlParameter("@MoveSelfTitle", SqlDbType.TinyInt, 1);
            param[30].Value = uc1.MoveSelfTitle;
            param[31] = new SqlParameter("@MoveOTitle", SqlDbType.TinyInt, 1);
            param[31].Value = uc1.MoveOTitle;
            param[32] = new SqlParameter("@TopTitle", SqlDbType.TinyInt, 1);
            param[32].Value = uc1.TopTitle;
            param[33] = new SqlParameter("@GoodTitle", SqlDbType.TinyInt, 1);
            param[33].Value = uc1.GoodTitle;
            param[34] = new SqlParameter("@LockUser", SqlDbType.TinyInt, 1);
            param[34].Value = uc1.LockUser;

            param[35] = new SqlParameter("@UserFlag", SqlDbType.NVarChar, 100);
            param[35].Value = uc1.UserFlag;
            param[36] = new SqlParameter("@CheckTtile", SqlDbType.TinyInt, 1);
            param[36].Value = uc1.CheckTtile;
            param[37] = new SqlParameter("@IPTF", SqlDbType.TinyInt, 1);
            param[37].Value = uc1.IPTF;
            param[38] = new SqlParameter("@EncUser", SqlDbType.TinyInt, 1);
            param[38].Value = uc1.EncUser;
            param[39] = new SqlParameter("@OCTF", SqlDbType.TinyInt, 1);
            param[39].Value = uc1.OCTF;
            param[40] = new SqlParameter("@StyleTF", SqlDbType.TinyInt, 1);
            param[40].Value = uc1.StyleTF;
            param[41] = new SqlParameter("@UpfaceSize", SqlDbType.Int, 4);
            param[41].Value = uc1.UpfaceSize;


            param[42] = new SqlParameter("@GIChange", SqlDbType.NVarChar, 10);
            param[42].Value = uc1.GIChange;
            param[43] = new SqlParameter("@GTChageRate", SqlDbType.NVarChar, 30);
            param[43].Value = uc1.GTChageRate;
            param[44] = new SqlParameter("@LoginPoint", SqlDbType.NVarChar, 20);
            param[44].Value = uc1.LoginPoint;
            param[45] = new SqlParameter("@RegPoint", SqlDbType.NVarChar, 20);
            param[45].Value = uc1.RegPoint;
            param[46] = new SqlParameter("@GroupTF", SqlDbType.TinyInt, 1);
            param[46].Value = uc1.GroupTF;