/* public override void AddEntity(Entity entity)
* {
* if (Entities == null) return;
*
* lock (Entities)
* {
* EntityManager.AddEntity(entity);
*
* if (Entities.TryAdd(entity.EntityId, entity))
* {
* if (entity.HealthManager is HealthManager)
* {
*
* }
* LevelEntityAddedEvent addedEvent = new LevelEntityAddedEvent(this, entity);
* EventDispatcher.DispatchEvent(addedEvent);
*
* entity.SpawnToPlayers(GetAllPlayers());
* }
* else
* {
* throw new Exception("Entity existed in the players list when it should not");
* }
* }
* }
*
* public override void RemoveEntity(Entity entity)
* {
* if (Entities == null) return;
*
* lock (Entities)
* {
* if (!Entities.TryRemove(entity.EntityId, out entity)) return; // It's ok. Holograms destroy this play..
*
* LevelEntityRemovedEvent removedEvent = new LevelEntityRemovedEvent(this, entity);
* EventDispatcher.DispatchEvent(removedEvent);
*
* entity.DespawnFromPlayers(GetAllPlayers());
* }
* }*/
public override void AddPlayer(MiNET.Player newPlayer, bool spawn)
{
if (newPlayer.Skin == null)
{
newPlayer.Skin = new Skin()
{
Animations = new List <Animation>(),
Cape = new Cape()
{
Data = new byte[0]
},
Data = ArrayOf <byte> .Create(8192, 0xFF),
Height = 64,
Width = 32,
IsPremiumSkin = false,
IsPersonaSkin = false,
Slim = false
};
}
base.AddPlayer(newPlayer, spawn);
if (Players.TryGetValue(newPlayer.EntityId, out MiNET.Player p))
{
LevelEntityAddedEvent addedEvent = new LevelEntityAddedEvent(this, p);
EventDispatcher.DispatchEventAsync(addedEvent);
}
}
public string UploadProductBom_SAGE50(DataTable dt, string userid)
{
try
{
ProcParam param = new ProcParam(8)
{
ProcedureName = "MASTER_PACK.UPLOAD_PURCHASE_ORDER"
};
var arrASSEMBLY_ID = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Assembly ID")).ToArray();
param.AddParamInput(0, "strASSEMBLY_ID", arrASSEMBLY_ID, OracleDbType.Varchar2);
var arrASSEMBLY_DESC = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Assembly Description")).ToArray();
param.AddParamInput(1, "strASSEMBLY_DESC", arrASSEMBLY_DESC, OracleDbType.Varchar2);
var arrREVISION_NO = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Revision Number")).ToArray();
param.AddParamInput(2, "strREVISION_NO", arrREVISION_NO, OracleDbType.Decimal);
var arrCOMPONENT_ID = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Component ID")).ToArray();
param.AddParamInput(3, "strCOMPONENT_ID", arrCOMPONENT_ID, OracleDbType.Varchar2);
var arrCOMPONENT_QTY_NEEDED = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Component Qty Needed")).ToArray();
param.AddParamInput(4, "strCOMPONENT_QTY_NEEDED", arrCOMPONENT_QTY_NEEDED, OracleDbType.Decimal);
var arrCOMPONENT_DESC = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Component Description")).ToArray();
param.AddParamInput(5, "strCOMPONENT_DESC", arrCOMPONENT_DESC, OracleDbType.Varchar2);
param.AddParamInput(6, "strUSER_ID", ArrayOf <object> .Create(dt.Rows.Count, userid), OracleDbType.Varchar2);
param.AddParamOutput(7, "RESULTMSG", OracleDbType.Varchar2, 255, "OK", dt.Rows.Count);
GlobalDB.Instance.DataAc.ExecuteNonQuery(param, dt.Rows.Count);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
else
{
if (((Oracle.DataAccess.Types.OracleString[])(param.ReturnValue(7)))[0].Value == "OK")
{
return("OK");
}
else
{
return("Error");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private int InsertPrintTransaction(DataTable dtbSelect)
{
int seqPrint = -1;
try
{
seqPrint = PrintingBuilder.Instance.GeneratePrintSEQ();
//List<ProcParam> procInsTPrintList = new List<ProcParam>();
//ProcParam procInsTPrint = null;
//foreach (ProductCard prdCard in lstPrdCard)
//{
// procInsTPrint = new ProcParam(4);
// procInsTPrint.ProcedureName = "GLOBAL_FUNCTION_PACK.T_PRINT_TRANSACTION_INS";
// procInsTPrint.AddParamInput(0, "strSEQ_NO", seqPrint);
// procInsTPrint.AddParamInput(1, "strTR1", prdCard.SERIAL_NO);
// procInsTPrint.AddParamInput(2, "strTR2", DBNull.Value);
// procInsTPrint.AddParamInput(3, "strTR3", DBNull.Value);
// procInsTPrintList.Add(procInsTPrint);
//}
ProcParam paramPrint = new ProcParam(4)
{
ProcedureName = "GLOBAL_FUNCTION_PACK.T_PRINT_TRANSACTION_INS"
};
//param 0 - SEQ_NO
paramPrint.AddParamInput(0, "strSEQ_NO", ArrayOf <object> .Create(dtbSelect.Rows.Count, seqPrint), OracleDbType.Varchar2);
//param 1 - strTR1
var arrPRODUCT_NO = (from DataRow row in dtbSelect.Rows
select row["PRODUCT_NO"]).ToArray();
paramPrint.AddParamInput(1, "strTR1", arrPRODUCT_NO, OracleDbType.Varchar2);
//param 2 - strTR2
var arrSTOCK_IN_DATE = (from DataRow row in dtbSelect.Rows
select string.Format("{0:yyyyMMdd}", row["STOCK_IN_DATE"])).ToArray();
paramPrint.AddParamInput(2, "strTR2", arrSTOCK_IN_DATE, OracleDbType.Varchar2);
//param 3 - strTR3
paramPrint.AddParamInput(3, "strTR3", ArrayOf <object> .Create(dtbSelect.Rows.Count, null), OracleDbType.Varchar2);
//insert value to print transaction.
PrintingBuilder.Instance.InsertTransactionPrint(paramPrint, dtbSelect.Rows.Count);
return(seqPrint);
}
catch (Exception ex)
{
return(-1);
}
}
private BitmapFont(int gridWidth, int gridHeight, List <char> characters)
{
GridWidth = gridWidth;
GridHeight = gridHeight;
Characters = characters.ToArray();
DefaultGlyph = new Glyph('\x0000', null, 0, 8);
Glyphs = ArrayOf <Glyph> .Create((int)characters.Max(x => (int)x), DefaultGlyph);
//Glyphs = new Dictionary<char, Glyph>(characters.Count); //new Glyph[characters.Count];
}
public string UploadVendorMaster(DataTable dt, string partyType, string userid)
{
try
{
ProcParam param = new ProcParam(7)
{
ProcedureName = "MASTER_PACK.UPLOAD_PARTY_MASTER"
};
var arrCustomerId = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Vendor ID")).ToArray();
param.AddParamInput(0, "strCUSTOMER_ID", arrCustomerId, OracleDbType.Varchar2);
var arrCustomerName = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Vendor Name")).ToArray();
param.AddParamInput(1, "strCUSTOMER_NAME", arrCustomerName, OracleDbType.Varchar2);
var arrTerm = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Due Days")).ToArray();
param.AddParamInput(2, "strTERM", arrTerm, OracleDbType.Varchar2);
//var arrPriceLevel = dt.AsEnumerable().ToList().Select(r => r.Field<string>("Pricing Level")).ToArray();
//param.AddParamInput(3, "strPRICE_LEVEL", arrPriceLevel, OracleDbType.Varchar2);
param.AddParamInput(3, "strPRICE_LEVEL", ArrayOf <object> .Create(dt.Rows.Count, string.Empty), OracleDbType.Varchar2);
param.AddParamInput(4, "strPARTY_TYPE", ArrayOf <object> .Create(dt.Rows.Count, partyType), OracleDbType.Varchar2);
param.AddParamInput(5, "strUSER_ID", ArrayOf <object> .Create(dt.Rows.Count, userid), OracleDbType.Varchar2);
param.AddParamOutput(6, "RESULTMSG", OracleDbType.Varchar2, 255, "OK", dt.Rows.Count);
GlobalDB.Instance.DataAc.ExecuteNonQuery(param, dt.Rows.Count);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
else
{
if (((Oracle.DataAccess.Types.OracleString[])(param.ReturnValue(6)))[0].Value == "OK")
{
return("OK");
}
else
{
return("Error");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateProductionProcess(List <ProdProcess> lstProdProcess, string strNEW_PROD_SEQ_NO, string userid)
{
ProcParam procDetail = null;
try
{
procDetail = new ProcParam(6)
{
ProcedureName = "MASTER_PACK.M_PROD_PROCESS_UPD"
};
//PROD_SEQ_NO
procDetail.AddParamInput(0, "strPROD_SEQ_NO", ArrayOf <object> .Create(lstProdProcess.Count, strNEW_PROD_SEQ_NO), OracleDbType.Varchar2);
//PROCESS_NO
var arrPROCESS_NO = (from prodP in lstProdProcess
select prodP.PROCESS_NO).ToArray();
procDetail.AddParamInput(1, "strPROCESS_NO", arrPROCESS_NO, OracleDbType.Varchar2);
//STEP_NO
var arrSTEP_NO = (from prodP in lstProdProcess
select(object) prodP.STEP_NO).ToArray();
procDetail.AddParamInput(2, "strSTEP_NO", arrSTEP_NO, OracleDbType.Int32);
//REC_STAT
var arrREC_STAT = (from prodP in lstProdProcess
select prodP.REC_STAT ? "Y" : "N").ToArray();
procDetail.AddParamInput(3, "strREC_STAT", arrREC_STAT, OracleDbType.Varchar2);
//USER_ID
procDetail.AddParamInput(4, "strUSER_ID", ArrayOf <object> .Create(lstProdProcess.Count, userid), OracleDbType.Varchar2);
//RESULTMSG
procDetail.AddParamOutput(5, "RESULTMSG", OracleDbType.Varchar2, 255, "OK", lstProdProcess.Count);
GlobalDB.Instance.DataAc.ExecuteNonQuery(procDetail, lstProdProcess.Count);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
}
catch (Exception ex)
{
throw ex;
}
}
public string UpdateArrival(T_ARRIVAL_HDR ArrHdr, List <T_ARRIVAL_DTL> lstArrDtl, string userid)
{
string resultMsg = string.Empty;
try
{
#region "Transaction Header"
ProcParam procHeader = new ProcParam(11)
{
ProcedureName = "MTL_IN_PACK.T_ARRIVAL_HDR_UPD"
};
procHeader.AddParamInput(0, "strARRIVAL_NO", ArrHdr.ARRIVAL_NO);
procHeader.AddParamInput(1, "strARRIVAL_DATE", ArrHdr.ARRIVAL_DATE);
procHeader.AddParamInput(2, "strWH_ID", ArrHdr.WH_ID);
procHeader.AddParamInput(3, "strPARTY_ID", ArrHdr.PARTY_ID);
procHeader.AddParamInput(4, "strREF_NO ", ArrHdr.REF_NO);
procHeader.AddParamInput(5, "strREF_DATE", ArrHdr.REF_DATE);
procHeader.AddParamInput(6, "strREMARK", ArrHdr.REMARK);
procHeader.AddParamInput(7, "strUSER_ID", ArrHdr.USER_ID);
procHeader.AddParamInput(8, "strREC_STAT", ArrHdr.REC_STAT ? "Y" : "N");
procHeader.AddParamInput(9, "strARR_TYPE", ArrHdr.ARR_TYPE);
procHeader.AddParamOutput(10, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK");
#endregion "Transaction Header"
#region "Transaction Detail"
#region Arrival Delete #Flag=0
var delArr = from arr in lstArrDtl
where arr.FLAG == 0
select arr;
ProcParam paramDel = null;
if (delArr.Any() && delArr.Count() > 0)
{
paramDel = new ProcParam(4)
{
ProcedureName = "MTL_IN_PACK.T_ARRIVAL_DTL_DEL"
};
//strUNIT_CODE
var arrARRIVAL_NO = (from arr in delArr
select arr.ARRIVAL_NO).ToArray();
paramDel.AddParamInput(0, "strARRIVAL_NO", arrARRIVAL_NO, OracleDbType.Varchar2);
var arrLINE_NO = (from arr in delArr
select(object) arr.LINE_NO).ToArray();
paramDel.AddParamInput(1, "strLINE_NO", arrLINE_NO, OracleDbType.Int32);
//User id
paramDel.AddParamInput(2, "strUSER_ID", ArrayOf <object> .Create(delArr.Count(), userid), OracleDbType.Varchar2);
//RESULTMSG
paramDel.AddParamOutput(3, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK", delArr.Count());
}
#endregion
#region Arrival Insert #Flag=2
var insArr = from arr in lstArrDtl
where arr.FLAG == 2
select arr;
ProcParam paramIns = null;
if (insArr.Any() && insArr.Count() > 0)
{
paramIns = new ProcParam(10)
{
ProcedureName = "MTL_IN_PACK.T_ARRIVAL_DTL_INS"
};
var arrARRIVAL_NO = (from arr in insArr
select arr.ARRIVAL_NO).ToArray();
paramIns.AddParamInput(0, "strARRIVAL_NO", arrARRIVAL_NO, OracleDbType.Varchar2);
var arrLINE_NO = (from arr in insArr
select(object) arr.LINE_NO).ToArray();
paramIns.AddParamInput(1, "strLINE_NO", arrLINE_NO, OracleDbType.Int32);
var arrMTL_SEQ_NO = (from arr in insArr
select arr.MTL_SEQ_NO).ToArray();
paramIns.AddParamInput(2, "strMTL_SEQ_NO", arrMTL_SEQ_NO, OracleDbType.Varchar2);
var arrUNIT_ID = (from arr in insArr
select arr.UNIT_ID).ToArray();
paramIns.AddParamInput(3, "strUNIT_ID", arrUNIT_ID, OracleDbType.Varchar2);
var arrQTY = (from arr in insArr
select(object) arr.QTY).ToArray();
paramIns.AddParamInput(4, "strQTY", arrQTY, OracleDbType.Decimal);
var arrREMARK = (from arr in insArr
select arr.REMARK).ToArray();
paramIns.AddParamInput(5, "strREMARK", arrREMARK, OracleDbType.Varchar2);
//strCREATED_BY
paramIns.AddParamInput(6, "strUSER_ID", ArrayOf <object> .Create(insArr.Count(), userid), OracleDbType.Varchar2);
//REC_STATUS
paramIns.AddParamInput(7, "strREC_STAT", ArrayOf <object> .Create(insArr.Count(), "Y"), OracleDbType.Varchar2);
var arrLOT_DATE = (from arr in insArr
select(object) arr.LOT_DATE).ToArray();
paramIns.AddParamInput(8, "strLOT_DATE", arrLOT_DATE, OracleDbType.Date);
//RESULTMSG
paramIns.AddParamOutput(9, "RESULTMSG", OracleDbType.Varchar2, 255, "OK", insArr.Count());
}
#endregion
#region Arrival Update #Flag=3
var updArr = from arr in lstArrDtl
where arr.FLAG == 3
select arr;
ProcParam paramUpd = null;
if (updArr.Any() && updArr.Count() > 0)
{
paramUpd = new ProcParam(9)
{
ProcedureName = "MTL_IN_PACK.T_ARRIVAL_DTL_UPD"
};
var arrARRIVAL_NO = (from arr in updArr
select arr.ARRIVAL_NO).ToArray();
paramUpd.AddParamInput(0, "strARRIVAL_NO", arrARRIVAL_NO, OracleDbType.Varchar2);
var arrLINE_NO = (from arr in updArr
select(object) arr.LINE_NO).ToArray();
paramUpd.AddParamInput(1, "strLINE_NO", arrLINE_NO, OracleDbType.Int32);
var arrMTL_SEQ_NO = (from arr in updArr
select arr.MTL_SEQ_NO).ToArray();
paramUpd.AddParamInput(2, "strMTL_SEQ_NO", arrMTL_SEQ_NO, OracleDbType.Varchar2);
var arrUNIT_ID = (from arr in updArr
select arr.UNIT_ID).ToArray();
paramUpd.AddParamInput(3, "strUNIT_ID", arrUNIT_ID, OracleDbType.Varchar2);
var arrQTY = (from arr in updArr
select(object) arr.QTY).ToArray();
paramUpd.AddParamInput(4, "strQTY", arrQTY, OracleDbType.Decimal);
var arrREMARK = (from arr in updArr
select arr.REMARK).ToArray();
paramUpd.AddParamInput(5, "strREMARK", arrREMARK, OracleDbType.Varchar2);
//strCREATED_BY
paramUpd.AddParamInput(6, "strUSER_ID", ArrayOf <object> .Create(updArr.Count(), userid), OracleDbType.Varchar2);
//REC_STATUS
paramUpd.AddParamInput(7, "strREC_STAT", ArrayOf <object> .Create(updArr.Count(), "Y"), OracleDbType.Varchar2);
//RESULTMSG
paramUpd.AddParamOutput(8, "RESULTMSG", OracleDbType.Varchar2, 255, "OK", updArr.Count());
}
#endregion
#endregion
GlobalDB.Instance.DataAc.ExecuteNonQuery(procHeader, paramDel, delArr.Count(), paramIns, insArr.Count(), paramUpd, updArr.Count());
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
resultMsg = "OK";
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public string InsertArrival(T_ARRIVAL_HDR ArrHdr, List <T_ARRIVAL_DTL> lstArrDtl, string userid, out string ARRIVAL_NO)
{
string resultMsg = string.Empty;
ARRIVAL_NO = string.Empty;
try
{
#region "Transaction Header"
ProcParam procHeader = new ProcParam(11)
{
ProcedureName = "MTL_IN_PACK.T_ARRIVAL_HDR_INS"
};
procHeader.AddParamInOutput(0, "strARRIVAL_NO", OracleDbType.NVarchar2, 30, ArrHdr.ARRIVAL_NO);
procHeader.AddParamInput(1, "strARRIVAL_DATE", ArrHdr.ARRIVAL_DATE);
procHeader.AddParamInput(2, "strWH_ID", ArrHdr.WH_ID);
procHeader.AddParamInput(3, "strPARTY_ID", ArrHdr.PARTY_ID);
procHeader.AddParamInput(4, "strREF_NO ", ArrHdr.REF_NO);
procHeader.AddParamInput(5, "strREF_DATE", ArrHdr.REF_DATE);
procHeader.AddParamInput(6, "strREMARK", ArrHdr.REMARK);
procHeader.AddParamInput(7, "strUSER_ID", ArrHdr.USER_ID);
procHeader.AddParamInput(8, "strREC_STAT", ArrHdr.REC_STAT ? "Y" : "N");
procHeader.AddParamInput(9, "strARR_TYPE", ArrHdr.ARR_TYPE);
procHeader.AddParamOutput(10, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK");
#endregion "Transaction Header"
#region "Transaction Detail"
#region Arrival Insert #Flag=2
var insArr = from arr in lstArrDtl
where arr.FLAG == 2
select arr;
ProcParam paramIns = null;
if (insArr.Any() && insArr.Count() > 0)
{
paramIns = new ProcParam(10)
{
ProcedureName = "MTL_IN_PACK.T_ARRIVAL_DTL_INS"
};
var arrARRIVAL_NO = (from arr in insArr
select arr.ARRIVAL_NO).ToArray();
paramIns.AddParamInput(0, "strARRIVAL_NO", arrARRIVAL_NO, OracleDbType.Varchar2);
var arrLINE_NO = (from arr in insArr
select(object) arr.LINE_NO).ToArray();
paramIns.AddParamInput(1, "strLINE_NO", arrLINE_NO, OracleDbType.Int32);
var arrMTL_SEQ_NO = (from arr in insArr
select arr.MTL_SEQ_NO).ToArray();
paramIns.AddParamInput(2, "strMTL_SEQ_NO", arrMTL_SEQ_NO, OracleDbType.Varchar2);
var arrUNIT_ID = (from arr in insArr
select arr.UNIT_ID).ToArray();
paramIns.AddParamInput(3, "strUNIT_ID", arrUNIT_ID, OracleDbType.Varchar2);
var arrQTY = (from arr in insArr
select(object) arr.QTY).ToArray();
paramIns.AddParamInput(4, "strQTY", arrQTY, OracleDbType.Decimal);
var arrREMARK = (from arr in insArr
select arr.REMARK).ToArray();
paramIns.AddParamInput(5, "strREMARK", arrREMARK, OracleDbType.Varchar2);
//strCREATED_BY
paramIns.AddParamInput(6, "strUSER_ID", ArrayOf <object> .Create(insArr.Count(), userid), OracleDbType.Varchar2);
//REC_STATUS
paramIns.AddParamInput(7, "strREC_STAT", ArrayOf <object> .Create(insArr.Count(), "Y"), OracleDbType.Varchar2);
var arrLOT_DATE = (from arr in insArr
select(object) arr.LOT_DATE).ToArray();
paramIns.AddParamInput(8, "strLOT_DATE", arrLOT_DATE, OracleDbType.Date);
//RESULTMSG
paramIns.AddParamOutput(9, "RESULTMSG", OracleDbType.Varchar2, 255, "OK", insArr.Count());
}
#endregion
#endregion
GlobalDB.Instance.DataAc.ExecuteNonQuery(procHeader, paramIns, insArr.Count(), 0, 0);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
OracleString resultKey = (OracleString)procHeader.ReturnValue(0);
OracleString result = (OracleString)procHeader.ReturnValue(10);
if (!resultKey.IsNull)
{
ARRIVAL_NO = resultKey.Value;
}
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public DataSet PrintTO(List <string> lstTO, string userid)
{
//declare dataset and name.
DataSet dtsResult = new DataSet("DTS_TRANSFER_ORDER");
int seqPrint = 0;
try
{
seqPrint = PrintingBuilder.Instance.GeneratePrintSEQ();
ProcParam paramPrint = new ProcParam(4)
{
ProcedureName = "GLOBAL_FUNCTION_PACK.T_PRINT_TRANSACTION_INS"
};
//param 0 - SEQ_NO
paramPrint.AddParamInput(0, "strSEQ_NO", ArrayOf <object> .Create(lstTO.Count, seqPrint), OracleDbType.Varchar2);
//param 1 - strTR1
var arrTR_NO = (from trans in lstTO
select trans).ToArray();
paramPrint.AddParamInput(1, "strTR1", arrTR_NO, OracleDbType.Varchar2);
//param 2 - strTR2
paramPrint.AddParamInput(2, "strTR2", ArrayOf <object> .Create(lstTO.Count, null), OracleDbType.Varchar2);
//param 3 - strTR3
paramPrint.AddParamInput(3, "strTR3", ArrayOf <object> .Create(lstTO.Count, null), OracleDbType.Varchar2);
//insert value to print transaction.
//PrintingBuilder.Instance.InsertTransactionPrint(paramPrint, lstTO.Count);
//List<ProcParam> procInsTPrintList = new List<ProcParam>();
//ProcParam procInsTPrint = null;
//foreach (string tono in lstTO)
//{
// procInsTPrint = new ProcParam(4);
// procInsTPrint.ProcedureName = "GLOBAL_FUNCTION_PACK.T_PRINT_TRANSACTION_INS";
// procInsTPrint.AddParamInput(0, "strSEQ_NO", seqPrint);
// procInsTPrint.AddParamInput(1, "strTR1", tono);
// procInsTPrint.AddParamInput(2, "strTR2", DBNull.Value);
// procInsTPrint.AddParamInput(3, "strTR3", DBNull.Value);
// procInsTPrintList.Add(procInsTPrint);
//}
////insert value to print transaction.
//PrintingBuilder.Instance.InsertTransactionPrint(procInsTPrintList);
// DataTable dtHeader = PrintingBuilder.Instance.PrintTableResult("TO_PACK.RPT_TRANSFER_ORDER", seqPrint, "T_TRANSFER_ORDER");
DataTable dtHeader = this.PrintTO(seqPrint, "T_TRANSFER_ORDER");
dtsResult.Tables.Add(dtHeader);
//PrintingBuilder.Instance.RemovePrintSEQ(seqPrint);
return(dtsResult);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public string InsertPlan(string PlanType, DataTable DtExcelPlan_DTL, DateTime planDate, string userid)
{
string resultMsg = string.Empty;
try
{
#region Transaction Header
ProcParam paramHDR = new ProcParam(5)
{
ProcedureName = "UPLOAD_PLAN.UPLOAD_PLAN_HDR_INSERT"
};
paramHDR.AddParamInOutput(0, "strPLAN_NO", OracleDbType.Varchar2, 30, "");
paramHDR.AddParamInput(1, "strUSER_ID", userid);
paramHDR.AddParamInput(2, "strTYPE", PlanType);
paramHDR.AddParamInput(3, "strPLAN_DATE", planDate);
paramHDR.AddParamOutput(4, "RESULTMSG", OracleDbType.NVarchar2, 255);
#endregion
#region Transaction Detail
// DataRow[] insertRows = dtCOMPDtl.Rows;
ProcParam paramDTL = null;
if (DtExcelPlan_DTL.Rows.Count > 0)
{
paramDTL = new ProcParam(34)
{
ProcedureName = "UPLOAD_PLAN.UPLOAD_PLAN_DTL_INSERT"
};
paramDTL.AddParamInput(0, "strPLAN_NO", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2);
var arrMC_SIZE_TON = (from DataRow row in DtExcelPlan_DTL.Rows
select row["MC_SIZE_TON"]).ToArray();
paramDTL.AddParamInput(1, "strMC_SIZE_TON", arrMC_SIZE_TON, OracleDbType.Varchar2);
var arrPDTL_BLOCK = (from DataRow row in DtExcelPlan_DTL.Rows
select row["PDTL_BLOCK"]).ToArray();
paramDTL.AddParamInput(2, "strPDTL_BLOCK", arrPDTL_BLOCK, OracleDbType.Varchar2);
var arrMC_NO = (from DataRow row in DtExcelPlan_DTL.Rows
select row["MC_NO"]).ToArray();
paramDTL.AddParamInput(3, "strMC_NO", arrMC_NO, OracleDbType.Varchar2);
var arrPDTL_SEQUENCE = (from DataRow row in DtExcelPlan_DTL.Rows
select row["PDTL_SEQUENCE"]).ToArray();
paramDTL.AddParamInput(4, "strPDTL_SEQUENCE", arrPDTL_SEQUENCE, OracleDbType.Varchar2);
var arrPRODUCT_NO = (from DataRow row in DtExcelPlan_DTL.Rows
select row["PRODUCT_NO"]).ToArray();
paramDTL.AddParamInput(5, "strPRODUCT_NO", arrPRODUCT_NO, OracleDbType.Varchar2);
if (PlanType == "H")
{
var arrPARTNAME = (from DataRow row in DtExcelPlan_DTL.Rows
select row["PARTNAME"]).ToArray();
paramDTL.AddParamInput(6, "strPARTNAME", arrPARTNAME, OracleDbType.Varchar2);
}
else
{
paramDTL.AddParamInput(6, "strPARTNAME", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2);
}
var arrMAT_TYPE = (from DataRow row in DtExcelPlan_DTL.Rows
select row["MAT_TYPE"]).ToArray();
paramDTL.AddParamInput(7, "strMAT_TYPE", arrMAT_TYPE, OracleDbType.Varchar2);
if (PlanType == "V")
{
var arrINSERT_1 = (from DataRow row in DtExcelPlan_DTL.Rows
select row["INSERT_1"]).ToArray();
paramDTL.AddParamInput(8, "strINSERT_1", arrINSERT_1, OracleDbType.Varchar2);
var arrINSERT_2 = (from DataRow row in DtExcelPlan_DTL.Rows
select row["INSERT_2"]).ToArray();
paramDTL.AddParamInput(9, "strINSERT_2", arrINSERT_2, OracleDbType.Varchar2);
var arrINSERT_3 = (from DataRow row in DtExcelPlan_DTL.Rows
select row["INSERT_3"]).ToArray();
paramDTL.AddParamInput(10, "strINSERT_3", arrINSERT_3, OracleDbType.Varchar2);
var arrTARGET_DAY = (from DataRow row in DtExcelPlan_DTL.Rows
select row["TARGET_DAY"]).ToArray();
paramDTL.AddParamInput(24, "strTARGET_DAY", arrTARGET_DAY, OracleDbType.Int32);
var arrPROD_LOT = (from DataRow row in DtExcelPlan_DTL.Rows
select row["PROD_LOT"]).ToArray();
paramDTL.AddParamInput(27, "strPROD_LOT", arrPROD_LOT, OracleDbType.Varchar2);
}
else
{
paramDTL.AddParamInput(8, "strINSERT_1", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2);
paramDTL.AddParamInput(9, "strINSERT_2", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2);
paramDTL.AddParamInput(10, "strINSERT_3", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2);
paramDTL.AddParamInput(24, "strTARGET_DAY", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, null), OracleDbType.Int32);
paramDTL.AddParamInput(27, "strPROD_LOT", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, ""), OracleDbType.Varchar2);
}
var arrCAV_ACT = (from DataRow row in DtExcelPlan_DTL.Rows
select row["CAV_ACT"]).ToArray();
paramDTL.AddParamInput(11, "strCAV_ACT", arrCAV_ACT, OracleDbType.Int32);
var arrCAV_FULL = (from DataRow row in DtExcelPlan_DTL.Rows
select row["CAV_FULL"]).ToArray();
paramDTL.AddParamInput(12, "strCAV_FULL", arrCAV_FULL, OracleDbType.Int32);
var arrMP_START = (from DataRow row in DtExcelPlan_DTL.Rows
select row["MP_START"]).ToArray();
paramDTL.AddParamInput(13, "strMP_START", arrMP_START, OracleDbType.Date);
var arrMP_FINISH = (from DataRow row in DtExcelPlan_DTL.Rows
select row["MP_FINISH"]).ToArray();
paramDTL.AddParamInput(14, "strMP_FINISH", arrMP_FINISH, OracleDbType.Date);
var arrPLAN_MP_DAY = (from DataRow row in DtExcelPlan_DTL.Rows
select row["PLAN_MP_DAY"]).ToArray();
paramDTL.AddParamInput(15, "strPLAN_MP_DAY", arrPLAN_MP_DAY, OracleDbType.Decimal);
var arrPRO_SHOT_WEIGHT = (from DataRow row in DtExcelPlan_DTL.Rows
select row["PRO_SHOT_WEIGHT"]).ToArray();
paramDTL.AddParamInput(16, "strPRO_SHOT_WEIGHT", arrPRO_SHOT_WEIGHT, OracleDbType.Decimal);
var arrCYCLE_TIME = (from DataRow row in DtExcelPlan_DTL.Rows
select row["CYCLE_TIME"]).ToArray();
paramDTL.AddParamInput(17, "strCYCLE_TIME", arrCYCLE_TIME, OracleDbType.Decimal);
var arrQTY_DAY = (from DataRow row in DtExcelPlan_DTL.Rows
select row["QTY_DAY"]).ToArray();
paramDTL.AddParamInput(18, "strQTY_DAY", arrQTY_DAY, OracleDbType.Int32);
var arrTOTAL_MAT_USE_KG = (from DataRow row in DtExcelPlan_DTL.Rows
select row["TOTAL_MAT_USE_KG"]).ToArray();
paramDTL.AddParamInput(19, "strTOTAL_MAT_USE_KG", arrTOTAL_MAT_USE_KG, OracleDbType.Decimal);
var arrTPCT_LOSS = (from DataRow row in DtExcelPlan_DTL.Rows
select row["TPCT_LOSS"]).ToArray();
paramDTL.AddParamInput(20, "strTPCT_LOSS", arrTPCT_LOSS, OracleDbType.Decimal);
var arrQTY_PLAN = (from DataRow row in DtExcelPlan_DTL.Rows
select row["QTY_PLAN"]).ToArray();
paramDTL.AddParamInput(21, "strQTY_PLAN", arrQTY_PLAN, OracleDbType.Int32);
var arrPLAN_MAT_AVG_DAY_KG = (from DataRow row in DtExcelPlan_DTL.Rows
select row["PLAN_MAT_AVG_DAY_KG"]).ToArray();
paramDTL.AddParamInput(22, "strPLAN_MAT_AVG_DAY_KG", arrPLAN_MAT_AVG_DAY_KG, OracleDbType.Decimal);
var arrMAT_DRY = (from DataRow row in DtExcelPlan_DTL.Rows
select row["MAT_DRY"]).ToArray();
paramDTL.AddParamInput(23, "strMAT_DRY", arrMAT_DRY, OracleDbType.NVarchar2);
var arrPDTL_REMARK = (from DataRow row in DtExcelPlan_DTL.Rows
select row["PDTL_REMARK"]).ToArray();
paramDTL.AddParamInput(25, "strPDTL_REMARK", arrPDTL_REMARK, OracleDbType.Varchar2);
var arrPARTY_ID = (from DataRow row in DtExcelPlan_DTL.Rows
select row["PARTY_ID"]).ToArray();
paramDTL.AddParamInput(26, "strPARTY_ID", arrPARTY_ID, OracleDbType.Varchar2);
paramDTL.AddParamInput(28, "strN_USER_ID", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, userid), OracleDbType.Varchar2);
var arrPROD_SEQ_NO = (from DataRow row in DtExcelPlan_DTL.Rows
select row["PROD_SEQ_NO"]).ToArray();
paramDTL.AddParamInput(29, "strPROD_SEQ_NO", arrPROD_SEQ_NO, OracleDbType.Varchar2);
paramDTL.AddParamInput(30, "strCHANGE_MOLD", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, 'N'), OracleDbType.Varchar2);
paramDTL.AddParamInput(31, "strCONTINUE_ORDER", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, 'N'), OracleDbType.Varchar2);
paramDTL.AddParamInput(32, "strREVISED_PLAN", ArrayOf <object> .Create(DtExcelPlan_DTL.Rows.Count, 'N'), OracleDbType.Varchar2);
//RESULTMSG
paramDTL.AddParamOutput(33, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK", DtExcelPlan_DTL.Rows.Count);
}
#endregion
GlobalDB.Instance.DataAc.ExecuteNonQuery(paramHDR, paramDTL, DtExcelPlan_DTL.Rows.Count, 0, 0);
// GlobalDB.Instance.DataAc.ExecuteNonQuery(paramHDR, paramDTL, lstCOMPDtl.Count,0,0);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
OracleString result = (OracleString)paramHDR.ReturnValue(4);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex) {
throw ex;
}
return(resultMsg);
}
public string InsUpdDelPlanListFLAG(List <ULPlanDetail> lstArrDtl, string userid)
{
string resultMsg = string.Empty;
try
{
#region "Transaction Detail"
#region Arrival Delete #Flag=0
var delArr = from arr in lstArrDtl
where arr.FLAG == 0
select arr;
ProcParam paramDel = null;
if (delArr.Any() && delArr.Count() > 0)
{
paramDel = new ProcParam(4)
{
ProcedureName = "UPLOAD_PLAN.UPLOAD_PLAN_DTL_DELETE"
};
var arrPLAN_DTL_ID = (from arr in delArr
select(object) arr.PLAN_DTL_ID).ToArray();
paramDel.AddParamInput(0, "strPLAN_DTL_ID", arrPLAN_DTL_ID, OracleDbType.Int32);
var arrPLAN_NO = (from arr in delArr
select arr.PLAN_NO).ToArray();
paramDel.AddParamInput(1, "strPLAN_NO", arrPLAN_NO, OracleDbType.Varchar2);
paramDel.AddParamInput(2, "strUSER_ID", ArrayOf <object> .Create(delArr.Count(), userid), OracleDbType.Varchar2);
//RESULTMSG
paramDel.AddParamOutput(3, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK", delArr.Count());
}
#endregion
#region Arrival Insert #Flag=2
var insArr = from arr in lstArrDtl
where arr.FLAG == 2
select arr;
ProcParam paramIns = null;
if (insArr.Any() && insArr.Count() > 0)
{
paramIns = new ProcParam(34)
{
ProcedureName = "UPLOAD_PLAN.UPLOAD_PLAN_DTL_INSERT"
};
var arrPLAN_NO = (from arr in insArr
select arr.PLAN_NO).ToArray();
paramIns.AddParamInput(0, "strPLAN_NO", arrPLAN_NO, OracleDbType.Varchar2);
var arrMC_SIZE_TON = (from arr in insArr
select arr.MC_SIZE_TON).ToArray();
paramIns.AddParamInput(1, "strMC_SIZE_TON", arrMC_SIZE_TON, OracleDbType.Varchar2);
var arrPDTL_BLOCK = (from arr in insArr
select arr.PDTL_BLOCK).ToArray();
paramIns.AddParamInput(2, "strPDTL_BLOCK", arrPDTL_BLOCK, OracleDbType.Varchar2);
var arrMC_NO = (from arr in insArr
select arr.MC_NO).ToArray();
paramIns.AddParamInput(3, "strMC_NO", arrMC_NO, OracleDbType.Varchar2);
var arrPDTL_SEQUENCE = (from arr in insArr
select arr.PDTL_SEQUENCE).ToArray();
paramIns.AddParamInput(4, "strPDTL_SEQUENCE", arrPDTL_SEQUENCE, OracleDbType.Varchar2);
var arrPRODUCT_NO = (from arr in insArr
select arr.PRODUCT_NO).ToArray();
paramIns.AddParamInput(5, "strPRODUCT_NO", arrPRODUCT_NO, OracleDbType.Varchar2);
var arrPARTNAME = (from arr in insArr
select arr.PARTNAME).ToArray();
paramIns.AddParamInput(6, "strPARTNAME", arrPARTNAME, OracleDbType.Varchar2);
var arrMAT_TYPE = (from arr in insArr
select arr.MAT_TYPE).ToArray();
paramIns.AddParamInput(7, "strMAT_TYPE", arrMAT_TYPE, OracleDbType.Varchar2);
var arrINSERT_1 = (from arr in insArr
select arr.INSERT_1).ToArray();
paramIns.AddParamInput(8, "strINSERT_1", arrINSERT_1, OracleDbType.Varchar2);
var arrINSERT_2 = (from arr in insArr
select arr.INSERT_2).ToArray();
paramIns.AddParamInput(9, "strINSERT_2", arrINSERT_2, OracleDbType.Varchar2);
var arrINSERT_3 = (from arr in insArr
select arr.INSERT_3).ToArray();
paramIns.AddParamInput(10, "strINSERT_3", arrINSERT_3, OracleDbType.Varchar2);
var arrCAV_ACT = (from arr in insArr
select(object) arr.CAV_ACT).ToArray();
paramIns.AddParamInput(11, "strCAV_ACT", arrCAV_ACT, OracleDbType.Int32);
var arrCAV_FULL = (from arr in insArr
select(object) arr.CAV_FULL).ToArray();
paramIns.AddParamInput(12, "strCAV_FULL", arrCAV_FULL, OracleDbType.Int32);
var arrMP_START = (from arr in insArr
select(object) arr.MP_START).ToArray();
paramIns.AddParamInput(13, "strMP_START", arrMP_START, OracleDbType.Date);
var arrMP_FINISH = (from arr in insArr
select(object) arr.MP_FINISH).ToArray();
paramIns.AddParamInput(14, "strMP_FINISH", arrMP_FINISH, OracleDbType.Date);
var arrPLAN_MP_DAY = (from arr in insArr
select(object) arr.PLAN_MP_DAY).ToArray();
paramIns.AddParamInput(15, "strPLAN_MP_DAY", arrPLAN_MP_DAY, OracleDbType.Decimal);
var arrPRO_SHOT_WEIGHT = (from arr in insArr
select(object) arr.PRO_SHOT_WEIGHT).ToArray();
paramIns.AddParamInput(16, "strPRO_SHOT_WEIGHT", arrPRO_SHOT_WEIGHT, OracleDbType.Decimal);
var arrCYCLE_TIME = (from arr in insArr
select(object) arr.CYCLE_TIME).ToArray();
paramIns.AddParamInput(17, "strCYCLE_TIME", arrCYCLE_TIME, OracleDbType.Decimal);
var arrQTY_DAY = (from arr in insArr
select(object) arr.QTY_DAY).ToArray();
paramIns.AddParamInput(18, "strQTY_DAY", arrQTY_DAY, OracleDbType.Int32);
var arrTOTAL_MAT_USE_KG = (from arr in insArr
select(object) arr.TOTAL_MAT_USE_KG).ToArray();
paramIns.AddParamInput(19, "strTOTAL_MAT_USE_KG", arrTOTAL_MAT_USE_KG, OracleDbType.Decimal);
var arrTPCT_LOSS = (from arr in insArr
select(object) arr.TPCT_LOSS).ToArray();
paramIns.AddParamInput(20, "strTPCT_LOSS", arrTPCT_LOSS, OracleDbType.Decimal);
var arrQTY_PLAN = (from arr in insArr
select(object) arr.QTY_PLAN).ToArray();
paramIns.AddParamInput(21, "strQTY_PLAN", arrQTY_PLAN, OracleDbType.Int32);
var arrPLAN_MAT_AVG_DAY_KG = (from arr in insArr
select(object) arr.PLAN_MAT_AVG_DAY_KG).ToArray();
paramIns.AddParamInput(22, "strPLAN_MAT_AVG_DAY_KG", arrPLAN_MAT_AVG_DAY_KG, OracleDbType.Decimal);
var arrMAT_DRY = (from arr in insArr
select(object) arr.MAT_DRY).ToArray();
paramIns.AddParamInput(23, "strMAT_DRY", arrMAT_DRY, OracleDbType.Decimal);
var arrTARGET_DAY = (from arr in insArr
select(object) arr.TARGET_DAY).ToArray();
paramIns.AddParamInput(24, "strTARGET_DAY", arrTARGET_DAY, OracleDbType.Int32);
var arrPDTL_REMARK = (from arr in insArr
select arr.PDTL_REMARK).ToArray();
paramIns.AddParamInput(25, "strPDTL_REMARK", arrPDTL_REMARK, OracleDbType.Varchar2);
var arrPARTY_ID = (from arr in insArr
select arr.PARTY_ID).ToArray();
paramIns.AddParamInput(26, "strPARTY_ID", arrPARTY_ID, OracleDbType.Varchar2);
var arrPROD_LOT = (from arr in insArr
select arr.PROD_LOT).ToArray();
paramIns.AddParamInput(27, "strPROD_LOT", arrPROD_LOT, OracleDbType.Varchar2);
paramIns.AddParamInput(28, "strN_USER_ID", ArrayOf <object> .Create(insArr.Count(), userid), OracleDbType.Varchar2);
var arrPROD_SEQ_NO = (from arr in insArr
select arr.PROD_SEQ_NO).ToArray();
paramIns.AddParamInput(29, "strPROD_SEQ_NO", arrPROD_SEQ_NO, OracleDbType.Varchar2);
var arrCHANGE_MOLD = (from arr in insArr
select(arr.CHANGE_MOLD ? "Y" : "N")).ToArray();
paramIns.AddParamInput(30, "strCHANGE_MOLD", arrCHANGE_MOLD, OracleDbType.Varchar2);
var arrCONTINUE_ORDER = (from arr in insArr
select(arr.CONTINUE_ORDER ? "Y" : "N")).ToArray();
paramIns.AddParamInput(31, "strCONTINUE_ORDER", arrCONTINUE_ORDER, OracleDbType.Varchar2);
var arrREVISED_PLAN = (from arr in insArr
select(arr.REVISED_PLAN ? "Y" : "N")).ToArray();
paramIns.AddParamInput(32, "strREVISED_PLAN", arrREVISED_PLAN, OracleDbType.Varchar2);
//RESULTMSG
paramIns.AddParamOutput(33, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK", insArr.Count());
}
#endregion
#region Arrival Update #Flag=3
var updArr = from arr in lstArrDtl
where arr.FLAG == 3
select arr;
ProcParam paramUpd = null;
if (updArr.Any() && updArr.Count() > 0)
{
paramUpd = new ProcParam(34)
{
ProcedureName = "UPLOAD_PLAN.UPLOAD_PLAN_DTL_UPDATE"
};
var arrPLAN_DTL_ID = (from arr in updArr
select(object) arr.PLAN_DTL_ID).ToArray();
paramUpd.AddParamInput(0, "strPLAN_DTL_ID", arrPLAN_DTL_ID, OracleDbType.Int32);
var arrMC_SIZE_TON = (from arr in updArr
select arr.MC_SIZE_TON).ToArray();
paramUpd.AddParamInput(1, "strMC_SIZE_TON", arrMC_SIZE_TON, OracleDbType.Varchar2);
var arrPDTL_BLOCK = (from arr in updArr
select arr.PDTL_BLOCK).ToArray();
paramUpd.AddParamInput(2, "strPDTL_BLOCK", arrPDTL_BLOCK, OracleDbType.Varchar2);
var arrMC_NO = (from arr in updArr
select arr.MC_NO).ToArray();
paramUpd.AddParamInput(3, "strMC_NO", arrMC_NO, OracleDbType.Varchar2);
var arrPDTL_SEQUENCE = (from arr in updArr
select arr.PDTL_SEQUENCE).ToArray();
paramUpd.AddParamInput(4, "strPDTL_SEQUENCE", arrPDTL_SEQUENCE, OracleDbType.Varchar2);
var arrPRODUCT_NO = (from arr in updArr
select arr.PRODUCT_NO).ToArray();
paramUpd.AddParamInput(5, "strPRODUCT_NO", arrPRODUCT_NO, OracleDbType.Varchar2);
var arrPARTNAME = (from arr in updArr
select arr.PARTNAME).ToArray();
paramUpd.AddParamInput(6, "strPARTNAME", arrPARTNAME, OracleDbType.Varchar2);
var arrMAT_TYPE = (from arr in updArr
select arr.MAT_TYPE).ToArray();
paramUpd.AddParamInput(7, "strMAT_TYPE", arrMAT_TYPE, OracleDbType.Varchar2);
var arrINSERT_1 = (from arr in updArr
select arr.INSERT_1).ToArray();
paramUpd.AddParamInput(8, "strINSERT_1", arrINSERT_1, OracleDbType.Varchar2);
var arrINSERT_2 = (from arr in updArr
select arr.INSERT_2).ToArray();
paramUpd.AddParamInput(9, "strINSERT_2", arrINSERT_2, OracleDbType.Varchar2);
var arrINSERT_3 = (from arr in updArr
select arr.INSERT_3).ToArray();
paramUpd.AddParamInput(10, "strINSERT_3", arrINSERT_3, OracleDbType.Varchar2);
var arrCAV_ACT = (from arr in updArr
select(object) arr.CAV_ACT).ToArray();
paramUpd.AddParamInput(11, "strCAV_ACT", arrCAV_ACT, OracleDbType.Int32);
var arrCAV_FULL = (from arr in updArr
select(object) arr.CAV_FULL).ToArray();
paramUpd.AddParamInput(12, "strCAV_FULL", arrCAV_FULL, OracleDbType.Int32);
var arrMP_START = (from arr in updArr
select(object) arr.MP_START).ToArray();
paramUpd.AddParamInput(13, "strMP_START", arrMP_START, OracleDbType.Date);
var arrMP_FINISH = (from arr in updArr
select(object) arr.MP_FINISH).ToArray();
paramUpd.AddParamInput(14, "strMP_FINISH", arrMP_FINISH, OracleDbType.Date);
var arrPLAN_MP_DAY = (from arr in updArr
select(object) arr.PLAN_MP_DAY).ToArray();
paramUpd.AddParamInput(15, "strPLAN_MP_DAY", arrPLAN_MP_DAY, OracleDbType.Decimal);
var arrPRO_SHOT_WEIGHT = (from arr in updArr
select(object) arr.PRO_SHOT_WEIGHT).ToArray();
paramUpd.AddParamInput(16, "strPRO_SHOT_WEIGHT", arrPRO_SHOT_WEIGHT, OracleDbType.Decimal);
var arrCYCLE_TIME = (from arr in updArr
select(object) arr.CYCLE_TIME).ToArray();
paramUpd.AddParamInput(17, "strCYCLE_TIME", arrCYCLE_TIME, OracleDbType.Decimal);
var arrQTY_DAY = (from arr in updArr
select(object) arr.QTY_DAY).ToArray();
paramUpd.AddParamInput(18, "strQTY_DAY", arrQTY_DAY, OracleDbType.Int32);
var arrTOTAL_MAT_USE_KG = (from arr in updArr
select(object) arr.TOTAL_MAT_USE_KG).ToArray();
paramUpd.AddParamInput(19, "strTOTAL_MAT_USE_KG", arrTOTAL_MAT_USE_KG, OracleDbType.Decimal);
var arrTPCT_LOSS = (from arr in updArr
select(object) arr.TPCT_LOSS).ToArray();
paramUpd.AddParamInput(20, "strTPCT_LOSS", arrTPCT_LOSS, OracleDbType.Decimal);
var arrQTY_PLAN = (from arr in updArr
select(object) arr.QTY_PLAN).ToArray();
paramUpd.AddParamInput(21, "strQTY_PLAN", arrQTY_PLAN, OracleDbType.Int32);
var arrPLAN_MAT_AVG_DAY_KG = (from arr in updArr
select(object) arr.PLAN_MAT_AVG_DAY_KG).ToArray();
paramUpd.AddParamInput(22, "strPLAN_MAT_AVG_DAY_KG", arrPLAN_MAT_AVG_DAY_KG, OracleDbType.Decimal);
var arrMAT_DRY = (from arr in updArr
select(object) arr.MAT_DRY).ToArray();
paramUpd.AddParamInput(23, "strMAT_DRY", arrMAT_DRY, OracleDbType.Decimal);
var arrTARGET_DAY = (from arr in updArr
select(object) arr.TARGET_DAY).ToArray();
paramUpd.AddParamInput(24, "strTARGET_DAY", arrTARGET_DAY, OracleDbType.Int32);
var arrPDTL_REMARK = (from arr in updArr
select arr.PDTL_REMARK).ToArray();
paramUpd.AddParamInput(25, "strPDTL_REMARK", arrPDTL_REMARK, OracleDbType.Varchar2);
var arrPARTY_ID = (from arr in updArr
select arr.PARTY_ID).ToArray();
paramUpd.AddParamInput(26, "strPARTY_ID", arrPARTY_ID, OracleDbType.Varchar2);
var arrPROD_LOT = (from arr in updArr
select arr.PROD_LOT).ToArray();
paramUpd.AddParamInput(27, "strPROD_LOT", arrPROD_LOT, OracleDbType.Varchar2);
paramUpd.AddParamInput(28, "strU_USER_ID", ArrayOf <object> .Create(updArr.Count(), userid), OracleDbType.Varchar2);
var arrPROD_SEQ_NO = (from arr in updArr
select arr.PROD_SEQ_NO).ToArray();
paramUpd.AddParamInput(29, "strPROD_SEQ_NO", arrPROD_SEQ_NO, OracleDbType.Varchar2);
var arrCHANGE_MOLD = (from arr in updArr
select(arr.CHANGE_MOLD ? "Y" : "N")).ToArray();
paramUpd.AddParamInput(30, "strCHANGE_MOLD", arrCHANGE_MOLD, OracleDbType.Varchar2);
var arrCONTINUE_ORDER = (from arr in updArr
select(arr.CONTINUE_ORDER ? "Y" : "N")).ToArray();
paramUpd.AddParamInput(31, "strCONTINUE_ORDER", arrCONTINUE_ORDER, OracleDbType.Varchar2);
var arrREVISED_PLAN = (from arr in updArr
select(arr.REVISED_PLAN ? "Y" : "N")).ToArray();
paramUpd.AddParamInput(32, "strREVISED_PLAN", arrREVISED_PLAN, OracleDbType.Varchar2);
//RESULTMSG
paramUpd.AddParamOutput(33, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK", updArr.Count());
}
#endregion
#endregion
GlobalDB.Instance.DataAc.ExecuteNonQuery(paramDel, delArr.Count(), paramIns, insArr.Count(), paramUpd, updArr.Count());
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
resultMsg = "OK";
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public string UploadProductMaster(DataTable dt, string prodType, string userid)
{
try
{
ProcParam param = new ProcParam(14)
{
ProcedureName = "MASTER_PACK.UPLOAD_PRODUCT_MASTER"
};
var arrPRODUCT_CODE = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Item ID")).ToArray();
param.AddParamInput(0, "strPRODUCT_CODE", arrPRODUCT_CODE, OracleDbType.Varchar2);
var arrPRODUCT_NAME = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Item Description")).ToArray();
param.AddParamInput(1, "strPRODUCT_NAME", arrPRODUCT_NAME, OracleDbType.Varchar2);
var arrPRODUCT_NAME_REF = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Description for Sales")).ToArray();
param.AddParamInput(2, "strPRODUCT_NAME_REF", arrPRODUCT_NAME_REF, OracleDbType.Varchar2);
var arrPRICE1 = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Sales Price 1")).ToArray();
param.AddParamInput(3, "strPRICE1", arrPRICE1, OracleDbType.Decimal);
var arrPRICE2 = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Sales Price 2")).ToArray();
param.AddParamInput(4, "strPRICE2", arrPRICE2, OracleDbType.Decimal);
var arrPRICE3 = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Sales Price 3")).ToArray();
param.AddParamInput(5, "strPRICE3", arrPRICE3, OracleDbType.Decimal);
var arrPRICE4 = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Sales Price 4")).ToArray();
param.AddParamInput(6, "strPRICE4", arrPRICE4, OracleDbType.Decimal);
var arrPRICE5 = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Sales Price 5")).ToArray();
param.AddParamInput(7, "strPRICE5", arrPRICE5, OracleDbType.Decimal);
var arrSALE_ACC_NO = dt.AsEnumerable().ToList().Select(r => r.Field <string>("G/L Sales Account")).ToArray();
param.AddParamInput(8, "strSALE_ACC_NO", arrSALE_ACC_NO, OracleDbType.Varchar2);
var arrCOS_ACC_NO = dt.AsEnumerable().ToList().Select(r => r.Field <string>("G/L COGS/Salary Acct")).ToArray();
param.AddParamInput(9, "strCOS_ACC_NO", arrCOS_ACC_NO, OracleDbType.Varchar2);
var arrCURRENT_REV_NO = dt.AsEnumerable().ToList().Select(r => r.Field <string>("Revision Number")).ToArray();
param.AddParamInput(10, "strCURRENT_REV_NO", arrCURRENT_REV_NO, OracleDbType.Varchar2);
param.AddParamInput(11, "strUSER_ID", ArrayOf <object> .Create(dt.Rows.Count, userid), OracleDbType.Varchar2);
param.AddParamInput(12, "strPROD_TYPE", ArrayOf <object> .Create(dt.Rows.Count, prodType), OracleDbType.Varchar2);
param.AddParamOutput(13, "RESULTMSG", OracleDbType.Varchar2, 255, "OK", dt.Rows.Count);
GlobalDB.Instance.DataAc.ExecuteNonQuery(param, dt.Rows.Count);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
else
{
if (((Oracle.DataAccess.Types.OracleString[])(param.ReturnValue(13)))[0].Value == "OK")
{
return("OK");
}
else
{
return("Error");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet PrintMachineReport(List <Machine> lstMachine)
{
//declare dataset and name.
DataSet dtsResult = new DataSet("DTS_MACHINE");
int seqPrint = 0;
try
{
seqPrint = PrintingBuilder.Instance.GeneratePrintSEQ();
ProcParam paramPrint = new ProcParam(4)
{
ProcedureName = "GLOBAL_FUNCTION_PACK.T_PRINT_TRANSACTION_INS"
};
//param 0 - SEQ_NO
paramPrint.AddParamInput(0, "strSEQ_NO", ArrayOf <object> .Create(lstMachine.Count, seqPrint), OracleDbType.Varchar2);
//param 1 - strTR1
var arrMC_NO = (from job in lstMachine
select job.MC_NO).ToArray();
paramPrint.AddParamInput(1, "strTR1", arrMC_NO, OracleDbType.Varchar2);
//param 2 - strTR2
paramPrint.AddParamInput(2, "strTR2", ArrayOf <object> .Create(lstMachine.Count, null), OracleDbType.Varchar2);
//param 3 - strTR3
paramPrint.AddParamInput(3, "strTR3", ArrayOf <object> .Create(lstMachine.Count, null), OracleDbType.Varchar2);
//insert value to print transaction.
PrintingBuilder.Instance.InsertTransactionPrint(paramPrint, lstMachine.Count);
//List<ProcParam> procInsTPrintList = new List<ProcParam>();
//ProcParam procInsTPrint = null;
//foreach (Machine mc in lstMachine)
//{
// procInsTPrint = new ProcParam(4);
// procInsTPrint.ProcedureName = "GLOBAL_FUNCTION_PACK.T_PRINT_TRANSACTION_INS";
// procInsTPrint.AddParamInput(0, "strSEQ_NO", seqPrint);
// procInsTPrint.AddParamInput(1, "strTR1", mc.MC_NO);
// procInsTPrint.AddParamInput(2, "strTR2", DBNull.Value);
// procInsTPrint.AddParamInput(3, "strTR3", DBNull.Value);
// procInsTPrintList.Add(procInsTPrint);
//}
////insert value to print transaction.
//PrintingBuilder.Instance.InsertTransactionPrint(procInsTPrintList);
DataTable dtDetail = this.GetPrintMachineOrder(seqPrint, "M_MACHINE");
dtsResult.Tables.Add(dtDetail);
PrintingBuilder.Instance.RemovePrintSEQ(seqPrint);
dtsResult.AcceptChanges();
}
catch (Exception ex)
{
dtsResult = null;
throw ex;
}
return(dtsResult);
}
public DataSet PrintDeliverySlipReport(List <LoadingOrder> lstLoadingOrd)
{
//declare dataset and name.
DataSet dtsResult = new DataSet("DTS_DELIVERY_SLIP");
int seqPrint = 0;
try
{
seqPrint = PrintingBuilder.Instance.GeneratePrintSEQ();
ProcParam paramPrint = new ProcParam(4)
{
ProcedureName = "GLOBAL_FUNCTION_PACK.T_PRINT_TRANSACTION_INS"
};
//param 0 - SEQ_NO
paramPrint.AddParamInput(0, "strSEQ_NO", ArrayOf <object> .Create(lstLoadingOrd.Count, seqPrint), OracleDbType.Varchar2);
//param 1 - strTR1
var arrLOADING_NO = (from job in lstLoadingOrd
select job.LOADING_NO).ToArray();
paramPrint.AddParamInput(1, "strTR1", arrLOADING_NO, OracleDbType.Varchar2);
//param 2 - strTR2
paramPrint.AddParamInput(2, "strTR2", ArrayOf <object> .Create(lstLoadingOrd.Count, null), OracleDbType.Varchar2);
//param 3 - strTR3
paramPrint.AddParamInput(3, "strTR3", ArrayOf <object> .Create(lstLoadingOrd.Count, null), OracleDbType.Varchar2);
//insert value to print transaction.
PrintingBuilder.Instance.InsertTransactionPrint(paramPrint, lstLoadingOrd.Count);
//List<ProcParam> procInsTPrintList = new List<ProcParam>();
//ProcParam procInsTPrint = null;
//foreach (LoadingOrder loadingOrd in lstLoadingOrd)
//{
// procInsTPrint = new ProcParam(4);
// procInsTPrint.ProcedureName = "GLOBAL_FUNCTION_PACK.T_PRINT_TRANSACTION_INS";
// procInsTPrint.AddParamInput(0, "strSEQ_NO", seqPrint);
// procInsTPrint.AddParamInput(1, "strTR1", loadingOrd.LOADING_NO);
// procInsTPrint.AddParamInput(2, "strTR2", DBNull.Value);
// procInsTPrint.AddParamInput(3, "strTR3", DBNull.Value);
// procInsTPrintList.Add(procInsTPrint);
//}
////insert value to print transaction.
//PrintingBuilder.Instance.InsertTransactionPrint(procInsTPrintList);
//get print value header
DataTable dtHeader = PrintingBuilder.Instance.PrintTableResult("LOADING_PACK.RPT_DELIVERY_HDR",
seqPrint,
"T_LOADING_HDR");
dtsResult.Tables.Add(dtHeader);
//------------------------------------------------------------------------------------------
//get print value detail
DataTable dtDetail = PrintingBuilder.Instance.PrintTableResult("LOADING_PACK.RPT_DELIVERY_DTL",
seqPrint,
"T_LOADING_DTL");
dtsResult.Tables.Add(dtDetail);
//------------------------------------------------------------------------------------------
dtsResult.Relations.Add("T_LOADING_HDR_T_LOADING_DTL",
dtsResult.Tables["T_LOADING_HDR"].Columns["LOADING_NO"],
dtsResult.Tables["T_LOADING_DTL"].Columns["LOADING_NO"]);
PrintingBuilder.Instance.RemovePrintSEQ(seqPrint);
dtsResult.AcceptChanges();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(dtsResult);
}
public string UpdatePartyProduct(DataTable dtbPartyProduct, string userid)
{
string resultMsg = string.Empty;
try
{
#region Transaction Detail Delete
DataRow[] deleteRows = dtbPartyProduct.Select("[FLAG] = 0");
ProcParam paramDel = null;
if (deleteRows.Length > 0)
{
paramDel = new ProcParam(4)
{
ProcedureName = "MASTER_PACK.PARTY_PRODUCT_DEL"
};
//PARTY_ID
var arrPARTY_ID = (from DataRow row in deleteRows
select row["PARTY_ID"]).ToArray();
paramDel.AddParamInput(0, "strPARTY_ID", arrPARTY_ID, OracleDbType.Varchar2);
//PROD_SEQ_NO
var arrPROD_SEQ_NO = (from DataRow row in deleteRows
select row["PROD_SEQ_NO"]).ToArray();
paramDel.AddParamInput(1, "strPROD_SEQ_NO", arrPROD_SEQ_NO, OracleDbType.Varchar2);
//USER_ID
paramDel.AddParamInput(2, "strUSER_ID", ArrayOf <object> .Create(deleteRows.Length, userid), OracleDbType.Varchar2);
//RESULTMSG
paramDel.AddParamOutput(3, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK", deleteRows.Length);
}
#endregion
#region Transaction Detail Insert
DataRow[] insertRows = dtbPartyProduct.Select("[FLAG] = 2");
ProcParam paramIns = null;
if (insertRows.Length > 0)
{
paramIns = new ProcParam(4)
{
ProcedureName = "MASTER_PACK.PARTY_PRODUCT_INS"
};
//PARTY_ID
var arrPARTY_ID = (from DataRow row in insertRows
select row["PARTY_ID"]).ToArray();
paramIns.AddParamInput(0, "strPARTY_ID", arrPARTY_ID, OracleDbType.Varchar2);
//PROD_SEQ_NO
var arrPROD_SEQ_NO = (from DataRow row in insertRows
select row["PROD_SEQ_NO"]).ToArray();
paramIns.AddParamInput(1, "strPROD_SEQ_NO", arrPROD_SEQ_NO, OracleDbType.Varchar2);
//USER_ID
paramIns.AddParamInput(2, "strUSER_ID", ArrayOf <object> .Create(insertRows.Length, userid), OracleDbType.Varchar2);
//RESULTMSG
paramIns.AddParamOutput(3, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK", insertRows.Length);
}
#endregion
GlobalDB.Instance.DataAc.ExecuteNonQuery(paramDel, deleteRows.Length, paramIns, insertRows.Length, null, -1);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
resultMsg = "OK";
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public string InsertMaterialSP(DataTable dt, string userid)
{
string resultMsg = string.Empty;
try
{
string productNo = dt.Rows[0][0].ToString().Trim();
IEnumerable <string> productList = dt.AsEnumerable().ToList().Select(r => r.Field <string>("PRODUCT_NO")).Distinct();
foreach (string product in productList)
{
DataRow[] dr = dt.Select("PRODUCT_NO = '" + product + "'");
ProcParam paramDel = new ProcParam(2)
{
ProcedureName = "MASTER_PACK.DEL_M_MATERIAL_SP"
};
paramDel.AddParamInput(0, "strPRODUCT_NO", product);
paramDel.AddParamOutput(1, "RESULTMSG", OracleDbType.Varchar2, 255);
GlobalDB.Instance.DataAc.ExecuteNonQuery(paramDel);
ProcParam paramHdr = new ProcParam(1)
{
ProcedureName = "MASTER_PACK.GET_MAT_SP_GROUP_NO"
};
paramHdr.AddParamOutput(0, "strMAT_SP_GROUP_NO", Oracle.DataAccess.Client.OracleDbType.NVarchar2, 255);
ProcParam paramDtl = new ProcParam(5)
{
ProcedureName = "MASTER_PACK.MATERIAL_SP_INS"
};
paramDtl.AddParamInput(0, "strMAT_SP_GROUP_NO", ArrayOf <object> .Create(dt.Rows.Count, String.Empty), OracleDbType.NVarchar2);
var arrProductNo = dr.Select(r => r.Field <string>("PRODUCT_NO")).ToArray();
paramDtl.AddParamInput(1, "strPRODUCT_NO", arrProductNo, OracleDbType.Varchar2);
var arrMatNo = dr.Select(r => r.Field <string>("MATERIAL_CODE")).ToArray();
paramDtl.AddParamInput(2, "strMATERIAL_NO", arrMatNo, OracleDbType.Varchar2);
paramDtl.AddParamInput(3, "strUSER", ArrayOf <object> .Create(dr.Count(), userid), OracleDbType.NVarchar2);
paramDtl.AddParamOutput(4, "RESULTMSG", OracleDbType.Varchar2, 255, "OK", dr.Count());
GlobalDB.Instance.DataAc.ExecuteNonQuery(paramHdr, paramDtl, dr.Count(), 0, 0);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
else
{
OracleString lastArrivalNo = (OracleString)paramHdr.ReturnValue(0);
if (((Oracle.DataAccess.Types.OracleString[])(paramDtl.ReturnValue(4)))[0].Value == "OK")
{
resultMsg = "OK";
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
