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