protected void Page_Load(object sender, EventArgs e) { id = TWRequest.GetQueryInt("id"); if (id > 0) { model_quan = bll_quan.GetModel(id); } if (!Page.IsPostBack) { if (model_quan != null) { try { txtBeginTime.Text = model_quan.quan_begin_date.Value.ToString("yyyy-MM-dd"); } catch (Exception eee) { } try { txtEndTime.Text = model_quan.quan_end_date.Value.ToString("yyyy-MM-dd"); } catch (Exception eee) { } txtTitle.Text = model_quan.quan_title; amount.Text = model_quan.quan_num.Value.ToString("0."); txtJin.Text = model_quan.quan_sort.GetValueOrDefault().ToString(); if (!string.IsNullOrEmpty(model_quan.quan_des)) { rptGroup.DataSource = Tea.DBUtility.DbHelperSQL.Query("select * from view_goods where id in(" + model_quan.quan_des + ")"); rptGroup.DataBind(); } } //ChkAdminLevel("user_sms", TWEnums.ActionEnum.View.ToString()); //檢查權限 } }
public Tea.Model.quan GetModel(string quan_code) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 quan_id,quan_user,quan_username,quan_name,quan_title,quan_lock,quan_add_date,quan_begin_date,quan_end_date,quan_date,quan_code,quan_pwd,quan_where,quan_show,quan_type,quan_des,quan_sort,quan_pic,quan_admin,quan_adminname,quan_num from " + databaseprefix + "quan "); strSql.Append(" where quan_code=@quan_code"); SqlParameter[] parameters = { new SqlParameter("@quan_code", SqlDbType.NVarChar, 64) }; parameters[0].Value = quan_code; Tea.Model.quan model = new Tea.Model.quan(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
//發送折扣券 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevelEdit("sys_settings", "Edit"); //ChkAdminLevel("user_sms", TWEnums.ActionEnum.Add.ToString()); //檢查權限 //檢查折扣券內容 if (amount.Text.Trim() == "") { JscriptMsg("請輸入金額!", ""); return; } if (txtEndTime.Text.Trim() == "") { JscriptMsg("請輸入到期時間!", ""); return; } //開始發送折扣券 string msg = string.Empty; bool result = false; Tea.Model.quan model = null; bool update = true; if (id > 0) { model = bll_quan.GetModel(id); } if (model == null) { model = new Model.quan(); update = false; } model.quan_title = txtTitle.Text; model.quan_add_date = System.DateTime.Now; model.quan_begin_date = Utils.StrToDateTime(txtBeginTime.Text, System.DateTime.Now); model.quan_end_date = Utils.StrToDateTime(txtEndTime.Text, System.DateTime.Now); model.quan_where = "lin"; model.quan_num = Utils.StrToDecimal(amount.Text, 0); #region 保存组合商品============== BLL.goods_group bll_good_group = new BLL.goods_group(); StringBuilder idList = new StringBuilder(); string[] goodsGroupIdArr = Request.Form.GetValues("goods_group_id"); string[] parentIdArr = Request.Form.GetValues("parent_id"); string[] goodsIdArr = Request.Form.GetValues("goods_id"); if (goodsGroupIdArr != null && parentIdArr != null && goodsIdArr != null && goodsGroupIdArr.Length > 0 && parentIdArr.Length > 0 && goodsIdArr.Length > 0) { for (int i = 0; i < goodsGroupIdArr.Length; i++) { int groupGoodsId = Utils.StrToInt(goodsGroupIdArr[i], 0); int parentId = Utils.StrToInt(parentIdArr[i], 0); int goodsId = Utils.StrToInt(goodsIdArr[i], 0); idList.Append(goodsId + ","); } } model.quan_des = idList.ToString() + "0"; #endregion model.quan_sort = Utils.StrToInt(txtJin.Text, 0); if (update) { bll_quan.Update(model); } else { model.quan_code = ljd.function.getUUIDString(12); bll_quan.Add(model); } if (result) { AddAdminLog(TWEnums.ActionEnum.Add.ToString(), "折扣券"); //記錄日誌 JscriptMsg("設定優惠券", "lin_list.aspx"); return; } else { JscriptMsg("設定優惠券", "lin_list.aspx"); return; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Tea.Model.quan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "quan("); strSql.Append("quan_user,quan_username,quan_name,quan_title,quan_lock,quan_add_date,quan_begin_date,quan_end_date,quan_date,quan_code,quan_pwd,quan_where,quan_show,quan_type,quan_des,quan_sort,quan_pic,quan_admin,quan_adminname,quan_num)"); strSql.Append(" values ("); strSql.Append("@quan_user,@quan_username,@quan_name,@quan_title,@quan_lock,@quan_add_date,@quan_begin_date,@quan_end_date,@quan_date,@quan_code,@quan_pwd,@quan_where,@quan_show,@quan_type,@quan_des,@quan_sort,@quan_pic,@quan_admin,@quan_adminname,@quan_num)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@quan_user", SqlDbType.Int, 4), new SqlParameter("@quan_username", SqlDbType.NVarChar, 64), new SqlParameter("@quan_name", SqlDbType.NVarChar, 256), new SqlParameter("@quan_title", SqlDbType.NVarChar, 256), new SqlParameter("@quan_lock", SqlDbType.Int, 4), new SqlParameter("@quan_add_date", SqlDbType.DateTime), new SqlParameter("@quan_begin_date", SqlDbType.DateTime), new SqlParameter("@quan_end_date", SqlDbType.DateTime), new SqlParameter("@quan_date", SqlDbType.DateTime), new SqlParameter("@quan_code", SqlDbType.NVarChar, 64), new SqlParameter("@quan_pwd", SqlDbType.NVarChar, 64), new SqlParameter("@quan_where", SqlDbType.NVarChar, 32), new SqlParameter("@quan_show", SqlDbType.Int, 4), new SqlParameter("@quan_type", SqlDbType.NVarChar, 32), new SqlParameter("@quan_des", SqlDbType.NText), new SqlParameter("@quan_sort", SqlDbType.Int, 4), new SqlParameter("@quan_pic", SqlDbType.NVarChar, 128), new SqlParameter("@quan_admin", SqlDbType.Int, 4), new SqlParameter("@quan_adminname", SqlDbType.NVarChar, 64), new SqlParameter("@quan_num", SqlDbType.Money, 8) }; parameters[0].Value = model.quan_user; parameters[1].Value = model.quan_username; parameters[2].Value = model.quan_name; parameters[3].Value = model.quan_title; parameters[4].Value = model.quan_lock; parameters[5].Value = model.quan_add_date; parameters[6].Value = model.quan_begin_date; parameters[7].Value = model.quan_end_date; parameters[8].Value = model.quan_date; parameters[9].Value = model.quan_code; parameters[10].Value = model.quan_pwd; parameters[11].Value = model.quan_where; parameters[12].Value = model.quan_show; parameters[13].Value = model.quan_type; parameters[14].Value = model.quan_des; parameters[15].Value = model.quan_sort; parameters[16].Value = model.quan_pic; parameters[17].Value = model.quan_admin; parameters[18].Value = model.quan_adminname; parameters[19].Value = model.quan_num; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Tea.Model.quan DataRowToModel(DataRow row) { Tea.Model.quan model = new Tea.Model.quan(); if (row != null) { if (row["quan_id"] != null && row["quan_id"].ToString() != "") { model.quan_id = int.Parse(row["quan_id"].ToString()); } if (row["quan_user"] != null && row["quan_user"].ToString() != "") { model.quan_user = int.Parse(row["quan_user"].ToString()); } if (row["quan_username"] != null) { model.quan_username = row["quan_username"].ToString(); } if (row["quan_name"] != null) { model.quan_name = row["quan_name"].ToString(); } if (row["quan_title"] != null) { model.quan_title = row["quan_title"].ToString(); } if (row["quan_lock"] != null && row["quan_lock"].ToString() != "") { model.quan_lock = int.Parse(row["quan_lock"].ToString()); } if (row["quan_add_date"] != null && row["quan_add_date"].ToString() != "") { model.quan_add_date = DateTime.Parse(row["quan_add_date"].ToString()); } if (row["quan_begin_date"] != null && row["quan_begin_date"].ToString() != "") { model.quan_begin_date = DateTime.Parse(row["quan_begin_date"].ToString()); } if (row["quan_end_date"] != null && row["quan_end_date"].ToString() != "") { model.quan_end_date = DateTime.Parse(row["quan_end_date"].ToString()); } if (row["quan_date"] != null && row["quan_date"].ToString() != "") { model.quan_date = DateTime.Parse(row["quan_date"].ToString()); } if (row["quan_code"] != null) { model.quan_code = row["quan_code"].ToString(); } if (row["quan_pwd"] != null) { model.quan_pwd = row["quan_pwd"].ToString(); } if (row["quan_where"] != null) { model.quan_where = row["quan_where"].ToString(); } if (row["quan_show"] != null && row["quan_show"].ToString() != "") { model.quan_show = int.Parse(row["quan_show"].ToString()); } if (row["quan_type"] != null) { model.quan_type = row["quan_type"].ToString(); } if (row["quan_des"] != null) { model.quan_des = row["quan_des"].ToString(); } if (row["quan_sort"] != null && row["quan_sort"].ToString() != "") { model.quan_sort = int.Parse(row["quan_sort"].ToString()); } if (row["quan_pic"] != null) { model.quan_pic = row["quan_pic"].ToString(); } if (row["quan_admin"] != null && row["quan_admin"].ToString() != "") { model.quan_admin = int.Parse(row["quan_admin"].ToString()); } if (row["quan_adminname"] != null) { model.quan_adminname = row["quan_adminname"].ToString(); } if (row["quan_num"] != null && row["quan_num"].ToString() != "") { model.quan_num = decimal.Parse(row["quan_num"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Tea.Model.quan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "quan set "); strSql.Append("quan_user=@quan_user,"); strSql.Append("quan_username=@quan_username,"); strSql.Append("quan_name=@quan_name,"); strSql.Append("quan_title=@quan_title,"); strSql.Append("quan_lock=@quan_lock,"); strSql.Append("quan_add_date=@quan_add_date,"); strSql.Append("quan_begin_date=@quan_begin_date,"); strSql.Append("quan_end_date=@quan_end_date,"); strSql.Append("quan_date=@quan_date,"); strSql.Append("quan_code=@quan_code,"); strSql.Append("quan_pwd=@quan_pwd,"); strSql.Append("quan_where=@quan_where,"); strSql.Append("quan_show=@quan_show,"); strSql.Append("quan_type=@quan_type,"); strSql.Append("quan_des=@quan_des,"); strSql.Append("quan_sort=@quan_sort,"); strSql.Append("quan_pic=@quan_pic,"); strSql.Append("quan_admin=@quan_admin,"); strSql.Append("quan_adminname=@quan_adminname,"); strSql.Append("quan_num=@quan_num"); strSql.Append(" where quan_id=@quan_id"); SqlParameter[] parameters = { new SqlParameter("@quan_user", SqlDbType.Int, 4), new SqlParameter("@quan_username", SqlDbType.NVarChar, 64), new SqlParameter("@quan_name", SqlDbType.NVarChar, 256), new SqlParameter("@quan_title", SqlDbType.NVarChar, 256), new SqlParameter("@quan_lock", SqlDbType.Int, 4), new SqlParameter("@quan_add_date", SqlDbType.DateTime), new SqlParameter("@quan_begin_date", SqlDbType.DateTime), new SqlParameter("@quan_end_date", SqlDbType.DateTime), new SqlParameter("@quan_date", SqlDbType.DateTime), new SqlParameter("@quan_code", SqlDbType.NVarChar, 64), new SqlParameter("@quan_pwd", SqlDbType.NVarChar, 64), new SqlParameter("@quan_where", SqlDbType.NVarChar, 32), new SqlParameter("@quan_show", SqlDbType.Int, 4), new SqlParameter("@quan_type", SqlDbType.NVarChar, 32), new SqlParameter("@quan_des", SqlDbType.NText), new SqlParameter("@quan_sort", SqlDbType.Int, 4), new SqlParameter("@quan_pic", SqlDbType.NVarChar, 128), new SqlParameter("@quan_admin", SqlDbType.Int, 4), new SqlParameter("@quan_adminname", SqlDbType.NVarChar, 64), new SqlParameter("@quan_num", SqlDbType.Money, 8), new SqlParameter("@quan_id", SqlDbType.Int, 4) }; parameters[0].Value = model.quan_user; parameters[1].Value = model.quan_username; parameters[2].Value = model.quan_name; parameters[3].Value = model.quan_title; parameters[4].Value = model.quan_lock; parameters[5].Value = model.quan_add_date; parameters[6].Value = model.quan_begin_date; parameters[7].Value = model.quan_end_date; parameters[8].Value = model.quan_date; parameters[9].Value = model.quan_code; parameters[10].Value = model.quan_pwd; parameters[11].Value = model.quan_where; parameters[12].Value = model.quan_show; parameters[13].Value = model.quan_type; parameters[14].Value = model.quan_des; parameters[15].Value = model.quan_sort; parameters[16].Value = model.quan_pic; parameters[17].Value = model.quan_admin; parameters[18].Value = model.quan_adminname; parameters[19].Value = model.quan_num; parameters[20].Value = model.quan_id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }