private bool DoEdit(int _id) { bool result = false; BLL.gift bll = new BLL.gift(); Model.gift model = bll.GetModel(_id); model.brand_id = Utils.StrToInt(ddlYear.SelectedValue + ddlMonth.SelectedValue, 0); model.gift_code = txtCode.Text; string type = ddlType.SelectedValue.Trim(); model.title = txtTitle.Text.Trim(); model.img_url = txtImgUrl.Text; model.type = type; //if (type == "2") //{ // model.article_list = ",0,"; // model.quantity = Utils.StrToInt(quantity.Text, 0); // model.amount = 0M; //} //else model.article_list = article_list.Text; if (type == "1") { //model.article_list = ",0,"; model.quantity = 0; model.amount = Utils.StrToDecimal(amount.Text, 0); } if (cbStatus.Checked) { model.status = 1; } else { model.status = 0; } model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99); model.left_quantity = Utils.StrToInt(txtLeftQuantity.Text, 0); model.content = txtContent.Value; if (bll.Update(model)) { AddAdminLog(TWEnums.ActionEnum.Edit.ToString(), "修改贈品:" + model.title); //記錄日誌 result = true; } return(result); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.gift model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "gift("); strSql.Append("title,img_url,type,article_list,brand_id,quantity,amount,sort_id,status,left_quantity,content,add_time,company,gift_code)"); strSql.Append(" values ("); strSql.Append("@title,@img_url,@type,@article_list,@brand_id,@quantity,@amount,@sort_id,@status,@left_quantity,@content,@add_time,@company,@gift_code)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.NVarChar, 255), new SqlParameter("@img_url", SqlDbType.NVarChar, 255), new SqlParameter("@type", SqlDbType.NVarChar, 50), new SqlParameter("@article_list", SqlDbType.NVarChar, 255), new SqlParameter("@brand_id", SqlDbType.Int, 4), new SqlParameter("@quantity", SqlDbType.Int, 4), new SqlParameter("@amount", SqlDbType.Decimal, 5), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@left_quantity", SqlDbType.Int, 4), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@company", SqlDbType.Int, 4), new SqlParameter("@gift_code", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.title; parameters[1].Value = model.img_url; parameters[2].Value = model.type; parameters[3].Value = model.article_list; parameters[4].Value = model.brand_id; parameters[5].Value = model.quantity; parameters[6].Value = model.amount; parameters[7].Value = model.sort_id; parameters[8].Value = model.status; parameters[9].Value = model.left_quantity; parameters[10].Value = model.content; parameters[11].Value = model.add_time; parameters[12].Value = model.company; parameters[13].Value = model.gift_code; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private bool DoAdd() { Model.gift model = new Model.gift(); BLL.gift bll = new BLL.gift(); model.brand_id = Utils.StrToInt((ddlYear.SelectedValue + ddlMonth.SelectedValue), 0); string type = ddlType.SelectedValue.Trim(); model.title = txtTitle.Text.Trim(); model.img_url = txtImgUrl.Text; model.type = type; //if (type == "2") //{ // model.article_list = ",0,"; // model.quantity = Utils.StrToInt(quantity.Text, 0); // model.amount = 0M; //} //else model.gift_code = txtCode.Text; model.article_list = article_list.Text; if (type == "1") { //model.article_list = ",0,"; model.quantity = 0; model.amount = Utils.StrToDecimal(amount.Text, 0); } if (cbStatus.Checked) { model.status = 1; } else { model.status = 0; } model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99); model.left_quantity = Utils.StrToInt(txtLeftQuantity.Text, 0); model.content = txtContent.Value; model.add_time = DateTime.Now; if (bll.Add(model) > 0) { AddAdminLog(TWEnums.ActionEnum.Add.ToString(), "添加贈品:" + model.title); //記錄日誌 return(true); } return(false); }
private void ShowInfo(int _id) { BLL.gift bll = new BLL.gift(); Model.gift model = bll.GetModel(_id); try { ddlYear.SelectedValue = model.brand_id.ToString().Substring(1, 4); ddlMonth.SelectedValue = model.brand_id.ToString().Substring(4, 2); } catch (Exception eee) { } txtCode.Text = model.gift_code; txtTitle.Text = model.title; txtImgUrl.Text = model.img_url; ddlType.SelectedValue = model.type; article_list.Text = model.article_list; quantity.Text = model.quantity.ToString(); amount.Text = model.amount.ToString(); txtSortId.Text = model.sort_id.ToString(); cbStatus.Checked = (model.status == 1); txtLeftQuantity.Text = model.left_quantity.ToString(); txtContent.Value = model.content; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.gift model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.gift model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.gift GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from " + databaseprefix + "gift "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.gift model = new Model.gift(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.title = ds.Tables[0].Rows[0]["title"].ToString(); model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString(); model.type = ds.Tables[0].Rows[0]["type"].ToString(); model.article_list = ds.Tables[0].Rows[0]["article_list"].ToString(); if (ds.Tables[0].Rows[0]["brand_id"].ToString() != "") { model.brand_id = int.Parse(ds.Tables[0].Rows[0]["brand_id"].ToString()); } if (ds.Tables[0].Rows[0]["quantity"].ToString() != "") { model.quantity = int.Parse(ds.Tables[0].Rows[0]["quantity"].ToString()); } if (ds.Tables[0].Rows[0]["amount"].ToString() != "") { model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString()); } if (ds.Tables[0].Rows[0]["sort_id"].ToString() != "") { model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString()); } if (ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["left_quantity"].ToString() != "") { model.left_quantity = int.Parse(ds.Tables[0].Rows[0]["left_quantity"].ToString()); } model.content = ds.Tables[0].Rows[0]["content"].ToString(); if (ds.Tables[0].Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString()); } if (ds.Tables[0].Rows[0]["company"].ToString() != "") { model.company = int.Parse(ds.Tables[0].Rows[0]["company"].ToString()); } model.gift_code = ds.Tables[0].Rows[0]["gift_code"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.gift model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "gift set "); strSql.Append("title=@title,"); strSql.Append("img_url=@img_url,"); strSql.Append("type=@type,"); strSql.Append("article_list=@article_list,"); strSql.Append("brand_id=@brand_id,"); strSql.Append("quantity=@quantity,"); strSql.Append("amount=@amount,"); strSql.Append("sort_id=@sort_id,"); strSql.Append("status=@status,"); strSql.Append("left_quantity=@left_quantity,"); strSql.Append("content=@content,"); strSql.Append("add_time=@add_time,"); strSql.Append("gift_code=@gift_code"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.NVarChar, 255), new SqlParameter("@img_url", SqlDbType.NVarChar, 255), new SqlParameter("@type", SqlDbType.NVarChar, 50), new SqlParameter("@article_list", SqlDbType.NVarChar, 255), new SqlParameter("@brand_id", SqlDbType.Int, 4), new SqlParameter("@quantity", SqlDbType.Int, 4), new SqlParameter("@amount", SqlDbType.Decimal, 5), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@left_quantity", SqlDbType.Int, 4), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@gift_code", SqlDbType.NVarChar, 100), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.title; parameters[1].Value = model.img_url; parameters[2].Value = model.type; parameters[3].Value = model.article_list; parameters[4].Value = model.brand_id; parameters[5].Value = model.quantity; parameters[6].Value = model.amount; parameters[7].Value = model.sort_id; parameters[8].Value = model.status; parameters[9].Value = model.left_quantity; parameters[10].Value = model.content; parameters[11].Value = model.add_time; parameters[12].Value = model.gift_code; parameters[13].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }