survey.cs

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

            else if (flag == 2)
            {
                Sql = "Delete From " + Pre + "vote_Manage where TID in(" + tid + ") and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
            #endregion
        }

        public bool del_VoteInfo(int flag)
        {
            #region 删除
            string Table = null;
            if (flag == 0)
            {
                Table = "vote_Class";
            }
            else if (flag == 1)
            {
                Table = "Vote_Topic";
            }
            else if (flag == 2)
            {
                Table = "vote_Item";
            }
            else if (flag == 3)
            {
                Table = "vote_Steps";
            }
            string Sql = "Delete From " + Pre + Table + " where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            int i = DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
            if (i == 0)
            {
                return false;
            }
            else
            {
                return true;
            }
            #endregion
        }

        public DataTable sel_voteInfo(int flag)
        {
            #region
            string Sql = null;
            if (flag == 0)//setItem.aspx
            {
                Sql = "Select a.VID,a.ClassName,b.TID,b.Title From " + Pre + "vote_Class as a inner join " + Pre + "Vote_Topic as b on a.VID=b.VID and a.SiteID='" + NetCMS.Global.Current.SiteID + "' and b.SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 1)//setParam.aspx
            {
                Sql = "Select * From " + Pre + "vote_Param";
            }
            else if (flag == 2)//setSteps.aspx
            {
                Sql = "Select TID,Title From " + Pre + "Vote_Topic where isSteps=1 and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 3)//setTitle.aspx
            {
                Sql = "Select VID,ClassName From " + Pre + "vote_Class where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            return DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            #endregion
        }

        public int del_InfoVote(int flag)
        {
            #region
            string Sql = null;
            if (flag == 0)
            {
                Sql = "Delete From " + Pre + "setSteps where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 1)
            {
                Sql = "Delete From " + Pre + "Vote_Topic where SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
            #endregion
        }

        public int del_voteSql(string CheckboxArray, int flag)
        {
            #region
            string Sql = null;
            if (flag == 0)
            {
                Sql = "Delete From " + Pre + "Vote_Topic where tid in(" + CheckboxArray + ") and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 1)
            {
                Sql = "Delete From " + Pre + "vote_Item where TID in(" + CheckboxArray + ") and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 2)
            {
                Sql = "Delete From " + Pre + "vote_Steps where TIDS in(" + CheckboxArray + ") or TIDU in(" + CheckboxArray + ") and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 3)
            {
                Sql = "Delete From " + Pre + "vote_manage where TID in(" + CheckboxArray + ") and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 4)
            {
                Sql = "Delete From " + Pre + "vote_Steps where sid in(" + CheckboxArray + ") and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 5)
            {
                Sql = "Delete From " + Pre + "vote_Manage where rid in(" + CheckboxArray + ") and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 6)
            {
                Sql = "Delete From " + Pre + "vote_Item where iid in(" + CheckboxArray + ") and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
            #endregion
        }
        public string GetUserName(string usernum)
        {//从会员表中取会员名
            string Sql = "Select UserName From " + Pre + "sys_User where UserNum=@UserNum and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            SqlParameter Param = new SqlParameter("@UserNum", usernum);
            return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, Param));
        }
        #endregion

        #region setClass.aspx
        public int Add(string Str_ClassName, string Str_Description, string SiteID)
        {
            SqlParameter[] Param = new SqlParameter[3];
            Param[0] = new SqlParameter("@Str_ClassName", SqlDbType.NVarChar, 20);
            Param[0].Value = Str_ClassName;
            Param[1] = new SqlParameter("@Str_Description", SqlDbType.NVarChar, 50);
            Param[1].Value = Str_Description;
            Param[2] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
            Param[2].Value = SiteID;
            string Sql = "Insert into " + Pre + "vote_Class (ClassName,Description,SiteID) Values(@Str_ClassName,@Str_Description,@SiteID)";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, Param);
        }
        public int Update_Str_InSql(string Str_ClassNameE, string Str_DescriptionE, int VID)
        {
            SqlParameter[] Param = new SqlParameter[3];
            Param[0] = new SqlParameter("@Str_ClassNameE", SqlDbType.NVarChar, 20);
            Param[0].Value = Str_ClassNameE;
            Param[1] = new SqlParameter("@Str_DescriptionE", SqlDbType.NVarChar, 50);
            Param[1].Value = Str_DescriptionE;
            Param[2] = new SqlParameter("@VID", SqlDbType.Int, 4);
            Param[2].Value = VID;
            string Sql = "Update " + Pre + "vote_Class Set ClassName=@Str_ClassNameE,Description=@Str_DescriptionE where vid=@VID  and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, Param);
        }
        #endregion

        #region setItem.aspx
        public int EditItem(VoteItemInfo info)
        {
            SqlConnection cn = new SqlConnection(DBConfig.CmsConString);
            cn.Open();
            try
            {
                string Sql = "select count(IID) from " + Pre + "Vote_Item where ItemName=@ItemName";
                if (info.IID > 0)
                {
                    Sql += " and IID<>" + info.IID;
                }

                SqlParameter Pm = new SqlParameter("@ItemName", info.ItemName);
                int n = (int)DbHelper.ExecuteNonQuery(cn, CommandType.Text, Sql, Pm);
                if (n > 0)
                    throw new Exception("该投票标题已经存在!");
                Sql = "Insert into " + Pre + "Vote_Item ([TID],[ItemName],[ItemMode],[PicSrc],[DisColor],[VoteCount],[ItemDetail],[SiteID]) ";
                Sql += " Values (@TID,@ItemName,@ItemMode,@PicSrc,@DisColor,@VoteCount,@ItemDetail,@SiteID)";
                if (info.IID > 0)
                {
                    Sql = "Update " + Pre + "Vote_Item Set TID=@TID,ItemName=@ItemName,ItemMode=@ItemMode,";
                    Sql += "PicSrc=@PicSrc,DisColor=@DisColor,VoteCount=@VoteCount,ItemDetail=@ItemDetail,SiteID=@SiteID where SiteID='" + NetCMS.Global.Current.SiteID + "' and IID=" + info.IID;
                }
                SqlParameter[] Param = new SqlParameter[8];
                Param[0] = new SqlParameter("@TID", SqlDbType.Int);
                Param[0].Value = info.TID;
                Param[1] = new SqlParameter("@ItemName", SqlDbType.NVarChar, 200);
                Param[1].Value = info.ItemName;
                Param[2] = new SqlParameter("@ItemMode", SqlDbType.TinyInt);
                Param[2].Value = info.ItemMode;
                Param[3] = new SqlParameter("@PicSrc", SqlDbType.NVarChar, 200);
                if (info.PicSrc == string.Empty)
                    Param[3].Value = DBNull.Value;
                else
                    Param[3].Value = info.PicSrc;
                Param[4] = new SqlParameter("@DisColor", SqlDbType.NVarChar, 7);
                if (info.DisColor == string.Empty)
                    Param[4].Value = DBNull.Value;
                else
                    Param[4].Value = info.DisColor;
                Param[5] = new SqlParameter("@VoteCount", SqlDbType.Int);
                Param[5].Value = info.VoteCount;
                Param[6] = new SqlParameter("@ItemDetail", SqlDbType.NVarChar, 255);
                if (info.ItemDetail == string.Empty)
                    Param[6].Value = DBNull.Value;
                else
                    Param[6].Value = info.ItemDetail;
                Param[7] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
                Param[7].Value = info.SiteID;
                return DbHelper.ExecuteNonQuery(cn, CommandType.Text, Sql, Param);
            }
            finally
            {
                if (cn.State == ConnectionState.Open)
                    cn.Close();
            }

        }
        #endregion

        #region setParam.aspx
        public int Update_Str_InSqls(int IPtime, byte IsReg, string IpLimit)
        {
            SqlConnection cn = new SqlConnection(DBConfig.CmsConString);
            cn.Open();
            try
            {
                string Sql = "select count(SysID) from " + Pre + "vote_Param where SiteID='" + NetCMS.Global.Current.SiteID + "'";
                int n = (int)DbHelper.ExecuteScalar(cn, CommandType.Text, Sql, null);
                if (n > 0)
                    Sql = "Update " + Pre + "vote_Param Set IPtime=@IPtime,IsReg=@IsReg,IpLimit=@IpLimit where SiteID=@SiteID";
                else
                {
                    Sql = "insert into " + Pre + "vote_Param (IPtime,IsReg,IpLimit,SiteID) values (";
                    Sql += "@IPtime,@IsReg,@IpLimit,@SiteID)";
                }
                SqlParameter[] Param = new SqlParameter[4];
                Param[0] = new SqlParameter("@IPtime", SqlDbType.Int);
                Param[0].Value = IPtime;
                Param[1] = new SqlParameter("@IsReg", SqlDbType.TinyInt);
                Param[1].Value = IsReg;
                Param[2] = new SqlParameter("@IpLimit", SqlDbType.NText);
                if (IpLimit.Trim() == string.Empty)
                    Param[2].Value = DBNull.Value;
                Param[2].Value = IpLimit;
                Param[3] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
                Param[3].Value = NetCMS.Global.Current.SiteID;
                return DbHelper.ExecuteNonQuery(cn, CommandType.Text, Sql, Param);