Пример #1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_product_type model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into wx_product_type(");
            strSql.Append("wid,parentId,tCode,tName,tUrl,class_layer,remark,icoPic,sort_id,creatDate,extStr,extStr2,store_id,tel,daohangurl,showDefault)");
            strSql.Append(" values (");
            strSql.Append("@wid,@parentId,@tCode,@tName,@tUrl,@class_layer,@remark,@icoPic,@sort_id,@creatDate,@extStr,@extStr2,@store_id,@tel,@daohangurl,@showDefault)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@wid",         SqlDbType.Int,          4),
                new SqlParameter("@parentId",    SqlDbType.Int,          4),
                new SqlParameter("@tCode",       SqlDbType.VarChar,     50),
                new SqlParameter("@tName",       SqlDbType.VarChar,    100),
                new SqlParameter("@tUrl",        SqlDbType.VarChar,    800),
                new SqlParameter("@class_layer", SqlDbType.Int,          4),
                new SqlParameter("@remark",      SqlDbType.VarChar,   2000),
                new SqlParameter("@icoPic",      SqlDbType.VarChar,    800),
                new SqlParameter("@sort_id",     SqlDbType.Int,          4),
                new SqlParameter("@creatDate",   SqlDbType.DateTime),
                new SqlParameter("@extStr",      SqlDbType.VarChar,    800),
                new SqlParameter("@extStr2",     SqlDbType.VarChar,   2000),
                new SqlParameter("@store_id",    SqlDbType.Int,          4),
                new SqlParameter("@tel",         SqlDbType.VarChar,    100),
                new SqlParameter("@daohangurl",  SqlDbType.VarChar,    800),
                new SqlParameter("@showDefault", SqlDbType.Bit, 1)
            };
            parameters[0].Value  = model.wid;
            parameters[1].Value  = model.parentId;
            parameters[2].Value  = model.tCode;
            parameters[3].Value  = model.tName;
            parameters[4].Value  = model.tUrl;
            parameters[5].Value  = model.class_layer;
            parameters[6].Value  = model.remark;
            parameters[7].Value  = model.icoPic;
            parameters[8].Value  = model.sort_id;
            parameters[9].Value  = model.creatDate;
            parameters[10].Value = model.extStr;
            parameters[11].Value = model.extStr2;
            parameters[12].Value = model.store_id;
            parameters[13].Value = model.tel;
            parameters[14].Value = model.daohangurl;
            parameters[15].Value = model.showDefault;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Пример #2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public MxWeiXinPF.Model.wx_product_type GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 id,wid,parentId,tCode,tName,tUrl,class_layer,remark,icoPic,sort_id,creatDate,extStr,extStr2,store_id,tel,daohangurl,showDefault from wx_product_type ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@id", SqlDbType.Int, 4)
            };
            parameters[0].Value = id;

            MxWeiXinPF.Model.wx_product_type model = new MxWeiXinPF.Model.wx_product_type();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Пример #3
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public MxWeiXinPF.Model.wx_product_type DataRowToModel(DataRow row)
 {
     MxWeiXinPF.Model.wx_product_type model = new MxWeiXinPF.Model.wx_product_type();
     if (row != null)
     {
         if (row["id"] != null && row["id"].ToString() != "")
         {
             model.id = int.Parse(row["id"].ToString());
         }
         if (row["wid"] != null && row["wid"].ToString() != "")
         {
             model.wid = int.Parse(row["wid"].ToString());
         }
         if (row["parentId"] != null && row["parentId"].ToString() != "")
         {
             model.parentId = int.Parse(row["parentId"].ToString());
         }
         if (row["tCode"] != null)
         {
             model.tCode = row["tCode"].ToString();
         }
         if (row["tName"] != null)
         {
             model.tName = row["tName"].ToString();
         }
         if (row["tUrl"] != null)
         {
             model.tUrl = row["tUrl"].ToString();
         }
         if (row["class_layer"] != null && row["class_layer"].ToString() != "")
         {
             model.class_layer = int.Parse(row["class_layer"].ToString());
         }
         if (row["remark"] != null)
         {
             model.remark = row["remark"].ToString();
         }
         if (row["icoPic"] != null)
         {
             model.icoPic = row["icoPic"].ToString();
         }
         if (row["sort_id"] != null && row["sort_id"].ToString() != "")
         {
             model.sort_id = int.Parse(row["sort_id"].ToString());
         }
         if (row["creatDate"] != null && row["creatDate"].ToString() != "")
         {
             model.creatDate = DateTime.Parse(row["creatDate"].ToString());
         }
         if (row["extStr"] != null)
         {
             model.extStr = row["extStr"].ToString();
         }
         if (row["extStr2"] != null)
         {
             model.extStr2 = row["extStr2"].ToString();
         }
         if (row["store_id"] != null && row["store_id"].ToString() != "")
         {
             model.store_id = int.Parse(row["store_id"].ToString());
         }
         if (row["tel"] != null)
         {
             model.tel = row["tel"].ToString();
         }
         if (row["daohangurl"] != null)
         {
             model.daohangurl = row["daohangurl"].ToString();
         }
         if (row["showDefault"] != null && row["showDefault"].ToString() != "")
         {
             if ((row["showDefault"].ToString() == "1") || (row["showDefault"].ToString().ToLower() == "true"))
             {
                 model.showDefault = true;
             }
             else
             {
                 model.showDefault = false;
             }
         }
     }
     return(model);
 }
