private void DoSelect()
{
if (!string.IsNullOrEmpty(userId))
{
sql = @"select UserId,Name as UserName,
(select top 1 GroupName from BJKY_Examine..PersonConfig where
(PatIndex('%'+UserId+'%',FirstLeaderIds)>0 or PatIndex('%'+UserId+'%',SecondLeaderIds)>0 or PatIndex('%'+UserId+'%',ClerkIds)>0)
and GroupType in ('经营目标单位','职能服务部门')) as DeptName from BJKY_Portal..SysUser where UserId='{0}'";
sql = string.Format(sql, userId);
PageState.Add("DataList", DataHelper.QueryDictList(sql));
}
if (!string.IsNullOrEmpty(deptId))
{
sql = @"select UserId,Name as UserName,(select top 1 GroupName from BJKY_Examine..PersonConfig where Id='{0}') as DeptName
from BJKY_Portal..SysUser where PatIndex('%'+UserId+'%',
(select top 1 FirstLeaderIds+','+SecondLeaderIds+','+convert(varchar(8000),ClerkIds) from BJKY_Examine..PersonConfig where Id='{0}'))>0";
sql = string.Format(sql, deptId);
PageState.Add("DataList", DataHelper.QueryDictList(sql));
}
if (!string.IsNullOrEmpty(id))// top 1,'{0}' as UserId,
{
ent = IntegratedMessage.Find(id);
SetFormData(ent);
if (ent.SubmitState == "1")//已发送
{
sql = @"select top 1 GroupName as DeptName,'{0}' as UserId,
(select top 1 Name from SysUser where UserId='{0}') as UserName from BJKY_Examine..PersonConfig where
(PatIndex('%{0}%',FirstLeaderIds)>0 or PatIndex('%{0}%',SecondLeaderIds)>0 or PatIndex('%{0}%',ClerkIds)>0) and
GroupType in ('经营目标单位','职能服务部门')";
sql = string.Format(sql, ent.ReceiverId);
PageState.Add("DataList", DataHelper.QueryDictList(sql));
}
else
{
if (!string.IsNullOrEmpty(ent.ReceiverIds))//未发送的消息有可能没有指定接收人
{
sql = @"select UserID as UserId ,Name as UserName,
(select top 1 GroupName from BJKY_Examine..PersonConfig
where (PatIndex('%'+UserId+'%',FirstLeaderIds)>0 or PatIndex('%'+UserId+'%',SecondLeaderIds)>0
or PatIndex('%'+UserId+'%',ClerkIds)>0) and GroupType in ('经营目标单位','职能服务部门')) as DeptName
from SysUser where PatIndex('%'+UserId+'%','{0}')>0";
sql = string.Format(sql, ent.ReceiverIds);
PageState.Add("DataList", DataHelper.QueryDictList(sql));
}
}
string sql1 = @"select * from BJKY_Portal..FileItem where PatIndex('%'+Id+'%','{0}')>0";
sql1 = string.Format(sql1, ent.Attachment);
PageState.Add("FileList", DataHelper.QueryDictList(sql1));
}
PageState.Add("MessageType", SysEnumeration.GetEnumDict("MessageType"));
}
protected void Page_Load(object sender, EventArgs e)
{
according = RequestData.Get <string>("According");
createId = RequestData.Get <string>("CreateId");
messageType = Server.UrlDecode(RequestData.Get <string>("MessageType"));
id = RequestData.Get <string>("id");
msgContent = Server.UrlDecode(RequestData.Get <string>("MessageContent"));
receiverId = RequestData.Get <string>("ReceiverId");
if (!string.IsNullOrEmpty(id))
{
ent = IntegratedMessage.Find(id);
}
switch (RequestActionString)
{
case "SignRead":
ent.State = "1";
ent.DoUpdate();
break;
case "Delete":
ent.State = "2";
ent.DoUpdate();
break;
case "SendMessage":
ent = new IntegratedMessage();
ent.ReceiverId = receiverId;
ent.ReceiverName = SysUser.Find(receiverId).Name;
ent.MessageType = "一般消息";
ent.MessageContent = msgContent;
ent.SubmitState = "1";
ent.DoCreate();
break;
default:
DoSelect();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Index = RequestData.Get <string>("Index");
IList <string> ids = RequestData.GetList <string>("ids");
switch (RequestActionString)
{
case "HaveRead":
if (ids.Count > 0)
{
foreach (string str in ids)
{
ent = IntegratedMessage.Find(str);
ent.State = "1";
ent.DoUpdate();
}
}
break;
default:
DoSelect();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
userId = RequestData.Get <string>("UserId");
id = RequestData.Get <string>("id");
Action = RequestData.Get <string>("Action");
deptId = RequestData.Get <string>("DeptId");
switch (RequestActionString)
{
case "ImportFile":
string fileIds = RequestData.Get <string>("fileIds");
if (!string.IsNullOrEmpty(fileIds))
{
sql = @"select * from BJKY_Portal..FileItem where PatIndex('%'+Id+'%','{0}')>0";
sql = string.Format(sql, fileIds);
PageState.Add("Result", DataHelper.QueryDictList(sql));
}
break;
case "AddUser":
IList <string> userIds = RequestData.GetList <string>("UserIds");
string struserIds = "";
for (int i = 0; i < userIds.Count; i++)
{
struserIds += userIds[i] + ",";
}
sql = @"select UserId,Name as UserName,(select top 1 GroupName from BJKY_Examine..PersonConfig where
(PatIndex('%'+UserId+'%',FirstLeaderIds)>0 or PatIndex('%'+UserId+'%',SecondLeaderIds)>0 or PatIndex('%'+UserId+'%',ClerkIds)>0)
and GroupType in ('经营目标单位','职能服务部门')) as DeptName from BJKY_Portal..SysUser where PatIndex('%'+UserId+'%','{0}')>0";
sql = string.Format(sql, struserIds);
PageState.Add("Users", DataHelper.QueryDictList(sql));
break;
case "update":
ent = GetMergedData <IntegratedMessage>();
if (Action == "Send")
{
string[] userIdArray = ent.ReceiverIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
string[] userNameArray = ent.ReceiverNames.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < userIdArray.Length; i++)
{
IntegratedMessage imEnt = new IntegratedMessage();
imEnt.ReceiverId = userIdArray[i];
imEnt.ReceiverName = userNameArray[i];
imEnt.MessageType = ent.MessageType;
imEnt.MessageContent = ent.MessageContent;
imEnt.Attachment = ent.Attachment;
imEnt.ShortMessage = ent.ShortMessage;
imEnt.Mail = ent.Mail;
imEnt.SubmitState = "1";
imEnt.DoCreate();
}
ent.DoDelete();
}
else
{
ent.DoUpdate();
}
break;
case "create":
ent = GetPostedData <IntegratedMessage>();
ent.DoCreate();
if (Action == "Send")
{
string[] userIdArray = ent.ReceiverIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
string[] userNameArray = ent.ReceiverNames.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < userIdArray.Length; i++)
{
IntegratedMessage imEnt = new IntegratedMessage();
imEnt.ReceiverId = userIdArray[i];
imEnt.ReceiverName = userNameArray[i];
imEnt.MessageType = ent.MessageType;
imEnt.MessageContent = ent.MessageContent;
imEnt.Attachment = ent.Attachment;
imEnt.ShortMessage = ent.ShortMessage;
imEnt.Mail = ent.Mail;
imEnt.SubmitState = "1";
imEnt.DoCreate();
}
ent.DoDelete();
}
break;
default:
DoSelect();
break;
}
}
