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);
}
}
