public ActionResult monthcard(int?page, string orderdata, string orderdata1) { page = ((!page.HasValue || page < 1) ? 1 : page); ViewBag.page = page; if (string.IsNullOrWhiteSpace(orderdata)) { orderdata = "dptid"; } if (string.IsNullOrWhiteSpace(orderdata1)) { orderdata1 = ""; } ViewBag.orderdata = orderdata; ViewBag.orderdata1 = orderdata1; Aitag.Models.NDcommon dbobj = new Aitag.Models.NDcommon(); string qdptid = "", qempname = "", qclogsdate = "", qclogedate = "", qcchkstatus = ""; if (!string.IsNullOrWhiteSpace(Request["qdptid"])) { qdptid = Request["qdptid"].Trim(); ViewBag.qdptid = qdptid; } if (!string.IsNullOrWhiteSpace(Request["qempname"])) { qempname = Request["qempname"].Trim(); ViewBag.qempname = qempname; } if (!string.IsNullOrWhiteSpace(Request["qcchkstatus"])) { qcchkstatus = Request["qcchkstatus"].Trim(); ViewBag.qcchkstatus = qcchkstatus; } string DateEx = "", DateEx1 = ""; dbobj.get_dateRang(Request["qclogsdate"], "acd", "min", @"日期起格式錯誤!!\n", out qclogsdate, out DateEx); ViewBag.qclogsdate = qclogsdate; dbobj.get_dateRang(Request["qclogedate"], "acd", "max", @"日期訖格式錯誤!!\n", out qclogedate, out DateEx1); ViewBag.qclogedate = qclogedate; DateEx += DateEx1; //NullStDate 跟 NullTeDate 會判斷格式,有錯誤就 修改全域的DateEx if (DateEx != "") { ViewBag.DateEx = @"<script>alert(""" + DateEx + @""");</script>"; } IPagedList <cardjudgelog> result; using (Aitag_DBContext con = new Aitag_DBContext()) { string sqlstr = "select CAST(CAST(NEWID() AS binary(3)) AS int) as cjid, empid, empname, dptid ,NULL as clogdate,'' as clogstime, '' as clogetime, '' as clogstatus, '' as clogcomment, sum(cloghour) as cloghour , '' as comid, '' as bmodid, NULL as bmoddate, cchkstatus, '' as cchkcomment, '' as cchkownman, NULL as cchkowndate from cardjudgelog where comid='" + Session["comid"].ToString() + "' and"; if (!string.IsNullOrWhiteSpace(ViewBag.qdptid)) { sqlstr += " dptid = '" + ViewBag.qdptid + "' and "; } if (!string.IsNullOrWhiteSpace(ViewBag.qempname)) { sqlstr += " empname like '%" + ViewBag.qempname + "%' and "; } if (!string.IsNullOrWhiteSpace(ViewBag.qclogsdate)) { sqlstr += " clogdate >= '" + ViewBag.qclogsdate + "' and "; } if (!string.IsNullOrWhiteSpace(ViewBag.qclogedate)) { sqlstr += " clogdate <= '" + ViewBag.qclogedate + "' and "; } if (!string.IsNullOrWhiteSpace(ViewBag.qcchkstatus)) { sqlstr += " cchkstatus = '" + ViewBag.qcchkstatus + "' and "; } sqlstr = sqlstr.Substring(0, sqlstr.Length - 5); sqlstr += " group by dptid, empid, empname, cchkstatus order by dptid,empid"; var query = con.cardjudgelog.SqlQuery(sqlstr).AsQueryable(); result = query.ToPagedList <cardjudgelog>(page.Value - 1, (int)Session["pagesize"]); } ViewBag.SetOrder_ch = SetOrder_ch(orderdata, orderdata1); return(View(result)); }