//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);
}
