public JsonResult HistoryGridViewer(string ViewLevel, string SDATE, string EDATE, int PageNum)
{
string TargetURL = "../Outgoing/HistoryViewList";
GridViewerModel GViewer = new GridViewerModel();
//初始化
int RecordTotal = 0;
List <OutgoingEventModel> DataList = new List <OutgoingEventModel>();
UserFreeStyleModel UserFreeStyle = JsonConvert.DeserializeObject <UserFreeStyleModel>(Session[UserFreeStyle_id].ToString());
string SQLWhere = "";
if (ViewLevel == "A" || ViewLevel == "B" || ViewLevel == "C")
{
SQLWhere += UserFreeStyle.SearchCompany != "" ? " AND Company = '" + UserFreeStyle.SearchCompany + "' " : "";
SQLWhere += UserFreeStyle.SearchDepartMentNo != "" ? " AND DepartMentNo = '" + UserFreeStyle.SearchDepartMentNo + "' " : "";
SQLWhere += UserFreeStyle.SearchEmpNo != "" ? " AND OutMan = '" + UserFreeStyle.SearchEmpNo + "' " : "";
}
else
{
SQLWhere += " AND OutMan = '" + LoginUserInfo.UserId + "' ";
}
DateTime cSDATE = DateTime.Parse(SDATE);
DateTime cEDATE = DateTime.Parse(EDATE);
SQLWhere += " AND OutDate BETWEEN '" + cSDATE.ToString("yyyyMMdd") + "' AND '" + cEDATE.ToString("yyyyMMdd") + "' ";
string SQLOrderby = " OutDate,OutTime ";
//賦予資料清單及資料總筆數
ModelFactory.GetHistoryViewList(SQLWhere, SQLOrderby, PageNum, GeneralObj.GridViewerLimit, ref DataList, ref RecordTotal);
GViewer.DataList.AddRange((DataList.ToList()));
GViewer.Page = PageNum;
GViewer.PageLimit = GeneralObj.GridViewerLimit;
GViewer.RecordTotal = RecordTotal;
GViewer.PageTotal = GViewer.GetPageTotal(RecordTotal, GeneralObj.GridViewerLimit);
GViewer.TargetURL = TargetURL;
return(Json(GViewer));
}
public JsonResult GridViewer(int PageNum)
{
string TargetURL = "../EmpGroup/GridViewer";
GridViewerModel GViewer = new GridViewerModel();
//初始化
int RecordTotal = 0;
List <EmpModel> DataList = new List <EmpModel>();
UserFreeStyleModel UserFreeStyle = JsonConvert.DeserializeObject <UserFreeStyleModel>(Session[UserFreeStyle_id].ToString());
string SQLWhere = "";
SQLWhere += UserFreeStyle.SearchCompany != "" ? " AND Company = '" + UserFreeStyle.SearchCompany + "' " : "";
SQLWhere += UserFreeStyle.SearchDepartMentNo != "" ? " AND DepartMentNo = '" + UserFreeStyle.SearchDepartMentNo + "' " : "";
SQLWhere += UserFreeStyle.SearchEmpNo != "" ? " AND EmployeeNo = '" + UserFreeStyle.SearchEmpNo + "' " : "";
SQLWhere += UserFreeStyle.SearchEmpStatus != "" ? " AND Status = '" + UserFreeStyle.SearchEmpStatus + "' " : "";
SQLWhere += UserFreeStyle.SearchText != "" ? " AND (EmployeeNo LIKE '%" + UserFreeStyle.SearchText + "%' OR EmployeeEName LIKE '%" + UserFreeStyle.SearchText + "%' OR EmployeeName LIKE '%" + UserFreeStyle.SearchText + "%' OR CardNo = '" + UserFreeStyle.SearchText + "' ) " : "";
string SQLOrderby = UserFreeStyle.OrderField + " " + UserFreeStyle.OrderType;
//賦予資料清單及資料總筆數
ModelFactory.GetGridViewList(SQLWhere, SQLOrderby, PageNum, GeneralObj.GridViewerLimit, ref DataList, ref RecordTotal);
GViewer.DataList.AddRange((DataList.ToList()));
GViewer.Page = PageNum;
GViewer.PageLimit = GeneralObj.GridViewerLimit;
GViewer.RecordTotal = RecordTotal;
GViewer.PageTotal = GViewer.GetPageTotal(RecordTotal, GeneralObj.GridViewerLimit);
GViewer.TargetURL = TargetURL;
return(Json(GViewer));
}
public JsonResult GridViewer(int PageNum)
{
string TargetURL = "../Program/GridViewer";
GridViewerModel GViewer = new GridViewerModel();
//初始化
int RecordTotal = 0;
List <ProgramModel> DataList = new List <ProgramModel>();
UserFreeStyleModel UserFreeStyle = JsonConvert.DeserializeObject <UserFreeStyleModel>(Session[UserFreeStyle_id].ToString());
string SQLWhere = " AND ProgID LIKE '" + UserFreeStyle.SearchText + "%' OR ProgName LIKE '" + UserFreeStyle.SearchText + "%' OR Power LIKE '" + UserFreeStyle.SearchText + "%'";
string SQLOrderby = UserFreeStyle.OrderField + " " + UserFreeStyle.OrderType;
//賦予資料清單及資料總筆數
ModelFactory.GetGridViewList(SQLWhere, SQLOrderby, PageNum, GeneralObj.GridViewerLimit, ref DataList, ref RecordTotal);
GViewer.DataList.AddRange((DataList.ToList()));
GViewer.Page = PageNum;
GViewer.PageLimit = GeneralObj.GridViewerLimit;
GViewer.RecordTotal = RecordTotal;
GViewer.PageTotal = GViewer.GetPageTotal(RecordTotal, GeneralObj.GridViewerLimit);
GViewer.TargetURL = TargetURL;
return(Json(GViewer));
}
