protected void lbtnSave_Click(object sender, EventArgs e) { try { ShowShop.BLL.Product.Express bll = new ShowShop.BLL.Product.Express(); ShowShop.Model.Product.Express model = new ShowShop.Model.Product.Express(); model.Name = this.txtName.Text.Trim(); model.FullName = this.txtFullName.Text.Trim(); model.Address = this.txtAddress.Text.Trim(); if (txtPhone.Text!="") { if(!ChangeHope.Common.ValidateHelper.IsPhone(txtPhone.Text.Trim())) { this.ltlMsg.Text = "操作失败,请输入正确的电话号码。"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } } model.Phone = this.txtPhone.Text.Trim(); model.Person = this.txtPerson.Text.Trim(); model.Sort = Convert.ToInt32(this.txtSort.Text.Trim()); if (ViewState["ID"] != null)//更新 { model.ID = Convert.ToInt32(ViewState["ID"].ToString()); model.Numstr = ViewState["NumStr"].ToString(); bll.Amend(model); } else//添加 { string str = DateTime.Now.ToFileTime().ToString(); Random rand = new Random(); model.Numstr = String.Format("YX{0}Ram{1}", str, rand.Next(10000, 99999)); bll.Add(model); } this.ltlMsg.Text = "操作成功,已保存该信息"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionOk"; } catch { this.ltlMsg.Text = "操作失败,请查看数据格式是否符合要求"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; } }
/// <summary> /// 得到一个对象实体 /// </summary> public ShowShop.Model.Product.Express GetModelByID(int id) { ShowShop.Model.Product.Express model = new ShowShop.Model.Product.Express(); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,name,fullname,address,phone,person,numstr,sort from yxs_express "); strSql.Append(" where [id]=@id "); SqlParameter[] parameters = (SqlParameter[])this.ValueIDPara(id); using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(), parameters)) { if (reader.Read()) { model.ID = reader.GetInt32(0); model.Name = reader.GetString(1); model.FullName = reader.GetString(2); model.Address = reader.GetString(3); model.Person = reader.GetString(4); model.Phone = reader.GetString(5); model.Numstr = reader.GetString(6); model.Sort = reader.GetInt32(7); } } return model; }
/// <summary> /// 得到指定条件的所有短消息 /// </summary> /// <param name="uid"></param> /// <returns></returns> public List<ShowShop.Model.Product.Express> GetAll(string strWhere) { List<ShowShop.Model.Product.Express> list = new List<ShowShop.Model.Product.Express>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,name,fullname,address,phone,person,numstr,sort from yxs_express "); if (strWhere != null && strWhere != "") { strSql.Append("where " + strWhere + " "); } strSql.Append(" order by sort asc"); using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString())) { while (reader.Read()) { ShowShop.Model.Product.Express model = new ShowShop.Model.Product.Express(); model.ID = reader.GetInt32(0); model.Name = reader.GetString(1); model.FullName = reader.GetString(2); model.Address = reader.GetString(3); model.Person = reader.GetString(4); model.Phone = reader.GetString(5); model.Numstr = reader.GetString(6); model.Sort = reader.GetInt32(7); list.Add(model); } } return list; }