/// <summary> /// 获得Model /// </summary> /// <param name="Top">大于0取前几行数据,否则取全部</param> /// <param name="whereStr">where条件</param> /// <param name="filedOrder">排序字段Order By + filedOrder (不可为空)</param> /// <returns></returns> public Model.user_cart GetModel(int Top, string whereStr, string filedOrder) { DataTable dt = dal.GetList(Top, whereStr, filedOrder).Tables[0]; Model.user_cart model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
/// <summary> /// 获得Model /// </summary> /// <param name="whereStr"></param> /// <returns></returns> public Model.user_cart GetModel(string whereStr) { DataTable dt = dal.GetList(whereStr).Tables[0]; Model.user_cart model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_user_cart", EnumCollection.ActionEnum.Modify.ToString()); //检查权限 BLL.user_cart bll = new BLL.user_cart(); Model.user_cart model = bll.GetModel(this.id); model.ct_id = Convert.ToInt32(txtct_id.Text); model.group_id = Convert.ToInt32(txtgroup_id.Text); model.user_id = Convert.ToInt32(txtuser_id.Text); model.goods_sale_type = Convert.ToInt32(txtgoods_sale_type.Text); model.goods_id = Convert.ToInt32(txtgoods_id.Text); model.goods_name = Convert.ToString(txtgoods_name.Text); model.goods_subtitle = Convert.ToString(txtgoods_subtitle.Text); model.goods_img = Convert.ToString(txtgoods_img.Text); model.goods_oprice = Convert.ToDecimal(txtgoods_oprice.Text); model.goods_price = Convert.ToDecimal(txtgoods_price.Text); model.goods_spec = Convert.ToString(txtgoods_spec.Text); model.goods_spec_id = Convert.ToString(txtgoods_spec_id.Text); model.num = Convert.ToInt32(txtnum.Text); model.add_time = Convert.ToDateTime(txtadd_time.Text); if (bll.Update(model)) { AddAdminLog(EnumCollection.ActionEnum.Modify.ToString(), "修改购物车表信息,主键:" + id); //记录日志 JscriptMsg("修改购物车表信息成功!", "Manage.aspx"); } else { JscriptMsg("保存过程中发生错误!", ""); } }
private void BindInfo() { BLL.user_cart bll = new BLL.user_cart(); Model.user_cart model = bll.GetModel(this.id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } txtct_id.Text = model.ct_id + ""; txtgroup_id.Text = model.group_id + ""; txtuser_id.Text = model.user_id + ""; txtgoods_sale_type.Text = model.goods_sale_type + ""; txtgoods_id.Text = model.goods_id + ""; txtgoods_name.Text = model.goods_name + ""; txtgoods_subtitle.Text = model.goods_subtitle + ""; txtgoods_img.Text = model.goods_img + ""; txtgoods_oprice.Text = model.goods_oprice + ""; txtgoods_price.Text = model.goods_price + ""; txtgoods_spec.Text = model.goods_spec + ""; txtgoods_spec_id.Text = model.goods_spec_id + ""; txtnum.Text = model.num + ""; txtadd_time.Text = model.add_time + ""; }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_user_cart", EnumCollection.ActionEnum.Add.ToString()); //检查权限 #region string strError = string.Empty; if (txtct_id.Text.Trim() == "" || txtct_id.Text.Trim().Length > 4) { strError += "商家id为空或超出长度![br]"; } if (txtgroup_id.Text.Trim() == "" || txtgroup_id.Text.Trim().Length > 4) { strError += "分组id为空或超出长度![br]"; } if (txtuser_id.Text.Trim() == "" || txtuser_id.Text.Trim().Length > 4) { strError += "购买者id为空或超出长度![br]"; } if (txtgoods_sale_type.Text.Trim() == "" || txtgoods_sale_type.Text.Trim().Length > 4) { strError += "商品销售类型为空或超出长度![br]"; } if (txtgoods_id.Text.Trim() == "" || txtgoods_id.Text.Trim().Length > 4) { strError += "商品id为空或超出长度![br]"; } if (txtgoods_name.Text.Trim() == "" || txtgoods_name.Text.Trim().Length > 200) { strError += "标题为空或超出长度![br]"; } if (txtgoods_subtitle.Text.Trim() == "" || txtgoods_subtitle.Text.Trim().Length > 200) { strError += "副标题为空或超出长度![br]"; } if (txtgoods_img.Text.Trim() == "" || txtgoods_img.Text.Trim().Length > 255) { strError += "封面图为空或超出长度![br]"; } if (txtgoods_oprice.Text.Trim() == "" || txtgoods_oprice.Text.Trim().Length > 8) { strError += "原价为空或超出长度![br]"; } if (txtgoods_price.Text.Trim() == "" || txtgoods_price.Text.Trim().Length > 8) { strError += "现价为空或超出长度![br]"; } if (txtgoods_spec.Text.Trim() == "" || txtgoods_spec.Text.Trim().Length > 4000) { strError += "规格值为空或超出长度![br]"; } if (txtgoods_spec_id.Text.Trim() == "" || txtgoods_spec_id.Text.Trim().Length > 255) { strError += "规格id为空或超出长度![br]"; } if (txtnum.Text.Trim() == "" || txtnum.Text.Trim().Length > 4) { strError += "数量为空或超出长度![br]"; } if (txtadd_time.Text.Trim() == "" || txtadd_time.Text.Trim().Length > 8) { strError += "添加时间为空或超出长度![br]"; } if (strError != string.Empty) { JscriptMsg(strError, "", "Error"); return; } #endregion Model.user_cart model = new Model.user_cart(); BLL.user_cart bll = new BLL.user_cart(); model.ct_id = Convert.ToInt32(txtct_id.Text); model.group_id = Convert.ToInt32(txtgroup_id.Text); model.user_id = Convert.ToInt32(txtuser_id.Text); model.goods_sale_type = Convert.ToInt32(txtgoods_sale_type.Text); model.goods_id = Convert.ToInt32(txtgoods_id.Text); model.goods_name = Convert.ToString(txtgoods_name.Text); model.goods_subtitle = Convert.ToString(txtgoods_subtitle.Text); model.goods_img = Convert.ToString(txtgoods_img.Text); model.goods_oprice = Convert.ToDecimal(txtgoods_oprice.Text); model.goods_price = Convert.ToDecimal(txtgoods_price.Text); model.goods_spec = Convert.ToString(txtgoods_spec.Text); model.goods_spec_id = Convert.ToString(txtgoods_spec_id.Text); model.num = Convert.ToInt32(txtnum.Text); model.add_time = Convert.ToDateTime(txtadd_time.Text); int id = bll.Add(model); if (id > 0) { AddAdminLog(EnumCollection.ActionEnum.Add.ToString(), "添加购物车表信息,主键:" + id); //记录日志 JscriptMsg("添加购物车表信息成功!", "Manage.aspx", ""); } else { JscriptMsg("保存过程中发生错误!", ""); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.user_cart DataRowToModel(DataRow row) { Model.user_cart model = new Model.user_cart(); if (row != null) { if (row["id"] != null) //&& row["id"].ToString() != "" { model.id = Convert.ToInt32(row["id"]); } if (row["ct_id"] != null) //&& row["ct_id"].ToString() != "" { model.ct_id = Convert.ToInt32(row["ct_id"]); } if (row["group_id"] != null) //&& row["group_id"].ToString() != "" { model.group_id = Convert.ToInt32(row["group_id"]); } if (row["user_id"] != null) //&& row["user_id"].ToString() != "" { model.user_id = Convert.ToInt32(row["user_id"]); } if (row["goods_sale_type"] != null) //&& row["goods_sale_type"].ToString() != "" { model.goods_sale_type = Convert.ToInt32(row["goods_sale_type"]); } if (row["goods_id"] != null) //&& row["goods_id"].ToString() != "" { model.goods_id = Convert.ToInt32(row["goods_id"]); } if (row["goods_name"] != null) //&& row["goods_name"].ToString() != "" { model.goods_name = Convert.ToString(row["goods_name"]); } if (row["goods_subtitle"] != null) //&& row["goods_subtitle"].ToString() != "" { model.goods_subtitle = Convert.ToString(row["goods_subtitle"]); } if (row["goods_img"] != null) //&& row["goods_img"].ToString() != "" { model.goods_img = Convert.ToString(row["goods_img"]); } if (row["goods_oprice"] != null) //&& row["goods_oprice"].ToString() != "" { model.goods_oprice = Convert.ToDecimal(row["goods_oprice"]); } if (row["goods_price"] != null) //&& row["goods_price"].ToString() != "" { model.goods_price = Convert.ToDecimal(row["goods_price"]); } if (row["goods_spec"] != null) //&& row["goods_spec"].ToString() != "" { model.goods_spec = Convert.ToString(row["goods_spec"]); } if (row["goods_spec_id"] != null) //&& row["goods_spec_id"].ToString() != "" { model.goods_spec_id = Convert.ToString(row["goods_spec_id"]); } if (row["num"] != null) //&& row["num"].ToString() != "" { model.num = Convert.ToInt32(row["num"]); } if (row["add_time"] != null && row["add_time"].ToString() != "") { model.add_time = Convert.ToDateTime(row["add_time"]); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_cart model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_cart model) { return(dal.Add(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_cart model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"Insert Into ybd_user_cart( ct_id ,group_id ,user_id ,goods_sale_type ,goods_id ,goods_name ,goods_subtitle ,goods_img ,goods_oprice ,goods_price ,goods_spec ,goods_spec_id ,num ,add_time ) Values ( @ct_id ,@group_id ,@user_id ,@goods_sale_type ,@goods_id ,@goods_name ,@goods_subtitle ,@goods_img ,@goods_oprice ,@goods_price ,@goods_spec ,@goods_spec_id ,@num ,@add_time ); SELECT @@IDENTITY;"); SqlParameter[] parameters = { new SqlParameter("@ct_id", SqlDbType.Int, 4) , new SqlParameter("@group_id", SqlDbType.Int, 4) , new SqlParameter("@user_id", SqlDbType.Int, 4) , new SqlParameter("@goods_sale_type", SqlDbType.Int, 4) , new SqlParameter("@goods_id", SqlDbType.Int, 4) , new SqlParameter("@goods_name", SqlDbType.NVarChar, 200) , new SqlParameter("@goods_subtitle", SqlDbType.NVarChar, 200) , new SqlParameter("@goods_img", SqlDbType.NVarChar, 255) , new SqlParameter("@goods_oprice", SqlDbType.Money, 8) , new SqlParameter("@goods_price", SqlDbType.Money, 8) , new SqlParameter("@goods_spec", SqlDbType.NVarChar, 4000) , new SqlParameter("@goods_spec_id", SqlDbType.NVarChar, 255) , new SqlParameter("@num", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.ct_id; parameters[1].Value = model.group_id; parameters[2].Value = model.user_id; parameters[3].Value = model.goods_sale_type; parameters[4].Value = model.goods_id; parameters[5].Value = model.goods_name; parameters[6].Value = model.goods_subtitle; parameters[7].Value = model.goods_img; parameters[8].Value = model.goods_oprice; parameters[9].Value = model.goods_price; parameters[10].Value = model.goods_spec; parameters[11].Value = model.goods_spec_id; parameters[12].Value = model.num; parameters[13].Value = model.add_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_cart model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"UPDATE ybd_user_cart SET ct_id = @ct_id ,group_id = @group_id ,user_id = @user_id ,goods_sale_type = @goods_sale_type ,goods_id = @goods_id ,goods_name = @goods_name ,goods_subtitle = @goods_subtitle ,goods_img = @goods_img ,goods_oprice = @goods_oprice ,goods_price = @goods_price ,goods_spec = @goods_spec ,goods_spec_id = @goods_spec_id ,num = @num ,add_time = @add_time WHERE id = @id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) , new SqlParameter("@ct_id", SqlDbType.Int, 4) , new SqlParameter("@group_id", SqlDbType.Int, 4) , new SqlParameter("@user_id", SqlDbType.Int, 4) , new SqlParameter("@goods_sale_type", SqlDbType.Int, 4) , new SqlParameter("@goods_id", SqlDbType.Int, 4) , new SqlParameter("@goods_name", SqlDbType.NVarChar, 200) , new SqlParameter("@goods_subtitle", SqlDbType.NVarChar, 200) , new SqlParameter("@goods_img", SqlDbType.NVarChar, 255) , new SqlParameter("@goods_oprice", SqlDbType.Money, 8) , new SqlParameter("@goods_price", SqlDbType.Money, 8) , new SqlParameter("@goods_spec", SqlDbType.NVarChar, 4000) , new SqlParameter("@goods_spec_id", SqlDbType.NVarChar, 255) , new SqlParameter("@num", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.id; parameters[1].Value = model.ct_id; parameters[2].Value = model.group_id; parameters[3].Value = model.user_id; parameters[4].Value = model.goods_sale_type; parameters[5].Value = model.goods_id; parameters[6].Value = model.goods_name; parameters[7].Value = model.goods_subtitle; parameters[8].Value = model.goods_img; parameters[9].Value = model.goods_oprice; parameters[10].Value = model.goods_price; parameters[11].Value = model.goods_spec; parameters[12].Value = model.goods_spec_id; parameters[13].Value = model.num; parameters[14].Value = model.add_time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }