definetable.cs

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

                where = "  where defineInfoId=@defineInfoId";
            }
            SqlParameter param = new SqlParameter("@defineInfoId", defid);
            string AllFields = "id,defineInfoId,defineCname,defineType,[IsNull]";
            string Condition = "" + Pre + "Define_Data " + where + "";
            string IndexField = "id";
            string OrderFields = "order by id Desc";
            return DbHelper.ExecutePage(AllFields, Condition, IndexField, OrderFields, PageIndex, PageSize, out RecordCount, out PageCount, param);
            #endregion
        }
        public int del_defineStr(string pr)
        {
            SqlParameter param = new SqlParameter("@defineInfoId", pr);
            string Sql= "Delete From " + Pre + "define_data where defineInfoId=@defineInfoId";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        public int del_deData(int DefID)
        {
            string Sql = "Delete From " + Pre + "define_data where Id=" + DefID + "";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
        }
        #endregion

        public int sel_defineClass(string _NewText,int flag)
        {
            #region
            SqlParameter param = new SqlParameter("@DefineName", _NewText);
            string Sql = null;
            if (flag == 0)
            {
                Sql = "Select count(DefineId) From " + Pre + "Define_Class Where DefineName=@DefineName";
            }
            else if (flag == 1)
            {
                Sql = "Select count(DefineId) From " + Pre + "Define_Class Where DefineInfoId=@DefineName";
            }
            return (int)DbHelper.ExecuteScalar(CommandType.Text, Sql, param);
            #endregion
        }
        public int add_defineClass(string rand, string _NewText, string _PraText)
        {
            SqlParameter[] param = new SqlParameter[] { new SqlParameter("@DefineInfoId", rand), new SqlParameter("@DefineName", _NewText), new SqlParameter("@ParentInfoId", _PraText) };
            string Sql = "Insert Into " + Pre + "Define_Class(DefineInfoId,DefineName,ParentInfoId,SiteID) values(@DefineInfoId,@DefineName,@ParentInfoId,'" + NetCMS.Global.Current.SiteID + "')";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        public void del_defineClass(string DefID, int flag)
        {
            #region
            SqlParameter param = null;
            if (flag < 3)
            {
                param = new SqlParameter("@DefineInfoId", DefID);
            }
            string Sql = null;
            if (flag == 0)
            {
                Sql = "Delete From " + Pre + "define_class where DefineInfoId=@DefineInfoId";
            }
            else if (flag == 1)
            {
                Sql = "Delete From " + Pre + "define_class where ParentInfoId=@DefineInfoId";
            }
            else if (flag == 2)
            {
                Sql = "Delete From " + Pre + "define_data where defineInfoId=@DefineInfoId";
            }
            else if (flag == 3)
            {
                Sql = "Delete From " + Pre + "define_class where DefineInfoId in(" + DefID + ")";
            }
            else if (flag == 4)
            {
                Sql = "Delete From " + Pre + "define_class where ParentInfoId in(" + DefID + ")";
            }
            else if (flag == 5)
            {
                Sql = "Delete From " + Pre + "define_data where Id in(" + DefID + ")";
            }
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            #endregion
        }
        public int del_defClassInfo(int flag)
        {
            #region
            string Sql = "";
            if (flag == 0)
            {
                if (NetCMS.Global.Current.SiteID == "0") 
                { 
                    Sql = "Delete From " + Pre + "define_class"; 
                }
                else 
                { 
                    Sql = "Delete From " + Pre + "define_class where SiteID='" + NetCMS.Global.Current.SiteID + "'"; 
                }
            }
            else if (flag == 1)
            {
                if (NetCMS.Global.Current.SiteID == "0")
                { 
                    Sql = "Delete From " + Pre + "define_data"; 
                }
                else 
                { 
                    Sql = "Delete From " + Pre + "define_data where SiteID='" + NetCMS.Global.Current.SiteID + "'"; 
                }
            }
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
            #endregion
        }
        //读取属于自定义字段
        public DataTable getDefineUser(int type)
        {
            string sql = "select id,defineInfoId,defineCname,defineColumns,defineType,IsNull,defineValue,defineExpr,definedvalue,SiteID,Type from " + Pre + "define_data where type=" + type;
            return DbHelper.ExecuteTable(CommandType.Text,sql,null);
        }
        
        //根据会员编号和自定义字段类型读取自定义字段
        public DataTable setDefineByNum(string userNum)
        {
            string sql = "select a.*,deID=b.Id,b.DsnewsId,b.DsEName,b.DsnewsTable,b.DsType,b.DsContent,b.DsApiId,b.SiteID from " + Pre + "define_data a inner join " + Pre + "define_save b on a.defineColumns=b.DsEname where b.DsnewsId='" + userNum + "'";
            return DbHelper.ExecuteTable(CommandType.Text, sql, null);
        }

        //添加修改会员自定义字段
        /// <summary>
        /// </summary>
        /// <param name="DsnewsId">ID编号</param>
        /// <param name="DsEName">英文名称</param>
        /// <param name="DsnewsTable">保存会员信息表名字</param>
        /// <param name="DsType">自定义类型  系统默认后台数据为:0,前台为1 </param>
        /// <param name="DsContent">内容</param>
        /// <param name="DsApiId">API唯一编号</param>
        /// <param name="SiteID"></param>
        /// <returns></returns>
        public int AddUpdateDefine(int Id,string DsnewsId, string DsEName, string DsnewsTable, int DsType, string DsContent, string DsApiId, string SiteID,int flag)
        {
            string sql=null;
            SqlParameter[] param = new SqlParameter[8];
            param[0] = new SqlParameter("@Id", SqlDbType.Int,4);
            param[0].Value = Id;
            param[1] = new SqlParameter("@DsnewsId", SqlDbType.NVarChar, 12);
            param[1].Value = DsnewsId;
            param[2] = new SqlParameter("@DsEName", SqlDbType.NVarChar, 50);
            param[2].Value = DsEName;
            param[3] = new SqlParameter("@DsnewsTable", SqlDbType.NVarChar, 50);
            param[3].Value = DsnewsTable;
            param[4] = new SqlParameter("@DsType", SqlDbType.TinyInt, 1);
            param[4].Value = DsType;
            param[5] = new SqlParameter("@DsContent", SqlDbType.NText, 16);
            param[5].Value = DsContent;
            param[6] = new SqlParameter("@DsApiId", SqlDbType.NVarChar, 30);
            param[6].Value = DsApiId;
            param[7] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
            param[7].Value = SiteID;
            if(flag==0)//添加
            {
                sql = "insert into " + Pre + "define_save(DsnewsId,DsEName,DsnewsTable,DsType,DsContent,DsApiId,SiteID) values(@DsnewsId,@DsEName,@DsnewsTable,@DsType,@DsContent,@DsApiId,@SiteID)";
            }
            else if (flag == 1)
            {
                sql = "update " + Pre + "define_save set DsContent=@DsContent where Id=@Id";
            }
            return DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
        }
    }
}