public int GgetSequenceCountupSFT_WS_RUN(string ID)
{
string sqlQuerry = "select isnull(max(SEQUENCE),'0')+ 1 from SFT_WS_RUN where ID = '" + ID + "' ";
sqlSFT sqlSFT = new sqlSFT();
string value = sqlSFT.sqlExecuteScalarString(sqlQuerry);
if (value != null && value != string.Empty)
{
return(int.Parse(value));
}
else
{
return(0);
}
}
public static double GetPQCStock(string productionOrder)
{
double PQCStock = 0;
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" select LOTSIZE from LOT where STATUS = 50 and ERP_OPSEQ = '0020' AND ERP_OPID ='B02'");
stringBuilder.Append(" AND ID = '" + productionOrder + "' ");
sqlSFT sqlSFT = new sqlSFT();
string value = sqlSFT.sqlExecuteScalarString(stringBuilder.ToString());
if (value != "")
{
PQCStock = double.Parse(value);
}
return(PQCStock);
}
public void DeleteRowIntoWarehouseEmptyStock(string ID, string status)
{
StringBuilder builder = new StringBuilder();
builder.Append("select DEFECTQTY from SFT_OP_REALRUN where SEQUENCE = 0 and OPID = 'B02---B01' ");
builder.Append(" and ID = '" + ID + "' ");
sqlSFT sFT = new sqlSFT();
var QtyDefect = sFT.sqlExecuteScalarString(builder.ToString());
if (double.Parse(QtyDefect) == 0) // Neu con defect thi khong duoc xoa Lot pending warehouse
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(" delete from LOT where 1=1 ");
stringBuilder.Append(" and ID = '" + ID + "' ");
stringBuilder.Append(" and STATUS = '" + status + "' ");
stringBuilder.Append(" and LOTSIZE = '0' ");
var result = sFT.sqlExecuteNonQuery(stringBuilder.ToString(), false);
}
}
public static int GetSequenceInSFT_OP_REALRUN(string ID, string ERP_OPSEQ, string ERP_OPID, string ERP_WSID)
{
string sequence = "";
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select MAX(SEQUENCE)+1 from SFT_OP_REALRUN where 1=1 ");
stringBuilder.Append("and ERP_OPSEQ ='" + ERP_OPSEQ + "' ");
stringBuilder.Append("and ERP_OPID ='" + ERP_OPID + "' ");
stringBuilder.Append("and ERP_WSID ='" + ERP_WSID + "' ");
stringBuilder.Append("and ID ='" + ID + "' ");
sqlSFT sqlSFT = new sqlSFT();
sequence = sqlSFT.sqlExecuteScalarString(stringBuilder.ToString());
if (sequence == String.Empty || sequence == "")
{
sequence = "1";
return(1);
}
return(int.Parse(sequence));
}
public SFT_WIP GetSFT_WIPofProducts(string product)
{
SFT_WIP sFT_WIP = new SFT_WIP();
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@"select sum(LOTSIZE) from LOT a
left join MODETAIL b on CMOID = ID
where ERP_OPSEQ = '0010' and a.STATUS = '0' and b.STATUS !='99' and b.STATUS !='100'
");
stringBuilder.Append(" and a.ITEMID = '" + product + "'");
sqlSFT sqlERPCON = new sqlSFT();
var Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
sFT_WIP.MQC_In_Available = double.Parse(Temp.ToString());
}
else
{
sFT_WIP.MQC_In_Available = 0;
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select sum(LOTSIZE) from LOT a
left join MODETAIL b on CMOID = ID
where ERP_OPSEQ = '0010' and a.STATUS = '50' and b.STATUS !='99' and b.STATUS !='100'
");
stringBuilder.Append(" and a.ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
sFT_WIP.MQC_Out_Available = double.Parse(Temp.ToString());
}
else
{
sFT_WIP.MQC_Out_Available = 0;
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select sum(LOTSIZE) from LOT a
left join MODETAIL b on CMOID = ID
where ERP_OPSEQ = '0020' and a.STATUS = '0' and b.STATUS !='99' and b.STATUS !='100'
");
stringBuilder.Append(" and a.ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
sFT_WIP.PQC_In_Available = double.Parse(Temp.ToString());
}
else
{
sFT_WIP.PQC_In_Available = 0;
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select sum(LOTSIZE) from LOT a
left join MODETAIL b on CMOID = ID
where ERP_OPSEQ = '0020' and a.STATUS = '50' and b.STATUS !='99' and b.STATUS !='100'
");
stringBuilder.Append(" and a.ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
sFT_WIP.PQC_Out_Available = double.Parse(Temp.ToString());
}
else
{
sFT_WIP.PQC_Out_Available = 0;
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select sum(LOTSIZE) from LOT a
left join MODETAIL b on CMOID = ID
where ERP_OPSEQ = '0020' and a.STATUS = '130' and b.STATUS !='99' and b.STATUS !='100'
");
stringBuilder.Append(" and a.ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
sFT_WIP.StockIntoWH = double.Parse(Temp.ToString());
}
else
{
sFT_WIP.StockIntoWH = 0;
}
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetSFT_WIPofProducts (string product)", ex.Message);
return(null);
}
return(sFT_WIP);
}
public SFT_WIP GetSFT_WIPofProducts(string product)
{
SFT_WIP sFT_WIP = new SFT_WIP();
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@"select sum(LOTSIZE) from LOT
where ERP_OPSEQ = '0010' and STATUS = '0'
");
stringBuilder.Append(" and ITEMID = '" + product + "'");
sqlSFT sqlERPCON = new sqlSFT();
var Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
sFT_WIP.MQC_In_Available = double.Parse(Temp.ToString());
}
else
{
sFT_WIP.MQC_In_Available = 0;
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select sum(LOTSIZE) from LOT
where ERP_OPSEQ = '0010' and STATUS = '50'
");
stringBuilder.Append(" and ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
sFT_WIP.MQC_Out_Available = double.Parse(Temp.ToString());
}
else
{
sFT_WIP.MQC_Out_Available = 0;
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select sum(LOTSIZE) from LOT
where ERP_OPSEQ = '0020' and STATUS = '0'
");
stringBuilder.Append(" and ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
sFT_WIP.PQC_In_Available = double.Parse(Temp.ToString());
}
else
{
sFT_WIP.PQC_In_Available = 0;
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select sum(LOTSIZE) from LOT
where ERP_OPSEQ = '0020' and STATUS = '50'
");
stringBuilder.Append(" and ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
sFT_WIP.PQC_Out_Available = double.Parse(Temp.ToString());
}
else
{
sFT_WIP.PQC_Out_Available = 0;
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select sum(LOTSIZE) from LOT
where ERP_OPSEQ = '0020' and STATUS = '130'
");
stringBuilder.Append(" and ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
sFT_WIP.StockIntoWH = double.Parse(Temp.ToString());
}
else
{
sFT_WIP.StockIntoWH = 0;
}
}
catch (Exception ex)
{
return(null);
}
return(sFT_WIP);
}
public SemiFinishedGoods GetStockGoodsONSFT(string dept, string product)
{
SemiFinishedGoods semiFinished = new SemiFinishedGoods();
try
{
GetStockinINVMC getStockinINVMC = new GetStockinINVMC();
var StockInWarehouse = getStockinINVMC.GetItemsInINVMCs(dept, product);
if (StockInWarehouse != null)
{
semiFinished.QtyInWarehouse = StockInWarehouse.Select(d => d.Quantity).Sum();
semiFinished.QtyWarehouse = StockInWarehouse.Select(d => d.Quantity).Sum();
}
semiFinished.Item = product;
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(@"select isnull(sum(LOTSIZE),'0') from LOT a
left join MODETAIL b on CMOID = ID
where ERP_OPSEQ = '0010' and a.STATUS = '0' and b.STATUS !='99' and b.STATUS !='100'
");
stringBuilder.Append(" and a.ITEMID = '" + product + "'");
sqlSFT sqlERPCON = new sqlSFT();
var Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
semiFinished.QtyInMQC = double.Parse(Temp);
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select isnull(sum(LOTSIZE),'0') from LOT a
left join MODETAIL b on CMOID = ID
where ERP_OPSEQ = '0010' and a.STATUS = '50' and b.STATUS !='99' and b.STATUS !='100'
");
stringBuilder.Append(" and a.ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
semiFinished.QtyOutMQC = double.Parse(Temp.ToString());
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select isnull(sum(LOTSIZE),'0') from LOT a
left join MODETAIL b on CMOID = ID
where ERP_OPSEQ = '0020' and a.STATUS = '0' and b.STATUS !='99' and b.STATUS !='100'
");
stringBuilder.Append(" and a.ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
semiFinished.QtyInPQC = double.Parse(Temp.ToString());
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select isnull(sum(LOTSIZE),'0') from LOT a
left join MODETAIL b on CMOID = ID
where ERP_OPSEQ = '0020' and a.STATUS = '50' and b.STATUS !='99' and b.STATUS !='100'
");
stringBuilder.Append(" and a.ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
semiFinished.QtyOutPQC = double.Parse(Temp.ToString());
}
stringBuilder = new StringBuilder();
stringBuilder.Append(@"select isnull(sum(LOTSIZE),'0') from LOT a
left join MODETAIL b on CMOID = ID
where ERP_OPSEQ = '0020' and a.STATUS = '130' and b.STATUS !='99' and b.STATUS !='100'
");
stringBuilder.Append(" and a.ITEMID = '" + product + "'");
// sqlERPCON sqlERPCON = new sqlERPCON();
Temp = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString());
if (Temp != null && Temp != "")
{
semiFinished.QtyPendingWarehouse = double.Parse(Temp.ToString());
}
semiFinished.QTyAtMQC = semiFinished.QtyOutMQC;
semiFinished.QTyAtPQC = semiFinished.QtyInPQC + semiFinished.QtyOutPQC;
semiFinished.QtyWip = semiFinished.QTyAtMQC + semiFinished.QTyAtPQC + semiFinished.QtyPendingWarehouse;
GetAccessory getAccessory = new GetAccessory();
semiFinished.accessories = getAccessory.GetAccessories(dept, product);
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetStockGoodsONSFT(string product) : " + product, ex.Message);
}
return(semiFinished);
}