public string GetDelType(int WMId, int UserId)
{
M_WebMessage message = new M_WebMessage();
if (this.Show(WMId, UserId).ReceiverId == UserId)
{
return "ReceiverDel";
}
return "SendDel";
}
public void Insert(M_WebMessage model)
{
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@ReceiverId", SqlDbType.Int, 4), new SqlParameter("@ReceiverName", SqlDbType.NVarChar), new SqlParameter("@SendId", SqlDbType.Int, 4), new SqlParameter("@SendName", SqlDbType.NVarChar), new SqlParameter("@Title", SqlDbType.NVarChar), new SqlParameter("@Content", SqlDbType.NVarChar), new SqlParameter("@IsSend", SqlDbType.Int, 4), new SqlParameter("@IsRead", SqlDbType.Int, 4), new SqlParameter("@ReceiverDel", SqlDbType.Int, 4), new SqlParameter("@SendDel", SqlDbType.Int, 4), new SqlParameter("@AllUser", SqlDbType.Int, 4), new SqlParameter("@UserGroupId", SqlDbType.Int, 4), new SqlParameter("@OverdueDate", SqlDbType.DateTime), new SqlParameter("@AddDate", SqlDbType.DateTime) };
commandParameters[0].Value = model.ReceiverId;
commandParameters[1].Value = model.ReceiverName;
commandParameters[2].Value = model.SendId;
commandParameters[3].Value = model.SendName;
commandParameters[4].Value = model.Title;
commandParameters[5].Value = model.Content;
commandParameters[6].Value = model.IsSend;
commandParameters[7].Value = model.IsRead;
commandParameters[8].Value = model.ReceiverDel;
commandParameters[9].Value = model.SendDel;
commandParameters[10].Value = model.AllUser;
commandParameters[11].Value = model.UserGroupId;
commandParameters[12].Value = model.OverdueDate;
commandParameters[13].Value = model.AddDate;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_WebMessage", commandParameters);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string Id=Request.QueryString["id"];
string TypeId=Request.QueryString["TypeId"];
if(Id=="" || Id==null || TypeId=="" || TypeId==null)
{
Response.Redirect("MessageList.aspx?TypeId="+TypeId+"");
Response.End();
}
m_user=b_user.GetCookie();
m_message=b_message.Show(int.Parse(Id),m_user.UserID);
if (m_message == null)
{
Response.Redirect("MessageList.aspx?TypeId="+TypeId+"");
Response.End();
}
if (m_message.AllUser == 1 || (m_message.AllUser == 0 && m_message.UserGroupId != 0) || (m_message.AllUser == 0 && m_message.SendId == 0 && m_message.UserGroupId==0))
{
LinkButton1.Visible = false;
ShowRe.Visible = false;
}
AddDate.Text = m_message.AddDate.ToString();
SendName.Text = m_message.SendName;
Title.Text = m_message.Title;
Content.Text = Function.Decode(m_message.Content);
Response.Write("<script type='text/javascript'>parent.LeftIframe.location.reload();</script>");
}
}
public void Auditing(string tableName, string idStr, int status)
{
if (idStr != string.Empty)
{
B_Admin admin = new B_Admin();
B_Column column = new B_Column();
B_Channel channel = new B_Channel();
string[] strArray = idStr.Split(new char[] { ',' });
foreach (string str in strArray)
{
int id = int.Parse(str);
DataRow info = this.dal.GetInfo(tableName, id);
if (info == null)
{
break;
}
int columnId = (int) info["colid"];
M_Column column2 = column.GetColumn(columnId);
if (column2 == null)
{
break;
}
M_Channel channel2 = channel.GetChannel(column2.ChId);
if (channel2 == null)
{
break;
}
int num3 = (int) info["Status"];
int num4 = (int) info["UserType"];
int userId = (int) info["UId"];
string str2 = info["UName"].ToString();
string newValue = info["Title"].ToString();
string str4 = channel2.Notice2.Replace("{@标题}", newValue);
M_LoginAdmin loginModel = admin.GetLoginModel();
int adiminId = loginModel.UserId;
string loginName = loginModel.LoginName;
this.dal.Auditing(tableName, id, status, adiminId, loginName);
if ((((status == 3) && (num3 != 3)) && (num4 == 0)) && (userId > 0))
{
B_WebMessage message = new B_WebMessage();
M_WebMessage message2 = new M_WebMessage();
message2.Title = "稿件采纳通知";
message2.Content = str4;
message2.IsRead = 0;
message2.IsSend = 1;
message2.ReceiverId = userId;
message2.ReceiverName = str2;
message2.SendId = 0;
message2.SendName = loginName;
message2.OverdueDate = DateTime.Now;
message2.AddDate = DateTime.Now;
message2.ReceiverDel = 0;
message2.SendDel = 0;
message.Insert(message2);
}
M_User user = new B_User().GetUser(userId);
if (user == null)
{
break;
}
B_UserGroup group = new B_UserGroup();
M_UserGroup model = group.GetModel(user.GroupID);
if (group == null)
{
break;
}
int num7 = int.Parse(group.Power_UserGroup("Contribute", 0, model.GroupPower)) * column2.ScoreReward;
new B_Money().Integral(num7, userId);
}
}
}
public void Cancel(string tableName, int id)
{
B_Channel channel = new B_Channel();
B_Column column = new B_Column();
B_Admin admin = new B_Admin();
DataRow info = this.dal.GetInfo(tableName, id);
if (info != null)
{
int columnId = (int) info["colid"];
M_Column column2 = column.GetColumn(columnId);
if (column2 != null)
{
M_Channel channel2 = channel.GetChannel(column2.ChId);
if (channel2 != null)
{
int num2 = (int) info["UserType"];
int num3 = (int) info["UId"];
string str = info["UName"].ToString();
string newValue = info["Title"].ToString();
string str3 = channel2.Notice1.Replace("{@标题}", newValue);
string loginName = admin.GetLoginModel().LoginName;
this.dal.Cancel(tableName, id);
if ((num2 == 0) && (num3 > 0))
{
B_WebMessage message = new B_WebMessage();
M_WebMessage model = new M_WebMessage();
model.Title = "退稿通知";
model.Content = str3;
model.IsRead = 0;
model.IsSend = 1;
model.ReceiverId = num3;
model.ReceiverName = str;
model.SendId = 0;
model.SendName = loginName;
model.OverdueDate = DateTime.Now;
model.AddDate = DateTime.Now;
model.ReceiverDel = 0;
model.SendDel = 0;
message.Insert(model);
}
}
}
}
}
public void Insert(M_WebMessage model)
{
this.iwebm.Insert(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string Action = Request.QueryString["Action"];
string Id = Request.QueryString["MessageId"];
string sReceiverName = Request.QueryString["ReceiverName"];
muser = buser.GetCookie();
//好友
int total = 0;
DataTable dt = new DataTable();
dt = buser.ListGroupMember("KyUserFriend.UserId=" + muser.UserID + " and FriendGroupId!=2", 1000, 1, ref total);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
UserFriend.Items.Add(new ListItem(dt.Rows[i]["LogName"].ToString(), dt.Rows[i]["LogName"].ToString()));
}
}
if (Action == null)
{
Action = "";
}
if (Id == null)
{
Id = "";
}
if (sReceiverName == null)
{
sReceiverName = "";
}
if (sReceiverName != "")
{
ReceiverName.Text = sReceiverName;
}
if (Action != "" || Id != "")
{
m_message = b_message.Show(int.Parse(Id), muser.UserID);
if (m_message.AllUser == 0 && m_message.UserGroupId == 0)
{
if (Action == "Re")
{
ReceiverName.Text = m_message.SendName;
Title.Text = "Re：" + m_message.Title + "";
Content.Text = "======在 " + m_message.AddDate + " 您来信中写道：======\r\n<br/>" + Function.Decode(m_message.Content) + "\n=======================================\n";
}
}
if (Action == "Fw")
{
Title.Text = "Fw：" + m_message.Title + "";
Content.Text = "======下面是转发信息======\n原发件人：" + m_message.SendName + "\n<br/>原发件内容：\n" + Function.Decode(m_message.Content) + "\n======================================\n";
}
if (m_message.IsSend == 0)
{
if (Action == "Edit")
{
ReceiverName.Text = m_message.ReceiverName;
Title.Text = m_message.Title;
Content.Text = Function.Decode(m_message.Content);
}
}
}
}
}
public M_WebMessage Show(int WMId, int UserId)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * from KyWebMessage ");
builder.Append("where WMId=" + WMId + "");
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@SqlStr", SqlDbType.NVarChar, 3910) };
commandParameters[0].Value = builder.ToString();
DataTable table = SqlHelper.ExecuteTable(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Sp_ExecuteSql", commandParameters);
if (table.Rows.Count > 0)
{
M_WebMessage message = new M_WebMessage();
if (table.Rows[0]["ReceiverId"].ToString() != "")
{
message.ReceiverId = int.Parse(table.Rows[0]["ReceiverId"].ToString());
}
message.ReceiverName = table.Rows[0]["ReceiverName"].ToString();
if (table.Rows[0]["SendId"].ToString() != "")
{
message.SendId = int.Parse(table.Rows[0]["SendId"].ToString());
}
message.SendName = table.Rows[0]["SendName"].ToString();
message.Title = table.Rows[0]["Title"].ToString();
message.Content = table.Rows[0]["Content"].ToString();
if (table.Rows[0]["IsSend"].ToString() != "")
{
message.IsSend = int.Parse(table.Rows[0]["IsSend"].ToString());
}
if (table.Rows[0]["IsRead"].ToString() != "")
{
message.IsRead = int.Parse(table.Rows[0]["IsRead"].ToString());
}
if (table.Rows[0]["ReceiverDel"].ToString() != "")
{
message.ReceiverDel = int.Parse(table.Rows[0]["ReceiverDel"].ToString());
}
if (table.Rows[0]["SendDel"].ToString() != "")
{
message.SendDel = int.Parse(table.Rows[0]["SendDel"].ToString());
}
if (table.Rows[0]["AllUser"].ToString() != "")
{
message.AllUser = int.Parse(table.Rows[0]["AllUser"].ToString());
}
if (table.Rows[0]["UserGroupId"].ToString() != "")
{
message.UserGroupId = int.Parse(table.Rows[0]["UserGroupId"].ToString());
}
if (table.Rows[0]["OverdueDate"].ToString() != "")
{
message.OverdueDate = DateTime.Parse(table.Rows[0]["OverdueDate"].ToString());
}
if (table.Rows[0]["AddDate"].ToString() != "")
{
message.AddDate = DateTime.Parse(table.Rows[0]["AddDate"].ToString());
}
if ((table.Rows[0]["AllUser"].ToString() == "0") && (table.Rows[0]["ReceiverId"].ToString() == ("" + UserId + "")))
{
this.UpdateRead(WMId);
}
return message;
}
return null;
}
public void UpdateDel(int WMId, int UserId, int DelTypeId)
{
StringBuilder builder = new StringBuilder();
if (DelTypeId == 1)
{
builder.Append("update KyWebMessage set ");
builder.Append(string.Concat(new object[] { "ReceiverDel=1 where WMId=", WMId, " and ReceiverId=", UserId, "" }));
}
if (DelTypeId == 2)
{
builder.Append("update KyWebMessage set ");
builder.Append(string.Concat(new object[] { "SendDel=1 where WMId=", WMId, " and SendId=", UserId, "" }));
}
if (DelTypeId == 3)
{
builder.Append("update KyWebMessage set ");
builder.Append(string.Concat(new object[] { "SendDel=1 where WMId=", WMId, " and SendId=", UserId, " and SendDel=0" }));
}
if (DelTypeId == 4)
{
string delType = this.GetDelType(WMId, UserId);
M_WebMessage message = new M_WebMessage();
message = this.Show(WMId, UserId);
if (((message.ReceiverDel == 2) || (message.SendDel == 2)) || (((message.SendId == message.ReceiverId) && (message.ReceiverDel == 1)) && (message.SendDel == 1)))
{
builder.Append("delete KyWebMessage ");
builder.Append("where WMId=" + WMId + "");
}
else
{
builder.Append("update KyWebMessage set ");
builder.Append(string.Concat(new object[] { "", delType, "=2 where WMId=", WMId, " and ", delType, "=1" }));
}
}
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@SqlStr", SqlDbType.NVarChar, 0x7d0) };
commandParameters[0].Value = builder.ToString();
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Sp_ExecuteSql", commandParameters);
}