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 DataTable updateFunctReport(eFunctReportItem eReport, string userId)
{
OracleParameter[] sqlParam = new OracleParameter[7];
sqlParam[0] = new OracleParameter("PFUNCPORTCD", eReport.FUNCREPORTCD);
sqlParam[1] = new OracleParameter("PFUNCCODE", eReport.FUNCCODE);
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_FUNC_REPORT.SP_UPDATE_FUNCT_REPORT", sqlParam));
}
public static DataTable insertNewGeoReport(eFunctReportItem eReport, string userId)
{
OracleParameter[] sqlParam = new OracleParameter[6];
sqlParam[0] = new OracleParameter("PFUNCCODE", eReport.FUNCCODE);
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", OracleType.Cursor)
{
Direction = ParameterDirection.Output
};
return(DBHelper.getDataTable_SP("HR_FUNC_REPORT.SP_INSERT_NEWFUNCT_REPORT", sqlParam));
}
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);
}
