/// <summary> /// 获得Model /// </summary> /// <param name="whereStr"></param> /// <returns></returns> public Model.user_address GetModel(string whereStr) { DataTable dt = dal.GetList(whereStr).Tables[0]; Model.user_address model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
/// <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_address GetModel(int Top, string whereStr, string filedOrder) { DataTable dt = dal.GetList(Top, whereStr, filedOrder).Tables[0]; Model.user_address model = dt.Rows.Count > 0 ? DataRowToModel(dt.Rows[0]) : null; return(model); }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_user_address", EnumCollection.ActionEnum.Modify.ToString()); //检查权限 BLL.user_address bll = new BLL.user_address(); Model.user_address model = bll.GetModel(this.id); model.type = Convert.ToInt32(txttype.Text); model.type_name = Convert.ToString(txttype_name.Text); model.user_id = Convert.ToInt32(txtuser_id.Text); model.name = Convert.ToString(txtname.Text); model.mobile = Convert.ToString(txtmobile.Text); model.tel = Convert.ToString(txttel.Text); model.sheng = Convert.ToString(txtsheng.Text); model.shi = Convert.ToString(txtshi.Text); model.xian = Convert.ToString(txtxian.Text); model.area = Convert.ToString(txtarea.Text); model.address = Convert.ToString(txtaddress.Text); model.postcode = Convert.ToString(txtpostcode.Text); model.IDCard = Convert.ToString(txtIDCard.Text); model.is_default = Convert.ToInt32(txtis_default.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_address bll = new BLL.user_address(); Model.user_address model = bll.GetModel(this.id); if (model == null) { JscriptMsg("信息不存在或已被删除!", "back"); return; } txttype.Text = model.type + ""; txttype_name.Text = model.type_name + ""; txtuser_id.Text = model.user_id + ""; txtname.Text = model.name + ""; txtmobile.Text = model.mobile + ""; txttel.Text = model.tel + ""; txtsheng.Text = model.sheng + ""; txtshi.Text = model.shi + ""; txtxian.Text = model.xian + ""; txtarea.Text = model.area + ""; txtaddress.Text = model.address + ""; txtpostcode.Text = model.postcode + ""; txtIDCard.Text = model.IDCard + ""; txtis_default.Text = model.is_default + ""; txtadd_time.Text = model.add_time + ""; }
protected void Page_Load(object sender, EventArgs e) { this.id = Vincent._DTcms.DTRequest.GetQueryInt("id", 0); this.refund_id = Vincent._DTcms.DTRequest.GetQueryInt("refund_id", 0); //如果传过来的是退货id if (this.id == 0) { this.id = this.refund_id; if (this.id == 0) { JscriptMsg("传输参数不正确!", "back", "Error"); return; } Model.refund refund = new BLL.refund().GetModel(this.id); if (!new BLL.orders().Exists(refund.order_no)) { JscriptMsg("记录不存在或已被删除!", "back", "Error"); return; } if (!Page.IsPostBack) { ChkAdminLevel("order_edit", Vincent._DTcms.DTEnums.ActionEnum.View.ToString()); //检查权限 ShowInfos(refund.order_no); orderStatus(); } addressModel = new BuysingooShop.BLL.user_address().GetModels(refund.user_id); } else { if (this.id == 0) { JscriptMsg("传输参数不正确!", "back", "Error"); return; } //Model.refund refund = new BLL.refund().GetModel(this.id); model = new BLL.orders().GetModel(this.id); if (model == null) { JscriptMsg("记录不存在或已被删除!", "back", "Error"); return; } if (!Page.IsPostBack) { ChkAdminLevel("order_list", Vincent._DTcms.DTEnums.ActionEnum.View.ToString()); //检查权限 ShowInfos(model.order_no); orderStatus(); } addressModel = new BuysingooShop.BLL.user_address().GetModels(model.user_id); } }
private void ShowInfo(int _id) { BLL.user_address bll = new BLL.user_address(); Model.user_address model = bll.GetModel(_id); txtNickName.Text = model.nick_name; txtTelphone.Text = model.telphone; txtMobile.Text = model.mobile; txtAddress.Text = model.address; txtPost.Text = model.post_code; txtCity.Text = model.city; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_address model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "user_address set "); strSql.Append("user_name=@user_name,"); strSql.Append("nick_name=@nick_name,"); strSql.Append("address=@address,"); strSql.Append("telphone=@telphone,"); strSql.Append("mobile=@mobile,"); strSql.Append("is_check=@is_check,"); strSql.Append("city=@city,"); strSql.Append("post_code=@post_code"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@nick_name", SqlDbType.NVarChar, 100), new SqlParameter("@address", SqlDbType.NVarChar, 255), new SqlParameter("@telphone", SqlDbType.NVarChar, 50), new SqlParameter("@mobile", SqlDbType.NVarChar, 20), new SqlParameter("@is_check", SqlDbType.Decimal, 1), new SqlParameter("@city", SqlDbType.NVarChar, 50), new SqlParameter("@post_code", SqlDbType.NVarChar, 20), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.user_name; parameters[1].Value = model.nick_name; parameters[2].Value = model.address; parameters[3].Value = model.telphone; parameters[4].Value = model.mobile; parameters[5].Value = model.is_check; parameters[6].Value = model.city; parameters[7].Value = model.post_code; parameters[8].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private bool DoEdit(int _id) { bool result = false; BLL.user_address bll = new BLL.user_address(); Model.user_address model = bll.GetModel(_id); model.address = txtAddress.Text.Trim();; model.mobile = txtMobile.Text.Trim(); model.nick_name = txtNickName.Text.Trim(); model.telphone = txtTelphone.Text.Trim(); model.city = txtCity.Text.Trim(); model.post_code = txtPost.Text.Trim(); if (bll.Update(model)) { result = true; } return(result); }
private bool DoAdd() { bool result = false; Model.user_address model = new Model.user_address(); BLL.user_address bll = new BLL.user_address(); Model.users userModel = new Web.UI.BasePage().GetUserInfo(); model.address = txtAddress.Text; model.is_check = 0; model.mobile = txtMobile.Text.Trim(); model.telphone = txtTelphone.Text.Trim(); model.user_name = userModel.user_name; model.nick_name = txtNickName.Text.Trim(); model.city = txtCity.Text.Trim(); model.post_code = txtPost.Text.Trim(); if (bll.Add(model) > 0) { result = true; } return(result); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_address model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "user_address("); strSql.Append("user_name,nick_name,address,telphone,mobile,city,post_code,is_check)"); strSql.Append(" values ("); strSql.Append("@user_name,@nick_name,@address,@telphone,@mobile,@city,@post_code,@is_check)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@nick_name", SqlDbType.NVarChar, 100), new SqlParameter("@address", SqlDbType.NVarChar, 255), new SqlParameter("@telphone", SqlDbType.NVarChar, 50), new SqlParameter("@mobile", SqlDbType.NVarChar, 20), new SqlParameter("@city", SqlDbType.NVarChar, 50), new SqlParameter("@post_code", SqlDbType.NVarChar, 20), new SqlParameter("@is_check", SqlDbType.Decimal, 1) }; parameters[0].Value = model.user_name; parameters[1].Value = model.nick_name; parameters[2].Value = model.address; parameters[3].Value = model.telphone; parameters[4].Value = model.mobile; parameters[5].Value = model.city; parameters[6].Value = model.post_code; parameters[7].Value = model.is_check; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public string addAddress(int userid, string name, string province, string city, string area, string street, int zipcode, string tel) { string returnvalue = ""; Model.user_address addressModel = new Model.user_address(); BLL.user_address addressBll = new BLL.user_address(); addressModel.user_id = userid; addressModel.acceptName = name; addressModel.provinces = province; addressModel.citys = city; addressModel.area = area; addressModel.street = street; addressModel.mobile = tel; addressModel.add_time = DateTime.Now; addressModel.postcode = zipcode; //执行新增操作 if (addressBll.Add(addressModel) > 0) { return(returnvalue = "{\"info\":\"新增收货地址成功!\", \"status\":1}"); } return(returnvalue = "{\"info\":\"新增收货地址失败!\", \"status\":0}"); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_address model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_address model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"UPDATE ybd_user_address SET type = @type ,type_name = @type_name ,user_id = @user_id ,name = @name ,mobile = @mobile ,tel = @tel ,sheng = @sheng ,shi = @shi ,xian = @xian ,area = @area ,address = @address ,postcode = @postcode ,IDCard = @IDCard ,is_default = @is_default ,add_time = @add_time WHERE id = @id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) , new SqlParameter("@type", SqlDbType.Int, 4) , new SqlParameter("@type_name", SqlDbType.NVarChar, 50) , new SqlParameter("@user_id", SqlDbType.Int, 4) , new SqlParameter("@name", SqlDbType.NVarChar, 50) , new SqlParameter("@mobile", SqlDbType.NVarChar, 50) , new SqlParameter("@tel", SqlDbType.NVarChar, 50) , new SqlParameter("@sheng", SqlDbType.NVarChar, 50) , new SqlParameter("@shi", SqlDbType.NVarChar, 50) , new SqlParameter("@xian", SqlDbType.NVarChar, 50) , new SqlParameter("@area", SqlDbType.NVarChar, 50) , new SqlParameter("@address", SqlDbType.NVarChar, 100) , new SqlParameter("@postcode", SqlDbType.NVarChar, 20) , new SqlParameter("@IDCard", SqlDbType.NVarChar, 50) , new SqlParameter("@is_default", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.id; parameters[1].Value = model.type; parameters[2].Value = model.type_name; parameters[3].Value = model.user_id; parameters[4].Value = model.name; parameters[5].Value = model.mobile; parameters[6].Value = model.tel; parameters[7].Value = model.sheng; parameters[8].Value = model.shi; parameters[9].Value = model.xian; parameters[10].Value = model.area; parameters[11].Value = model.address; parameters[12].Value = model.postcode; parameters[13].Value = model.IDCard; parameters[14].Value = model.is_default; parameters[15].Value = model.add_time; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.user_address GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from " + databaseprefix + "user_address "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.user_address model = new Model.user_address(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "") { model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); } if (ds.Tables[0].Rows[0]["nick_name"] != null && ds.Tables[0].Rows[0]["nick_name"].ToString() != "") { model.nick_name = ds.Tables[0].Rows[0]["nick_name"].ToString(); } if (ds.Tables[0].Rows[0]["address"] != null && ds.Tables[0].Rows[0]["address"].ToString() != "") { model.address = ds.Tables[0].Rows[0]["address"].ToString(); } if (ds.Tables[0].Rows[0]["telphone"] != null && ds.Tables[0].Rows[0]["telphone"].ToString() != "") { model.telphone = ds.Tables[0].Rows[0]["telphone"].ToString(); } if (ds.Tables[0].Rows[0]["mobile"] != null && ds.Tables[0].Rows[0]["mobile"].ToString() != "") { model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString(); } if (ds.Tables[0].Rows[0]["city"] != null && ds.Tables[0].Rows[0]["city"].ToString() != "") { model.city = ds.Tables[0].Rows[0]["city"].ToString(); } if (ds.Tables[0].Rows[0]["post_code"] != null && ds.Tables[0].Rows[0]["post_code"].ToString() != "") { model.post_code = ds.Tables[0].Rows[0]["post_code"].ToString(); } if (ds.Tables[0].Rows[0]["is_check"] != null && ds.Tables[0].Rows[0]["is_check"].ToString() != "") { model.is_check = decimal.Parse(ds.Tables[0].Rows[0]["is_check"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_address model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"Insert Into ybd_user_address( type ,type_name ,user_id ,name ,mobile ,tel ,sheng ,shi ,xian ,area ,address ,postcode ,IDCard ,is_default ,add_time ) Values ( @type ,@type_name ,@user_id ,@name ,@mobile ,@tel ,@sheng ,@shi ,@xian ,@area ,@address ,@postcode ,@IDCard ,@is_default ,@add_time ); SELECT @@IDENTITY;"); SqlParameter[] parameters = { new SqlParameter("@type", SqlDbType.Int, 4) , new SqlParameter("@type_name", SqlDbType.NVarChar, 50) , new SqlParameter("@user_id", SqlDbType.Int, 4) , new SqlParameter("@name", SqlDbType.NVarChar, 50) , new SqlParameter("@mobile", SqlDbType.NVarChar, 50) , new SqlParameter("@tel", SqlDbType.NVarChar, 50) , new SqlParameter("@sheng", SqlDbType.NVarChar, 50) , new SqlParameter("@shi", SqlDbType.NVarChar, 50) , new SqlParameter("@xian", SqlDbType.NVarChar, 50) , new SqlParameter("@area", SqlDbType.NVarChar, 50) , new SqlParameter("@address", SqlDbType.NVarChar, 100) , new SqlParameter("@postcode", SqlDbType.NVarChar, 20) , new SqlParameter("@IDCard", SqlDbType.NVarChar, 50) , new SqlParameter("@is_default", SqlDbType.Int, 4) , new SqlParameter("@add_time", SqlDbType.DateTime, 8) }; parameters[0].Value = model.type; parameters[1].Value = model.type_name; parameters[2].Value = model.user_id; parameters[3].Value = model.name; parameters[4].Value = model.mobile; parameters[5].Value = model.tel; parameters[6].Value = model.sheng; parameters[7].Value = model.shi; parameters[8].Value = model.xian; parameters[9].Value = model.area; parameters[10].Value = model.address; parameters[11].Value = model.postcode; parameters[12].Value = model.IDCard; parameters[13].Value = model.is_default; parameters[14].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_address model) { return(dal.Update(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.user_address DataRowToModel(DataRow row) { Model.user_address model = new Model.user_address(); if (row != null) { if (row["id"] != null) //&& row["id"].ToString() != "" { model.id = Convert.ToInt32(row["id"]); } if (row["type"] != null) //&& row["type"].ToString() != "" { model.type = Convert.ToInt32(row["type"]); } if (row["type_name"] != null) //&& row["type_name"].ToString() != "" { model.type_name = Convert.ToString(row["type_name"]); } if (row["user_id"] != null) //&& row["user_id"].ToString() != "" { model.user_id = Convert.ToInt32(row["user_id"]); } if (row["name"] != null) //&& row["name"].ToString() != "" { model.name = Convert.ToString(row["name"]); } if (row["mobile"] != null) //&& row["mobile"].ToString() != "" { model.mobile = Convert.ToString(row["mobile"]); } if (row["tel"] != null) //&& row["tel"].ToString() != "" { model.tel = Convert.ToString(row["tel"]); } if (row["sheng"] != null) //&& row["sheng"].ToString() != "" { model.sheng = Convert.ToString(row["sheng"]); } if (row["shi"] != null) //&& row["shi"].ToString() != "" { model.shi = Convert.ToString(row["shi"]); } if (row["xian"] != null) //&& row["xian"].ToString() != "" { model.xian = Convert.ToString(row["xian"]); } if (row["area"] != null) //&& row["area"].ToString() != "" { model.area = Convert.ToString(row["area"]); } if (row["address"] != null) //&& row["address"].ToString() != "" { model.address = Convert.ToString(row["address"]); } if (row["postcode"] != null) //&& row["postcode"].ToString() != "" { model.postcode = Convert.ToString(row["postcode"]); } if (row["IDCard"] != null) //&& row["IDCard"].ToString() != "" { model.IDCard = Convert.ToString(row["IDCard"]); } if (row["is_default"] != null) //&& row["is_default"].ToString() != "" { model.is_default = Convert.ToInt32(row["is_default"]); } if (row["add_time"] != null && row["add_time"].ToString() != "") { model.add_time = Convert.ToDateTime(row["add_time"]); } return(model); } else { return(null); } }
//保存 protected void btnSubmit_Click(object sender, EventArgs e) { ChkAdminLevel("_ybd_user_address", EnumCollection.ActionEnum.Add.ToString()); //检查权限 #region string strError = string.Empty; if (txttype.Text.Trim() == "" || txttype.Text.Trim().Length > 4) { strError += "地址类型id为空或超出长度![br]"; } if (txttype_name.Text.Trim() == "" || txttype_name.Text.Trim().Length > 50) { strError += "地址类型名称为空或超出长度![br]"; } if (txtuser_id.Text.Trim() == "" || txtuser_id.Text.Trim().Length > 4) { strError += "用户id为空或超出长度![br]"; } if (txtname.Text.Trim() == "" || txtname.Text.Trim().Length > 50) { strError += "收货人姓名为空或超出长度![br]"; } if (txtmobile.Text.Trim() == "" || txtmobile.Text.Trim().Length > 50) { strError += "手机号为空或超出长度![br]"; } if (txttel.Text.Trim() == "" || txttel.Text.Trim().Length > 50) { strError += "联系电话为空或超出长度![br]"; } if (txtsheng.Text.Trim() == "" || txtsheng.Text.Trim().Length > 50) { strError += "省为空或超出长度![br]"; } if (txtshi.Text.Trim() == "" || txtshi.Text.Trim().Length > 50) { strError += "市为空或超出长度![br]"; } if (txtxian.Text.Trim() == "" || txtxian.Text.Trim().Length > 50) { strError += "区县为空或超出长度![br]"; } if (txtarea.Text.Trim() == "" || txtarea.Text.Trim().Length > 50) { strError += "区域为空或超出长度![br]"; } if (txtaddress.Text.Trim() == "" || txtaddress.Text.Trim().Length > 100) { strError += "详细地址为空或超出长度![br]"; } if (txtpostcode.Text.Trim() == "" || txtpostcode.Text.Trim().Length > 20) { strError += "邮政编码为空或超出长度![br]"; } if (txtIDCard.Text.Trim() == "" || txtIDCard.Text.Trim().Length > 50) { strError += "身份证号为空或超出长度![br]"; } if (txtis_default.Text.Trim() == "" || txtis_default.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_address model = new Model.user_address(); BLL.user_address bll = new BLL.user_address(); model.type = Convert.ToInt32(txttype.Text); model.type_name = Convert.ToString(txttype_name.Text); model.user_id = Convert.ToInt32(txtuser_id.Text); model.name = Convert.ToString(txtname.Text); model.mobile = Convert.ToString(txtmobile.Text); model.tel = Convert.ToString(txttel.Text); model.sheng = Convert.ToString(txtsheng.Text); model.shi = Convert.ToString(txtshi.Text); model.xian = Convert.ToString(txtxian.Text); model.area = Convert.ToString(txtarea.Text); model.address = Convert.ToString(txtaddress.Text); model.postcode = Convert.ToString(txtpostcode.Text); model.IDCard = Convert.ToString(txtIDCard.Text); model.is_default = Convert.ToInt32(txtis_default.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("保存过程中发生错误!", ""); } }