protected override void ExecuteChild(AuditSummaryReq dataReq, ResponseAPI dataRes)
{
PivotDataRes res = new PivotDataRes();
try
{
DBMode = dataReq.DBMode;
res._result.ServerAddr = ConnectionString();
res._result.DBMode = DBMode;
var mode = String.IsNullOrEmpty(dataReq.mode) ? null : dataReq.mode.Trim().ToLower();
switch (mode)
{
case "depcodeol":
GetPivotProblemByDepcodeol(dataReq, res, conString);
break;
default:
GetPivotProblemByDep(dataReq, res, conString);
break;
}
}
catch (SqlException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Execute exception Error";
}
catch (InvalidOperationException ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Connection Exception Error";
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
dataRes.data = res;
}
private PivotDataRes GetPivotProblemByDep(AuditSummaryReq dataReq, PivotDataRes res, string conStr = null)
{
try
{
var dt = getProblemByDep(dataReq, conStr);
string JSONresult, jsonrow;
List <string> columns = new List <string>();
List <string> rows = new List <string>();
if (dt != null && dt.Columns.Count > 0)
{
foreach (DataColumn column in dt.Columns)
{
columns.Add(column.ColumnName);
}
foreach (DataRow row in dt.Rows)
{
var depmst = row[0].ToString();
AuditSummaryReq req1 = new AuditSummaryReq();
req1 = dataReq;
req1.depmst = depmst;
var obj = ASSETKKF_ADO.Mssql.Report.PivotDataAdo.GetInstant().getQuantityByDep(req1, null, conStr).FirstOrDefault();
if (obj != null)
{
row[2] = obj.QTY_ASSET;
row[3] = obj.QTY_AUDIT;
}
//rows.Add(string.Join(";", row.ItemArray.Select(item => item.ToString())));
jsonrow = JsonConvert.SerializeObject(row.ItemArray, Newtonsoft.Json.Formatting.Indented);
rows.Add(jsonrow);
}
}
JSONresult = JsonConvert.SerializeObject(dt, Newtonsoft.Json.Formatting.Indented);
if (!String.IsNullOrEmpty(JSONresult))
{
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
else
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Bad Request";
}
res.columns = columns;
res.rows = rows;
res.jsonresult = JSONresult;
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}