private void Show(string cid)
{
Hashtable hashtable = (Hashtable)HttpContext.Current.Application["config_fenye"];
int num = Convert.ToInt32(hashtable["fenye_commom"]);
int num2 = 0;
try
{
if (!string.IsNullOrEmpty(base.Request.QueryString["page"]))
{
num2 = Convert.ToInt32(base.Request.QueryString["page"]);
}
}
catch
{
}
if (num2 == 0)
{
num2 = 1;
}
int num3 = num * (num2 - 1);
string text = string.Concat(new string[]
{
" cid=",
cid,
" and CreatorID=",
this.Uid,
" "
});
int num4 = Convert.ToInt32(MsSqlOperate.ExecuteScalar(CommandType.Text, "select count(*) from CRM_Contact where " + text, null));
this.num.InnerHtml = "当前查询条件总计 - <span style='color:#ff0000; font-weight:bold;'>" + num4 + "</span> 条 记录数据";
string sql = string.Concat(new object[]
{
"select top ",
num,
" * from CRM_Contact where ",
text,
" order by id desc"
});
if (num2 != 1)
{
sql = string.Concat(new object[]
{
"SELECT TOP ",
num,
" * FROM CRM_Contact WHERE id<(SELECT MIN(id) FROM (SELECT TOP ",
num3.ToString(),
" id FROM CRM_Contact WHERE (",
text,
" ) ORDER BY id DESC) T1) AND (",
text,
" ) ORDER BY id DESC"
});
}
this.Bind(sql, this.rpt);
this.Page1.sty("meneame", num2, this.GetCountPage(num4, num), "?cid=" + cid + "&page=");
}
private IList GetOrdersUser()
{
object value = MsSqlOperate.ExecuteScalar(CommandType.Text, "select min(id) from sys_dep where ParentID=0", new SqlParameter[0]);
List <Sys_UserInfo> list = new List <Sys_UserInfo>();
this.GetTreeItems(Convert.ToInt32(value), list);
return(list);
}
private string GetVoteItemCount(string name, int vid)
{
string cmdText = "select count(*) from VoteDetail where VoteID=" + vid + " and ItemName=@ItemName";
return(string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, cmdText, new SqlParameter[]
{
new SqlParameter("@ItemName", name ?? "")
})));
}
private static void UpdateDeps()
{
int a_ = 7;
if (true)
{
}
//HttpContext.Current.Application[Module.a("쒰잲솴", a_)] = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, Admin_Help.UpdateFlows(), new SqlParameter[0]));
HttpContext.Current.Application["uut"] = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, Admin_Help.UpdateFlows(), new SqlParameter[0]));
}
//public static void UpdateIMUser(Sys_UserInfo ui)
//{
// try
// {
// string cmdText = "select [Key] from WM_Users where Name='" + ui.UserName + "'";
// string text = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, cmdText, new SqlParameter[0]));
// if (Utils.IsNumber(text))
// {
// string str = string.Concat(new string[]
// {
// "update WM_Users set Nickname='",
// ui.RealName,
// "',Password='******',EMail='",
// ui.Email,
// "',Phone='",
// ui.Phone,
// "',TelPhone='",
// ui.Tel,
// "' where Name='",
// ui.UserName,
// "';"
// });
// string text2 = string.Format("DELETE FROM WM_UDD WHERE uid={1} ; INSERT INTO WM_UDD(did,uid,tid)VALUES({0},{1},0) ", ui.DepID, text);
// text2 = str + text2;
// MsSqlOperate.ExecuteNonQuery(CommandType.Text, text2, new SqlParameter[0]);
// AccountImpl.Instance._RefreshUserInfo(Convert.ToInt64(text));
// }
// else
// {
// AccountImpl.Instance.AddUser(ui.UserName, ui.RealName, ui.PassWord, ui.Email, ui.Phone, ui.Tel);
// string cmdText2 = "select [Key] from WM_Users where Name='" + ui.UserName + "'";
// string text3 = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, cmdText2, new SqlParameter[0]));
// if (Utils.IsNumber(text3))
// {
// string text2 = string.Format("DELETE FROM WM_UDD WHERE uid={1} ; INSERT INTO WM_UDD(did,uid,tid)VALUES({0},{1},0) ", ui.DepID, text3);
// MsSqlOperate.ExecuteNonQuery(CommandType.Text, text2, new SqlParameter[0]);
// }
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public static void UpdateIMUser(Sys_UserInfo ui)
{
try
{
string cmdText = "select ID from Users where Name='" + ui.UserName + "'";
string text = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, cmdText, new SqlParameter[0]));
if (Utils.IsNumber(text))
{
string str = string.Concat(new string[]
{
"update Users set Nickname='",
ui.RealName,
"',Password='******',EMail='",
ui.Email,
"',Tel='",
ui.Phone,
"',Mobile='",
ui.Tel,
"' where Name='",
ui.UserName,
"';"
});
//MsSqlOperate.ExecuteNonQuery(CommandType.Text, str, new SqlParameter[0]);
}
else
{
int id = AccountImpl.Instance.CreateUser(
ui.UserName.ToString(),
ui.RealName.ToString(),
ui.PassWord.ToString(),
ui.Email.ToString(),
-1, 0
);
AccountInfo newUser = AccountImpl.Instance.GetUserInfo(id);
//AccountImpl.Instance.AddUser(ui.UserName, ui.RealName, ui.PassWord, ui.Email, ui.Phone, ui.Tel);
string cmdText2 = "select ID from Users where Name='" + ui.UserName + "'";
string text3 = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, cmdText2, new SqlParameter[0]));
if (Utils.IsNumber(text3))
{
string text2 = string.Format("DELETE FROM WM_UDD WHERE uid={1} ; INSERT INTO WM_UDD(did,uid,tid)VALUES({0},{1},0) ", ui.DepID, text3);
//MsSqlOperate.ExecuteNonQuery(CommandType.Text, text2, new SqlParameter[0]);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void Show()
{
int num = 50;
int num2 = 0;
try
{
if (!string.IsNullOrEmpty(base.Request.QueryString["page"]))
{
num2 = Convert.ToInt32(base.Request.QueryString["page"]);
}
}
catch
{
}
if (num2 == 0)
{
num2 = 1;
}
string text = " UserName='******'";
int num3 = num * (num2 - 1);
int num4 = Convert.ToInt32(MsSqlOperate.ExecuteScalar(CommandType.Text, "select count(*) from Sys_UserLogin where " + text, null));
this.num.InnerHtml = "当前查询条件总计 - <span style='color:#ff0000; font-weight:bold;'>" + num4 + "</span> 条 记录数据";
string sql = string.Concat(new object[]
{
"select top ",
num,
" * from Sys_UserLogin where ",
text,
" order by id desc"
});
if (num2 != 1)
{
sql = string.Concat(new object[]
{
"SELECT TOP ",
num,
" * FROM Sys_UserLogin WHERE id<(SELECT MIN(id) FROM (SELECT TOP ",
num3.ToString(),
" id FROM Sys_UserLogin WHERE (",
text,
" ) ORDER BY id DESC) T1) AND (",
text,
" ) ORDER BY id DESC"
});
}
this.Bind(sql, this.rpt);
this.Page1.sty("meneame", num2, this.GetCountPage(num4, num), "?page=");
}
//protected HtmlForm form1;
protected void Page_Load(object sender, EventArgs e)
{
string cmdText = "select count(id) from Docs_Doc where CreatorID=" + this.Uid;
string cmdText2 = string.Concat(new string[]
{
"select count(id) from Docs_Doc where CreatorID<>",
this.Uid,
" and IsShare=1 and ShareUsers like '%#",
this.Uid,
"#%' "
});
this.num1 = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, cmdText, null));
this.num2 = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, cmdText2, null));
}
private string GetAllNums()
{
return(string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, "select count(id) from News_Article", new SqlParameter[0])));
}
private void Show(string fid)
{
Hashtable hashtable = (Hashtable)HttpContext.Current.Application["config_fenye"];
int num = Convert.ToInt32(hashtable["fenye_mail"]);
int num2 = 0;
try
{
if (!string.IsNullOrEmpty(base.Request.QueryString["page"]))
{
num2 = Convert.ToInt32(base.Request.QueryString["page"]);
}
}
catch
{
}
if (num2 == 0)
{
num2 = 1;
}
int num3 = num * (num2 - 1);
string text = "FolderType=" + fid + " and ReceiverID=" + this.Uid;
string text2 = base.Request.QueryString["keywords"];
if (!string.IsNullOrEmpty(text2) && Utils.CheckSql(text2))
{
string text3 = text;
text = string.Concat(new string[]
{
text3,
" and (SenderRealName like '%",
text2,
"%' or SenderDepName like '%",
text2,
"%' or Subject like '%",
text2,
"%') "
});
}
int num4 = Convert.ToInt32(MsSqlOperate.ExecuteScalar(CommandType.Text, "select count(*) from Mails where " + text, null));
this.num.InnerHtml = "当前查询条件总计 - <span style='color:#ff0000; font-weight:bold;'>" + num4 + "</span> 条 记录数据";
string sql = string.Concat(new object[]
{
"select top ",
num,
" * from Mails where ",
text,
" order by id desc"
});
if (num2 != 1)
{
sql = string.Concat(new object[]
{
"SELECT TOP ",
num,
" * FROM Mails WHERE id<(SELECT MIN(id) FROM (SELECT TOP ",
num3.ToString(),
" id FROM Mails WHERE (",
text,
" ) ORDER BY id DESC) T1) AND (",
text,
" ) ORDER BY id DESC"
});
}
this.Bind(sql, this.rpt);
if (string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
this.Page2.sty("meneame", num2, this.GetCountPage(num4, num), "?fid=" + base.Request.QueryString["fid"] + "&page=");
}
if (!string.IsNullOrEmpty(base.Request.QueryString["keywords"]))
{
this.Page2.sty("meneame", num2, this.GetCountPage(num4, num), string.Concat(new string[]
{
"?fid=",
base.Request.QueryString["fid"],
"&keywords=",
text2,
"&page="
}));
}
}
private void Show()
{
Hashtable hashtable = (Hashtable)HttpContext.Current.Application["config_fenye"];
int num = Convert.ToInt32(hashtable["fenye_commom"]);
int num2 = 0;
try
{
if (!string.IsNullOrEmpty(base.Request.QueryString["page"]))
{
num2 = Convert.ToInt32(base.Request.QueryString["page"]);
}
}
catch
{
}
if (num2 == 0)
{
num2 = 1;
}
int num3 = num * (num2 - 1);
string text = "UserID=" + this.Uid;
string text2 = base.Request.QueryString["keywords"];
if (!string.IsNullOrEmpty(text2) && Utils.CheckSql(text2))
{
text = text + " and (Subject like '%" + text2 + "%' ) ";
}
int num4 = Convert.ToInt32(MsSqlOperate.ExecuteScalar(CommandType.Text, "select count(*) from NoteBook where " + text, null));
this.num.InnerHtml = "当前查询条件总计 - <span style='color:#ff0000; font-weight:bold;'>" + num4 + "</span> 条 记录数据";
string sql = string.Concat(new object[]
{
"select top ",
num,
" * from NoteBook where ",
text,
" order by id desc"
});
if (num2 != 1)
{
sql = string.Concat(new object[]
{
"SELECT TOP ",
num,
" * FROM NoteBook WHERE id<(SELECT MIN(id) FROM (SELECT TOP ",
num3.ToString(),
" id FROM NoteBook WHERE (",
text,
" ) ORDER BY id DESC) T1) AND (",
text,
" ) ORDER BY id DESC"
});
}
this.Bind(sql, this.rpt);
if (text == "UserID=" + this.Uid)
{
this.Page1.sty("meneame", num2, this.GetCountPage(num4, num), "?page=");
}
else
{
this.Page1.sty("meneame", num2, this.GetCountPage(num4, num), "?keywords=" + text2 + "&page=");
}
}
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()
{
int num = 30;
int num2 = 0;
try
{
if (!string.IsNullOrEmpty(base.Request.QueryString["page"]))
{
num2 = Convert.ToInt32(base.Request.QueryString["page"]);
}
}
catch
{
}
if (num2 == 0)
{
num2 = 1;
}
int num3 = num * (num2 - 1);
string text = base.Request.QueryString["keywords"];
string text2 = base.Request.QueryString["action"];
string text3 = "";
if (text2 == "mydoc")
{
text3 = " CreatorID=" + this.Uid;
if (!string.IsNullOrEmpty(text))
{
string text4 = text3;
text3 = string.Concat(new string[]
{
text4,
" and (LogTitle like '%",
text,
"%' or CreatorRealName like '%",
text,
"%') "
});
}
}
if (text2 == "shared")
{
text3 = string.Concat(new string[]
{
" (CreatorID<>",
this.Uid,
" and ShareUsers like '%#",
this.Uid,
"#%') "
});
if (!string.IsNullOrEmpty(text))
{
string text4 = text3;
text3 = string.Concat(new string[]
{
text4,
" and (LogTitle like '%",
text,
"%' or CreatorRealName like '%",
text,
"%') "
});
}
}
int num4 = Convert.ToInt32(MsSqlOperate.ExecuteScalar(CommandType.Text, "select count(id) from WorkLog where " + text3, null));
this.num.InnerHtml = "当前总计 - <span style='color:#ff0000; font-weight:bold;'>" + num4 + "</span> 条 记录数据";
string sql = string.Concat(new object[]
{
"select top ",
num,
" * from WorkLog where ",
text3,
" order by id desc"
});
if (num2 != 1)
{
sql = string.Concat(new object[]
{
"SELECT TOP ",
num,
" * FROM WorkLog WHERE id<(SELECT MIN(id) FROM (SELECT TOP ",
num3.ToString(),
" id FROM WorkLog WHERE (",
text3,
" ) ORDER BY id DESC) T1) AND (",
text3,
" ) ORDER BY id DESC"
});
}
this.Bind(sql, this.rpt);
if (string.IsNullOrEmpty(text))
{
this.Page1.sty("meneame", num2, this.GetCountPage(num4, num), "?action=" + text2 + "&page=");
}
else
{
this.Page1.sty("meneame", num2, this.GetCountPage(num4, num), string.Concat(new string[]
{
"?action=",
text2,
"&keywords=",
text,
"&page="
}));
}
}
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()
{
Hashtable hashtable = (Hashtable)HttpContext.Current.Application["config_fenye"];
int num = Convert.ToInt32(hashtable["fenye_commom"]);
int num2 = 0;
try
{
if (!string.IsNullOrEmpty(base.Request.QueryString["page"]))
{
num2 = Convert.ToInt32(base.Request.QueryString["page"]);
}
}
catch
{
}
if (num2 == 0)
{
num2 = 1;
}
int num3 = num * (num2 - 1);
string text = base.Request.QueryString["keywords"];
string text2 = base.Request.QueryString["action"];
string text3 = "";
if (text2 == "mydoc")
{
if (!string.IsNullOrEmpty(text))
{
text3 = string.Concat(new string[]
{
" CreatorID=",
this.Uid,
" and (DocTitle like '%",
text,
"%' or CreatorRealName like '%",
text,
"%' ) "
});
}
else
{
text3 = " CreatorID=" + this.Uid;
}
if (!string.IsNullOrEmpty(base.Request.QueryString["type"]))
{
text3 = " CreatorID=" + this.Uid + " and DocTypeID=" + base.Request.QueryString["type"];
}
}
if (text2 == "shared")
{
if (!string.IsNullOrEmpty(text))
{
text3 = string.Concat(new string[]
{
" CreatorID<>",
this.Uid,
" and IsShare=1 and ShareUsers like '%#",
this.Uid,
"#%' and (DocTitle like '%",
text,
"%' or CreatorRealName like '%",
text,
"%' ) "
});
}
else
{
text3 = string.Concat(new string[]
{
" CreatorID<>",
this.Uid,
" and IsShare=1 and ShareUsers like '%#",
this.Uid,
"#%' "
});
}
}
int num4 = Convert.ToInt32(MsSqlOperate.ExecuteScalar(CommandType.Text, "select count(*) from Docs_Doc where " + text3, null));
this.num.InnerHtml = "当前查询条件总计 - <span style='color:#ff0000; font-weight:bold;'>" + num4 + "</span> 条 记录数据";
string sql = string.Concat(new object[]
{
"select top ",
num,
" * from Docs_Doc where ",
text3,
" order by id desc"
});
if (num2 != 1)
{
sql = string.Concat(new object[]
{
"SELECT TOP ",
num,
" * FROM Docs_Doc WHERE id<(SELECT MIN(id) FROM (SELECT TOP ",
num3.ToString(),
" id FROM Docs_Doc WHERE (",
text3,
" ) ORDER BY id DESC) T1) AND (",
text3,
" ) ORDER BY id DESC"
});
}
this.Bind(sql, this.rpt);
if (string.IsNullOrEmpty(text))
{
this.Page2.sty("meneame", num2, this.GetCountPage(num4, num), "?action=" + text2 + "&page=");
}
else
{
this.Page2.sty("meneame", num2, this.GetCountPage(num4, num), string.Concat(new string[]
{
"?action=",
text2,
"&keywords=",
text,
"&page="
}));
}
}
private void Show1()
{
this.list1.Visible = true;
string text = base.Request.QueryString["type"];
int num = 60;
int num2 = 0;
try
{
if (!string.IsNullOrEmpty(base.Request.QueryString["page"]))
{
num2 = Convert.ToInt32(base.Request.QueryString["page"]);
}
}
catch
{
}
if (num2 == 0)
{
num2 = 1;
}
int num3 = num * (num2 - 1);
string text2 = string.Concat(new string[]
{
" AttendType=",
text,
" and UID=",
this.Uid,
" "
});
string value = base.Request.QueryString["st"];
if (!string.IsNullOrEmpty(value))
{
string text3 = base.Request.QueryString["st"];
string text4 = base.Request.QueryString["et"];
string text5 = text2;
text2 = string.Concat(new string[]
{
text5,
" and (addtime between '",
text3,
"' and '",
text4,
"') "
});
}
else
{
text2 += " and datediff(d,addtime,getdate())<180 ";
}
int num4 = Convert.ToInt32(MsSqlOperate.ExecuteScalar(CommandType.Text, "select count(id) from Work_Attend where " + text2, null));
this.num1.InnerHtml = "当前查询条件总计 - <span style='color:#ff0000; font-weight:bold;'>" + num4 + "</span> 条 记录数据";
string sql = string.Concat(new object[]
{
"select top ",
num,
" * from Work_Attend where ",
text2,
" order by id desc"
});
if (num2 != 1)
{
sql = string.Concat(new object[]
{
"SELECT TOP ",
num,
" * FROM Work_Attend WHERE id<(SELECT MIN(id) FROM (SELECT TOP ",
num3.ToString(),
" id FROM Work_Attend WHERE (",
text2,
" ) ORDER BY id DESC) T1) AND (",
text2,
" ) ORDER BY id DESC"
});
}
this.Bind(sql, this.rpt1);
if (!string.IsNullOrEmpty(value))
{
this.Page1.sty("meneame", num2, this.GetCountPage(num4, num), string.Concat(new string[]
{
"?type=",
text,
"&st=",
base.Request.QueryString["st"],
"&et=",
base.Request.QueryString["et"],
"&page="
}));
}
else
{
this.Page1.sty("meneame", num2, this.GetCountPage(num4, num), "?type=" + text + "&page=");
}
}
private string GetNumsByType(int typeid)
{
return(string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, "select count(id) from News_Article where typeid=" + typeid, new SqlParameter[0])));
}
private IList GetAllNewsUser(string nid)
{
IList <Sys_UserInfo> list = new List <Sys_UserInfo>();
string cmdText = "select ShareDeps from News_Article where id=" + nid;
string text = string.Concat(MsSqlOperate.ExecuteScalar(CommandType.Text, cmdText, new SqlParameter[0]));
IEnumerator enumerator;
if (text.Contains(","))
{
string[] array = text.Split(new char[]
{
','
});
string text2 = "";
List <string> list2 = new List <string>();
for (int i = 0; i < array.Length; i++)
{
if (array[i].Contains("#"))
{
string item = array[i].Split(new char[]
{
'#'
})[1];
list2.Add(item);
}
}
string[] array2 = list2.ToArray();
for (int i = 0; i < array2.Length; i++)
{
if (i != array2.Length - 1)
{
text2 = text2 + " depid=" + array2[i] + " or ";
}
else
{
text2 = text2 + " depid=" + array2[i] + " ";
}
}
IList all = Sys_User.Init().GetAll(text2, null);
enumerator = all.GetEnumerator();
try
{
while (enumerator.MoveNext())
{
object current = enumerator.Current;
Sys_UserInfo item2 = current as Sys_UserInfo;
list.Add(item2);
}
goto IL_1C3;
}
finally
{
IDisposable disposable = enumerator as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
}
IList all2 = Sys_User.Init().GetAll("Status=0 and IsLock=0", null);
enumerator = all2.GetEnumerator();
try
{
while (enumerator.MoveNext())
{
object current = enumerator.Current;
Sys_UserInfo item2 = current as Sys_UserInfo;
list.Add(item2);
}
}
finally
{
IDisposable disposable = enumerator as IDisposable;
if (disposable != null)
{
disposable.Dispose();
}
}
IL_1C3:
return((IList)list);
}
private void Show(string cid)
{
CRMInfo byId = CRM.Init().GetById(Convert.ToInt32(cid));
this.CRM_Name1.InnerText = byId.CRM_Name;
if (string.Concat(byId.CreatorID) != this.Uid)
{
this.div.Visible = false;
}
this.Grade.Text = Convert.ToString(byId.Grade).ToUpper() + " - " + this.GetGrade(byId.Grade);
this.lx.Text = string.Concat(new string[]
{
" <span style='color:#006600;font-weight:bold;'>电话:</span> ",
byId.Tel,
" <span style='color:#006600;font-weight:bold;'>传真:</span> ",
byId.Fax,
" <span style='color:#006600;font-weight:bold;'>邮编:</span> ",
byId.Zip
});
this.hlw.Text = string.Concat(new string[]
{
" <span style='color:#006600;font-weight:bold;'>网站:</span> ",
byId.Site,
" <span style='color:#006600;font-weight:bold;'>QQ:</span> ",
byId.QQ,
" <span style='color:#006600;font-weight:bold;'>Email:</span> ",
byId.Email
});
this.Address.Text = byId.Address;
this.MainPeople.Text = byId.MainPeople;
this.Position.Text = byId.Position;
this.Product.Text = byId.Product;
this.TypeName.Text = byId.TypeName;
this.Notes.Text = byId.Notes;
string cmdText = "select count(*) from crm_contact where cid=" + cid;
object obj = MsSqlOperate.ExecuteScalar(CommandType.Text, cmdText, new SqlParameter[0]);
this.Contact.Text = string.Concat(new object[]
{
"目前已接触 <strong>",
obj,
"</strong> 次 <a href=/manage/crm/CRM_Contact_List.aspx?cid=",
cid,
"><strong>查看接触详情</strong></a> <a href=/manage/crm/CRM_Contact_Manage.aspx?cid=",
cid,
"><strong>添加客户接触</strong></a>"
});
if (!string.IsNullOrEmpty(byId.FilePath))
{
string[] array = byId.FilePath.Split(new char[]
{
'|'
});
for (int i = 0; i < array.Length; i++)
{
if (array[i].Trim() != "")
{
int num = array[i].LastIndexOf('/') + 1;
string arg = array[i].Substring(num, array[i].Length - num);
string s = array[i].Replace("~", "");
this.fjs += string.Format(this.fj, base.Server.UrlEncode(s), arg);
}
}
}
}