public ActionResult logqryList(int?page, string orderdata, string orderdata1)
        {
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "hdellogid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;

            string qhdellogstatus = "", qhlogsdate = "", qhlogedate = "";

            if (!string.IsNullOrWhiteSpace(Request["qhdellogstatus"]))
            {
                qhdellogstatus         = Request["qhdellogstatus"].Trim();
                ViewBag.qhdellogstatus = qhdellogstatus;
            }
            if (!string.IsNullOrWhiteSpace(Request["qhlogsdate"]))
            {
                qhlogsdate         = Request["qhlogsdate"].Trim();
                ViewBag.qhlogsdate = qhlogsdate;
            }
            if (!string.IsNullOrWhiteSpace(Request["qhlogedate"]))
            {
                qhlogedate         = Request["qhlogedate"].Trim();
                ViewBag.qhlogedate = qhlogedate;
            }

            NDcommon dbobj = new NDcommon();

            string DateEx = "", DateEx1 = "";

            if (dbobj.get_dbnull2(Request["qhlogsdate"]) != "")
            {
                dbobj.get_dateRang(Request["qhlogsdate"], "m", "min", @"出差日期起格式錯誤!!\n", out qhlogsdate, out DateEx);
                ViewBag.qhlogsdate = qhlogsdate;
            }
            if (dbobj.get_dbnull2(Request["qhlogedate"]) != "")
            {
                dbobj.get_dateRang(Request["qhlogedate"], "m", "max", @"出差日期訖格式錯誤!!\n", out qhlogedate, out DateEx1);
                ViewBag.qhlogedate = qhlogedate;
            }
            DateEx += DateEx1;

            if (DateEx != "")
            {
                ViewBag.DateEx = @"<script>alert(""" + DateEx + @""");</script>";
            }


            IPagedList <delholidaylog> result;

            using (Aitag_DBContext con = new Aitag_DBContext())
            {
                string sqlstr = "SELECT * FROM delholidaylog where 1=1 "
//                    + " and empid='" + (string)Session["empid"] + "'"
                                + " and comid='" + (string)Session["comid"] + "'";

                if (qhdellogstatus != "")
                {
                    sqlstr += " and hdellogstatus = '" + qhdellogstatus + "'";
                }
                if (qhlogsdate != "")
                {
                    sqlstr += " and hlogsdate >= '" + qhlogsdate + "'";
                }
                if (qhlogedate != "")
                {
                    sqlstr += " and hlogedate <= '" + qhlogedate + "'";
                }

                sqlstr += " order by " + orderdata + " " + orderdata1;

                var query = con.delholidaylog.SqlQuery(sqlstr).AsQueryable();

                result = query.ToPagedList <delholidaylog>(page.Value - 1, (int)Session["pagesize"]);
            }
            ViewBag.SetOrder_ch = SetOrder_ch1(orderdata, orderdata1);
            return(View(result));
        }
        public ActionResult logcheckList(int?page, string orderdata, string orderdata1)
        {
            page         = ((!page.HasValue || page < 1) ? 1 : page);
            ViewBag.page = page;
            if (string.IsNullOrWhiteSpace(orderdata))
            {
                orderdata = "hdellogid";
            }

            if (string.IsNullOrWhiteSpace(orderdata1))
            {
                orderdata1 = "desc";
            }
            ViewBag.orderdata  = orderdata;
            ViewBag.orderdata1 = orderdata1;

            string qhlogsdate = "", qhlogedate = "";

            if (!string.IsNullOrWhiteSpace(Request["qhlogsdate"]))
            {
                qhlogsdate         = Request["qhlogsdate"].Trim();
                ViewBag.qhlogsdate = qhlogsdate;
            }
            if (!string.IsNullOrWhiteSpace(Request["qhlogedate"]))
            {
                qhlogedate         = Request["qhlogedate"].Trim();
                ViewBag.qhlogedate = qhlogedate;
            }

            NDcommon dbobj = new NDcommon();

            string DateEx = "", DateEx1 = "";

            if (dbobj.get_dbnull2(Request["qhlogsdate"]) != "")
            {
                dbobj.get_dateRang(Request["qhlogsdate"], "m", "min", @"出差日期起格式錯誤!!\n", out qhlogsdate, out DateEx);
                ViewBag.qhlogsdate = qhlogsdate;
            }
            if (dbobj.get_dbnull2(Request["qhlogedate"]) != "")
            {
                dbobj.get_dateRang(Request["qhlogedate"], "m", "max", @"出差日期訖格式錯誤!!\n", out qhlogedate, out DateEx1);
                ViewBag.qhlogedate = qhlogedate;
            }
            DateEx += DateEx1;

            if (DateEx != "")
            {
                ViewBag.DateEx = @"<script>alert(""" + DateEx + @""");</script>";
            }


            IPagedList <delholidaylog> result;

            using (Aitag_DBContext con = new Aitag_DBContext())
            {
                //多個角色時
                string tmpplay = (string)Session["mplayrole"];
                tmpplay = tmpplay.Replace("'", "");
                string[] tmpa  = tmpplay.Split(',');
                string   sql_1 = "";
                foreach (string s in tmpa)
                {
                    sql_1 += "'''" + s + "''',";
                }
                sql_1 = sql_1.Substring(0, sql_1.Length - 1);
                //====

                string sqlstr = "SELECT * FROM delholidaylog where hdellogstatus = '0'";

                if (sql_1 != "")
                {
                    sqlstr += " and rolestampid in (" + sql_1 + ")";
                }
                if (qhlogsdate != "")
                {
                    sqlstr += " and hlogsdate >= '" + qhlogsdate + "'";
                }
                if (qhlogedate != "")
                {
                    sqlstr += " and hlogedate <= '" + qhlogedate + "'";
                }

                sqlstr += " order by " + orderdata + " " + orderdata1;

                var query = con.delholidaylog.SqlQuery(sqlstr).AsQueryable();

                result = query.ToPagedList <delholidaylog>(page.Value - 1, (int)Session["pagesize"]);
            }
            ViewBag.SetOrder_ch = SetOrder_ch(orderdata, orderdata1);
            return(View(result));
        }