/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_message model) { StringBuilder strSql = new StringBuilder(); StringBuilder str1 = new StringBuilder(); //利用反射获得属性的所有公共属性 PropertyInfo[] pros = model.GetType().GetProperties(); List <MySqlParameter> paras = new List <MySqlParameter>(); strSql.Append("update " + databaseprefix + "user_message set "); foreach (PropertyInfo pi in pros) { //如果不是主键则追加sql字符串 if (!pi.Name.Equals("id")) { //判断属性值是否为空 if (pi.GetValue(model, null) != null) { str1.Append(pi.Name + "=@" + pi.Name + ","); //声明参数 paras.Add(new MySqlParameter("@" + pi.Name, pi.GetValue(model, null))); //对参数赋值 } } } strSql.Append(str1.ToString().Trim(',')); strSql.Append(" where id=@id"); paras.Add(new MySqlParameter("@id", model.id)); return(DbHelperMySql.ExecuteSql(strSql.ToString(), paras.ToArray()) > 0); }
private bool DoAdd() { bool result = true; Model.user_message model = new Model.user_message(); BLL.user_message bll = new BLL.user_message(); model.title = txtTitle.Text.Trim(); model.content = txtContent.Value; string[] arrUserName = txtUserName.Text.Trim().Split(','); if (arrUserName.Length > 0) { foreach (string username in arrUserName) { if (new BLL.users().Exists(username)) { model.accept_user_name = username; if (bll.Add(model) < 1) { result = false; } } } } return result; }
private bool DoAdd() { bool result = true; Model.user_message model = new Model.user_message(); BLL.user_message bll = new BLL.user_message(); model.title = txtTitle.Text.Trim(); model.content = txtContent.Value; string[] arrUserName = txtUserName.Text.Trim().Split(','); if (arrUserName.Length > 0) { foreach (string username in arrUserName) { if (new BLL.users().Exists(username)) { model.accept_user_name = username; if (bll.Add(model) < 1) { result = false; } } } } return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.user_message GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,type,post_user_name,accept_user_name,is_read,title,content,post_time,read_time from " + databaseprefix + "user_message "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.user_message model = new Model.user_message(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["type"] != null && ds.Tables[0].Rows[0]["type"].ToString() != "") { model.type = int.Parse(ds.Tables[0].Rows[0]["type"].ToString()); } if (ds.Tables[0].Rows[0]["post_user_name"] != null && ds.Tables[0].Rows[0]["post_user_name"].ToString() != "") { model.post_user_name = ds.Tables[0].Rows[0]["post_user_name"].ToString(); } if (ds.Tables[0].Rows[0]["accept_user_name"] != null && ds.Tables[0].Rows[0]["accept_user_name"].ToString() != "") { model.accept_user_name = ds.Tables[0].Rows[0]["accept_user_name"].ToString(); } if (ds.Tables[0].Rows[0]["is_read"] != null && ds.Tables[0].Rows[0]["is_read"].ToString() != "") { model.is_read = int.Parse(ds.Tables[0].Rows[0]["is_read"].ToString()); } if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["content"] != null && ds.Tables[0].Rows[0]["content"].ToString() != "") { model.content = ds.Tables[0].Rows[0]["content"].ToString(); } if (ds.Tables[0].Rows[0]["post_time"] != null && ds.Tables[0].Rows[0]["post_time"].ToString() != "") { model.post_time = DateTime.Parse(ds.Tables[0].Rows[0]["post_time"].ToString()); } if (ds.Tables[0].Rows[0]["read_time"] != null && ds.Tables[0].Rows[0]["read_time"].ToString() != "") { model.read_time = DateTime.Parse(ds.Tables[0].Rows[0]["read_time"].ToString()); } return(model); } else { return(null); } }
private void ShowInfo(int _id) { BLL.user_message bll = new BLL.user_message(); Model.user_message model = bll.GetModel(_id); div_view.Visible = true; div_add.Visible = false; btnSubmit.Visible = false; labType.Text = GetMessageType(model.type); if (!string.IsNullOrEmpty(model.post_user_name)) { labPostUserName.Text = model.post_user_name; } else { labPostUserName.Text = "-"; } labAcceptUserName.Text = model.accept_user_name; labPostTime.Text = model.post_time.ToString(); labIsRead.Text = model.is_read == 1 ? "已阅读" : "未阅读"; if (model.read_time != null) { labReadTime.Text = model.read_time.ToString(); } else { labReadTime.Text = "-"; } labTitle.Text = model.title; litContent.Text = model.content; }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.user_message GetModel(int id) { StringBuilder strSql = new StringBuilder(); StringBuilder str1 = new StringBuilder(); Model.user_message model = new Model.user_message(); //利用反射获得属性的所有公共属性 PropertyInfo[] pros = model.GetType().GetProperties(); foreach (PropertyInfo p in pros) { str1.Append(p.Name + ",");//拼接字段 } strSql.Append("select top 1 " + str1.ToString().Trim(',')); strSql.Append(" from " + databaseprefix + "user_message"); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters[0].Value = id; DataTable dt = DbHelperMySql.Query(strSql.ToString(), parameters).Tables[0]; if (dt.Rows.Count > 0) { return(DataRowToModel(dt.Rows[0])); } else { return(null); } }
private void ShowInfo(int _id) { BLL.user_message bll = new BLL.user_message(); Model.user_message model = bll.GetModel(_id); txtTitle.Text = model.title; txtContent.InnerText = model.content; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_message model) { int newId; using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString)) { conn.Open(); using (OleDbTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "user_message("); strSql.Append("[type],post_user_name,accept_user_name,is_read,title,content,post_time,read_time)"); strSql.Append(" values ("); strSql.Append("@type,@post_user_name,@accept_user_name,@is_read,@title,@content,@post_time,@read_time)"); OleDbParameter[] parameters = { new OleDbParameter("@type", OleDbType.Integer, 4), new OleDbParameter("@post_user_name", OleDbType.VarChar, 100), new OleDbParameter("@accept_user_name", OleDbType.VarChar, 100), new OleDbParameter("@is_read", OleDbType.Integer, 4), new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@content", OleDbType.VarChar), new OleDbParameter("@post_time", OleDbType.Date), new OleDbParameter("@read_time", OleDbType.Date) }; parameters[0].Value = model.type; parameters[1].Value = model.post_user_name; parameters[2].Value = model.accept_user_name; parameters[3].Value = model.is_read; parameters[4].Value = model.title; parameters[5].Value = model.content; parameters[6].Value = model.post_time; if (model.read_time != null) { parameters[7].Value = model.read_time; } else { parameters[7].Value = DBNull.Value; } DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID newId = GetMaxId(conn, trans); trans.Commit(); } catch { trans.Rollback(); return(-1); } } } return(newId); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(int type, string post_user_name, string accept_user_name, string title, string content) { Model.user_message model = new Model.user_message(); model.type = type; model.post_user_name = post_user_name; model.accept_user_name = accept_user_name; model.title = title; model.content = content; return(Add(model)); }
/// <summary> /// ����һ������ /// </summary> public int Add(int type, string post_user_name, string accept_user_name, string title, string content) { Model.user_message model = new Model.user_message(); model.type = type; model.post_user_name = post_user_name; model.accept_user_name = accept_user_name; model.title = title; model.content = content; return Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "user_message set "); strSql.Append("[type]=@type,"); strSql.Append("post_user_name=@post_user_name,"); strSql.Append("accept_user_name=@accept_user_name,"); strSql.Append("is_read=@is_read,"); strSql.Append("title=@title,"); strSql.Append("content=@content,"); strSql.Append("post_time=@post_time,"); strSql.Append("read_time=@read_time"); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@type", OleDbType.Integer, 4), new OleDbParameter("@post_user_name", OleDbType.VarChar, 100), new OleDbParameter("@accept_user_name", OleDbType.VarChar, 100), new OleDbParameter("@is_read", OleDbType.Integer, 4), new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@content", SqlDbType.NText), new OleDbParameter("@post_time", OleDbType.Date), new OleDbParameter("@read_time", OleDbType.Date), new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = model.type; parameters[1].Value = model.post_user_name; parameters[2].Value = model.accept_user_name; parameters[3].Value = model.is_read; parameters[4].Value = model.title; parameters[5].Value = model.content; parameters[6].Value = model.post_time; if (model.read_time != null) { parameters[7].Value = model.read_time; } else { parameters[7].Value = DBNull.Value; } parameters[8].Value = model.id; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 重写虚方法,此方法在Init事件执行 /// </summary> protected override void InitPage() { id = MXRequest.GetQueryInt("id"); BLL.user_message bll = new BLL.user_message(); if (!bll.Exists(id)) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,您要浏览的页面不存在或已删除啦!"))); return; } model = bll.GetModel(id); //设为已阅读状态 bll.UpdateField(id, "is_read=1,read_time='" + DateTime.Now + "'"); }
/// <summary> /// 重写虚方法,此方法在Init事件执行 /// </summary> protected override void InitPage() { id = DTRequest.GetQueryInt("id"); BLL.user_message bll = new BLL.user_message(); if (!bll.Exists(id)) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出錯啦,您要瀏覽的頁面不存在或已刪除啦!")); return; } model = bll.GetModel(id); //设为已阅读状态 bll.UpdateField(id, "is_read=1,read_time='" + DateTime.Now + "'"); }
/// <summary> /// 重写虚方法,此方法在Init事件执行 /// </summary> protected override void InitPage() { id = DTRequest.GetQueryInt("id"); BLL.user_message bll = new BLL.user_message(); if (!bll.Exists(id)) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,您要浏览的页面不存在或已删除啦!")); return; } model = bll.GetModel(id); //设为已阅读状态 bll.UpdateField(id, "is_read=1,read_time='" + DateTime.Now + "'"); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(int type, string post_user_name, string accept_user_name, string title, string content, int userId) { Model.user_message model = new Model.user_message { type = type, post_user_name = post_user_name, accept_user_name = accept_user_name, title = title, content = content, receiver = userId }; return(Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_user_message set "); strSql.Append("type=@type,"); strSql.Append("post_user_name=@post_user_name,"); strSql.Append("accept_user_name=@accept_user_name,"); strSql.Append("is_read=@is_read,"); strSql.Append("title=@title,"); strSql.Append("content=@content,"); strSql.Append("post_time=@post_time,"); strSql.Append("read_time=@read_time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@type", SqlDbType.TinyInt, 1), new SqlParameter("@post_user_name", SqlDbType.NVarChar, 100), new SqlParameter("@accept_user_name", SqlDbType.NVarChar, 100), new SqlParameter("@is_read", SqlDbType.TinyInt, 1), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@post_time", SqlDbType.DateTime), new SqlParameter("@read_time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.type; parameters[1].Value = model.post_user_name; parameters[2].Value = model.accept_user_name; parameters[3].Value = model.is_read; parameters[4].Value = model.title; parameters[5].Value = model.content; parameters[6].Value = model.post_time; parameters[7].Value = model.read_time; parameters[8].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 重写虚方法,此方法在Init事件执行 /// </summary> protected override void InitPage() { id = DTRequest.GetQueryInt("id"); BLL.user_message bll = new BLL.user_message(); if (!bll.Exists(id)) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错了,您要浏览的页面不存在或已删除!"))); return; } model = bll.GetModel(id); if (model.accept_user_name != userModel.user_name && model.post_user_name != userModel.user_name) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错了,您所查看的并非自己的短消息!"))); return; } //设为已阅读状态 bll.UpdateField(id, "is_read=1,read_time='" + DateTime.Now + "'"); }
/// <summary> /// 将对象转换为实体 /// </summary> public Model.user_message DataRowToModel(DataRow row) { Model.user_message model = new Model.user_message(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["type"] != null && row["type"].ToString() != "") { model.type = int.Parse(row["type"].ToString()); } if (row["post_user_name"] != null) { model.post_user_name = row["post_user_name"].ToString(); } if (row["accept_user_name"] != null) { model.accept_user_name = row["accept_user_name"].ToString(); } if (row["is_read"] != null && row["is_read"].ToString() != "") { model.is_read = int.Parse(row["is_read"].ToString()); } if (row["title"] != null) { model.title = row["title"].ToString(); } if (row["content"] != null) { model.content = row["content"].ToString(); } if (row["post_time"] != null && row["post_time"].ToString() != "") { model.post_time = DateTime.Parse(row["post_time"].ToString()); } if (row["read_time"] != null && row["read_time"].ToString() != "") { model.read_time = DateTime.Parse(row["read_time"].ToString()); } } return(model); }
/// <summary> /// 将对象转换实体 /// </summary> public Model.user_message DataRowToModel(DataRow row) { Model.user_message model = new Model.user_message(); if (row != null) { //利用反射获得属性的所有公共属性 Type modelType = model.GetType(); for (int i = 0; i < row.Table.Columns.Count; i++) { //查找实体是否存在列表相同的公共属性 PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName); if (proInfo != null && row[i] != DBNull.Value) { proInfo.SetValue(model, row[i], null);//用索引值设置属性值 } } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "user_message("); strSql.Append("type,post_user_name,accept_user_name,is_read,title,content,post_time,read_time,receiver)"); strSql.Append(" values ("); strSql.Append("@type,@post_user_name,@accept_user_name,@is_read,@title,@content,@post_time,@read_time,@receiver)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@type", SqlDbType.TinyInt, 1), new SqlParameter("@post_user_name", SqlDbType.NVarChar, 100), new SqlParameter("@accept_user_name", SqlDbType.NVarChar, 100), new SqlParameter("@is_read", SqlDbType.TinyInt, 1), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@post_time", SqlDbType.DateTime), new SqlParameter("@read_time", SqlDbType.DateTime), new SqlParameter("@receiver", SqlDbType.Int, 4), }; parameters[0].Value = model.type; parameters[1].Value = model.post_user_name; parameters[2].Value = model.accept_user_name; parameters[3].Value = model.is_read; parameters[4].Value = model.title; parameters[5].Value = model.content; parameters[6].Value = model.post_time; parameters[7].Value = model.read_time; parameters[8].Value = model.receiver; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_message model) { StringBuilder strSql = new StringBuilder(); StringBuilder str1 = new StringBuilder(); //数据字段 StringBuilder str2 = new StringBuilder(); //数据参数 //利用反射获得属性的所有公共属性 PropertyInfo[] pros = model.GetType().GetProperties(); List <MySqlParameter> paras = new List <MySqlParameter>(); strSql.Append("insert into " + databaseprefix + "user_message("); foreach (PropertyInfo pi in pros) { //如果不是主键则追加sql字符串 if (!pi.Name.Equals("id")) { //判断属性值是否为空 if (pi.GetValue(model, null) != null) { str1.Append(pi.Name + ","); //拼接字段 str2.Append("@" + pi.Name + ","); //声明参数 paras.Add(new MySqlParameter("@" + pi.Name, pi.GetValue(model, null))); //对参数赋值 } } } strSql.Append(str1.ToString().Trim(',')); strSql.Append(") values ("); strSql.Append(str2.ToString().Trim(',')); strSql.Append(") "); strSql.Append(";select @@IDENTITY;"); object obj = DbHelperMySql.GetSingle(strSql.ToString(), paras.ToArray()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 重写虚方法,此方法在Init事件执行 /// </summary> protected override void InitPage() { base.InitPage(); id = DTRequest.GetQueryInt("id"); message_status = DTRequest.GetQueryInt("status", 0); BLL.user_message bll = new BLL.user_message(); if (!bll.Exists(id)) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,您要浏览的页面不存在或已删除啦!"))); return; } model = bll.GetModel(id); if (model.accept_user_name != userModel.user_name || (model.type == 2 && model.post_user_name != userModel.user_name)) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,您所查看的并非自己的短消息!"))); return; } //设为已阅读状态 bll.UpdateField(id, "is_read=1,read_time='" + DateTime.Now + "'"); //查找下一条 var messageDt = new DataTable(); if (message_status == 0) { messageDt = bll.GetList(10, string.Format("accept_user_name='{0}' and type=1 and Id<{1}", userModel.user_name, id), "id desc").Tables[0]; } else if (message_status == 1) { messageDt = bll.GetList(10, string.Format("accept_user_name='{0}' and type=1 and is_read=1 and Id<{1}", userModel.user_name, id), "id desc").Tables[0]; } else { messageDt = bll.GetList(10, string.Format("accept_user_name='{0}' and type=1 and is_read=0 and Id<{1}", userModel.user_name, id), "id desc").Tables[0]; } next_id = messageDt != null && messageDt.Rows.Count > 0 ? (int)messageDt.Rows[0]["id"] : 0; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_message model) { //收件箱 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into gm_dt_sysuser_message("); strSql.Append("type,post_user_name,accept_user_name,is_read,title,content,post_time,read_time)"); strSql.Append(" values ("); strSql.Append("@type,@post_user_name,@accept_user_name,@is_read,@title,@content,@post_time,@read_time)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@type", SqlDbType.TinyInt, 1), new SqlParameter("@post_user_name", SqlDbType.NVarChar, 100), new SqlParameter("@accept_user_name", SqlDbType.NVarChar, 100), new SqlParameter("@is_read", SqlDbType.TinyInt, 1), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@post_time", SqlDbType.DateTime), new SqlParameter("@read_time", SqlDbType.DateTime), new SqlParameter("@ReturnValue", SqlDbType.Int) }; parameters[0].Value = 2; parameters[1].Value = model.post_user_name; parameters[2].Value = model.accept_user_name; parameters[3].Value = model.is_read; parameters[4].Value = model.title; parameters[5].Value = model.content; parameters[6].Value = model.post_time; parameters[7].Value = model.read_time; parameters[8].Direction = ParameterDirection.Output; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //发件箱 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("insert into gm_dt_sysuser_message("); strSql2.Append("type,post_user_name,accept_user_name,title,content,post_time)"); strSql2.Append(" values ("); strSql2.Append("@type,@post_user_name,@accept_user_name,@title,@content,@post_time)"); strSql2.Append(";select @@IDENTITY"); SqlParameter[] parameters2 = { new SqlParameter("@type", SqlDbType.TinyInt, 1), new SqlParameter("@post_user_name", SqlDbType.NVarChar, 100), new SqlParameter("@accept_user_name", SqlDbType.NVarChar, 100), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@post_time", SqlDbType.DateTime) }; parameters2[0].Value = 3; parameters2[1].Value = model.post_user_name; parameters2[2].Value = model.accept_user_name; parameters2[3].Value = model.title; parameters2[4].Value = model.content; parameters2[5].Value = model.post_time; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return((int)parameters[8].Value); }
/// <summary> /// 将对象转换为实体 /// </summary> public Model.user_message DataRowToModel(DataRow row) { Model.user_message model = new Model.user_message(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["type"] != null && row["type"].ToString() != "") { model.type = int.Parse(row["type"].ToString()); } if (row["post_user_name"] != null) { model.post_user_name = row["post_user_name"].ToString(); } if (row["accept_user_name"] != null) { model.accept_user_name = row["accept_user_name"].ToString(); } if (row["is_read"] != null && row["is_read"].ToString() != "") { model.is_read = int.Parse(row["is_read"].ToString()); } if (row["title"] != null) { model.title = row["title"].ToString(); } if (row["content"] != null) { model.content = row["content"].ToString(); } if (row["post_time"] != null && row["post_time"].ToString() != "") { model.post_time = DateTime.Parse(row["post_time"].ToString()); } if (row["read_time"] != null && row["read_time"].ToString() != "") { model.read_time = DateTime.Parse(row["read_time"].ToString()); } } return model; }
private void user_message_add(HttpContext context) { //检查用户是否登录 Model.users model = new BasePage().GetUserInfo(); if (model == null) { context.Response.Write("{\"msg\":0, \"msgbox\":\"对不起,用户没有登录或登录超时啦!\"}"); return; } string code = context.Request.Form["txtCode"]; string send_save = DTRequest.GetFormString("sendSave"); string user_name = DTRequest.GetFormString("txtUserName"); string title = DTRequest.GetFormString("txtTitle"); string content = DTRequest.GetFormString("txtContent"); //校检验证码 string result = verify_code(context, code); if (result != "success") { context.Response.Write(result); return; } //检查用户名 if (user_name == "" || !new BLL.users().Exists(user_name)) { context.Response.Write("{\"msg\":0, \"msgbox\":\"对不起,该用户名不存在或已经被删除啦!\"}"); return; } //检查标题 if (title == "") { context.Response.Write("{\"msg\":0, \"msgbox\":\"对不起,请输入短消息标题!\"}"); return; } //检查内容 if (content == "") { context.Response.Write("{\"msg\":0, \"msgbox\":\"对不起,请输入短消息内容!\"}"); return; } //保存数据 Model.user_message modelMessage = new Model.user_message(); modelMessage.type = 2; modelMessage.post_user_name = model.user_name; modelMessage.accept_user_name = user_name; modelMessage.title = title; modelMessage.content = Utils.ToHtml(content); new BLL.user_message().Add(modelMessage); if (send_save == "true") //保存到收件箱 { modelMessage.type = 3; new BLL.user_message().Add(modelMessage); } context.Response.Write("{\"msg\":1, \"msgbox\":\"发布短信息成功啦!\"}"); return; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_message model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_message model) { return(dal.Add(model)); }