private TrackOfflineRes SetAuditPostMST(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null) { try { List <ASAUDITPOSTMST> lst = new List <ASAUDITPOSTMST>(); lst = GetCutPostMST(dataReq, conStr); if (lst != null && lst.Count == 0) { var req = new AuditPostReq { COMPANY = dataReq.company, SQNO = dataReq.sqno, INPID = dataReq.ucode }; InsertAuditPostMST(req, conStr); } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } return(res); }
private TrackOfflineRes GetProblem(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null) { try { var obj = GetProblemBase(dataReq, conStr); if (obj != null) { res.problem = obj; res._result._code = "200"; res._result._message = ""; res._result._status = "OK"; } else { res._result._code = "404"; res._result._message = "ไม่พบข้อมูล"; res._result._status = "Bad Request"; } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } return(res); }
private TrackOfflineRes addPostTRN(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null) { try { var obj = InsertTrackPostTRN(dataReq, conStr); if (obj.Result > 0) { res._result._code = "200"; res._result._message = ""; res._result._status = "OK"; } else { res._result._code = "400"; res._result._message = "พบความผิดพลาดระหว่างประมวลผลข้อมูล " + obj.Result.ToString(); res._result._status = "Bad Request"; } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } return(res); }
private TrackOfflineRes getSQNO(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null) { try { var obj = GetAUDITCUTDATEMST(dataReq, conStr); if (obj != null) { res.sqno = obj.SQNO; res.yr = obj.YR.ToString(); res.mn = obj.MN.ToString(); res.yrmn = obj.YRMN.ToString(); res._result._code = "200"; res._result._message = ""; res._result._status = "OK"; } else { res._result._code = "404"; res._result._message = "ไม่พบข้อมูล"; res._result._status = "Bad Request"; } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } return(res); }
private TrackOfflineRes getTrackOffline(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null) { try { List <TrackPostMSTRes> lstTrackPostMST = new List <TrackPostMSTRes>(); List <TrackPostTRNRes> lstTrackPostTRN = new List <TrackPostTRNRes>(); lstTrackPostMST = GetTrackPostMST(dataReq, conStr); lstTrackPostTRN = GetTrackPostTRN(dataReq, conStr); res.lstTrackPostMST = lstTrackPostMST; res.lstTrackPostTRN = lstTrackPostTRN; if ((lstTrackPostMST != null && lstTrackPostMST.Count > 0) || (lstTrackPostTRN != null && lstTrackPostTRN.Count > 0)) { res._result._code = "200"; res._result._message = ""; res._result._status = "OK"; } else { res._result._code = "404"; res._result._message = "ไม่พบข้อมูล"; res._result._status = "Bad Request"; } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } return(res); }
private TrackOfflineRes GetTrackOfflineHD(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null) { try { List <TrackHDRes> lstTrackHD = new List <TrackHDRes>(); lstTrackHD = GetTrackHD(dataReq, conStr); res.lstTrackHD = lstTrackHD; if (lstTrackHD != null && lstTrackHD.Count > 0) { res._result._code = "200"; res._result._message = ""; res._result._status = "OK"; } else { res._result._code = "404"; res._result._message = "ไม่พบข้อมูล"; res._result._status = "Bad Request"; } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } return(res); }
private TrackOfflineRes addPostMST(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null) { try { ASSETKKF_MODEL.Data.Mssql.Asset.AsFixedAsset req1 = new AsFixedAsset() { ASSETNO = dataReq.assetno }; AsFixedAsset asset = ASSETKKF_ADO.Mssql.Asset.AsFixedAssetAdo.GetInstant().Search(req1, null, conStr).FirstOrDefault(); if (asset != null) { dataReq.assetname = asset.ASSETNAME; } var obj = InsertTrackPostMST(dataReq, conStr); if (obj.Result > 0) { res._result._code = "200"; res._result._message = ""; res._result._status = "OK"; } else { res._result._code = "400"; res._result._message = "พบความผิดพลาดระหว่างประมวลผลข้อมูล " + obj.Result.ToString(); res._result._status = "Bad Request"; } } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } return(res); }
private TrackOfflineRes auditPostTRN(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null) { try { string msg, flag, transy; flag = "1"; transy = ""; msg = ""; ASAUDITPOSTTRN objTRN = new ASAUDITPOSTTRN(); if (String.IsNullOrEmpty(dataReq.sqno)) { msg = "เลขที่เอกสารไม่ถูกต้อง"; res._result._code = "404"; res._result._message = msg; res._result._status = "Bad Request"; } else { objTRN = GetASAUDITPOSTTRN(dataReq, conStr); if (objTRN == null) { transy = "Y"; res._result._code = "200"; res._result._message = msg; res._result._status = "OK"; } else { msg = "ไม่สามารถบันทึกผลการตรวจสอบได้ เนื่องจากรหัสทรัพย์สินนี้เคยถูกบันทึกผลแล้ว"; res._result._code = "501"; res._result._message = msg; res._result._status = "Not Implemented"; } } dataReq.flag = flag; dataReq.remark = msg; UpdateTransferTrackPostTRN(dataReq, conStr); if (!String.IsNullOrEmpty(transy)) { int yr, mn, yrmn; Int32.TryParse(dataReq.yr, out yr); Int32.TryParse(dataReq.mn, out mn); Int32.TryParse(dataReq.yrmn, out yrmn); var reqPostTrn = new AUDITPOSTTRNReq() { SQNO = dataReq.sqno, COMPANY = dataReq.company, DEPCODEOL = dataReq.depcodeol, YR = yr, MN = mn, YRMN = yrmn, MEMO1 = dataReq.memo1, ASSETNO = dataReq.assetno, ASSETNAME = dataReq.assetname, OFFICECODE = dataReq.officecode, OFNAME = dataReq.ofname, POSITNAME = dataReq.positname, MODE = "ADD", UCODE = dataReq.inpid }; if (!String.IsNullOrEmpty(dataReq.transy) && dataReq.transy.ToLower().Equals("y")) { var stSave = UpdateAuditPostTRN(reqPostTrn, conStr); if (stSave.Result != 0) { flag = "2"; msg = "บันทึกผลการตรวจสอบเรียบร้อยแล้ว"; } else { msg = "พบข้อผิดพลาดจากการบันทึกผลการตรวจสอบ"; } } else { msg = "ไม่บันทึกผลการตรวจสอบ"; } dataReq.remark = msg; dataReq.flag = flag; } dataReq.transy = !String.IsNullOrEmpty(dataReq.transy) ? dataReq.transy.ToUpper() : dataReq.transy; UpdateAuditTrackPostTRN(dataReq, conStr); } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } return(res); }
private TrackOfflineRes auditPostMST(TrackOfflineReq dataReq, TrackOfflineRes res, string conStr = null) { try { string msg, flag, transy; flag = "1"; transy = ""; msg = ""; ASAUDITPOSTMST objMst = new ASAUDITPOSTMST(); if (String.IsNullOrEmpty(dataReq.sqno)) { msg = "เลขที่เอกสารไม่ถูกต้อง"; res._result._code = "404"; res._result._message = msg; res._result._status = "Bad Request"; } else { objMst = GetASAUDITPOSTMST(dataReq, conStr); if (objMst != null) { if (!String.IsNullOrEmpty(objMst.PCODE)) { msg = "ไม่สามารถบันทึกผลการตรวจสอบได้ เนื่องจากรหัสทรัพย์สินนี้เคยถูกบันทึกผลเป็น" + objMst.PCODE + " : " + objMst.PNAME; res._result._code = "501"; res._result._message = msg; res._result._status = "Not Implemented"; } else { transy = "Y"; res._result._code = "200"; res._result._message = msg; res._result._status = "OK"; } } else { msg = "ไม่พบข้อมูล"; res._result._code = "404"; res._result._message = msg; res._result._status = "Bad Request"; } } dataReq.flag = flag; dataReq.remark = msg; UpdateTransferTrackPostMST(dataReq, conStr); if (!String.IsNullOrEmpty(transy)) { var reqPostMst = new AUDITPOSTMSTReq { SQNO = dataReq.sqno, DEPCODEOL = objMst != null? objMst.DEPCODEOL:null, COMPANY = dataReq.company, LEADERCODE = objMst != null ? objMst.LEADERCODE:null, LEADERNAME = objMst != null ? objMst.LEADERNAME:null, AREACODE = objMst != null ? objMst.AREACODE:null, AREANAME = null, ASSETNO = dataReq.assetno, FINDY = dataReq.findy, PCODE = dataReq.pcode, PNAME = dataReq.pname, UCODE = dataReq.inpid, PFLAG = dataReq.pflag, MEMO1 = dataReq.memo1 }; if (!String.IsNullOrEmpty(dataReq.transy) && dataReq.transy.ToLower().Equals("y")) { var stSave = UpdateAuditPostMST(reqPostMst, conStr); if (stSave.Result != 0) { flag = "2"; msg = "บันทึกผลการตรวจสอบเรียบร้อยแล้ว"; } else { msg = "พบข้อผิดพลาดจากการบันทึกผลการตรวจสอบ"; } } else { msg = "ไม่บันทึกผลการตรวจสอบ"; } dataReq.remark = msg; dataReq.flag = flag; } dataReq.transy = !String.IsNullOrEmpty(dataReq.transy) ? dataReq.transy.ToUpper() : dataReq.transy; UpdateAuditTrackPostMST(dataReq, conStr); } catch (Exception ex) { res._result._code = "500 "; res._result._message = ex.Message; res._result._status = "Internal Server Error"; } return(res); }
protected override void ExecuteChild(TrackOfflineReq dataReq, ResponseAPI dataRes) { var res = new TrackOfflineRes(); try { DBMode = dataReq.DBMode; res._result.ServerAddr = ConnectionString(); res._result.DBMode = DBMode; var mode = String.IsNullOrEmpty(dataReq.mode) ? dataReq.mode : dataReq.mode.ToLower(); switch (mode) { case "getsqno": getSQNO(dataReq, res, conString); break; case "getproblem": GetProblem(dataReq, res, conString); break; case "addpostmst": addPostMST(dataReq, res, conString); break; case "addposttrn": addPostTRN(dataReq, res, conString); break; case "updatepostmst": auditPostMST(dataReq, res, conString); break; case "updateposttrn": auditPostTRN(dataReq, res, conString); break; case "gettrackhd": GetTrackOfflineHD(dataReq, res, conString); break; case "setauditpostmst": SetAuditPostMST(dataReq, res, conString); break; default: getTrackOffline(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; }