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