//public ActionResult getGeoReportByDept([DataSourceRequest]DataSourceRequest request, string deptcode) //{ // List<eGeoReportItem> result = new List<eGeoReportItem>(); // result = bGeoReport.getGeoReportByDepartment(deptcode); // return Json(result.ToDataSourceResult(request)); //} public ActionResult getGeoReportByDept([DataSourceRequest] DataSourceRequest request, string deptcode) { List <eGeoReportItem> result = new List <eGeoReportItem>(); result = bGeoReport.getGeoReportByDepartment(deptcode); DataTable dtResult = GeoReportAccess.getReportByDepartment(deptcode); string jsonString = JsonConvert.SerializeObject(dtResult); JsonResult jsResult = new JsonResult(); jsResult = Json(dtResult.ToDataSourceResult(request)); DataTable dtTest = (DataTable)JsonConvert.DeserializeObject(jsonString, (typeof(DataTable))); //return jsResult; //return jsonResult; /* * DataRow dtr = dtResult.Rows[0]; * eGeoReportItem item = new eGeoReportItem(); * foreach(DataColumn cl in dtr.Table.Columns) * { * PropertyInfo prop = item.GetType().GetProperty(cl.ColumnName); * FieldInfo fld = item.GetType().GetField(cl.ColumnName); * } */ return(Json(dtTest.ToDataSourceResult(request))); }
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); }