protected void BtnDelete_Click(object sender, EventArgs e)
{
int id;
if (int.TryParse(Request.QueryString["id"], out id))
{
CY.HotelBooking.Core.Business.Message message = CY.HotelBooking.Core.Business.Message.Load(id);
if (message != null)
{
message.DeleteOnSave();
message.Users.ClearOnSave();
message.Save();
}
CY.HotelBooking.Core.Business.Log log = new CY.HotelBooking.Core.Business.Log();
log.Manager = Manager.Code;
log.Message = Manager.Code + "删除消息：" + message.Title;
log.Save();
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "短信息成功删除!", "<script>window.location.href='MessageList.aspx'</script>");
}
else
{
throw new Exception("参数出错!");
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
CY.HotelBooking.Core.Business.Message message = new CY.HotelBooking.Core.Business.Message();
CY.HotelBooking.Core.Business.UserMessage usermessage;
message.Title = MessageTitle.Text;
message.Content = Server.HtmlEncode(MessageContent.Value.Trim());
message.PubDate = System.DateTime.Now;
message.Manager_Code = Session["ManagerCode"].ToString();
if (ddl_IsPub.SelectedValue == "")
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "error", "<script>alert('是否为公告不能为空!')</script>");
return;
}
message.Manager_IsPub = int.Parse(ddl_IsPub.SelectedValue.ToString());
message.Save();
if (ddl_IsPub.SelectedValue.Equals("0"))
{
if (tb_UserIDs.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "AddFailed!", "<script>alert('消息发送对象不能为空!');</script>");
return;
}
string[] userIdList = tb_UserIDs.Text.Split(',');
foreach (string item in userIdList)
{
usermessage = new CY.HotelBooking.Core.Business.UserMessage { UserID = int.Parse(item), MessageID = message.Id, UserMessageState = 0 };
message.Users.AddOnSave(usermessage);
}
}
else
{
IList<CY.HotelBooking.Core.Business.User> userlist = CY.HotelBooking.Core.Business.User.GetAllUsers();
foreach (CY.HotelBooking.Core.Business.User u in userlist)
{
usermessage = new CY.HotelBooking.Core.Business.UserMessage { UserID = u.Id, MessageID = message.Id, UserMessageState = 0};
message.Users.AddOnSave(usermessage);
}
}
message.Save();
CY.HotelBooking.Core.Business.Log log = new CY.HotelBooking.Core.Business.Log();
log.Manager =Manager.Code;
log.Message =Manager.Code+"添加消息：" + message.Title;
log.Save();
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "短信息成功保存!", "<script>alert('保存成功!');window.location.href='MessageList.aspx'</script>");
}
public IList<CY.HotelBooking.Core.Business.Log> FillLogsByCondition(string managerCode, string dateStart, string dateEnd)
{
String SqlSelect =
"SELECT [Log_ID],[Log_Message],[Log_DateCreated],[ManagerCode]FROM[Web_Log] where ";
SqlServerUtility db = new SqlServerUtility();
IList<CY.HotelBooking.Core.Business.Log> results = new List<CY.HotelBooking.Core.Business.Log>();
if (managerCode != "")
{
SqlSelect += " [ManagerCode]=@ManagerCode and ";
db.AddParameter("@ManagerCode", SqlDbType.NVarChar,managerCode);
}
DateTime dtTemp = new DateTime();
if (dateStart != "" && DateTime.TryParse(dateStart, out dtTemp))
{
SqlSelect += " [Log_DateCreated]>@Log_DateStart and ";
db.AddParameter("@Log_DateStart", SqlDbType.DateTime, dateStart);
}
if (dateEnd != "" && DateTime.TryParse(dateEnd, out dtTemp))
{
dtTemp = dtTemp.AddDays(1);
SqlSelect += " [Log_DateCreated]<@Log_DateEnd and ";
db.AddParameter("@Log_DateEnd", SqlDbType.DateTime, dtTemp.ToLongDateString());
}
SqlSelect += " 1=1 ";
SqlSelect += SqlOrder;
SqlDataReader reader = db.ExecuteSqlReader(SqlSelect);
if (reader != null)
{
while (reader.Read())
{
CY.HotelBooking.Core.Business.Log log = new CY.HotelBooking.Core.Business.Log();
if (!reader.IsDBNull(0)) log.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) log.Message = reader.GetString(1);
if (!reader.IsDBNull(2)) log.DateCreated = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) log.Manager = reader.GetString(3);
results.Add(log);
}
reader.Close();
}
return results;
}
public IList<CY.HotelBooking.Core.Business.Log> FillLogs()
{
SqlServerUtility db = new SqlServerUtility();
IList<CY.HotelBooking.Core.Business.Log> results = new List<CY.HotelBooking.Core.Business.Log>();
SqlDataReader reader = db.ExecuteSqlReader(SqlSelectAll);
if (reader != null)
{
while (reader.Read())
{
CY.HotelBooking.Core.Business.Log log = new CY.HotelBooking.Core.Business.Log();
if (!reader.IsDBNull(0)) log.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) log.Message = reader.GetString(1);
if (!reader.IsDBNull(2)) log.DateCreated = reader.GetDateTime(2);
if (!reader.IsDBNull(3)) log.Manager = reader.GetString(3);
results.Add(log);
}
reader.Close();
}
return results;
}
protected void BtnModify_Click(object sender, EventArgs e)
{
int id;
if (int.TryParse(Request.QueryString["id"], out id))
{
CY.HotelBooking.Core.Business.Message message = CY.HotelBooking.Core.Business.Message.Load(id);
CY.HotelBooking.Core.Business.UserMessage usermessage;
if (message != null)
{
message.Title = MessageTitle.Text;
message.Content = Server.HtmlEncode(MessageContent.Value);
message.Manager_IsPub = int.Parse(ddl_IsPub.SelectedValue.ToString());
string[] previousUserList = preUserList.Split(',');
List<string> modifiedUserList = new List<string>();
if (ddl_IsPub.SelectedValue.Trim() == "0")
{
modifiedUserList = tb_UserIDs.Text.Split(',').ToList();
}
else
{
IList<CY.HotelBooking.Core.Business.User> userslist = CY.HotelBooking.Core.Business.User.GetAllUsers();
foreach (CY.HotelBooking.Core.Business.User u in userslist)
{
modifiedUserList.Add(u.Id.ToString());
}
}
List<string> intersectUserList = modifiedUserList.Intersect(previousUserList).ToList();
List<string> userListToDelete = previousUserList.Except(intersectUserList).ToList();
List<string> userListToAdd = modifiedUserList.Except(intersectUserList).ToList();
for (int i = 0; i < userListToDelete.Count(); i++)
{
if (!userListToDelete[i].Equals(""))
{
usermessage = CY.HotelBooking.Core.Business.UserMessage.GetUserMessageByUserIdandMsgId(int.Parse(userListToDelete[i]), id);
message.Users.DeleteOnSave(usermessage);
}
}
for (int j = 0; j < userListToAdd.Count(); j++)
{
if (!userListToAdd[j].Equals(""))
{
usermessage = new CY.HotelBooking.Core.Business.UserMessage { UserID = int.Parse(userListToAdd[j]), MessageID = id, UserMessageState = 0 };
message.Users.AddOnSave(usermessage);
}
}
message.Save();
CY.HotelBooking.Core.Business.Log log = new CY.HotelBooking.Core.Business.Log();
log.Manager = Manager.Code;
log.Message = Manager.Code + "修改消息：" + message.Title;
log.Save();
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "短信息成功删除!", "<script>alert('保存成功!');window.location.href='MessageDetail.aspx?id=" + id + "'</script>");
}
else
{
throw new Exception("参数出错!");
}
}
else
{
throw new Exception("参数错误!");
}
}
