usermisc.cs

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

            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("@Discount", SqlDbType.Float, 8);
            param[49].Value = uc1.Discount;
            return param;
            #endregion
        }

        #endregion 会员组部分

        #region 公告部分
        public void del_userNews(string Aid,int flag)
        {
            string Sql = null;
            SqlParameter param =null;
            if (flag == 0)
            {
                Sql = "Delete From  " + Pre + "user_news where id in(" + Aid + ") " + NetCMS.Common.Public.getSessionStr() + "";
            }
            else if (flag == 1)
            {
                Sql = "Delete From  " + Pre + "user_card where id in(" + Aid + ")" + NetCMS.Common.Public.getSessionStr() + "";
            }
            else if (flag == 2)
            {
                param = new SqlParameter("@ClassID", Aid);
                Sql = "delete From " + Pre + "API_Navi where am_ParentID=@ClassID and UserNum='" + NetCMS.Global.Current.UserNum + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }

        public void update_userInfo(string Aid, string lockstr,int flag)
        {
            string Sql = null;
            if(flag==0)
            {
                Sql="update " + Pre + "user_news " + lockstr + " where id in(" + Aid + ") " + NetCMS.Common.Public.getSessionStr() + "";
            }
            else if (flag == 1)
            {
                if (lockstr == "000000000")
                {
                    string _Tmpstr = "";
                    _Tmpstr = " set TimeOutDate='1900-1-1'";
                    Sql = "update " + Pre + "user_card " + _Tmpstr + " where id in(" + Aid + ") " + NetCMS.Common.Public.getSessionStr() + "";
                }
                else
                {
                    Sql = "update " + Pre + "user_card " + lockstr + " where id in(" + Aid + ") " + NetCMS.Common.Public.getSessionStr() + "";
                }
            }
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
        }

        /// <summary>
        /// 则插入新记录公告
        /// </summary>
        /// <param name="uc2"></param>
        public void addUpdate_Announce(NetCMS.Model.UserInfo5 uc2,bool flag)
        {
            #region
            string Sql = null;
            if (flag)
            {
                Sql = "insert into " + Pre + "user_news (";
                Sql += "newsID,Title,content,creatTime,GroupNumber,getPoint,SiteId,isLock";
                Sql += ") values (";
                Sql += "@newsID,@Title,@content,@creatTime,@GroupNumber,@getPoint,@SiteId,0)";
            }
            else
            {
                Sql = "update " + Pre + "user_news set Title=@Title,content=@content,GroupNumber=@GroupNumber,getPoint=@getPoint where Id=" + uc2.Id + " " + NetCMS.Common.Public.getSessionStr() + "";
            }
            SqlParameter[] parm = GetAnnounceParameters(uc2);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
            #endregion
        }

        /// <summary>
        /// 获取UserInfo5构造
        /// </summary>
        /// <param name="uc1"></param>
        /// <returns></returns>
        private SqlParameter[] GetAnnounceParameters(NetCMS.Model.UserInfo5 uc1)
        {
            #region
            SqlParameter[] param = new SqlParameter[9];
            param[0] = new SqlParameter("@newsID", SqlDbType.NVarChar, 12);
            param[0].Value = uc1.newsID;
            param[1] = new SqlParameter("@Title", SqlDbType.NVarChar, 50);
            param[1].Value = uc1.Title;
            param[2] = new SqlParameter("@content", SqlDbType.NText);
            param[2].Value = uc1.content;
            param[3] = new SqlParameter("@creatTime", SqlDbType.DateTime, 8);
            param[3].Value = uc1.creatTime;
            param[4] = new SqlParameter("@GroupNumber", SqlDbType.NVarChar, 12);
            param[4].Value = uc1.GroupNumber;
            param[5] = new SqlParameter("@getPoint", SqlDbType.NVarChar, 50);
            param[5].Value = uc1.getPoint;
            param[6] = new SqlParameter("@SiteId", SqlDbType.NVarChar, 12);
            param[6].Value = uc1.SiteId;
            param[7] = new SqlParameter("@isLock", SqlDbType.TinyInt, 1);
            param[7].Value = uc1.isLock;
            param[8] = new SqlParameter("@Id", SqlDbType.Int, 4);
            param[8].Value = uc1.Id;
            return param;
            #endregion
        }
        /// <summary>
        /// 获取UserInfo5构造
        /// </summary>
        /// <param name="uc1"></param>
        /// <returns></returns>
        private SqlParameter[] UpdateAnnounceParameters(NetCMS.Model.UserInfo5 uc1)
        {
            #region
            SqlParameter[] param = new SqlParameter[5];
            param[0] = new SqlParameter("@Title", SqlDbType.NVarChar, 50);
            param[0].Value = uc1.Title;
            param[1] = new SqlParameter("@content", SqlDbType.NText);
            param[1].Value = uc1.content;
            param[2] = new SqlParameter("@GroupNumber", SqlDbType.NVarChar, 12);
            param[2].Value = uc1.GroupNumber;
            param[3] = new SqlParameter("@getPoint", SqlDbType.NVarChar, 50);
            param[3].Value = uc1.getPoint;
            param[4] = new SqlParameter("@Id", SqlDbType.Int, 4);
            param[4].Value = uc1.Id;
            return param;
            #endregion
        }
        #endregion 公告部分

        #region 点卡
        public DataTable GetPage(string _islock, string _isuse, string _isbuy, string _timeout, string _SiteID, string cardnumber, string cardpassword, int PageIndex, int PageSize, out int RecordCount, out int PageCount, params SQLConditionInfo[] SqlCondition)
        {
            #region
            string QSQL = "";
            if (cardnumber != "" && cardnumber != null)
            {
                QSQL += " and CardNumber = '" + cardnumber.ToString() + "'";
            }

            if (cardpassword != "" && cardpassword != null)
            {
                QSQL += " and CardPassWord = '" + cardpassword.ToString() + "'";
            }

            if (_islock != "" && _islock != null)
            {
                QSQL += " and isLock = " + int.Parse(_islock.ToString()) + "";
            }
            if (_isuse != "" && _isuse != null)
            {
                QSQL += " and isUse = " + int.Parse(_isuse.ToString()) + "";
            }
            if (_isbuy != "" && _isbuy != null)
            {
                QSQL += " and isBuy = " + int.Parse(_isbuy.ToString()) + "";
            }
            if (_timeout != "" && _timeout != null)
            {
                if (_timeout.ToString() == "1")
                {
                    QSQL += " and TimeOutDate <= '" + System.DateTime.Now + "'";
                }
                else
                {
                    QSQL += " and TimeOutDate > '" + System.DateTime.Now + "'";
                }
            }
            if (_SiteID != "" && _SiteID != null)
            {
                if (NetCMS.Global.Current.SiteID == "0")
                {
                    QSQL += " and SiteID='" + _SiteID + "'";
                }
                else
                {
                    QSQL += " and SiteID='" + NetCMS.Global.Current.SiteID + "'";
                }
            }
            else
            {
                QSQL += " and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }

            string AllFields = "id,CaID,CardNumber,CardPassWord,creatTime,Money,Point,isBuy,isUse,isLock,UserNum,SiteId,TimeOutDate";
            string Condition = Pre + "user_Card where 1=1 " + QSQL;
            string IndexField = "ID";
            string OrderFields = "order by Id Desc";
            return DbHelper.ExecutePage(AllFields, Condition, IndexField, OrderFields, PageIndex, PageSize, out RecordCount, out PageCount, null);
            #endregion
        }
        /// <summary>
        /// 得到编号是否重复
        /// </summary>
        /// <param name="CardNumber"></param>
        /// <returns></returns>
        public object getCardNumberTF(string CardNumber)
        {
            SqlParameter param = new SqlParameter("@CardNumber", CardNumber);
            string Sql = "select CardNumber from " + Pre + "user_card where CardNumber=@CardNumber";
            return DbHelper.ExecuteScalar(CommandType.Text, Sql, param);
        }

        /// <summary>
        /// 点卡密码是否重复
        /// </summary>
        /// <param name="CardPass"></param>
        /// <returns></returns>
        public bool getCardPassTF(string CardPass)
        {
            SqlParameter param = new SqlParameter("@CardPass", CardPass);
            bool flg = false;
            string Sql = "select id from " + Pre + "user_card where CardPassWord=@CardPass";
            object obj = DbHelper.ExecuteScalar(CommandType.Text, Sql, param);
            if (obj != null)
            {
                flg = true;
            }
            return flg;
        }

        public void addUpdate_card(NetCMS.Model.IDCARD uc,int flag)
        {
            #region
            string Sql = null;
            if (flag == 0)
            {
                Sql = "Insert Into " + Pre + "user_card(CaID,CardNumber,CardPassWord,creatTime,[Money],Point,isBuy,isUse,isLock,UserNum,siteID,TimeOutDate) Values(@CaID,@CardNumber,@CardPassWord,@creatTime,@Money,@Point,@isBuy,@isUse,@isLock,@UserNum,@siteID,@TimeOutDate)";
            }
            else if (flag == 1)
            {
                Sql = "Update " + Pre + "user_card set CardPassWord=@CardPassWord,[Money]=@Money,Point=@Point,isBuy=@isBuy,isUse=@isUse,isLock=@isLock,TimeOutDate=@TimeOutDate where Id=" + uc.Id + " and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            SqlParameter[] parm = insertCardRParameters(uc);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
            #endregion
        }

        /// <summary>
        /// 获取IDCARD构造
        /// </summary>
        /// <param name="uc1"></param>
        /// <returns></returns>
        private SqlParameter[] insertCardRPar