/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.dt_article_attribute_value model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_article_attribute_value("); strSql.Append("article_id,sub_title,source,author,goods_no,stock_quantity,market_price,sell_price,point,video_src,activity_sources,activity_integral,is_launchs,receive_address)"); strSql.Append(" values ("); strSql.Append("@article_id,@sub_title,@source,@author,@goods_no,@stock_quantity,@market_price,@sell_price,@point,@video_src,@activity_sources,@activity_integral,@is_launchs,@receive_address)"); SqlParameter[] parameters = { new SqlParameter("@article_id", SqlDbType.Int, 4), new SqlParameter("@sub_title", SqlDbType.NVarChar, 255), new SqlParameter("@source", SqlDbType.NVarChar, 100), new SqlParameter("@author", SqlDbType.NVarChar, 50), new SqlParameter("@goods_no", SqlDbType.NVarChar, 100), new SqlParameter("@stock_quantity", SqlDbType.Int, 4), new SqlParameter("@market_price", SqlDbType.Decimal, 5), new SqlParameter("@sell_price", SqlDbType.Decimal, 5), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@video_src", SqlDbType.NVarChar, 255), new SqlParameter("@activity_sources", SqlDbType.NVarChar, 4), new SqlParameter("@activity_integral", SqlDbType.Int, 4), new SqlParameter("@is_launchs", SqlDbType.Int, 4), new SqlParameter("@receive_address", SqlDbType.NText) }; parameters[0].Value = model.article_id; parameters[1].Value = model.sub_title; parameters[2].Value = model.source; parameters[3].Value = model.author; parameters[4].Value = model.goods_no; parameters[5].Value = model.stock_quantity; parameters[6].Value = model.market_price; parameters[7].Value = model.sell_price; parameters[8].Value = model.point; parameters[9].Value = model.video_src; parameters[10].Value = model.activity_sources; parameters[11].Value = model.activity_integral; parameters[12].Value = model.is_launchs; parameters[13].Value = model.receive_address; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.dt_article_attribute_value GetModel(int article_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 article_id,sub_title,source,author,goods_no,stock_quantity,market_price,sell_price,point,video_src,activity_sources,activity_integral,is_launchs,receive_address from dt_article_attribute_value "); strSql.Append(" where article_id=@article_id "); SqlParameter[] parameters = { new SqlParameter("@article_id", SqlDbType.Int, 4) }; parameters[0].Value = article_id; Model.dt_article_attribute_value model = new Model.dt_article_attribute_value(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.dt_article_attribute_value DataRowToModel(DataRow row) { Model.dt_article_attribute_value model = new Model.dt_article_attribute_value(); if (row != null) { if (row["article_id"] != null && row["article_id"].ToString() != "") { model.article_id = int.Parse(row["article_id"].ToString()); } if (row["sub_title"] != null) { model.sub_title = row["sub_title"].ToString(); } if (row["source"] != null) { model.source = row["source"].ToString(); } if (row["author"] != null) { model.author = row["author"].ToString(); } if (row["goods_no"] != null) { model.goods_no = row["goods_no"].ToString(); } if (row["stock_quantity"] != null && row["stock_quantity"].ToString() != "") { model.stock_quantity = int.Parse(row["stock_quantity"].ToString()); } if (row["market_price"] != null && row["market_price"].ToString() != "") { model.market_price = decimal.Parse(row["market_price"].ToString()); } if (row["sell_price"] != null && row["sell_price"].ToString() != "") { model.sell_price = decimal.Parse(row["sell_price"].ToString()); } if (row["point"] != null && row["point"].ToString() != "") { model.point = int.Parse(row["point"].ToString()); } if (row["video_src"] != null) { model.video_src = row["video_src"].ToString(); } if (row["activity_sources"] != null) { model.activity_sources = row["activity_sources"].ToString(); } if (row["activity_integral"] != null && row["activity_integral"].ToString() != "") { model.activity_integral = int.Parse(row["activity_integral"].ToString()); } if (row["is_launchs"] != null && row["is_launchs"].ToString() != "") { model.is_launchs = int.Parse(row["is_launchs"].ToString()); } if (row["receive_address"] != null) { model.receive_address = row["receive_address"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.dt_article_attribute_value model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_article_attribute_value set "); strSql.Append("sub_title=@sub_title,"); strSql.Append("source=@source,"); strSql.Append("author=@author,"); strSql.Append("goods_no=@goods_no,"); strSql.Append("stock_quantity=@stock_quantity,"); strSql.Append("market_price=@market_price,"); strSql.Append("sell_price=@sell_price,"); strSql.Append("point=@point,"); strSql.Append("video_src=@video_src,"); strSql.Append("activity_sources=@activity_sources,"); strSql.Append("activity_integral=@activity_integral,"); strSql.Append("is_launchs=@is_launchs,"); strSql.Append("receive_address=@receive_address"); strSql.Append(" where article_id=@article_id "); SqlParameter[] parameters = { new SqlParameter("@sub_title", SqlDbType.NVarChar, 255), new SqlParameter("@source", SqlDbType.NVarChar, 100), new SqlParameter("@author", SqlDbType.NVarChar, 50), new SqlParameter("@goods_no", SqlDbType.NVarChar, 100), new SqlParameter("@stock_quantity", SqlDbType.Int, 4), new SqlParameter("@market_price", SqlDbType.Decimal, 5), new SqlParameter("@sell_price", SqlDbType.Decimal, 5), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@video_src", SqlDbType.NVarChar, 255), new SqlParameter("@activity_sources", SqlDbType.NVarChar, 4), new SqlParameter("@activity_integral", SqlDbType.Int, 4), new SqlParameter("@is_launchs", SqlDbType.Int, 4), new SqlParameter("@receive_address", SqlDbType.NText), new SqlParameter("@article_id", SqlDbType.Int, 4) }; parameters[0].Value = model.sub_title; parameters[1].Value = model.source; parameters[2].Value = model.author; parameters[3].Value = model.goods_no; parameters[4].Value = model.stock_quantity; parameters[5].Value = model.market_price; parameters[6].Value = model.sell_price; parameters[7].Value = model.point; parameters[8].Value = model.video_src; parameters[9].Value = model.activity_sources; parameters[10].Value = model.activity_integral; parameters[11].Value = model.is_launchs; parameters[12].Value = model.receive_address; parameters[13].Value = model.article_id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void get_active_source() { BLL.dt_article_attribute_value bll = new BLL.dt_article_attribute_value(); Model.dt_article_attribute_value model = bll.GetModel(activeID); sourceActive = model.activity_integral == null ? 0 : (int)model.activity_integral; }