protected override void ExecuteChild(AsFixedAsset dataReq, ResponseAPI dataRes) { var res = new TaskAuditRes(); try { DBMode = dataReq.DBMode; res._result.ServerAddr = ConnectionString(); res._result.DBMode = DBMode; var state = ASSETKKF_ADO.Mssql.Asset.TaskAuditAdo.GetInstant().AuditCancel(dataReq, null, conString); var taskReq = new TaskAudit() { INPID = dataReq.INPID, COMPANY = dataReq.COMPANY }; var lst = ASSETKKF_ADO.Mssql.Asset.TaskAuditAdo.GetInstant().GetData(taskReq, null, conString); if (lst == null) { res._result._code = "404"; res._result._message = "ไม่พบข้อมูล"; res._result._status = "Bad Request"; } else { res._result._code = "200"; res._result._message = ""; res._result._status = "OK"; } res.TaskAuditLST = lst; } 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; }
protected override void ExecuteChild(TaskAudit dataReq, ResponseAPI dataRes) { var res = new TaskAuditRes(); try { DBMode = dataReq.DBMode; res._result.ServerAddr = ConnectionString(); res._result.DBMode = DBMode; List <ASSETKKF_MODEL.Data.Mssql.Asset.TaskAudit> auditLst = new List <TaskAudit>(); var mode = String.IsNullOrEmpty(dataReq.MODE) ? dataReq.MODE : dataReq.MODE.ToLower(); switch (mode) { case "tracking": auditLst = ASSETKKF_ADO.Mssql.Asset.TaskAuditAdo.GetInstant().GetTracking(dataReq, null, conString); break; default: auditLst = ASSETKKF_ADO.Mssql.Asset.TaskAuditAdo.GetInstant().GetData(dataReq, null, conString); break; } res.TaskAuditLST = auditLst; if (auditLst == null) { res._result._code = "404"; res._result._message = "ไม่พบข้อมูล"; res._result._status = "Bad Request"; } else { res._result._code = "200"; res._result._message = ""; res._result._status = "OK"; } } 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; }