/// <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>
/// 重写虚方法,此方法在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));
}
