Ejemplo n.º 1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Tea.Model.basic model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update " + databaseprefix + "basic set ");
            strSql.Append("basic_label=@basic_label,");
            strSql.Append("basic_value=@basic_value,");
            strSql.Append("basic_sort=@basic_sort,");
            strSql.Append("basic_show=@basic_show,");
            strSql.Append("basic_type=@basic_type,");
            strSql.Append("basic_where=@basic_where,");
            strSql.Append("basic_pic=@basic_pic,");
            strSql.Append("basic_money=@basic_money,");
            strSql.Append("basic_content=@basic_content");
            strSql.Append(" where basic_id=@basic_id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@basic_label",   SqlDbType.NVarChar, 128),
                new SqlParameter("@basic_value",   SqlDbType.NVarChar, 128),
                new SqlParameter("@basic_sort",    SqlDbType.Int,        4),
                new SqlParameter("@basic_show",    SqlDbType.Int,        4),
                new SqlParameter("@basic_type",    SqlDbType.NVarChar, 128),
                new SqlParameter("@basic_where",   SqlDbType.NVarChar, 128),
                new SqlParameter("@basic_pic",     SqlDbType.NVarChar, 128),
                new SqlParameter("@basic_money",   SqlDbType.Money,      8),
                new SqlParameter("@basic_content", SqlDbType.NText),
                new SqlParameter("@basic_id",      SqlDbType.Int, 4)
            };
            parameters[0].Value = model.basic_label;
            parameters[1].Value = model.basic_value;
            parameters[2].Value = model.basic_sort;
            parameters[3].Value = model.basic_show;
            parameters[4].Value = model.basic_type;
            parameters[5].Value = model.basic_where;
            parameters[6].Value = model.basic_pic;
            parameters[7].Value = model.basic_money;
            parameters[8].Value = model.basic_content;
            parameters[9].Value = model.basic_id;

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

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Ejemplo n.º 2
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Tea.Model.basic DataRowToModel(DataRow row)
 {
     Tea.Model.basic model = new Tea.Model.basic();
     if (row != null)
     {
         if (row["basic_id"] != null && row["basic_id"].ToString() != "")
         {
             model.basic_id = int.Parse(row["basic_id"].ToString());
         }
         if (row["basic_label"] != null)
         {
             model.basic_label = row["basic_label"].ToString();
         }
         if (row["basic_value"] != null)
         {
             model.basic_value = row["basic_value"].ToString();
         }
         if (row["basic_sort"] != null && row["basic_sort"].ToString() != "")
         {
             model.basic_sort = int.Parse(row["basic_sort"].ToString());
         }
         if (row["basic_show"] != null && row["basic_show"].ToString() != "")
         {
             model.basic_show = int.Parse(row["basic_show"].ToString());
         }
         if (row["basic_type"] != null)
         {
             model.basic_type = row["basic_type"].ToString();
         }
         if (row["basic_where"] != null)
         {
             model.basic_where = row["basic_where"].ToString();
         }
         if (row["basic_pic"] != null)
         {
             model.basic_pic = row["basic_pic"].ToString();
         }
         if (row["basic_money"] != null && row["basic_money"].ToString() != "")
         {
             model.basic_money = decimal.Parse(row["basic_money"].ToString());
         }
         if (row["basic_content"] != null)
         {
             model.basic_content = row["basic_content"].ToString();
         }
     }
     return(model);
 }
Ejemplo n.º 3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Tea.Model.basic model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into " + databaseprefix + "basic(");
            strSql.Append("basic_label,basic_value,basic_sort,basic_show,basic_type,basic_where,basic_pic,basic_money,basic_content)");
            strSql.Append(" values (");
            strSql.Append("@basic_label,@basic_value,@basic_sort,@basic_show,@basic_type,@basic_where,@basic_pic,@basic_money,@basic_content)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@basic_label",   SqlDbType.NVarChar, 128),
                new SqlParameter("@basic_value",   SqlDbType.NVarChar, 128),
                new SqlParameter("@basic_sort",    SqlDbType.Int,        4),
                new SqlParameter("@basic_show",    SqlDbType.Int,        4),
                new SqlParameter("@basic_type",    SqlDbType.NVarChar, 128),
                new SqlParameter("@basic_where",   SqlDbType.NVarChar, 128),
                new SqlParameter("@basic_pic",     SqlDbType.NVarChar, 128),
                new SqlParameter("@basic_money",   SqlDbType.Money,      8),
                new SqlParameter("@basic_content", SqlDbType.NText)
            };
            parameters[0].Value = model.basic_label;
            parameters[1].Value = model.basic_value;
            parameters[2].Value = model.basic_sort;
            parameters[3].Value = model.basic_show;
            parameters[4].Value = model.basic_type;
            parameters[5].Value = model.basic_where;
            parameters[6].Value = model.basic_pic;
            parameters[7].Value = model.basic_money;
            parameters[8].Value = model.basic_content;

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

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Tea.Model.basic GetModel(string basic_label)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 basic_id,basic_label,basic_value,basic_sort,basic_show,basic_type,basic_where,basic_pic,basic_money,basic_content from " + databaseprefix + "basic ");
            strSql.Append(" where basic_label=@basic_label and basic_where='yunfei'");
            SqlParameter[] parameters =
            {
                new SqlParameter("@basic_label", SqlDbType.NVarChar, 128)
            };
            parameters[0].Value = basic_label;

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

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }