public string GETtUsed(string ptUrl, string ptPOSNo, string ptTransNo, string ptTransType, string ptTransDate , string ptPlantCode, string ptBBYNo, string ptDiscAmt, string ptDateIns, string ptTimeIns, string ptSrcSeqNo) { //-------------------------------------------Used------------------------------------------------// try { mlREQQtaByTdrUsed oREQQtaByTdrUsed = new mlREQQtaByTdrUsed() { tML_POSNo = ptPOSNo, tML_TransNo = ptTransNo, tML_TransType = ptTransType, tML_TransDate = ptTransDate, tML_PlantCode = ptPlantCode, tML_BBYNo = ptBBYNo, tML_DiscAmt = ptDiscAmt, tML_DateIns = ptDateIns, tML_TimeIns = ptTimeIns, tML_SrcSeqNo = ptSrcSeqNo }; var tJson = JsonConvert.SerializeObject(oREQQtaByTdrUsed, Formatting.Indented); var tResultMsg = oC_POSTJsonToAPI.C_POSTtHTTPCliant(ptUrl + "/Used", tJson); var oRESQtaByTdr = JsonConvert.DeserializeObject <mlRESQtaByTdr>(tResultMsg); var tResult = oRESQtaByTdr.tML_ResCode + "|" + oRESQtaByTdr.tML_Message + "|" + oRESQtaByTdr.tML_DateIns + "|" + oRESQtaByTdr.tML_TimeIns; return(tResult); } catch (Exception oEx) { throw oEx; } }
public mlRESQtaByTdr C_SEToUsed(mlREQQtaByTdrUsed poREQQtaByTdrUsed) { var oRESQtaByTdrcs = new cResQtaByTdrcs(); var oSql = new StringBuilder(); string tResCode; string tMessage; string tTransStatus = "U"; try { var tTransDate = "'" + cCNSP.DTEtByFormat(poREQQtaByTdrUsed.tML_TransDate, "YYYY-MM-DD") + "'"; oSql.Clear(); oSql.AppendLine("UPDATE TPSTSalBBYTdr WITH(ROWLOCK)"); oSql.AppendLine("SET FTSbyStatus='" + tTransStatus + "' "); oSql.AppendLine(",FCScdAmt = '" + poREQQtaByTdrUsed.tML_DiscAmt + "' "); oSql.AppendLine("WHERE (FTShdPlantCode = '" + poREQQtaByTdrUsed.tML_PlantCode + "' )"); oSql.AppendLine("AND (FTTmnNum = '" + poREQQtaByTdrUsed.tML_POSNo + "')"); oSql.AppendLine("AND (FTShdTransNo = '" + poREQQtaByTdrUsed.tML_TransNo + "' )"); oSql.AppendLine("AND (FTShdTransType = '" + poREQQtaByTdrUsed.tML_TransType + "' )"); oSql.AppendLine("AND (FDShdTransDate = " + tTransDate + " )"); oSql.AppendLine("AND (FTScdBBYNo = '" + poREQQtaByTdrUsed.tML_BBYNo + "' )"); oSql.AppendLine("AND (FDDateIns = '" + poREQQtaByTdrUsed.tML_DateIns + "' )"); oSql.AppendLine("AND (FTTimeIns = '" + poREQQtaByTdrUsed.tML_TimeIns + "' )"); oSql.AppendLine("AND (FNSrcSeqNo = '" + poREQQtaByTdrUsed.tML_SrcSeqNo + "' )"); oSql.AppendLine("AND (FTSbyStatus = 'R')"); var nResult = cCNSP.SP_SETnDbTbl(oSql.ToString()); if (nResult > 0) { tResCode = "04"; tMessage = "ยืนยันการใช่สิทธิ์ สำเร็จ"; return(oRESQtaByTdrcs.C_SEToRESQtaByTdr(tResCode, tMessage)); } else { tResCode = "44"; tMessage = "ยืนยันการใช่สิทธิ์ ไม่สำเร็จ"; return(oRESQtaByTdrcs.C_SEToRESQtaByTdr(tResCode, tMessage)); } } catch (Exception oEx) { tResCode = "44"; tMessage = "Used Error=" + oEx.Message; return(oRESQtaByTdrcs.C_SEToRESQtaByTdr(tResCode, tMessage)); } }
public IHttpActionResult SEToPromoByTdrUsed([FromBody] mlREQQtaByTdrUsed pmlREQQtaByTdrUsed) { try { oC_Log.Debug("-------------------------------START------------------------------------"); Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); // C_CHKxMemcach(); var oUsed = new cUsed(); oC_RESQtaByTdrcs = new mlRESQtaByTdr(); oC_RESQtaByTdrcs = oUsed.C_SEToUsed(pmlREQQtaByTdrUsed); oC_Log.Debug("-------------------------------End------------------------------------"); return(Json(oC_RESQtaByTdrcs)); } catch (Exception oEx) { return(BadRequest(oEx.Message)); } }