protected void lbtnSave_Click(object sender, EventArgs e)
{
ShowShop.BLL.Order.OrderLeave bll = new ShowShop.BLL.Order.OrderLeave();
ShowShop.Model.Order.OrderLeave model = new ShowShop.Model.Order.OrderLeave();
model.OrderId = ViewState["OrderId"].ToString();
model.CreateDate = DateTime.Now;
model.Content = this.txtReplyContent.Text.Trim();
model.State = 0;
model.MemberId = -1;
try
{
if (ViewState["ID"] != null) //表示修改管理员回复的信息
{
model.ID = Convert.ToInt32(ViewState["ID"].ToString());
bll.Amend(model);
this.ltlMsg.Text = "操作成功，已修改该信息";
this.pnlMsg.Visible = true;
this.pnlMsg.CssClass = "actionOk";
}
else
{
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";
}
finally
{
bll = null;
model = null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ShowShop.Model.Order.OrderLeave GetModelByID(int id)
{
ShowShop.Model.Order.OrderLeave model = new ShowShop.Model.Order.OrderLeave();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,memberid,orderid,content,createdate,state from yxs_orderleave ");
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.MemberId = reader.GetInt32(1);
model.OrderId = reader.GetString(2);
model.Content = reader.GetString(3);
model.CreateDate = reader.GetDateTime(4);
model.State = reader.GetInt32(5);
}
else
{
model = null;
}
}
return model;
}
/// <summary>
/// 得到指定条件的所有集合
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public List<ShowShop.Model.Order.OrderLeave> GetAll(string strWhere)
{
List<ShowShop.Model.Order.OrderLeave> list = new List<ShowShop.Model.Order.OrderLeave>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,memberid,orderid,content,createdate,state from yxs_orderleave ");
if (strWhere != null && strWhere != "")
{
strSql.Append("where " + strWhere + " ");
}
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString()))
{
while (reader.Read())
{
ShowShop.Model.Order.OrderLeave model = new ShowShop.Model.Order.OrderLeave();
model.ID = reader.GetInt32(0);
model.MemberId = reader.GetInt32(1);
model.OrderId = reader.GetString(2);
model.Content = reader.GetString(3);
model.CreateDate = reader.GetDateTime(4);
model.State = reader.GetInt32(5);
list.Add(model);
}
}
return list;
}
