public ActionResult Index()
{
ViewData["LoginUserInfo"] = LoginUserInfo;
string ProgramID = "Z001";
ProgramModel SysProgram = null;
if (!GeneralObj.CheckProgID(LoginUserInfo.ProgramList, ProgramID))
{
return(View("../SysMsg/NoAccess"));
}
else
{
SysProgram = GeneralObj.GetProgram(LoginUserInfo.ProgramList, ProgramID);
ViewData["SysProgram"] = SysProgram;
}
UserFreeStyleModel UserFreeStyle;
try
{
if (Request["action"] == "BACK" && Session[UserFreeStyle_id] != null)
{
UserFreeStyle = JsonConvert.DeserializeObject <UserFreeStyleModel>(Session[UserFreeStyle_id].ToString());
}
else
{
UserFreeStyle = new UserFreeStyleModel()
{
Name = UserFreeStyle_id,
OrderField = "YearId",
OrderType = "DESC",
PageNum = "0",
SearchCompany = GeneralObj.SearchCompanyDefault(LoginUserInfo, SysProgram),
SearchText = "", //搜尋狀態
};
}
}
catch
{
UserFreeStyle = new UserFreeStyleModel()
{
Name = UserFreeStyle_id,
OrderField = "YearId",
OrderType = "DESC",
PageNum = "0",
SearchCompany = GeneralObj.SearchCompanyDefault(LoginUserInfo, SysProgram),
SearchText = "", //搜尋狀態
};
}
Session[UserFreeStyle_id] = JsonConvert.SerializeObject(UserFreeStyle);
ViewData["UserFreeStyle"] = UserFreeStyle;
return(View());
}
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 ActionResult Index()
{
ViewData["LoginUserInfo"] = LoginUserInfo;
string ip = Request.ServerVariables["REMOTE_ADDR"];
if (ip.IndexOf("127.0.0.1") != -1)
{
Response.Write("您無法使用此作業!");
return(new EmptyResult());
}
UserFreeStyleModel UserFreeStyle;
try
{
if (Request["action"] == "BACK" && Session[UserFreeStyle_id] != null)
{
UserFreeStyle = JsonConvert.DeserializeObject <UserFreeStyleModel>(Session[UserFreeStyle_id].ToString());
}
else
{
UserFreeStyle = new UserFreeStyleModel()
{
Name = UserFreeStyle_id,
OrderField = "ProgID",
OrderType = "ASC",
PageNum = "0",
SearchText = ""
};
}
}
catch
{
UserFreeStyle = new UserFreeStyleModel()
{
Name = UserFreeStyle_id,
OrderField = "ProgID",
OrderType = "ASC",
PageNum = "0",
SearchText = ""
};
}
Session[UserFreeStyle_id] = JsonConvert.SerializeObject(UserFreeStyle);
ViewData["UserFreeStyle"] = UserFreeStyle;
return(View());
}
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));
}
public ActionResult Manage()
{
ViewData["LoginUserInfo"] = LoginUserInfo;
string ProgramID = "W002";
ProgramModel SysProgram = null;
if (!GeneralObj.CheckProgID(LoginUserInfo.ProgramList, ProgramID))
{
return(View("../SysMsg/NoAccess"));
}
else
{
SysProgram = GeneralObj.GetProgram(LoginUserInfo.ProgramList, ProgramID);
ViewData["SysProgram"] = SysProgram;
}
UserFreeStyleModel UserFreeStyle;
UserFreeStyle = new UserFreeStyleModel()
{
Name = "AttendanceManage",
OrderField = "",
OrderType = "",
PageNum = "",
SearchCompany = GeneralObj.SearchCompanyDefault(LoginUserInfo, SysProgram),
SearchDepartMentNo = GeneralObj.SearchDepartMentDefault(LoginUserInfo, SysProgram),
SearchEmpNo = "", //搜尋人員
SearchEmpStatus = "1", //搜尋 離職狀態
SearchText = "", //搜尋狀態
};
ViewData["UserFreeStyle"] = UserFreeStyle;
return(View());
}
public JsonResult GetManageAttendanceList(string UserFreeStyleJson, string SDATE, string EDATE, int Skip)
{
List <AttendanceModel> AttendanceList = null;
UserFreeStyleModel UserFreeStyle = null;
try
{
UserFreeStyle = JsonConvert.DeserializeObject <UserFreeStyleModel>(UserFreeStyleJson);
DateTime cSDATE = DateTime.Parse(SDATE);
DateTime cEDATE = DateTime.Parse(EDATE);
AttendanceList = ModelFactory.GetAttendanceList(1, UserFreeStyle.SearchCompany, UserFreeStyle.SearchDepartMentNo, UserFreeStyle.SearchEmpNo, UserFreeStyle.SearchText, cSDATE, cEDATE, "1", GeneralObj.AttendanceLimit, Skip);
return(Json(AttendanceList));
}
catch (Exception ex)
{
return(Json("0|" + ex.Message));
}
catch
{
return(Json("0|系統發生錯誤!"));
}
}
public ActionResult History()
{
ViewData["LoginUserInfo"] = LoginUserInfo;
string ProgramID = "W006";
ProgramModel SysProgram = null;
if (!GeneralObj.CheckProgID(LoginUserInfo.ProgramList, ProgramID))
{
//特例: 允許進入
//SysProgram = GeneralObj.GetProgram(LoginUserInfo.ProgramList, ProgramID);
SysProgram = new ProgramModel();
SysProgram.ProgID = "W006";
SysProgram.ProgName = "外出歷程記錄";
SysProgram.ViewLevel = "";
ViewData["SysProgram"] = SysProgram;
//return View("../SysMsg/NoAccess");
}
else
{
SysProgram = GeneralObj.GetProgram(LoginUserInfo.ProgramList, ProgramID);
ViewData["SysProgram"] = SysProgram;
}
UserFreeStyleModel UserFreeStyle;
try
{
if (Request["action"] == "BACK" && Session[UserFreeStyle_id] != null)
{
UserFreeStyle = JsonConvert.DeserializeObject <UserFreeStyleModel>(Session[UserFreeStyle_id].ToString());
}
else
{
UserFreeStyle = new UserFreeStyleModel()
{
Name = UserFreeStyle_id,
OrderField = "EmployeeNo",
OrderType = "ASC",
PageNum = "0",
SearchCompany = GeneralObj.SearchCompanyDefault(LoginUserInfo, SysProgram),
SearchDepartMentNo = GeneralObj.SearchDepartMentDefault(LoginUserInfo, SysProgram),
SearchEmpNo = "", //搜尋人員
SearchEmpStatus = "1", //搜尋 離職狀態
SearchText = "", //搜尋狀態
};
}
}
catch
{
UserFreeStyle = new UserFreeStyleModel()
{
Name = UserFreeStyle_id,
OrderField = "",
OrderType = "ASC",
PageNum = "0",
SearchCompany = GeneralObj.SearchCompanyDefault(LoginUserInfo, SysProgram),
SearchDepartMentNo = GeneralObj.SearchDepartMentDefault(LoginUserInfo, SysProgram),
SearchEmpNo = "", //搜尋人員
SearchEmpStatus = "1", //搜尋 離職狀態
SearchText = "", //搜尋狀態
};
}
Session[UserFreeStyle_id] = JsonConvert.SerializeObject(UserFreeStyle);
ViewData["UserFreeStyle"] = UserFreeStyle;
return(View());
}
