public async Task <object> moveToKeep(RequestAllModelsPTC model)
{
ReturnDataMoveLoc result = new ReturnDataMoveLoc();
if (model.token != null)
{
UserProfile userProfile = _jwtGenerator.DecodeToken(model.token);
result = await new PTCMethods(_mapper, _jwtGenerator).MoveTooling(model);
if (result != null)
{
if (result.flag == "0")
{
//TODO update
string DateNow = DateTime.Today.ToString("dd/MM/yyyy", new CultureInfo("en-US"));
var query = $"UPDATE KPDBA.PTC_JS_PLAN_DETAIL SET RETURN_DATE = TO_DATE ('{DateNow}', 'dd/mm/yyyy'), RETURN_USER_ID = TO_CHAR ('{userProfile.userID}') WHERE JOB_ID = '{model.jobID}'";
var upDateResult = await new DataContext().GetResultDapperAsyncDynamic(DataBaseHostEnum.KPR, query);
}
else
{
return(result);
}
}
}
else
{
result = new ReturnDataMoveLoc {
flag = "1",
text = "\"error: ระบบไม่ได้รับ Token กรุณา Login ใหม่อีกครั้งหรือ ติดต่อแผนก IT\""
};
}
return(result);
}
public async Task <ActionResult <Object> > ApiAllPTC(RequestAllModelsPTC model)
{
switch (model.fn)
{
case "FIND TOOL":
var _findToolResult = await new PTCMethods(_mapper, _jwtGenerator).FindLocOfTooling(model);
return(Ok(_findToolResult));
case "SCAN LOCATION TO MOVE":
var _moveToolResult = await new PTCMethods(_mapper, _jwtGenerator).MoveTooling(model);
return(Ok(_moveToolResult));
case "CHECK USER WAREHOUSE":
var _WareHouseResult = await new PTCMethods(_mapper, _jwtGenerator).checkWareHouse(model);
return(Ok(_WareHouseResult));
case "CURRENT PLANS":
var _currentPlansResult = await new PTCMethodsPickUp(_mapper, _jwtGenerator).GetCurrentPlans(model);
return(Ok(_currentPlansResult));
case "PICK UP TO MOVE":
var _pickUpResult = await new PTCMethodsPickUp(_mapper, _jwtGenerator).PickUpTooling(model);
return(Ok(_pickUpResult));
case "GET WITHDRAWAL HISTORY":
var _historyResult = await new PTCMethodsReturnTool(_mapper, _jwtGenerator).getWithdrawalHistory(model);
return(Ok(_historyResult));
case "MOVE TO KEEP":
var _keepResult = await new PTCMethodsReturnTool(_mapper, _jwtGenerator).moveToKeep(model);
return(Ok(_keepResult));
//!Function DEV test, Don't forget to delete this function!!
case "CHECK LOCATION OF TOOL":
var _findLocOfTool = await new PTCMethods(_mapper, _jwtGenerator).FindLocOfTooling(model);
return(Ok(_findLocOfTool));
default:
var res = new ReturnDataMoveLoc {
flag = "1",
text = "\"error: กรุณากำหนด Function ให้ถูกต้อง\""
};
return(res);
}
}
//* Move Tool
public async Task <ReturnDataMoveLoc> MoveTooling(RequestAllModelsPTC model)
{
string _returnFlag = "0";
string _returnText = "ผ่าน";
if (model.token != null)
{
UserProfile userProfile = _jwtGenerator.DecodeToken(model.token);
if (userProfile != null)
{
var queryCheck = $"SELECT COUNT(1) AS COUN FROM KPDBA.DIECUT_SN WHERE DIECUT_SN ='{model.ptcID}'";
var resultCheck = await new DataContext().GetResultDapperAsyncDynamic(DataBaseHostEnum.KPR, queryCheck);
decimal toolReal = (resultCheck as List <dynamic>) [0].COUN;
if (toolReal == 1)
{
var query = $"SELECT SD.LOC_ID, LOC.LOC_DETAIL, SD.QTY FROM (SELECT SD.WAREHOUSE_ID, SD.LOC_ID, SUM (SD.QTY) QTY FROM KPDBA.PTC_STOCK_DETAIL SD WHERE SD.WAREHOUSE_ID = '{model.warehouseID}' AND SD.PTC_ID = '{model.ptcID}' GROUP BY SD.WAREHOUSE_ID, SD.LOC_ID HAVING SUM (SD.QTY) > 0) SD JOIN (SELECT WAREHOUSE_ID, LOC_ID, LOC_DETAIL FROM KPDBA.LOCATION_PTC) LOC ON (SD.WAREHOUSE_ID = LOC.WAREHOUSE_ID AND SD.LOC_ID = LOC.LOC_ID)";
var result = await new DataContext().GetResultDapperAsyncObject(DataBaseHostEnum.KPR, query);
decimal count = (result as List <object>).Count;
if (count == 0)
{
_returnFlag = "1";
_returnText = "\"error: อุปกรณ์หมด ไม่มีอุปกรณ์คงเหลือภายในคลัง\"";
}
else
{
var results = _mapper.Map <IEnumerable <GetLoc> > (result);
var dataLoc = results.ElementAt(0);
var queryCompID = $"SELECT COMP_ID COMP FROM KPDBA.WAREHOUSE WHERE WAREHOUSE_ID ='{model.warehouseID}'";
var resultCompID = await new DataContext().GetResultDapperAsyncObject(DataBaseHostEnum.KPR, queryCompID);
var compID = (resultCompID as List <dynamic>) [0].COMP;
var tranSEQ = 1;
var QTY = "-1";
var S_STATUS = 'T';
var tranType = "4"; // โอนย้ายเข้า
var locID = dataLoc.LOC_ID; // old loc
string tran_id = await new StoreConnectionMethod(_mapper).PtcGetTranID(compID: model.warehouseID, tranType: compID);
var tranDate = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss", new CultureInfo("en-US"));
var insertGetQuery = $"INSERT INTO KPDBA.PTC_STOCK_DETAIL (TRAN_ID, TRAN_SEQ, TRAN_TYPE, TRAN_DATE,PTC_ID, QTY, COMP_ID, WAREHOUSE_ID, LOC_ID, STATUS, CR_DATE, CR_ORG_ID, CR_USER_ID) VALUES ('{tran_id}', TO_NUMBER('{tranSEQ}'), TO_NUMBER('{tranType}'), TO_DATE('{tranDate}', 'dd/mm/yyyy hh24:mi:ss'),'{model.ptcID}', TO_NUMBER('{QTY}'), TO_CHAR('{compID}'),'{model.warehouseID}','{locID}', TO_CHAR('{S_STATUS}'), SYSDATE, '{userProfile.org}', '{userProfile.userID}')";
var resultInsert = await new DataContext().InsertResultDapperAsync(DataBaseHostEnum.KPR, insertGetQuery);
tranSEQ = 2;
QTY = "1";
tranType = "4"; // โอนย้ายเข้า
locID = model.locID; // newLoc
tranDate = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss", new CultureInfo("en-US"));
var insertOutQuery = $"INSERT INTO KPDBA.PTC_STOCK_DETAIL (TRAN_ID, TRAN_SEQ, TRAN_TYPE, TRAN_DATE,PTC_ID, QTY, COMP_ID, WAREHOUSE_ID, LOC_ID, STATUS, CR_DATE, CR_ORG_ID, CR_USER_ID) VALUES ('{tran_id}', TO_NUMBER('{tranSEQ}'), TO_NUMBER('{tranType}'), TO_DATE('{tranDate}', 'dd/mm/yyyy hh24:mi:ss'),'{model.ptcID}', TO_NUMBER('{QTY}'), TO_CHAR('{compID}'),'{model.warehouseID}','{locID}', TO_CHAR('{S_STATUS}'), SYSDATE, '{userProfile.org}', '{userProfile.userID}')";
var resultOutInsert = await new DataContext().InsertResultDapperAsync(DataBaseHostEnum.KPR, insertOutQuery);
}
}
else
{
_returnFlag = "1";
_returnText = "\"error: ไม่พบหมายเลขของอุปกรณ์นี้ในฐานข้อมูล\"";
}
}
else
{
_returnFlag = "1";
_returnText = "\"error: ข้อมูล Token ผิดพลาด กรุณาติดต่อฝ่ายIT \"";
}
}
else
{
_returnFlag = "1";
_returnText = "\"error: ระบบไม่ได้รับ Token กรุณา Login ใหม่อีกครั้งหรือ ติดต่อแผนก IT\"";
}
var retuenResult = new ReturnDataMoveLoc {
flag = _returnFlag,
text = _returnText
};
return(retuenResult);
}
//* Pick up the tool
public async Task <object> PickUpTooling(RequestAllModelsPTC model)
{
string _returnFlag = "0";
string _returnText = "ผ่าน";
GetLoc _dataLoc = new GetLoc();
if (model.token != null)
{
UserProfile userProfile = _jwtGenerator.DecodeToken(model.token);
var queryCheck = $"SELECT COUNT(1) AS COUN FROM KPDBA.DIECUT_SN WHERE DIECUT_SN ='{model.ptcID}'";
var resultCheck = await new DataContext().GetResultDapperAsyncDynamic(DataBaseHostEnum.KPR, queryCheck);
decimal toolValid = (resultCheck as List <dynamic>) [0].COUN;
if (toolValid == 1)
{
var query = $"SELECT SD.LOC_ID, LOC.LOC_DETAIL, SD.QTY FROM (SELECT SD.WAREHOUSE_ID, SD.LOC_ID, SUM (SD.QTY) QTY FROM KPDBA.PTC_STOCK_DETAIL SD WHERE SD.WAREHOUSE_ID = '{model.warehouseID}' AND SD.PTC_ID = '{model.ptcID}' GROUP BY SD.WAREHOUSE_ID, SD.LOC_ID HAVING SUM (SD.QTY) > 0) SD JOIN (SELECT WAREHOUSE_ID, LOC_ID, LOC_DETAIL FROM KPDBA.LOCATION_PTC) LOC ON (SD.WAREHOUSE_ID = LOC.WAREHOUSE_ID AND SD.LOC_ID = LOC.LOC_ID)";
var result = await new DataContext().GetResultDapperAsyncObject(DataBaseHostEnum.KPR, query);
decimal count = (result as List <object>).Count;
if (count != 0)
{
var results = _mapper.Map <IEnumerable <GetLoc> > (result);
var dataLoc = results.ElementAt(0);
var queryCompID = $"SELECT COMP_ID COMP FROM KPDBA.WAREHOUSE WHERE WAREHOUSE_ID ='{model.warehouseID}'";
var resultCompID = await new DataContext().GetResultDapperAsyncObject(DataBaseHostEnum.KPR, queryCompID);
string queryCheckIDPlan = $"SELECT COUNT(1) AS COUN FROM KPDBA.PTC_JS_PLAN_DETAIL WHERE JOB_ID = '{model.jobID}'";
var stateCheckPlan = await new DataContext().GetResultDapperAsyncObject(DataBaseHostEnum.KPR, queryCheckIDPlan);
decimal stateCheck = (stateCheckPlan as List <dynamic>) [0].COUN;
if (stateCheck == 0)
{
string queryPlanDetail = $"INSERT INTO KPDBA.PTC_JS_PLAN_DETAIL (JOB_ID, MACH_ID, STEP_ID, SPLIT_SEQ, PLAN_SUB_SEQ, SEQ_RUN, WDEPT_ID, REVISION, ACT_DATE, PTC_TYPE, PTC_ID, WITHD_DATE, WITHD_USER_ID, DIECUT_SN) VALUES ('{model.jobID}', TO_CHAR ('{model.machID}'), TO_CHAR ('{model.stepID}'), TO_NUMBER ('{model.splitSeq}'), TO_NUMBER ('{model.planSubSeq}'), TO_NUMBER ('{model.seqRun}'), TO_NUMBER ('{model.wdeptID}'), TO_NUMBER ('{model.revision}'), TO_DATE ('{model.actDate}', 'dd/mm/yyyy hh24:mi:ss'), '{model.ptcType}', '{model.ptcID}', TO_DATE(TO_CHAR(SYSDATE), 'dd/mm/yyyy'), TO_CHAR ('{userProfile.userID}'), '{model.ptcID}')";
var insertPlanDetail = await new DataContext().InsertResultDapperAsync(DataBaseHostEnum.KPR, queryPlanDetail);
var compID = (resultCompID as List <dynamic>) [0].COMP;
var tranSEQ = 1;
var tranType = "4"; // โอนย้ายเข้า
var locID = dataLoc.LOC_ID; // old loc
string tran_id = await new StoreConnectionMethod(_mapper).PtcGetTranID(compID: model.warehouseID, tranType: compID);
var tranDate = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss", new CultureInfo("en-US"));
var insertGetQuery = $"INSERT INTO KPDBA.PTC_STOCK_DETAIL (TRAN_ID, TRAN_SEQ, TRAN_TYPE, TRAN_DATE,PTC_ID, QTY, COMP_ID, WAREHOUSE_ID, LOC_ID, STATUS, CR_DATE, CR_ORG_ID, CR_USER_ID) VALUES ('{tran_id}', TO_NUMBER('{tranSEQ}'), TO_NUMBER('{tranType}'), TO_DATE('{tranDate}', 'dd/mm/yyyy hh24:mi:ss'),'{model.ptcID}', TO_NUMBER('-1'), TO_CHAR('{compID}'),'{model.warehouseID}','{locID}', 'T', SYSDATE, '{userProfile.org}', '{userProfile.userID}')";
var resultInsert = await new DataContext().InsertResultDapperAsync(DataBaseHostEnum.KPR, insertGetQuery);
Console.WriteLine(Foo(resultInsert));
string Foo <T> (T parameter)
{
return(typeof(T).Name);
}
tranSEQ = 2;
tranType = "4"; // โอนย้ายเข้า
locID = "$W70"; // newLoc ย้ายไปพื้นที่เบิก
tranDate = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss", new CultureInfo("en-US"));
var insertOutQuery = $"INSERT INTO KPDBA.PTC_STOCK_DETAIL (TRAN_ID, TRAN_SEQ, TRAN_TYPE, TRAN_DATE,PTC_ID, QTY, COMP_ID, WAREHOUSE_ID, LOC_ID, STATUS, CR_DATE, CR_ORG_ID, CR_USER_ID) VALUES ('{tran_id}', TO_NUMBER('{tranSEQ}'), TO_NUMBER('{tranType}'), TO_DATE('{tranDate}', 'dd/mm/yyyy hh24:mi:ss'),'{model.ptcID}', TO_NUMBER('1'), TO_CHAR('{compID}'),'{model.warehouseID}','{locID}', 'T', SYSDATE, '{userProfile.org}', '{userProfile.userID}')";
var resultOutInsert = await new DataContext().InsertResultDapperAsync(DataBaseHostEnum.KPR, insertOutQuery);
}
else
{
_returnFlag = "1";
_returnText = "\"error: หมายเลข JOB ID นี้ได้ถูกลงทะเบียนเรียบร้อยแล้ว\"";
}
}
else
{
_returnFlag = "1";
_returnText = "\"error: อุปกรณ์หมด ไม่มีอุปกรณ์คงเหลือภายในคลัง\"";
}
}
else
{
//* check QR code is Loccation right?
var queryCheckLoc = $"SELECT COUNT(1) AS COUN FROM KPDBA.LOCATION_PTC WHERE LOC_ID = '{model.ptcID}'";
var resultCheckLoc = await new DataContext().GetResultDapperAsyncDynamic(DataBaseHostEnum.KPR, queryCheckLoc);
decimal LocValid = (resultCheckLoc as List <dynamic>) [0].COUN;
if (LocValid == 1)
{
_returnFlag = "1";
_returnText = "\"error: QR code นี้คือ Location\"";
}
else
{
_returnFlag = "1";
_returnText = "\"error: ไม่พบหมายเลขของอุปกรณ์นี้ในฐานข้อมูล\"";
}
}
}
else
{
_returnFlag = "1";
_returnText = "\"error: ระบบไม่ได้รับ Token กรุณา Login ใหม่อีกครั้งหรือ ติดต่อแผนก IT\"";
}
var returnResult = new ReturnDataMoveLoc {
flag = _returnFlag,
text = _returnText
};
return(returnResult);
}