protected void Page_Load(object sender, EventArgs e)
{
try
{
if (HttpContext.Current.Session["username"].ToString() == "null" || HttpContext.Current.Session["userpwd"].ToString() == "null")
{
HttpContext.Current.Response.Write(" <script> alert( '您还未登陆，请先登录！！！');window.parent.location.href= '../../Default.aspx' </script> ");
}
sqlTable st = new sqlTable();
string year = DateTime.Now.Year.ToString();//当前年份
//月汇总
string TableName1 = "Login"; //表名1
string TableName2 = "Summary"; //表名2
string TableName55 = "Jiediao";
string[] MonthSourceList = { "Login.name", "Summary.work_day" }; //查看列名
string[] MonthSourceList22 = { "Login.name", "Jiediao.transfer" }; //查看列名
string[] MonthSelectList = { "Summary.year", "Summary.month", "Login.username" }; //限定列名
string[] MonthSelectList22 = { "Jiediao.year", "Jiediao.month", "Login.username" }; //限定列名
string[] MonthSelectValue = { year, HttpContext.Current.Session["months"].ToString(), "Summary.username" }; //限定列值
string[] MonthSelectValue22 = { year, HttpContext.Current.Session["months"].ToString(), "Jiediao.username" }; //限定列值
//DataTable MonthCmd = st.selectAll2(TableName1, TableName2, MonthSourceList, MonthSelectList, MonthSelectValue);
DataTable MonthCmd = st.selectAll2(TableName1, TableName2, TableName55, MonthSourceList, MonthSelectList, MonthSelectValue, MonthSourceList22, MonthSelectList22, MonthSelectValue22);
//年汇总
string TableName3 = "Summary_Month"; //表名
string[] YearSourceList = { "month", "summary" }; //查看列名
string[] YearSelectList = { "year" }; //限定列名
string[] YearSelectValue = { HttpContext.Current.Session["years"].ToString() }; //限定列值
DataTable YearCmd = st.selectAll3(TableName3, YearSourceList, YearSelectList, YearSelectValue);
//按年查看员工汇总
string TableName4 = "Summary_Year_User"; //表名
string[] UserSourceList = { "name", "summary_user" }; //查看列名
string[] UserSelectList = { "year" }; //限定列名
string[] UserSelectValue = { HttpContext.Current.Session["yearuser"].ToString() }; //限定列值
DataTable UserCmd = st.selectAll4(TableName4, UserSourceList, UserSelectList, UserSelectValue);
try
{
if (MonthCmd != null || YearCmd != null || UserCmd != null)
{
Month_Repeater.DataSource = MonthCmd;
Month_Repeater.DataBind();
Year_Repeater.DataSource = YearCmd;
Year_Repeater.DataBind();
Person_Repeater.DataSource = UserCmd;
Person_Repeater.DataBind();
}
}
catch (Exception)
{
HttpContext.Current.Response.Write(" <script> alert( '语法错误！！！');window.location.href= '../../Default.aspx ' </script> ");
}
}
catch (Exception)
{
HttpContext.Current.Response.Write(" <script> alert( '您还未登陆，请先登录！！！');window.parent.location.href= '../../Default.aspx' </script> ");
}
}