public List <Calendars> Find_Calendar_ByPara_list(string uid, string eid)
{
string text = "select * from Calendar where {0}";
string arg = string.Concat(new string[]
{
" LogicDelete=0 and Uid='",
uid,
"' and Eid='",
eid,
"' "
});
text = string.Format(text, arg);
List <Calendars> result;
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, text, new SqlParameter[0]))
{
if (dataSet.Tables[0].Rows.Count > 0)
{
List <Calendars> list = new List <Calendars>();
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
list.Add(this.SetPram(dataSet.Tables[0].Rows[i]));
}
result = list;
}
else
{
result = null;
}
}
return(result);
}
public Calendars Find_Calendar_ByPara(string uid, string eid)
{
string text = "select * from Calendar where {0}";
string arg = string.Concat(new string[]
{
" LogicDelete=0 and Uid='",
uid,
"' and Eid='",
eid,
"' "
});
text = string.Format(text, arg);
Calendars result;
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, text, new SqlParameter[0]))
{
if (dataSet.Tables[0].Rows.Count > 0)
{
result = this.SetPram(dataSet.Tables[0].Rows[0]);
}
else
{
result = null;
}
}
return(result);
}
private static void BBS_Login(string u, string p)
{
string text = p.Substring(8, 16).ToLower();
HttpCookie httpCookie = new HttpCookie("DXBBS");
httpCookie["UserName"] = Filter.Encode(u, ForumConfig.ReadConfigInfo().SecureKey);
httpCookie["UserPass"] = Filter.Encode(text, ForumConfig.ReadConfigInfo().SecureKey);
httpCookie["Key"] = Filter.Encode(Clients.CookiesKey, ForumConfig.ReadConfigInfo().SecureKey);
httpCookie.Expires = DateTime.Now.AddDays((double)2);
httpCookie["IsHide"] = "false";
HttpContext.Current.Response.Cookies.Add(httpCookie);
string cmdText = "select a.*,b.LevelName from WC_Forum_User a,WC_Forum_Level b where username=@u and a.LevelID=b.id";
DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[]
{
new SqlParameter("@u", u)
});
int num = 0;
int.TryParse(dataSet.Tables[0].Rows[0]["ID"].ToString(), out num);
if (num > 0)
{
Sessions.UserID = num;
Sessions.UserName = u;
Sessions.LevelID = Convert.ToInt32(dataSet.Tables[0].Rows[0]["LevelID"]);
Sessions.LevelName = string.Concat(dataSet.Tables[0].Rows[0]["LevelName"]);
}
dataSet.Dispose();
}
private void Bind(string sql, Repeater r)
{
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, sql, null))
{
r.DataSource = dataSet.Tables[0].DefaultView;
r.DataBind();
}
}
private void Show()
{
Hashtable hashtable = (Hashtable)HttpContext.Current.Application["config_fenye"];
//int pageSize = Convert.ToInt32(hashtable["fenye_commom"]);
int pageSize = 20;
int num = 0;
try
{
if (!string.IsNullOrEmpty(base.Request.QueryString["page"]))
{
num = Convert.ToInt32(base.Request.QueryString["page"]);
}
}
catch
{
}
if (num == 0)
{
num = 1;
}
PagedDataSource pagedDataSource = new PagedDataSource();
string text = " a.TypeID = b.id ";
string text2 = base.Request.QueryString["keywords"];
if (!string.IsNullOrEmpty(text2) && Utils.CheckSql(text2))
{
text = " a.TypeID = b.id ";
text = text + " and (a.NewsTitle like '%" + text2 + "%' ) ";
}
if (!string.IsNullOrEmpty(base.Request.QueryString["tid"]))
{
string str = base.Request.QueryString["tid"];
text = " a.TypeID=" + str + " and a.TypeID = b.id ";
}
string cmdText = "select a.*,b.TypeName from News_Article as a,News_Type as b where " + text + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.num.InnerHtml = "当前查询条件总计 - <span style='color:#ff0000; font-weight:bold;'>" + dataSet.Tables[0].Rows.Count + "</span> 条 记录数据";
pagedDataSource.DataSource = dataSet.Tables[0].DefaultView;
pagedDataSource.AllowPaging = true;
pagedDataSource.PageSize = pageSize;
pagedDataSource.CurrentPageIndex = num - 1;
this.rpt.DataSource = pagedDataSource;
this.rpt.DataBind();
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
this.Page2.sty("meneame", num, pagedDataSource.PageCount, "?keywords=" + text2 + "&page=");
}
if (!string.IsNullOrEmpty(base.Request.QueryString["tid"]))
{
this.Page2.sty("meneame", num, pagedDataSource.PageCount, "?tid=" + base.Request.QueryString["tid"] + "&page=");
}
this.Page2.sty("meneame", num, pagedDataSource.PageCount, "?page=");
}
}
public List <Calendars> Find_Calendar_List_ByUID_and_TIME(string[] uid, string[] stime, string[] etime, int startIndex, int pageNum)
{
string text = " ";
for (int i = 0; i < uid.Length; i++)
{
if (i != uid.Length - 1)
{
string text2 = text;
text = string.Concat(new string[]
{
text2,
" ( logicdelete= 0 and UID = '",
uid[i].ToString(),
"' and STime > '",
stime[i].ToString(),
"' and STime <= '",
etime[i].ToString(),
"') or "
});
}
else
{
string text2 = text;
text = string.Concat(new string[]
{
text2,
" ( logicdelete= 0 and UID = '",
uid[i].ToString(),
"' and STime > '",
stime[i].ToString(),
"' and STime <= '",
etime[i].ToString(),
"') "
});
}
}
string text3 = "select * from Calendar where {0}";
text3 = string.Format(text3, text);
List <Calendars> result;
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, text3, new SqlParameter[0]))
{
List <Calendars> list = new List <Calendars>();
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
list.Add(this.SetPram(dataSet.Tables[0].Rows[i]));
}
result = list;
}
return(result);
}
private void Show1()
{
this.type1.Visible = true;
if (!string.IsNullOrEmpty(base.Request.QueryString["tid"]))
{
this.Attend1.Visible = true;
}
string cmdText = "select a.id,a.AttendNames,a.AttendTimes,b.SignTimes,b.SignJudge,b.Notes,b.id as wid from Work_AttendSet as a left join (select * from Work_Attend where AttendType=1 and UID=" + this.Uid + " and datediff(d,addtime,getdate())=0) as b on a.id=b.AttendTimeID";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.rpt1.DataSource = dataSet.Tables[0].DefaultView;
this.rpt1.DataBind();
}
}
private void GetFirtNode()
{
DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, "select * from Gov_Model_Type", null);
dataSet.Relations.Add("sort", dataSet.Tables[0].Columns["id"], dataSet.Tables[0].Columns["ParentID"], false);
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
if (dataRow["ParentID"].ToString() == "0")
{
Gov_Model_TypeInfo gov_Model_TypeInfo = this.SetPram(dataRow);
gov_Model_TypeInfo.Ch = "";
gov_Model_TypeInfo.Sh = gov_Model_TypeInfo.TypeName;
this.li.Add(gov_Model_TypeInfo);
this.PopulateSubTree(dataRow, this.i);
}
}
}
private void GetFirtNode()
{
DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, "select * from Sys_Dep order by orders asc", null);
dataSet.Relations.Add("sort", dataSet.Tables[0].Columns["id"], dataSet.Tables[0].Columns["ParentID"], false);
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
if (dataRow["ParentID"].ToString() == "0")
{
Sys_DepInfo sys_DepInfo = this.SetPram(dataRow);
sys_DepInfo.Ch = "<img src=../images/ico_system.gif />";
this.li.Add(sys_DepInfo);
this.PopulateSubTree(dataRow, this.i);
}
}
dataSet.Dispose();
}
private void GetFirtNode()
{
DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, "select * from Flows_Model_Type order by orders asc", null);
dataSet.Relations.Add("sort", dataSet.Tables[0].Columns["id"], dataSet.Tables[0].Columns["ParentID"], false);
Flows_Model_TypeInfo flows_Model_TypeInfo = new Flows_Model_TypeInfo();
flows_Model_TypeInfo.id = 0;
flows_Model_TypeInfo.Ch = "<img src=../images/ico_faq.gif />";
flows_Model_TypeInfo.TypeName = "不属于任何分类的流程";
this.li.Add(flows_Model_TypeInfo);
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
if (dataRow["ParentID"].ToString() == "0")
{
Flows_Model_TypeInfo flows_Model_TypeInfo2 = this.SetPram(dataRow);
flows_Model_TypeInfo2.Ch = "<img src=../images/ico_browsefolder.gif />";
this.li.Add(flows_Model_TypeInfo2);
this.PopulateSubTree(dataRow, this.i);
}
}
dataSet.Dispose();
}
private void Show(int vid)
{
VoteInfo byId = Vote.Init().GetById(vid);
if (!string.IsNullOrEmpty(byId.VoteContent) && (byId.ShowUser == 1 || this.Modules.Contains("45")))
{
this.ds = MsSqlOperate.ExecuteDataset(CommandType.Text, "select * from VoteDetail where VoteID=" + vid, new SqlParameter[0]);
List <TmpInfo> list = new List <TmpInfo>();
if (byId.VoteContent.Contains("\n"))
{
string[] array = byId.VoteContent.Split(new string[]
{
"\n"
}, StringSplitOptions.None);
for (int i = 0; i < array.Length; i++)
{
if (!string.IsNullOrEmpty(array[i].Replace("\n", "").Replace("\r", "")))
{
list.Add(new TmpInfo
{
Tmp1 = array[i].Replace("\n", "").Replace("\r", "")
});
}
}
}
else
{
list.Add(new TmpInfo
{
Tmp1 = byId.VoteContent.Replace("\n", "").Replace("\r", "")
});
}
this.rpt.DataSource = list;
this.rpt.DataBind();
}
}
private void DownLoad()
{
string text = "";
int num = Convert.ToInt32(base.Request.QueryString["uid"]);
int num2 = Convert.ToInt32(base.Request.QueryString["st"]);
Sys_UserInfo byId = Sys_User.Init().GetById(num);
string date = this.GetDate(num2);
string text2 = byId.RealName + " (" + byId.DepName + ")\r\n\r\n";
string text3 = text;
text = string.Concat(new string[]
{
text3,
text2,
" ",
date,
"\r\n\r\n"
});
if (byId.et6.Contains("#" + this.Uid + "#"))
{
string cmdText = string.Concat(new object[]
{
"select * from Calendar where uid='",
num,
"' and stime like '",
num2,
"%' order by stime asc"
});
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
string j = string.Concat(dataSet.Tables[0].Rows[i]["stime"]);
string j2 = string.Concat(dataSet.Tables[0].Rows[i]["etime"]);
DateTime datetime = this.GetDatetime(j);
DateTime datetime2 = this.GetDatetime(j2);
if (Utils.GetDayOf2Date(datetime, datetime2) == 1)
{
text = text + "时间：" + this.GetTime(j) + "\r\n";
object obj = text;
text = string.Concat(new object[]
{
obj,
"标题：",
dataSet.Tables[0].Rows[i]["ename"],
"\r\n"
});
obj = text;
text = string.Concat(new object[]
{
obj,
"详情：",
dataSet.Tables[0].Rows[i]["memo"],
"\r\n\r\n"
});
}
else
{
text3 = text;
text = string.Concat(new string[]
{
text3,
"时间：",
this.GetTime(j),
" 至 ",
this.GetTime(j2),
"\r\n"
});
object obj = text;
text = string.Concat(new object[]
{
obj,
"标题：",
dataSet.Tables[0].Rows[i]["ename"],
"\r\n"
});
obj = text;
text = string.Concat(new object[]
{
obj,
"详情：",
dataSet.Tables[0].Rows[i]["memo"],
"\r\n\r\n"
});
}
}
}
base.Response.Clear();
base.Response.ClearHeaders();
base.Response.Buffer = false;
base.Response.AppendHeader("Content-Disposition", "attachment;filename=" + num2 + ".txt");
base.Response.ContentType = "application/vnd.txt";
base.Response.Write(text);
base.Response.Flush();
base.Response.End();
}
else
{
base.Response.Write(string.Concat(new string[]
{
"<script>alert('您不是",
byId.RealName,
"(",
byId.DepName,
")的直接上级,无权查看他的工作日程');window.location='/manage/common/MyMemo.aspx'</script>"
}));
}
}
private void Show()
{
Hashtable hashtable = (Hashtable)HttpContext.Current.Application["config_fenye"];
int pageSize = Convert.ToInt32(hashtable["fenye_commom"]);
string text = "1=1";
string text2 = base.Request.QueryString["keywords"];
if (!string.IsNullOrEmpty(text2) && Utils.CheckSql(text2))
{
text = string.Concat(new string[]
{
" (a.CRM_Name like '%",
text2,
"%' or b.ContactAim like '%",
text2,
"%') "
});
}
string cmdText = string.Concat(new string[]
{
"select a.id as crmid,a.CRM_Name as crm,b.id as contactid,b.ContactAim as ContactTitle,b.addtime as ContactTime from crm a,crm_contact b where a.id=b.cid and a.CreatorID=",
this.Uid,
" and ",
text,
" order by b.id desc"
});
DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]);
int num = 0;
try
{
if (!string.IsNullOrEmpty(base.Request.QueryString["page"]))
{
num = Convert.ToInt32(base.Request.QueryString["page"]);
}
}
catch
{
}
if (num == 0)
{
num = 1;
}
PagedDataSource pagedDataSource = new PagedDataSource();
pagedDataSource.DataSource = dataSet.Tables[0].DefaultView;
pagedDataSource.AllowPaging = true;
pagedDataSource.PageSize = pageSize;
pagedDataSource.CurrentPageIndex = num - 1;
this.rpt.DataSource = pagedDataSource;
this.rpt.DataBind();
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
this.Page1.sty("meneame", num, pagedDataSource.PageCount, "?keywords=" + base.Request.QueryString["keywords"] + "&page=");
}
else
{
this.Page1.sty("meneame", num, pagedDataSource.PageCount, "?page=");
}
this.rpt.DataSource = pagedDataSource;
this.rpt.DataBind();
this.num.InnerHtml = "当前查询条件总计 - <span style='color:#ff0000; font-weight:bold;'>" + dataSet.Tables[0].Rows.Count + "</span> 条 记录数据";
dataSet.Dispose();
}
private static void BBS_Update(string u, string p, Sys_UserInfo dxbbs_ui)
{
if (dxbbs_ui != null)
{
string text = p.Substring(8, 16).ToLower();
string cmdText = "select * from WC_Forum_User where username=@u";
DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[]
{
new SqlParameter("@u", u)
});
string text2 = text;
int num = Math.Abs(dxbbs_ui.Sex - 1);
string text3;
if (num != 1)
{
text3 = "userface/girl.jpg";
}
else
{
text3 = "userface/boy.jpg";
}
string realName = dxbbs_ui.RealName;
string iP = RequestUtils.GetIP();
if (dataSet.Tables[0].Rows.Count > 0)
{
string cmdText2;
if (dxbbs_ui.RoleID != 4)
{
cmdText2 = string.Concat(new object[]
{
"update WC_Forum_User set UserPass='******',sex=",
num,
",NickName='",
realName,
"',LoginIP='",
iP,
"',LoginTime=getdate() where username='******';"
});
}
else
{
cmdText2 = string.Concat(new object[]
{
"update WC_Forum_User set UserPass='******',sex=",
num,
",NickName='",
realName,
"',LoginIP='",
iP,
"',LevelID=1,LoginTime=getdate() where username='******';"
});
}
MsSqlOperate.ExecuteNonQuery(CommandType.Text, cmdText2, new SqlParameter[0]);
}
else
{
string cmdText3;
if (dxbbs_ui.RoleID != 4)
{
cmdText3 = string.Concat(new object[]
{
"insert into WC_Forum_User(UserName,UserPass,PasswordType,Question,Answer,Email,Sex,Photo,PhotoWidth,PhotoHeight,NickName,LevelID,RegTime,UploadTime,LoginTime,LevelType,ip) values('",
u,
"','",
text2,
"',1,'123','456','*****@*****.**',",
num,
",'",
text3,
"',100,100,'",
realName,
"',7,getdate(),getdate(),getdate(),5,'",
iP,
"');"
});
}
else
{
cmdText3 = string.Concat(new object[]
{
"insert into WC_Forum_User(UserName,UserPass,PasswordType,Question,Answer,Email,Sex,Photo,PhotoWidth,PhotoHeight,NickName,LevelID,RegTime,UploadTime,LoginTime,LevelType,ip) values('",
u,
"','",
text2,
"',1,'123','456','*****@*****.**',",
num,
",'",
text3,
"',100,100,'",
realName,
"',1,getdate(),getdate(),getdate(),1,'",
iP,
"');"
});
}
MsSqlOperate.ExecuteNonQuery(CommandType.Text, cmdText3, new SqlParameter[0]);
}
dataSet.Dispose();
}
}
private void Show(string uid, string st)
{
Sys_UserInfo byId = Sys_User.Init().GetById(Convert.ToInt32(uid));
this.t = this.GetDate(st);
this.uname = byId.RealName + " (" + byId.DepName + ")";
string text = this.ct;
this.ct = string.Concat(new string[]
{
text,
this.uname,
" ",
this.t,
"\r\n\r\n"
});
if (byId.et6.Contains("#" + this.Uid + "#"))
{
int num = Convert.ToInt32(uid);
Convert.ToInt32(st);
string cmdText = string.Concat(new object[]
{
"select * from Calendar where uid='",
num,
"' and stime like '",
st,
"%' order by stime asc"
});
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
string j = string.Concat(dataSet.Tables[0].Rows[i]["stime"]);
string j2 = string.Concat(dataSet.Tables[0].Rows[i]["etime"]);
DateTime datetime = this.GetDatetime(j);
DateTime datetime2 = this.GetDatetime(j2);
if (Utils.GetDayOf2Date(datetime, datetime2) == 1)
{
this.ct = this.ct + "时间：" + this.GetTime(j) + "\r\n";
object obj = this.ct;
this.ct = string.Concat(new object[]
{
obj,
"标题：",
dataSet.Tables[0].Rows[i]["ename"],
"\r\n"
});
obj = this.ct;
this.ct = string.Concat(new object[]
{
obj,
"详情：",
dataSet.Tables[0].Rows[i]["memo"],
"\r\n\r\n"
});
}
else
{
text = this.ct;
this.ct = string.Concat(new string[]
{
text,
"时间：",
this.GetTime(j),
" 至 ",
this.GetTime(j2),
"\r\n"
});
object obj = this.ct;
this.ct = string.Concat(new object[]
{
obj,
"标题：",
dataSet.Tables[0].Rows[i]["ename"],
"\r\n"
});
obj = this.ct;
this.ct = string.Concat(new object[]
{
obj,
"详情：",
dataSet.Tables[0].Rows[i]["memo"],
"\r\n\r\n"
});
}
}
this.Bodys.Value = this.ct;
return;
}
}
base.Response.Write(string.Concat(new string[]
{
"<script>alert('您不是",
byId.RealName,
"(",
byId.DepName,
")的直接上级,无权查看他的工作日程');window.location='/manage/common/MyMemo.aspx'</script>"
}));
}
private void Show()
{
SqlParameter sqlParameter = new SqlParameter();
sqlParameter.ParameterName = "@uid";
sqlParameter.Size = 50;
sqlParameter.Value = this.Uid;
SqlParameter sqlParameter2 = new SqlParameter();
sqlParameter2.ParameterName = "@depid";
sqlParameter2.Size = 50;
sqlParameter2.Value = this.DepID;
SqlParameter sqlParameter3 = new SqlParameter();
sqlParameter3.Direction = ParameterDirection.Output;
sqlParameter3.ParameterName = "@pt1";
sqlParameter3.Size = 4;
SqlParameter sqlParameter4 = new SqlParameter();
sqlParameter4.Direction = ParameterDirection.Output;
sqlParameter4.ParameterName = "@pt2";
sqlParameter4.Size = 4;
SqlParameter sqlParameter5 = new SqlParameter();
sqlParameter5.Direction = ParameterDirection.Output;
sqlParameter5.ParameterName = "@pt3";
sqlParameter5.Size = 4;
SqlParameter sqlParameter6 = new SqlParameter();
sqlParameter6.Direction = ParameterDirection.Output;
sqlParameter6.ParameterName = "@pt4";
sqlParameter6.Size = 4;
SqlParameter sqlParameter7 = new SqlParameter();
sqlParameter7.Direction = ParameterDirection.Output;
sqlParameter7.ParameterName = "@pt5";
sqlParameter7.Size = 4;
SqlParameter sqlParameter8 = new SqlParameter();
sqlParameter8.Direction = ParameterDirection.Output;
sqlParameter8.ParameterName = "@pt6";
sqlParameter8.Size = 4;
SqlParameter sqlParameter9 = new SqlParameter();
sqlParameter9.Direction = ParameterDirection.Output;
sqlParameter9.ParameterName = "@pt7";
sqlParameter9.Size = 4;
SqlParameter sqlParameter10 = new SqlParameter();
sqlParameter10.Direction = ParameterDirection.Output;
sqlParameter10.ParameterName = "@pt8";
sqlParameter10.Size = 4;
SqlParameter sqlParameter11 = new SqlParameter();
sqlParameter11.Direction = ParameterDirection.Output;
sqlParameter11.ParameterName = "@pt10";
sqlParameter11.Size = 4;
SqlParameter sqlParameter12 = new SqlParameter();
sqlParameter12.Direction = ParameterDirection.Output;
sqlParameter12.ParameterName = "@pt11";
sqlParameter12.Size = 4;
SqlParameter sqlParameter13 = new SqlParameter();
sqlParameter13.Direction = ParameterDirection.Output;
sqlParameter13.ParameterName = "@pt12";
sqlParameter13.Size = 4;
SqlParameter sqlParameter14 = new SqlParameter();
sqlParameter14.Direction = ParameterDirection.Output;
sqlParameter14.ParameterName = "@pt13";
sqlParameter14.Size = 4;
SqlParameter[] cmdParms = new SqlParameter[]
{
sqlParameter3,
sqlParameter4,
sqlParameter5,
sqlParameter6,
sqlParameter7,
sqlParameter8,
sqlParameter9,
sqlParameter10,
sqlParameter11,
sqlParameter12,
sqlParameter13,
sqlParameter14,
sqlParameter,
sqlParameter2
};
using (MsSqlOperate.ExecuteDataset(CommandType.StoredProcedure, "Global_GetDesktopData", cmdParms))
{
this.news_num = string.Concat(sqlParameter3.Value);
this.mails_num1 = string.Concat(sqlParameter4.Value);
this.mails_num2 = string.Concat(sqlParameter5.Value);
this.flows_num1 = string.Concat(sqlParameter6.Value);
this.flows_num2 = string.Concat(sqlParameter7.Value);
this.calendar_num = string.Concat(sqlParameter8.Value);
this.note_num = string.Concat(sqlParameter9.Value);
this.mydoc_num = string.Concat(sqlParameter10.Value);
this.shared_num = string.Concat(sqlParameter11.Value);
this.shared_num2 = string.Concat(sqlParameter12.Value);
this.exe_num = string.Concat(sqlParameter13.Value);
this.man_num = string.Concat(sqlParameter14.Value);
this.work_num1 = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, "select count(id) from worklog where CreatorID=" + this.Uid, new SqlParameter[0]));
this.work_num2 = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, string.Concat(new string[]
{
"select count(id) from worklog where CreatorID<>",
this.Uid,
" and ShareUsers like '%#",
this.Uid,
"#%' "
}), new SqlParameter[0]));
}
}
private void Show()
{
SqlParameter sqlParameter = new SqlParameter();
sqlParameter.ParameterName = "@uid";
sqlParameter.Size = 50;
sqlParameter.Value = this.Uid;
SqlParameter sqlParameter2 = new SqlParameter();
sqlParameter2.ParameterName = "@depid";
sqlParameter2.Size = 50;
sqlParameter2.Value = this.DepID;
SqlParameter sqlParameter3 = new SqlParameter();
sqlParameter3.Direction = ParameterDirection.Output;
sqlParameter3.ParameterName = "@pt1";
sqlParameter3.Size = 4;
SqlParameter sqlParameter4 = new SqlParameter();
sqlParameter4.Direction = ParameterDirection.Output;
sqlParameter4.ParameterName = "@pt2";
sqlParameter4.Size = 4;
SqlParameter sqlParameter5 = new SqlParameter();
sqlParameter5.Direction = ParameterDirection.Output;
sqlParameter5.ParameterName = "@pt3";
sqlParameter5.Size = 4;
SqlParameter sqlParameter6 = new SqlParameter();
sqlParameter6.Direction = ParameterDirection.Output;
sqlParameter6.ParameterName = "@pt4";
sqlParameter6.Size = 4;
SqlParameter sqlParameter7 = new SqlParameter();
sqlParameter7.Direction = ParameterDirection.Output;
sqlParameter7.ParameterName = "@pt5";
sqlParameter7.Size = 4;
SqlParameter sqlParameter8 = new SqlParameter();
sqlParameter8.Direction = ParameterDirection.Output;
sqlParameter8.ParameterName = "@pt6";
sqlParameter8.Size = 4;
SqlParameter sqlParameter9 = new SqlParameter();
sqlParameter9.Direction = ParameterDirection.Output;
sqlParameter9.ParameterName = "@pt7";
sqlParameter9.Size = 4;
SqlParameter sqlParameter10 = new SqlParameter();
sqlParameter10.Direction = ParameterDirection.Output;
sqlParameter10.ParameterName = "@pt8";
sqlParameter10.Size = 4;
SqlParameter sqlParameter11 = new SqlParameter();
sqlParameter11.Direction = ParameterDirection.Output;
sqlParameter11.ParameterName = "@pt10";
sqlParameter11.Size = 4;
SqlParameter sqlParameter12 = new SqlParameter();
sqlParameter12.Direction = ParameterDirection.Output;
sqlParameter12.ParameterName = "@pt11";
sqlParameter12.Size = 4;
SqlParameter sqlParameter13 = new SqlParameter();
sqlParameter13.Direction = ParameterDirection.Output;
sqlParameter13.ParameterName = "@pt12";
sqlParameter13.Size = 4;
SqlParameter sqlParameter14 = new SqlParameter();
sqlParameter14.Direction = ParameterDirection.Output;
sqlParameter14.ParameterName = "@pt13";
sqlParameter14.Size = 4;
SqlParameter[] cmdParms = new SqlParameter[]
{
sqlParameter3,
sqlParameter4,
sqlParameter5,
sqlParameter6,
sqlParameter7,
sqlParameter8,
sqlParameter9,
sqlParameter10,
sqlParameter11,
sqlParameter12,
sqlParameter13,
sqlParameter14,
sqlParameter,
sqlParameter2
};
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.StoredProcedure, "Global_GetDesktopData", cmdParms))
{
this.news_num = string.Concat(sqlParameter3.Value);
this.mails_num1 = string.Concat(sqlParameter4.Value);
this.mails_num2 = string.Concat(sqlParameter5.Value);
this.flows_num1 = string.Concat(sqlParameter6.Value);
this.flows_num2 = string.Concat(sqlParameter7.Value);
this.calendar_num = string.Concat(sqlParameter8.Value);
this.note_num = string.Concat(sqlParameter9.Value);
this.mydoc_num = string.Concat(sqlParameter10.Value);
this.shared_num = string.Concat(sqlParameter11.Value);
this.shared_num2 = string.Concat(sqlParameter12.Value);
this.exe_num = string.Concat(sqlParameter13.Value);
this.man_num = string.Concat(sqlParameter14.Value);
this.forum_num = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, "select count(id) from wc_forum_reply1 where DateDiff(d,addtime,getdate())=0", new SqlParameter[0]));
int num = 22;
if (!string.IsNullOrEmpty(this.px))
{
int num2 = Convert.ToInt32(this.px.Split(new char[]
{
'?'
})[0]);
if (num2 < 1030 && num2 > 1000)
{
num = 22;
}
if (num2 < 1000)
{
num = 18;
}
if (num2 > 1100 && num2 < 1300)
{
num = 31;
}
if (num2 >= 1300)
{
num = 36;
}
}
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
string text = string.Format(this.tmp, new object[]
{
"/Manage/News/News_View.aspx?nid=" + dataSet.Tables[0].Rows[i]["id"],
dataSet.Tables[0].Rows[i]["NewsTitle"],
Utils.GetSubString2(string.Concat(dataSet.Tables[0].Rows[i]["NewsTitle"]), num, ".."),
Utils.ConvertDate(dataSet.Tables[0].Rows[i]["addtime"]),
"资讯" + (i + 1),
i
});
this.qyzx += text;
}
int num3 = 7 - dataSet.Tables[0].Rows.Count;
for (int i = 0; i < num3; i++)
{
this.qyzx += this.block_line;
}
for (int i = 0; i < dataSet.Tables[1].Rows.Count; i++)
{
string text;
if (string.Concat(dataSet.Tables[1].Rows[i]["isread"]) == "0")
{
text = string.Format(this.tmp_noread, new object[]
{
"/Manage/Common/Mail_View.aspx?fid=0&mid=" + dataSet.Tables[1].Rows[i]["id"],
dataSet.Tables[1].Rows[i]["Subject"] + " - " + Utils.ConvertDate3(dataSet.Tables[1].Rows[i]["SendTime"]),
Utils.GetSubString2(string.Concat(dataSet.Tables[1].Rows[i]["Subject"]), num + 1, ".."),
dataSet.Tables[1].Rows[i]["SenderRealName"],
"未读邮件" + (i + 1),
i
});
}
else
{
text = string.Format(this.tmp_hasread, new object[]
{
"/Manage/Common/Mail_View.aspx?fid=0&mid=" + dataSet.Tables[1].Rows[i]["id"],
dataSet.Tables[1].Rows[i]["Subject"] + " - " + Utils.ConvertDate3(dataSet.Tables[1].Rows[i]["SendTime"]),
Utils.GetSubString2(string.Concat(dataSet.Tables[1].Rows[i]["Subject"]), num + 1, ".."),
dataSet.Tables[1].Rows[i]["SenderRealName"],
"已读邮件" + (i + 1),
i
});
}
this.wdyj += text;
}
int num4 = 7 - dataSet.Tables[1].Rows.Count;
for (int i = 0; i < num4; i++)
{
this.wdyj += this.block_line;
}
int num5 = 0;
for (int i = 0; i < dataSet.Tables[2].Rows.Count; i++)
{
if (i < 7)
{
string text2 = string.Concat(dataSet.Tables[2].Rows[i]["CreatorRealName"]);
string arg;
if (text2.Trim() == this.RealName)
{
arg = "[我的申请] ";
}
else
{
arg = "[审批/查阅] ";
}
string text = string.Format(this.tmp_flow, new object[]
{
"/Manage/Flow/Flow_View.aspx?fl=" + dataSet.Tables[2].Rows[i]["id"],
dataSet.Tables[2].Rows[i]["Flow_Name"],
Utils.GetSubString2(arg + dataSet.Tables[2].Rows[i]["Flow_Name"], num + 1, ".."),
dataSet.Tables[2].Rows[i]["CreatorRealName"],
"流程" + (i + 1),
i
});
if (!this.wdsp.Contains(text))
{
this.wdsp += text;
}
else
{
num5++;
}
}
}
int num6 = 7 - Utils.GetSplitNum("<tr><td height=24>", this.wdsp);
for (int i = 0; i < num6; i++)
{
this.wdsp += this.block_line;
}
Hashtable hashtable = (Hashtable)HttpContext.Current.Application["stand_config"];
this.script = string.Concat(hashtable["index_tips"]);
if (dataSet.Tables[3].Rows.Count > 0)
{
string format = " marqueecontent[{0}] = '{1}'; ";
string str = "";
for (int i = 0; i < dataSet.Tables[3].Rows.Count; i++)
{
str += string.Format(format, i, string.Concat(dataSet.Tables[3].Rows[i]["tips"]));
}
this.script = str;
}
}
}
private void Show(string type)
{
if (type == "verify")
{
this.flow_list = "公文签收";
string cmdText;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string str = string.Concat(new string[]
{
" and (a.Flow_Name like '%",
text,
"%' or a.CreatorRealName like '%",
text,
"%' ) "
});
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=1 and b.sign=0 and b.UserID=" + this.Uid + str + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verify");
goto IL_112;
}
}
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=1 and b.sign=0 and b.UserID=" + this.Uid + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verify");
}
}
IL_112:
if (type == "verified")
{
this.flow_list = "已签收公文";
string cmdText;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string str = string.Concat(new string[]
{
" and (a.Flow_Name like '%",
text,
"%' or a.CreatorRealName like '%",
text,
"%' ) "
});
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=1 and b.sign=1 and b.UserID=" + this.Uid + str + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verified");
goto IL_21E;
}
}
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=1 and b.sign=1 and b.UserID=" + this.Uid + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verified");
}
}
IL_21E:
if (type == "archived")
{
this.flow_list = "已归档公文";
string cmdText;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string str = string.Concat(new string[]
{
" and (a.Flow_Name like '%",
text,
"%' or a.CreatorRealName like '%",
text,
"%' ) "
});
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=5 and b.UserID=" + this.Uid + str + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verified");
return;
}
}
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=5 and b.UserID=" + this.Uid + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "archived");
}
}
}
private void Show(string type)
{
SqlParameter sqlParameter = new SqlParameter();
sqlParameter.ParameterName = "@uid";
sqlParameter.Size = 50;
sqlParameter.Value = this.Uid;
SqlParameter sqlParameter2 = new SqlParameter();
sqlParameter2.Direction = ParameterDirection.Output;
sqlParameter2.ParameterName = "@pt1";
sqlParameter2.Size = 4;
SqlParameter sqlParameter3 = new SqlParameter();
sqlParameter3.Direction = ParameterDirection.Output;
sqlParameter3.ParameterName = "@pt2";
sqlParameter3.Size = 4;
SqlParameter sqlParameter4 = new SqlParameter();
sqlParameter4.Direction = ParameterDirection.Output;
sqlParameter4.ParameterName = "@pt3";
sqlParameter4.Size = 4;
SqlParameter sqlParameter5 = new SqlParameter();
sqlParameter5.Direction = ParameterDirection.Output;
sqlParameter5.ParameterName = "@pt4";
sqlParameter5.Size = 4;
SqlParameter[] cmdParms = new SqlParameter[]
{
sqlParameter2,
sqlParameter3,
sqlParameter4,
sqlParameter5,
sqlParameter
};
MsSqlOperate.ExecuteNonQuery(CommandType.StoredProcedure, "Flows_GetUserFlowBoxCount", cmdParms);
this.wdpy.InnerText = string.Concat(sqlParameter2.Value);
this.yjpy.InnerText = string.Concat(sqlParameter3.Value);
this.wdsq.InnerText = string.Concat(sqlParameter4.Value);
this.view.InnerText = string.Concat(sqlParameter5.Value);
if (type == "verify")
{
this.flow_list = ">> 我的批阅";
string cmdText;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string text2 = string.Concat(new string[]
{
" (Flow_Name like '%",
text,
"%' or CreatorRealName like '%",
text,
"%' ) "
});
cmdText = string.Concat(new string[]
{
"select a.* from flows a where a.status=0 and a.CurrentStepUserList like '%#",
this.Uid,
"#%' and a.CurrentStepID not in (select b.OperationStepID from Flows_StepAction b where b.UserID=",
this.Uid,
" and b.FlowID=a.id ) and ",
text2
});
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verify");
goto IL_330;
}
}
cmdText = string.Concat(new string[]
{
"select a.* from flows a where a.status=0 and a.CurrentStepUserList like '%#",
this.Uid,
"#%' and a.CurrentStepID not in (select b.OperationStepID from Flows_StepAction b where b.UserID=",
this.Uid,
" and b.FlowID=a.id ) order by a.id desc"
});
if (!string.IsNullOrEmpty(base.Request.QueryString["td"]))
{
cmdText = string.Concat(new string[]
{
"select a.* from flows a where a.comid=",
base.Request.QueryString["td"],
" and a.status=0 and a.CurrentStepUserList like '%#",
this.Uid,
"#%' and a.CurrentStepID not in (select b.OperationStepID from Flows_StepAction b where b.UserID=",
this.Uid,
" and b.FlowID=a.id ) order by a.id desc"
});
}
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verify");
}
}
IL_330:
if (type == "verified")
{
this.flow_list = ">> 已经批阅";
IList all;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string text2 = string.Concat(new string[]
{
"(Flow_Name like '%",
text,
"%' or CreatorRealName like '%",
text,
"%' ) and "
});
all = Flows.Init().GetAll(text2 + " HasOperatedUserList like '%#" + this.Uid + "#%'", "order by id desc");
}
else
{
if (string.IsNullOrEmpty(base.Request.QueryString["td"]))
{
all = Flows.Init().GetAll("HasOperatedUserList like '%#" + this.Uid + "#%'", "order by id desc");
}
else
{
all = Flows.Init().GetAll(string.Concat(new string[]
{
"comid=",
base.Request.QueryString["td"],
" and HasOperatedUserList like '%#",
this.Uid,
"#%'"
}), "order by id desc");
}
}
this.CutPage(all, "verified");
}
if (type == "apply")
{
this.flow_list = ">> 我的申请";
IList all;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string text2 = string.Concat(new string[]
{
"(Flow_Name like '%",
text,
"%' or CreatorRealName like '%",
text,
"%') and "
});
all = Flows.Init().GetAll(text2 + " CreatorID=" + this.Uid, "order by id desc");
}
else
{
if (string.IsNullOrEmpty(base.Request.QueryString["td"]))
{
all = Flows.Init().GetAll("CreatorID=" + this.Uid, "order by id desc");
}
else
{
all = Flows.Init().GetAll("comid=" + base.Request.QueryString["td"] + " and CreatorID=" + this.Uid, "order by id desc");
}
}
this.CutPage(all, "apply");
}
if (type == "view")
{
this.flow_list = ">> 抄送呈报";
IList all;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string text2 = string.Concat(new string[]
{
"(Flow_Name like '%",
text,
"%' or CreatorRealName like '%",
text,
"%' ) and "
});
all = Flows.Init().GetAll(text2 + " ViewUserList like '%#" + this.Uid + "#%'", "order by id desc");
}
else
{
if (string.IsNullOrEmpty(base.Request.QueryString["td"]))
{
all = Flows.Init().GetAll("ViewUserList like '%#" + this.Uid + "#%'", "order by id desc");
}
else
{
all = Flows.Init().GetAll(string.Concat(new string[]
{
"comid=",
base.Request.QueryString["td"],
" and ViewUserList like '%#",
this.Uid,
"#%'"
}), "order by id desc");
}
}
this.CutPage(all, "view");
}
}
private void Show()
{
IList all = News_Type.Init().GetAll(null, " order by orders asc");
for (int i = 0; i < all.Count; i++)
{
News_TypeInfo news_TypeInfo = all[i] as News_TypeInfo;
if (string.Concat(news_TypeInfo.id) == (base.Request.QueryString["tid"] ?? ""))
{
this.news_list = news_TypeInfo.TypeName;
}
}
int pageSize = 30;
int num = 0;
try
{
if (!string.IsNullOrEmpty(base.Request.QueryString["page"]))
{
num = Convert.ToInt32(base.Request.QueryString["page"]);
}
}
catch
{
}
if (num == 0)
{
num = 1;
}
PagedDataSource pagedDataSource = new PagedDataSource();
string text = " a.TypeID = b.id and ( a.ShareDeps='' or a.ShareDeps like '%#" + this.DepID + "#%') ";
string text2 = base.Request.QueryString["keywords"];
if (!string.IsNullOrEmpty(text2) && Utils.CheckSql(text2))
{
text = " a.TypeID = b.id and ( a.ShareDeps='' or a.ShareDeps like '%#" + this.DepID + "#%') ";
text = text + " and (a.NewsTitle like '%" + text2 + "%' ) ";
}
if (!string.IsNullOrEmpty(base.Request.QueryString["tid"]))
{
string text3 = base.Request.QueryString["tid"];
text = string.Concat(new string[]
{
" a.TypeID=",
text3,
" and a.TypeID = b.id and ( a.ShareDeps='' or a.ShareDeps like '%#",
this.DepID,
"#%') "
});
}
string cmdText = "select a.*,b.TypeName from News_Article as a,News_Type as b where " + text + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.num.InnerHtml = "当前总计 - <span style='color:#ff0000; font-weight:bold;'>" + dataSet.Tables[0].Rows.Count + "</span> 条 记录数据";
pagedDataSource.DataSource = dataSet.Tables[0].DefaultView;
pagedDataSource.AllowPaging = true;
pagedDataSource.PageSize = pageSize;
pagedDataSource.CurrentPageIndex = num - 1;
this.rpt.DataSource = pagedDataSource;
this.rpt.DataBind();
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
this.Page1.sty("meneame", num, pagedDataSource.PageCount, "?keywords=" + text2 + "&page=");
}
if (!string.IsNullOrEmpty(base.Request.QueryString["tid"]))
{
this.Page1.sty("meneame", num, pagedDataSource.PageCount, "?tid=" + base.Request.QueryString["tid"] + "&page=");
}
this.Page1.sty("meneame", num, pagedDataSource.PageCount, "?page=");
}
}
private void Show(int uid)
{
Sys_UserInfo byId = Sys_User.Init().GetById(uid);
if (!byId.et6.Contains("#" + this.Uid + "#"))
{
base.Response.Write(string.Concat(new string[]
{
"<script>alert('您不是",
byId.RealName,
"(",
byId.DepName,
")的直接上级,无权查看他的工作日程');window.location='/manage/common/MyMemo.aspx'</script>"
}));
}
this.uname = byId.RealName + " (" + byId.DepName + ")";
int pageSize = 30;
string text = " and 1=1 ";
string text2 = base.Request.QueryString["st"];
string text3 = base.Request.QueryString["et"];
if (!string.IsNullOrEmpty(text2) && !string.IsNullOrEmpty(text3))
{
text2 = text2.Replace("-", "");
text3 = text3.Replace("-", "");
string text4 = text;
text = string.Concat(new string[]
{
text4,
" and (SUBSTRING(STime, 1, 8) between ",
text2,
" and ",
text3,
")"
});
}
if (!string.IsNullOrEmpty(text2) && string.IsNullOrEmpty(text3))
{
text2 = text2.Replace("-", "");
text = text + " and (SUBSTRING(STime, 1, 8) between " + text2 + " and CONVERT(varchar(50), GETDATE(), 112))";
}
if (string.IsNullOrEmpty(text2) && !string.IsNullOrEmpty(text3))
{
text3 = text3.Replace("-", "");
text = text + " and (SUBSTRING(STime, 1, 8) between CONVERT(varchar(50), GETDATE(), 112) and " + text3 + ")";
}
string cmdText = string.Concat(new object[]
{
"SELECT DISTINCT SUBSTRING(STime, 1, 8) AS s FROM Calendar where uid='",
uid,
"' ",
text,
" ORDER BY s DESC"
});
int num = 0;
try
{
if (!string.IsNullOrEmpty(base.Request.QueryString["page"]))
{
num = Convert.ToInt32(base.Request.QueryString["page"]);
}
}
catch
{
}
if (num == 0)
{
num = 1;
}
PagedDataSource pagedDataSource = new PagedDataSource();
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.num.InnerHtml = "当前查询条件总计 - <span style='color:#ff0000; font-weight:bold;'>" + dataSet.Tables[0].Rows.Count + "</span> 条 记录数据 每页30条";
pagedDataSource.DataSource = dataSet.Tables[0].DefaultView;
pagedDataSource.AllowPaging = true;
pagedDataSource.PageSize = pageSize;
pagedDataSource.CurrentPageIndex = num - 1;
this.rpt.DataSource = pagedDataSource;
this.rpt.DataBind();
if (!string.IsNullOrEmpty(base.Request.QueryString["st"]) && !string.IsNullOrEmpty(base.Request.QueryString["et"]))
{
this.Page1.sty("meneame", num, pagedDataSource.PageCount, string.Concat(new string[]
{
"?uid=",
base.Request.QueryString["uid"],
"&st=",
base.Request.QueryString["st"],
"&et=",
base.Request.QueryString["et"],
"&page="
}));
}
else
{
this.Page1.sty("meneame", num, pagedDataSource.PageCount, "?uid=" + base.Request.QueryString["uid"] + "&page=");
}
}
}
private void Show(string type)
{
SqlParameter sqlParameter = new SqlParameter();
sqlParameter.ParameterName = "@uid";
sqlParameter.Size = 50;
sqlParameter.Value = this.Uid;
SqlParameter sqlParameter2 = new SqlParameter();
sqlParameter2.Direction = ParameterDirection.Output;
sqlParameter2.ParameterName = "@pt1";
sqlParameter2.Size = 4;
SqlParameter sqlParameter3 = new SqlParameter();
sqlParameter3.Direction = ParameterDirection.Output;
sqlParameter3.ParameterName = "@pt2";
sqlParameter3.Size = 4;
SqlParameter sqlParameter4 = new SqlParameter();
sqlParameter4.Direction = ParameterDirection.Output;
sqlParameter4.ParameterName = "@pt3";
sqlParameter4.Size = 4;
SqlParameter[] cmdParms = new SqlParameter[]
{
sqlParameter2,
sqlParameter3,
sqlParameter4,
sqlParameter
};
MsSqlOperate.ExecuteNonQuery(CommandType.StoredProcedure, "Gov_GetRecipientCount", cmdParms);
this.wdpy.InnerText = string.Concat(sqlParameter2.Value);
this.yjpy.InnerText = string.Concat(sqlParameter3.Value);
this.wdsq.InnerText = string.Concat(sqlParameter4.Value);
if (type == "verify")
{
this.flow_list = ">> 公文签收";
string cmdText;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string str = string.Concat(new string[]
{
" and (a.Flow_Name like '%",
text,
"%' or a.CreatorRealName like '%",
text,
"%' ) "
});
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=1 and b.sign=0 and b.UserID=" + this.Uid + str + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verify");
goto IL_216;
}
}
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=1 and b.sign=0 and b.UserID=" + this.Uid + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verify");
}
}
IL_216:
if (type == "verified")
{
this.flow_list = ">> 已签收公文";
string cmdText;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string str = string.Concat(new string[]
{
" and (a.Flow_Name like '%",
text,
"%' or a.CreatorRealName like '%",
text,
"%' ) "
});
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=1 and b.sign=1 and b.UserID=" + this.Uid + str + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verified");
goto IL_32E;
}
}
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=1 and b.sign=1 and b.UserID=" + this.Uid + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verified");
}
}
IL_32E:
if (type == "archived")
{
this.flow_list = ">> 已归档公文";
string cmdText;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string str = string.Concat(new string[]
{
" and (a.Flow_Name like '%",
text,
"%' or a.CreatorRealName like '%",
text,
"%' ) "
});
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=5 and b.UserID=" + this.Uid + str + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verified");
return;
}
}
cmdText = "select a.* from Gov a,Gov_Recipient b where a.id=b.Flow_ID and a.status=5 and b.UserID=" + this.Uid + " order by a.id desc";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "archived");
}
}
}
private void Show(string type)
{
if (type == "verify")
{
this.flow_list = "我的批阅";
string cmdText;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string text2 = string.Concat(new string[]
{
" (Flow_Name like '%",
text,
"%' or CreatorRealName like '%",
text,
"%' ) "
});
cmdText = string.Concat(new string[]
{
"select a.* from flows a where a.status=0 and a.CurrentStepUserList like '%#",
this.Uid,
"#%' and a.CurrentStepID not in (select b.OperationStepID from Flows_StepAction b where b.UserID=",
this.Uid,
" and b.FlowID=a.id ) and ",
text2
});
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verify");
goto IL_1D5;
}
}
cmdText = string.Concat(new string[]
{
"select a.* from flows a where a.status=0 and a.CurrentStepUserList like '%#",
this.Uid,
"#%' and a.CurrentStepID not in (select b.OperationStepID from Flows_StepAction b where b.UserID=",
this.Uid,
" and b.FlowID=a.id ) order by a.id desc"
});
if (!string.IsNullOrEmpty(base.Request.QueryString["td"]))
{
cmdText = string.Concat(new string[]
{
"select a.* from flows a where a.comid=",
base.Request.QueryString["td"],
" and a.status=0 and a.CurrentStepUserList like '%#",
this.Uid,
"#%' and a.CurrentStepID not in (select b.OperationStepID from Flows_StepAction b where b.UserID=",
this.Uid,
" and b.FlowID=a.id ) order by a.id desc"
});
}
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
this.CutPage(dataSet, "verify");
}
}
IL_1D5:
if (type == "verified")
{
this.flow_list = "已经批阅";
IList all;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string text2 = string.Concat(new string[]
{
"(Flow_Name like '%",
text,
"%' or CreatorRealName like '%",
text,
"%' ) and "
});
all = Flows.Init().GetAll(text2 + " HasOperatedUserList like '%#" + this.Uid + "#%'", "order by id desc");
}
else
{
if (string.IsNullOrEmpty(base.Request.QueryString["td"]))
{
all = Flows.Init().GetAll("HasOperatedUserList like '%#" + this.Uid + "#%'", "order by id desc");
}
else
{
all = Flows.Init().GetAll(string.Concat(new string[]
{
"comid=",
base.Request.QueryString["td"],
" and HasOperatedUserList like '%#",
this.Uid,
"#%'"
}), "order by id desc");
}
}
this.CutPage(all, "verified");
}
if (type == "apply")
{
this.flow_list = "我的申请";
IList all;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string text2 = string.Concat(new string[]
{
"(Flow_Name like '%",
text,
"%' or CreatorRealName like '%",
text,
"%') and "
});
all = Flows.Init().GetAll(text2 + " CreatorID=" + this.Uid, "order by id desc");
}
else
{
if (string.IsNullOrEmpty(base.Request.QueryString["td"]))
{
all = Flows.Init().GetAll("CreatorID=" + this.Uid, "order by id desc");
}
else
{
all = Flows.Init().GetAll("comid=" + base.Request.QueryString["td"] + " and CreatorID=" + this.Uid, "order by id desc");
}
}
this.CutPage(all, "apply");
}
if (type == "view")
{
this.flow_list = "抄送呈报";
IList all;
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
string text = base.Request.QueryString["keywords"];
string text2 = string.Concat(new string[]
{
"(Flow_Name like '%",
text,
"%' or CreatorRealName like '%",
text,
"%' ) and "
});
all = Flows.Init().GetAll(text2 + " ViewUserList like '%#" + this.Uid + "#%'", "order by id desc");
}
else
{
if (string.IsNullOrEmpty(base.Request.QueryString["td"]))
{
all = Flows.Init().GetAll("ViewUserList like '%#" + this.Uid + "#%'", "order by id desc");
}
else
{
all = Flows.Init().GetAll(string.Concat(new string[]
{
"comid=",
base.Request.QueryString["td"],
" and ViewUserList like '%#",
this.Uid,
"#%'"
}), "order by id desc");
}
}
this.CutPage(all, "view");
}
}
private string CheckPass(string u, string p)
{
Hashtable hashtable = (Hashtable)HttpContext.Current.Application["stand_config"];
double value = Convert.ToDouble(hashtable["user_cookie_delay"]);
IList list = new List <Sys_UserInfo>();
string cmdText = "select * from sys_user where UserName=@U and PassWord=@P";
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new List <SqlParameter>
{
new SqlParameter("@U", u ?? ""),
new SqlParameter("@P", Encrypt.MD5_32(p.Trim().ToLower()) ?? "")
}.ToArray()))
{
if (dataSet.Tables[0].Rows.Count > 0)
{
list = (IList)Utils.GetList <Sys_UserInfo>(dataSet);
}
}
string result;
if (list.Count == 0)
{
result = "n";
}
else
{
Sys_UserInfo sys_UserInfo = list[0] as Sys_UserInfo;
sys_UserInfo.IsOnline = 1;
sys_UserInfo.CurrentLoginTime = DateTime.Now.ToString("yyMddhhmmssfff");
string moduleList = this.GetModuleList(sys_UserInfo.DepID, sys_UserInfo.RoleID);
string text = string.Concat(new object[]
{
sys_UserInfo.id,
"|",
sys_UserInfo.UserName,
"|",
sys_UserInfo.RealName,
"|",
sys_UserInfo.DepID,
"|",
sys_UserInfo.DepName,
"|",
moduleList,
"|",
sys_UserInfo.CurrentLoginTime,
"|",
base.Request.Form["px"]
});
//string value2 = Encrypt.RC4_Encode(text, "lazy1111");
string value2 = Encrypt.EncryptString(text, "lazy1111");
HttpContext.Current.Session["UserCookies"] = text;
HttpContext.Current.Session.Timeout = Convert.ToInt32(value) * 10;
HttpCookie httpCookie = new HttpCookie("UserCookies");
if (!string.IsNullOrEmpty(base.Request.Form["chkRemember"]))
{
httpCookie.Expires = DateTime.Now.AddHours(value);
}
httpCookie["key"] = value2;
base.Response.Cookies.Add(httpCookie);
sys_UserInfo.LastLoginTime = DateTime.Now;
sys_UserInfo.LastLoginIp = RequestUtils.GetIP();
sys_UserInfo.LoginQuantity++;
Sys_User.Init().Update(sys_UserInfo);
IList <Sys_UserInfo> list2 = base.Application["user_online"] as IList <Sys_UserInfo>;
bool flag = false;
foreach (object current in list2)
{
Sys_UserInfo sys_UserInfo2 = current as Sys_UserInfo;
if (sys_UserInfo2.id == sys_UserInfo.id)
{
flag = true;
sys_UserInfo2.IsOnline = 1;
sys_UserInfo2.CurrentLoginTime = sys_UserInfo.CurrentLoginTime;
sys_UserInfo2.LastLoginTime = sys_UserInfo.LastLoginTime;
}
}
if (!flag)
{
list2.Add(sys_UserInfo);
}
Sys_UserLoginInfo sys_UserLoginInfo = new Sys_UserLoginInfo();
sys_UserLoginInfo.UserName = sys_UserInfo.UserName;
sys_UserLoginInfo.UserInfo = sys_UserInfo.RealName + "(" + sys_UserInfo.DepName + ")";
sys_UserLoginInfo.LoginIP = RequestUtils.GetIP();
sys_UserLoginInfo.LoginTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
Sys_UserLogin.Init().Add(sys_UserLoginInfo);
result = sys_UserInfo.Status + "," + sys_UserInfo.IsLock;
}
return(result);
}
private void GetCT(int u, ref string ct, string where)
{
string cmdText = string.Concat(new object[]
{
"select * from Calendar where uid='",
u,
"' and ",
where,
" order by stime asc"
});
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, cmdText, new SqlParameter[0]))
{
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
string j = string.Concat(dataSet.Tables[0].Rows[i]["stime"]);
string j2 = string.Concat(dataSet.Tables[0].Rows[i]["etime"]);
DateTime datetime = this.GetDatetime(j);
DateTime datetime2 = this.GetDatetime(j2);
if (Utils.GetDayOf2Date(datetime, datetime2) == 1)
{
ct = ct + "时间：" + this.GetTime(j) + "\r\n";
object obj = ct;
ct = string.Concat(new object[]
{
obj,
"标题：",
dataSet.Tables[0].Rows[i]["ename"],
"\r\n"
});
obj = ct;
ct = string.Concat(new object[]
{
obj,
"详情：",
dataSet.Tables[0].Rows[i]["memo"],
"\r\n\r\n"
});
}
else
{
string text = ct;
ct = string.Concat(new string[]
{
text,
"时间：",
this.GetTime(j),
" 至 ",
this.GetTime(j2),
"\r\n"
});
object obj = ct;
ct = string.Concat(new object[]
{
obj,
"标题：",
dataSet.Tables[0].Rows[i]["ename"],
"\r\n"
});
obj = ct;
ct = string.Concat(new object[]
{
obj,
"详情：",
dataSet.Tables[0].Rows[i]["memo"],
"\r\n\r\n"
});
}
}
}
}
private void td1()
{
string str = base.Request.QueryString["type"];
string text = " AttendType=" + str;
string text2 = base.Request.QueryString["keywords"];
string text3 = base.Request.QueryString["st"];
string text4 = base.Request.QueryString["et"];
string text5 = text;
text = string.Concat(new string[]
{
text5,
" and (addtime between '",
text3,
"' and '",
text4,
"') and ("
});
text5 = text;
text = string.Concat(new string[]
{
text5,
" RealName like '%",
text2,
"%' or DepName like '%",
text2,
"%' ) "
});
using (DataSet dataSet = MsSqlOperate.ExecuteDataset(CommandType.Text, "select * from Work_Attend where" + text, new SqlParameter[0]))
{
DataTable dataTable = dataSet.Tables[0];
if (dataTable.Rows.Count > 0)
{
try
{
StringWriter stringWriter = new StringWriter();
stringWriter.WriteLine("人员姓名,考勤日期,考勤类别,考勤数据,备注 ");
foreach (DataRow dataRow in dataTable.Rows)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder = this.AppendCSVFields(stringBuilder, string.Concat(dataRow["RealName"]));
stringBuilder = this.AppendCSVFields(stringBuilder, Convert.ToDateTime(string.Concat(dataRow["AddTime"])).ToString("yyyy-MM-dd"));
//stringBuilder = this.AppendCSVFields(stringBuilder, dataRow["StandardNames"] + dataRow["StandardTimes"]);
//stringBuilder = this.AppendCSVFields(stringBuilder, dataRow["StandardNames"] & dataRow["StandardTimes"]);
stringBuilder = this.AppendCSVFields(stringBuilder, string.Concat(new object[]
{
dataRow["SignTimes"],
" (",
dataRow["SignJudge"],
")"
}));
stringBuilder = this.AppendCSVFields(stringBuilder, string.Concat(dataRow["Notes"]));
stringBuilder.Remove(stringBuilder.Length - 1, 1);
stringWriter.WriteLine(stringBuilder.ToString());
}
DownloadFile(base.Response, stringWriter.GetStringBuilder(), "考勤" + text3 + ".csv");
stringWriter.Close();
base.Response.End();
goto IL_2CE;
}
catch (Exception ex)
{
throw;
}
}
base.Response.Write("<script>alert('没有任何数据');window.location='WorkList.aspx?type=1';</script>");
IL_2CE :;
}
}