public static List <eFunctReportItem> getFunctReportByFunctCode(string functCode) { List <eFunctReportItem> lstResult = new List <eFunctReportItem>(); DataTable dtResult = FunctionReportAccess.getFunctReportByFunctCode(functCode); foreach (DataRow dtr in dtResult.Rows) { eFunctReportItem item = new eFunctReportItem(); item.FUNCREPORTCD = dtr["FUNCPORTCD"].ToString(); item.FUNCCODE = dtr["FUNCCODE"].ToString(); item.SYS_EMPID = dtr["SYS_EMPID"].ToString(); string strDate = dtr["APPLYDATE"].ToString(); item.APPLYDATE = DateTime.ParseExact(strDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture); if (dtr["ISACTIVE"].ToString() == "0") { item.ISACTIVE = false; } else { item.ISACTIVE = true; } item.EMPNAME = dtr["EMPNAME"].ToString(); lstResult.Add(item); } return(lstResult); }
public static List <EmployeeMaster> getUserFunctionReports(string funccode) { List <EmployeeMaster> functionReports = new List <EmployeeMaster>(); FunctionReportAccess access = new FunctionReportAccess(); DataTable dtResult = access.GetUsersFunctionReports(funccode); foreach (DataRow dtr in dtResult.Rows) { EmployeeMaster item = new EmployeeMaster { SYS_EMPID = dtr["SYS_EMPID"].ToString(), EMPID = dtr["EMPID"].ToString(), EMPNAME = dtr["EMPNAME"].ToString(), POSITION = dtr["POSITION"].ToString(), SKILL = dtr["SKILL"].ToString() }; CategoryValueEntity position = bEmployeeMaster.getPositions().Where(p => p.Code == item.POSITION).FirstOrDefault(); CategoryValueEntity skill = bEmployeeMaster.getSkills().Where(p => p.Code == item.SKILL).FirstOrDefault(); if (position != null) { item.POSITION = position.CategoryValue; } if (skill != null) { item.SKILL = skill.CategoryValue; } functionReports.Add(item); } return(functionReports); }
public static List <FunctionReport> getAllGeoReports() { List <FunctionReport> functionReports = new List <FunctionReport>(); FunctionReportAccess access = new FunctionReportAccess(); DataTable dtResult = access.GetFunctionReports(); foreach (DataRow dtr in dtResult.Rows) { FunctionReport item = new FunctionReport { FUNCPORTCD = dtr["FUNCPORTCD"].ToString(), FUNCCODE = dtr["FUNCCODE"].ToString(), SYS_EMPID = dtr["SYS_EMPID"].ToString(), APPLYDATE = DateTime.Parse(string.IsNullOrEmpty(dtr["APPLYDATE"].ToString()) ? "1-1-1999" : dtr["APPLYDATE"].ToString()), ISACTIVE = dtr["ISACTIVE"].ToString(), POSITION = dtr["POSITION"].ToString(), SKILL = dtr["SKILL"].ToString(), REMARK = dtr["REMARK"].ToString(), FUNCTREPORTLEVEL = dtr["FUNCTREPORTLEVEL"].ToString(), CREATE_UID = dtr["CREATE_UID"].ToString(), CREATE_DT = dtr["CREATE_DT"].ToString(), UPDATE_UID = dtr["UPDATE_UID"].ToString(), UPDATE_DT = dtr["UPDATE_DT"].ToString(), }; functionReports.Add(item); } return(functionReports); }
public ActionResult createFunctReporter([DataSourceRequest] DataSourceRequest request, eFunctReportItem _reporter, string deptcode) { //FormEntity formEntity = new FormEntity(); //formEntity.FormID = _form.FORM_CODE; //formEntity.FormName = _form.FORM_NAME; //formEntity.DictionaryID = ""; //formEntity.CREATE_UID = "hieuht"; //formEntity.FilePath = _form.FILE_PATH; //formEntity.ModuleID = ""; //bool result = FormAccess.InsertForm(formEntity); _reporter.FUNCCODE = deptcode; string userId = Session["UserId"].ToString(); DataTable dtResult = FunctionReportAccess.insertNewGeoReport(_reporter, userId); Session["functreport_tree"] = bFunctionReport.getTreeFunctionDepts(); dynamic res = string.Empty; res = new { result = dtResult.Rows[0][0].ToString(), message = dtResult.Rows[0][1].ToString() }; return(Json(new[] { _reporter, res }.ToDataSourceResult(request, ModelState))); //return Json("ok", JsonRequestBehavior.AllowGet); }
public static List <FunctionReportViewModel> getTreeFunctionReports() { List <FunctionReportViewModel> functionReports = new List <FunctionReportViewModel>(); FunctionReportAccess access = new FunctionReportAccess(); DataTable dtResult = access.GetTreeFunctionReports(); foreach (DataRow dtr in dtResult.Rows) { FunctionReportViewModel item = new FunctionReportViewModel { FUNCPORTCD = dtr["FUNCPORTCD"].ToString(), FUNCNAME = dtr["FUNCNAME"].ToString(), FUNCCODE = dtr["FUNCCODE"].ToString(), FUNCPARENT = dtr["FUNCPARENT"].ToString() }; functionReports.Add(item); } return(functionReports); }
public static List <EmployeeMaster> getUserInFunctReportByDeptCode(string functCode) { List <EmployeeMaster> functionReports = new List <EmployeeMaster>(); FunctionReportAccess access = new FunctionReportAccess(); DataTable dtResult = access.GetUsersFunctionReports(functCode); foreach (DataRow dtr in dtResult.Rows) { EmployeeMaster item = new EmployeeMaster { //FUNCPORTCD = dtr["FUNCPORTCD"].ToString(), EMPID = dtr["EMPID"].ToString(), EMPNAME = dtr["EMPNAME"].ToString() + "," + dtr["SYS_EMPID"].ToString(), SYS_EMPID = dtr["SYS_EMPID"].ToString() }; functionReports.Add(item); } return(functionReports); }
public static List <JObject> getFunctionorDataForChart(string funcCode) { List <JObject> elements = new List <JObject>(); DataTable dtResult = FunctionReportAccess.GetFunctionorByFuncCode(funcCode); string sys_empidFun = string.Empty; foreach (DataRow dtr in dtResult.Rows) { sys_empidFun = dtr["SYS_EMPIDFUN"].ToString(); } if (!string.IsNullOrEmpty(sys_empidFun)) { DataTable geos = FunctionReportAccess.GetFunctionorsBySysFun(sys_empidFun); foreach (DataRow dtr in geos.Rows) { JObject subSupervisor = new JObject(); subSupervisor["id"] = dtr["SYS_EMPID"].ToString(); subSupervisor["pid"] = dtr["SYS_EMPIDFUN"].ToString(); subSupervisor["EMPID"] = dtr["EMPID"].ToString(); subSupervisor["EMPNAME"] = dtr["EMPNAME"].ToString(); subSupervisor["FUNCNAME"] = dtr["FUNCNAME"].ToString(); subSupervisor["POSITION"] = dtr["POSITION"].ToString(); subSupervisor["EMAIL"] = dtr["EMAIL"].ToString(); subSupervisor["IMAGE"] = dtr["IMAGE"].ToString(); elements.Add(subSupervisor); } //Get root. EmployeeMaster root = bEmployeeMaster.getEmployeeBySysEmpid(sys_empidFun); JObject rootSupervisor = new JObject(); rootSupervisor["id"] = sys_empidFun; rootSupervisor["pid"] = "null"; rootSupervisor["EMPID"] = root.EMPID; rootSupervisor["EMPNAME"] = root.EMPNAME; rootSupervisor["FUNCNAME"] = root.FUNCNAME; rootSupervisor["POSITION"] = root.POSITION; rootSupervisor["EMAIL"] = root.EMAIL; rootSupervisor["IMAGE"] = root.IMAGE; elements.Add(rootSupervisor); } return(elements); }
public static void DeleteFunctReport(string functRortCd) { FunctionReportAccess access = new FunctionReportAccess(); access.DeleteFunctReport(functRortCd); }
public static void DeleteFunctReportByFKey(string functCode, string sysEmpId) { FunctionReportAccess access = new FunctionReportAccess(); access.DeleteFunctReportByFKey(functCode, sysEmpId); }
public static void InsertFunctReport(string functCode, string sysEmpId) { FunctionReportAccess access = new FunctionReportAccess(); access.InsertFunctReport(functCode, sysEmpId); }