Пример #4
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(MxWeiXinPF.Model.wx_product_type model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update wx_product_type set ");
            strSql.Append("wid=@wid,");
            strSql.Append("parentId=@parentId,");
            strSql.Append("tCode=@tCode,");
            strSql.Append("tName=@tName,");
            strSql.Append("tUrl=@tUrl,");
            strSql.Append("class_layer=@class_layer,");
            strSql.Append("remark=@remark,");
            strSql.Append("icoPic=@icoPic,");
            strSql.Append("sort_id=@sort_id,");
            strSql.Append("creatDate=@creatDate,");
            strSql.Append("extStr=@extStr,");
            strSql.Append("extStr2=@extStr2,");
            strSql.Append("store_id=@store_id,");
            strSql.Append("tel=@tel,");
            strSql.Append("daohangurl=@daohangurl,");
            strSql.Append("showDefault=@showDefault");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@wid",         SqlDbType.Int,          4),
                new SqlParameter("@parentId",    SqlDbType.Int,          4),
                new SqlParameter("@tCode",       SqlDbType.VarChar,     50),
                new SqlParameter("@tName",       SqlDbType.VarChar,    100),
                new SqlParameter("@tUrl",        SqlDbType.VarChar,    800),
                new SqlParameter("@class_layer", SqlDbType.Int,          4),
                new SqlParameter("@remark",      SqlDbType.VarChar,   2000),
                new SqlParameter("@icoPic",      SqlDbType.VarChar,    800),
                new SqlParameter("@sort_id",     SqlDbType.Int,          4),
                new SqlParameter("@creatDate",   SqlDbType.DateTime),
                new SqlParameter("@extStr",      SqlDbType.VarChar,    800),
                new SqlParameter("@extStr2",     SqlDbType.VarChar,   2000),
                new SqlParameter("@store_id",    SqlDbType.Int,          4),
                new SqlParameter("@tel",         SqlDbType.VarChar,    100),
                new SqlParameter("@daohangurl",  SqlDbType.VarChar,    800),
                new SqlParameter("@showDefault", SqlDbType.Bit,          1),
                new SqlParameter("@id",          SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.wid;
            parameters[1].Value  = model.parentId;
            parameters[2].Value  = model.tCode;
            parameters[3].Value  = model.tName;
            parameters[4].Value  = model.tUrl;
            parameters[5].Value  = model.class_layer;
            parameters[6].Value  = model.remark;
            parameters[7].Value  = model.icoPic;
            parameters[8].Value  = model.sort_id;
            parameters[9].Value  = model.creatDate;
            parameters[10].Value = model.extStr;
            parameters[11].Value = model.extStr2;
            parameters[12].Value = model.store_id;
            parameters[13].Value = model.tel;
            parameters[14].Value = model.daohangurl;
            parameters[15].Value = model.showDefault;
            parameters[16].Value = model.id;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #5
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public MxWeiXinPF.Model.wx_product_type DataRowToModel(DataRow row)
        {
            MxWeiXinPF.Model.wx_product_type model=new MxWeiXinPF.Model.wx_product_type();
            if (row != null)
            {
                if(row["id"]!=null && row["id"].ToString()!="")
                {
                    model.id=int.Parse(row["id"].ToString());
                }
                if(row["wid"]!=null && row["wid"].ToString()!="")
                {
                    model.wid=int.Parse(row["wid"].ToString());
                }
                if(row["parentId"]!=null && row["parentId"].ToString()!="")
                {
                    model.parentId=int.Parse(row["parentId"].ToString());
                }
                if(row["tCode"]!=null)
                {
                    model.tCode=row["tCode"].ToString();
                }
                if(row["tName"]!=null)
                {
                    model.tName=row["tName"].ToString();
                }
                if(row["tUrl"]!=null)
                {
                    model.tUrl=row["tUrl"].ToString();
                }
                if(row["class_layer"]!=null && row["class_layer"].ToString()!="")
                {
                    model.class_layer=int.Parse(row["class_layer"].ToString());
                }
                if(row["remark"]!=null)
                {
                    model.remark=row["remark"].ToString();
                }
                if(row["icoPic"]!=null)
                {
                    model.icoPic=row["icoPic"].ToString();
                }
                if(row["sort_id"]!=null && row["sort_id"].ToString()!="")
                {
                    model.sort_id=int.Parse(row["sort_id"].ToString());
                }
                if(row["creatDate"]!=null && row["creatDate"].ToString()!="")
                {
                    model.creatDate=DateTime.Parse(row["creatDate"].ToString());
                }
                if(row["extStr"]!=null)
                {
                    model.extStr=row["extStr"].ToString();
                }
                if(row["extStr2"]!=null)
                {
                    model.extStr2=row["extStr2"].ToString();
                }
                if (row["store_id"] != null && row["store_id"].ToString() != "")
                {
                    model.store_id = int.Parse(row["store_id"].ToString());
                }
                if (row["tel"] != null)
                {
                    model.tel = row["tel"].ToString();
                }
                if (row["daohangurl"] != null)
                {
                    model.daohangurl = row["daohangurl"].ToString();
                }
                if (row["showDefault"] != null && row["showDefault"].ToString() != "")
                {
                    if ((row["showDefault"].ToString() == "1") || (row["showDefault"].ToString().ToLower() == "true"))
                    {
                        model.showDefault = true;
                    }
                    else
                    {
                        model.showDefault = false;
                    }
                }

            }
            return model;
        }
Пример #6
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public MxWeiXinPF.Model.wx_product_type GetModel(int id)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select  top 1 id,wid,parentId,tCode,tName,tUrl,class_layer,remark,icoPic,sort_id,creatDate,extStr,extStr2,store_id,tel,daohangurl,showDefault from wx_product_type ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.Int,4)
            };
            parameters[0].Value = id;

            MxWeiXinPF.Model.wx_product_type model=new MxWeiXinPF.Model.wx_product_type();
            DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
            if(ds.Tables[0].Rows.Count>0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }