public static DataTable updateGeoReport(eGeoReportItem eReport, string userId) { OracleParameter[] sqlParam = new OracleParameter[7]; sqlParam[0] = new OracleParameter("PREPORTCODE", eReport.GEOREPORTCD); sqlParam[1] = new OracleParameter("PDEPTCODE", eReport.DEPTCODE); sqlParam[2] = new OracleParameter("PSYS_EMPID", eReport.SYS_EMPID); sqlParam[3] = new OracleParameter("PAPPLYDATE", eReport.APPLYDATE.ToString("yyyyMMdd")); sqlParam[4] = new OracleParameter("PISACTIVE", eReport.ISACTIVE ? "1" : "0"); sqlParam[5] = new OracleParameter("PUSER", userId); sqlParam[6] = new OracleParameter("T_TABLE", OracleDbType.RefCursor) { Direction = ParameterDirection.Output }; return(DBHelper.getDataTable_SP("HR_GEO_REPORT.SP_UPDATE_GEO_REPORT", sqlParam)); }
public static DataTable insertNewGeoReport(eGeoReportItem eReport, string userId) { OracleParameter[] sqlParam = new OracleParameter[6]; sqlParam[0] = new OracleParameter("PDEPTCODE", eReport.DEPTCODE); sqlParam[1] = new OracleParameter("PSYS_EMPID", eReport.SYS_EMPID); sqlParam[2] = new OracleParameter("PAPPLYDATE", eReport.APPLYDATE.ToString("yyyyMMdd")); //sqlParam[3] = new OracleParameter("UPDATE_DT", formEntity.UPDATE_DT); sqlParam[3] = new OracleParameter("PISACTIVE", eReport.ISACTIVE ? "1" : "0"); sqlParam[4] = new OracleParameter("PUSER", userId); sqlParam[5] = new OracleParameter("T_TABLE", OracleDbType.RefCursor) { Direction = ParameterDirection.Output }; //return DBHelper.getDataTable_SP("HR_GEO_REPORT.SP_INSERT_GEO_REPORT", sqlParam); return(DBHelper.getDataTable_SP("HR_GEO_REPORT.SP_INSERT_GEO_REPORT_VER2", sqlParam)); }
public static List <eGeoReportItem> getGeoReportByDepartment(string deptcode) { List <eGeoReportItem> lstResult = new List <eGeoReportItem>(); DataTable dtResult = GeoReportAccess.getReportByDepartment(deptcode); /* * foreach (DataRow dtr in dtResult.Rows) * { * eGeoReportItem item = new eGeoReportItem(); * item.GEOREPORTCD = dtr["GEOREPORTCD"].ToString(); * item.DEPTCODE = dtr["DEPTCODE"].ToString(); * item.SYS_EMPID = dtr["SYS_EMPID"].ToString(); * string strDate = dtr["APPLYDATE"].ToString(); * item.APPLYDATE = DateTime.ParseExact(strDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture); * item.ISACTIVE = dtr["ISACTIVE"].ToString(); * item.EMPNAME = dtr["EMPNAME"].ToString(); * lstResult.Add(item); * } */ foreach (DataRow dtr in dtResult.Rows) { eGeoReportItem item = new eGeoReportItem(); item.GEOREPORTCD = dtr["GEOREPORTCD"].ToString(); item.DEPTCODE = dtr["DEPTCODE"].ToString(); item.SYS_EMPID = dtr["SYS_EMPID"].ToString(); string strDate = dtr["APPLYDATE"].ToString(); item.APPLYDATE = DateTime.ParseExact(strDate, "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture); int nActive = 0; int.TryParse(dtr["ISACTIVE"].ToString(), out nActive); item.ISACTIVE = Convert.ToBoolean(nActive); item.EMPNAME = dtr["EMPNAME"].ToString(); lstResult.Add(item); } return(lstResult); }
public ActionResult updateGeoReporter([DataSourceRequest] DataSourceRequest request, eGeoReportItem _reporter, string deptcode) { //FormEntity formEntity = new FormEntity(); //formEntity.FormID = _form.FORM_CODE; //formEntity.FormName = _form.FORM_NAME; //formEntity.DictionaryID = ""; //formEntity.FilePath = _form.FILE_PATH; //formEntity.ModuleID = ""; //formEntity.UPDATE_UID = "hieuht"; //bool result = FormAccess.UpdateForm(formEntity); _reporter.DEPTCODE = deptcode; string userId = Session["UserId"].ToString(); DataTable dtResult = GeoReportAccess.updateGeoReport(_reporter, userId); Session["geoorganizationreport_tree"] = bGeoReport.getTreeGeoDepts(); 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))); }