protected void Save() { ShowShop.BLL.Accessories.Leaveword bll = new ShowShop.BLL.Accessories.Leaveword(); ShowShop.Model.Accessories.Leaveword model = new ShowShop.Model.Accessories.Leaveword(); model.ID = Convert.ToInt32(ViewState["id"].ToString()); model.Type = Convert.ToInt32(ViewState["type"].ToString()); model.UserName = ViewState["username"].ToString(); model.Telephone = ViewState["tel"].ToString(); model.QQ = ViewState["qq"].ToString(); model.MSN = ViewState["msn"].ToString(); model.Email = ViewState["email"].ToString(); model.IP = ViewState["ip"].ToString(); model.IsRegUser = Convert.ToInt32(ViewState["isreg"].ToString()); model.AddDate = Convert.ToDateTime(ViewState["adddate"].ToString()); model.IsRead = Convert.ToInt32(ViewState["isread"].ToString()); model.IsAuditing = Convert.ToInt32(ViewState["isauditing"].ToString()); model.StoreId = Convert.ToInt32(ViewState["storeid"].ToString()); //需要更新的信息 model.Title = this.txtTitle.Text; model.IsReply = Convert.ToInt32(this.rabIsReply.SelectedValue); model.Content = this.txtContent.Text; model.ReplyContent = this.txtReplyContent.Text; model.ReplyDate = DateTime.Now; model.Address = ViewState["address"].ToString(); bll.Amend(model); this.ltlMsg.Text = "操作成功,已回复该信息!"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionOk"; }
/// <summary> /// 得到一个实体 /// </summary> /// <param name="id"></param> /// <returns></returns> public ShowShop.Model.Accessories.Leaveword GetModelByID(int id) { ShowShop.Model.Accessories.Leaveword model = new ShowShop.Model.Accessories.Leaveword(); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 [id],[type],[username],[telephone],[qq],[msn],[email],[title],[ip],[isreguser],[content],[adddate],[isread],[replycontent],[isreply],[replydate],[isauditing],[storeid],[address] from yxs_leaveword "); 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.Type = reader.GetInt32(1); model.UserName = reader.GetString(2)==""?" ":reader.GetString(2); model.Telephone = reader.GetString(3)==""?" ":reader.GetString(3); model.QQ = reader.GetString(4) == "" ? " " : reader.GetString(4); model.MSN = reader.GetString(5) == "" ? " " : reader.GetString(5); model.Email = reader.GetString(6) == "" ? " " : reader.GetString(6); model.Title = reader.GetString(7)== ""?" ":reader.GetString(7); model.IP = reader.GetString(8) == ""? " " : reader.GetString(8); model.IsRegUser = reader.GetInt32(9); model.Content = reader.GetString(10) == ""? " " : reader.GetString(10); model.AddDate = reader.GetDateTime(11); model.IsRead = reader.GetInt32(12); model.ReplyContent = reader["replycontent"] == DBNull.Value ? " " : reader["replycontent"].ToString(); model.IsReply = reader.GetInt32(14); model.ReplyDate = reader["replydate"] == DBNull.Value ? DateTime.Parse("0001-01-01") : Convert.ToDateTime(reader["replydate"]); model.IsAuditing = reader.GetInt32(16); model.StoreId = reader.GetInt32(17); model.Address = reader["address"] == DBNull.Value ? " " : reader["address"].ToString(); } } return model; }
/// <summary> /// 所有数据集合 /// </summary> /// <returns></returns> public List<ShowShop.Model.Accessories.Leaveword> GetAll() { List<ShowShop.Model.Accessories.Leaveword> list = new List<ShowShop.Model.Accessories.Leaveword>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select [id],[type],[username],[telephone],[qq],[msn],[email],[title],[ip],[isreguser],[content],[adddate],[isread],[replycontent],[isreply],[replydate],[isauditing],[storeid],[address] from yxs_leaveword "); strSql.Append(" where 1=1"); using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString())) { while (reader.Read()) { ShowShop.Model.Accessories.Leaveword model = new ShowShop.Model.Accessories.Leaveword(); model.ID = reader.GetInt32(0); model.Type = reader.GetInt32(1); model.UserName = reader.GetString(2); model.Telephone = reader.GetString(3); model.QQ = reader.GetString(4); model.MSN = reader.GetString(5); model.Email = reader.GetString(6); model.Title = reader.GetString(7); model.IP = reader.GetString(8); model.IsRegUser = reader.GetInt32(9); model.Content = reader.GetString(10); model.AddDate = reader.GetDateTime(11); model.IsRead = reader.GetInt32(12); model.ReplyContent = reader.GetString(13); model.IsReply = reader.GetInt32(14); model.ReplyDate = reader.GetDateTime(15); model.IsAuditing = reader.GetInt32(16); model.StoreId = reader.GetInt32(17); model.Address = reader.GetString(18); list.Add(model); } } return list; }