private bool DoAdd()
{
bool flag = true;
Rain.Model.user_message model = new Rain.Model.user_message();
Rain.BLL.user_message userMessage = new Rain.BLL.user_message();
model.title = this.txtTitle.Text.Trim();
model.content = this.txtContent.Value;
string[] strArray = this.txtUserName.Text.Trim().Split(',');
if (strArray.Length > 0)
{
foreach (string user_name in strArray)
{
if (new Rain.BLL.users().Exists(user_name))
{
model.accept_user_name = user_name;
if (userMessage.Add(model) < 1)
{
flag = false;
}
}
}
}
return(flag);
}
public int Add(Rain.Model.user_message model)
{
int maxId;
using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString))
{
oleDbConnection.Open();
using (OleDbTransaction trans = oleDbConnection.BeginTransaction())
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into " + this.databaseprefix + "user_message(");
stringBuilder.Append("[type],post_user_name,accept_user_name,is_read,title,content,post_time,read_time)");
stringBuilder.Append(" values (");
stringBuilder.Append("@type,@post_user_name,@accept_user_name,@is_read,@title,@content,@post_time,@read_time)");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[8]
{
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)
};
oleDbParameterArray[0].Value = (object)model.type;
oleDbParameterArray[1].Value = (object)model.post_user_name;
oleDbParameterArray[2].Value = (object)model.accept_user_name;
oleDbParameterArray[3].Value = (object)model.is_read;
oleDbParameterArray[4].Value = (object)model.title;
oleDbParameterArray[5].Value = (object)model.content;
oleDbParameterArray[6].Value = (object)model.post_time;
if (model.read_time.HasValue)
{
oleDbParameterArray[7].Value = (object)model.read_time;
}
else
{
oleDbParameterArray[7].Value = (object)DBNull.Value;
}
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder.ToString(), oleDbParameterArray);
maxId = this.GetMaxId(oleDbConnection, trans);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(maxId);
}
public Rain.Model.user_message DataRowToModel(DataRow row)
{
Rain.Model.user_message userMessage = new Rain.Model.user_message();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
userMessage.id = int.Parse(row["id"].ToString());
}
if (row["type"] != null && row["type"].ToString() != "")
{
userMessage.type = int.Parse(row["type"].ToString());
}
if (row["post_user_name"] != null)
{
userMessage.post_user_name = row["post_user_name"].ToString();
}
if (row["accept_user_name"] != null)
{
userMessage.accept_user_name = row["accept_user_name"].ToString();
}
if (row["is_read"] != null && row["is_read"].ToString() != "")
{
userMessage.is_read = int.Parse(row["is_read"].ToString());
}
if (row["title"] != null)
{
userMessage.title = row["title"].ToString();
}
if (row["content"] != null)
{
userMessage.content = row["content"].ToString();
}
if (row["post_time"] != null && row["post_time"].ToString() != "")
{
userMessage.post_time = DateTime.Parse(row["post_time"].ToString());
}
if (row["read_time"] != null && row["read_time"].ToString() != "")
{
userMessage.read_time = new DateTime?(DateTime.Parse(row["read_time"].ToString()));
}
}
return(userMessage);
}
public bool Update(Rain.Model.user_message model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update " + this.databaseprefix + "user_message set ");
stringBuilder.Append("[type]=@type,");
stringBuilder.Append("post_user_name=@post_user_name,");
stringBuilder.Append("accept_user_name=@accept_user_name,");
stringBuilder.Append("is_read=@is_read,");
stringBuilder.Append("title=@title,");
stringBuilder.Append("content=@content,");
stringBuilder.Append("post_time=@post_time,");
stringBuilder.Append("read_time=@read_time");
stringBuilder.Append(" where id=@id");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[9]
{
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", (object)SqlDbType.NText),
new OleDbParameter("@post_time", OleDbType.Date),
new OleDbParameter("@read_time", OleDbType.Date),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)model.type;
oleDbParameterArray[1].Value = (object)model.post_user_name;
oleDbParameterArray[2].Value = (object)model.accept_user_name;
oleDbParameterArray[3].Value = (object)model.is_read;
oleDbParameterArray[4].Value = (object)model.title;
oleDbParameterArray[5].Value = (object)model.content;
oleDbParameterArray[6].Value = (object)model.post_time;
if (model.read_time.HasValue)
{
oleDbParameterArray[7].Value = (object)model.read_time;
}
else
{
oleDbParameterArray[7].Value = (object)DBNull.Value;
}
oleDbParameterArray[8].Value = (object)model.id;
return(DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), oleDbParameterArray) > 0);
}
protected override void InitPage()
{
this.id = DTRequest.GetQueryInt("id");
Rain.BLL.user_message userMessage = new Rain.BLL.user_message();
if (!userMessage.Exists(this.id))
{
HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错了，您要浏览的页面不存在或已删除！"))));
}
else
{
this.model = userMessage.GetModel(this.id);
if (this.model.accept_user_name != this.userModel.user_name && this.model.post_user_name != this.userModel.user_name)
{
HttpContext.Current.Response.Redirect(this.linkurl("error", (object)("?msg=" + Utils.UrlEncode("出错了，您所查看的并非自己的短消息！"))));
}
else
{
userMessage.UpdateField(this.id, "is_read=1,read_time='" + (object)DateTime.Now + "'");
}
}
}
public bool Update(Rain.Model.user_message model)
{
return(this.dal.Update(model));
}
public int Add(Rain.Model.user_message model)
{
return(this.dal.Add(model));
}
