public string UpdateRole(Role role, string userid)
{
string result = string.Empty;
try
{
ProcParam param = new ProcParam(5);
param.ProcedureName = "ADMINISTRATOR_PACK.ROLE_UPD";
param.AddParamInput(0, "strROLE_ID", role.ROLE_ID);
param.AddParamInput(1, "strROLE_NAME", role.ROLE_NAME);
param.AddParamInput(2, "strREC_STAT", (role.REC_STAT ? "Y" : "N"));
param.AddParamInput(3, "strUSER_ID", userid);
param.AddParamOutput(4, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK");
GlobalDB.Instance.DataAc.ExecuteNonQuery(param);
////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString resultDB = (OracleString)param.ReturnValue(4);
if (!resultDB.IsNull)
{
result = resultDB.Value;
}
else
{
throw GlobalDB.Instance.DataAc.LastException;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public List <JobLot> GetJobLotList(string jobNo, string userid)
{
List <JobLot> lstJobLot = null;
JobLot jobLot;
try
{
ProcParam procPara = new ProcParam(3);
procPara.ProcedureName = "SCANNER_PACK.GET_JOB_LOT_LIST";
procPara.AddParamRefCursor(0, "io_cursor");
procPara.AddParamInput(1, "strJobNo", jobNo);
procPara.AddParamInput(2, "strUserID", userid);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstJobLot = new List <JobLot>();
while (OraDataReader.Instance.OraReader.Read())
{
jobLot = new JobLot();
jobLot.JOB_LOT = OraDataReader.Instance.GetString("JOB_LOT");
lstJobLot.Add(jobLot);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
throw ex;
}
return(lstJobLot);
}
public string Press_UpdateReplenishConfirm(string serialNo, string mode, int qty, string userid)
{
string resultMsg = string.Empty;
try
{
ProcParam procPara = new ProcParam(5)
{
ProcedureName = "SCANNER_PACK_PRESS.UPD_QC_NG_CONF"
};
procPara.AddParamInput(0, "strSERIAL_NO", serialNo);
procPara.AddParamInput(1, "strMODE", mode);
procPara.AddParamInput(2, "strQTY", qty);
procPara.AddParamInput(3, "strUserID", userid);
procPara.AddParamOutput(4, "RESULTMSG", OracleDbType.Varchar2, 255);
GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString result = (OracleString)procPara.ReturnValue(4);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public string Assembly_UpdateNGQty(string jobNo, int lineNo, int nQty, string userid)
{
string resultMsg = string.Empty;
try
{
ProcParam procPara = new ProcParam(5)
{
ProcedureName = "SCANNER_PACK_ASY.UPD_JOB_LOT_NG_QTY"
};
procPara.AddParamInput(0, "strJOB_NO", jobNo);
procPara.AddParamInput(1, "strLINE_NO", lineNo);
procPara.AddParamInput(2, "strQTY", nQty);
procPara.AddParamInput(3, "strUSER_ID", userid);
procPara.AddParamOutput(4, "RESULTMSG", OracleDbType.Varchar2, 255);
GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString result = (OracleString)procPara.ReturnValue(4);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public string Assembly_CheckValidationUser(string userid)
{
string result = string.Empty;
try
{
ProcParam procPara = new ProcParam(2)
{
ProcedureName = "SCANNER_PACK_ASY.USER_VALIDATION"
};
procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Raw, 255);
procPara.AddParamInput(1, "strUSER_ID", userid);
GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara);
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
//OracleString objResult = (OracleString)procPara.ReturnValue(0);
OracleBinary objResult = (OracleBinary)procPara.ReturnValue(0);
if (!objResult.IsNull)
{
result = UtilityBLL.GetReturnRawData(objResult);
}
else
{
result = string.Empty;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public string UpdateStatusPlanHDR(string planNo, string status, string userId)
{
string resultMsg = string.Empty;
try
{
ProcParam param = new ProcParam(4)
{
ProcedureName = "UPLOAD_PLAN.UPDATE_ULPLAN_STATUS"
};
param.AddParamInput(0, "strPLAN_NO", planNo);
param.AddParamInput(1, "strREC_STAT", status);
param.AddParamInput(2, "strU_USER_ID", userId);
param.AddParamOutput(3, "RESULTMSG", OracleDbType.Varchar2, 255);
GlobalDB.Instance.DataAc.ExecuteNonQuery(param);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
OracleString result = (OracleString)param.ReturnValue(3);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public string UpdProductCard(string serialNo, string mcNo, string processMode, int nQty, string userid)
{
string resultMsg = string.Empty;
try
{
ProcParam procPara = new ProcParam(6);
procPara.ProcedureName = "SCANNER_PACK_VER.UPD_PC_INFO_PROCESS";
procPara.AddParamInput(0, "strSERIAL_NO", serialNo);
procPara.AddParamInput(1, "strPROCESS", processMode);
procPara.AddParamInput(2, "strMC_NO", mcNo);
procPara.AddParamInput(3, "strQty", nQty);
procPara.AddParamOutput(4, "resultmsg", OracleDbType.Varchar2, 255);
procPara.AddParamInput(5, "strUser_id", userid);
GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString result = (OracleString)procPara.ReturnValue(4);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
/// <summary>
/// Update Machine
/// </summary>
/// <param name="mc">Machine Entity</param>
/// <returns>Result Message</returns>
public string UpdateMachine(Machine mc, string userid)
{
string resultMsg = string.Empty;
try
{
ProcParam param = new ProcParam(8);
param.ProcedureName = "MASTER_PACK.M_MACHINE_UPD";
param.AddParamInput(0, "strMC_NO", mc.MC_NO);
param.AddParamInput(1, "strMACHINE_NAME", mc.MACHINE_NAME);
param.AddParamInput(2, "strMACHINE_TYPE", mc.MACHINE_TYPE);
param.AddParamInput(3, "strMACHINE_SIZE", mc.MACHINE_SIZE);
param.AddParamInput(4, "strREMARK", mc.REMARK);
param.AddParamInput(5, "strREC_STAT", (mc.REC_STAT ? "Y" : "N"));
param.AddParamInput(6, "strUSER_ID", userid);
param.AddParamOutput(7, "RESULTMSG", OracleDbType.Varchar2, 255);
GlobalDB.Instance.DataAc.ExecuteNonQuery(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString result = (OracleString)param.ReturnValue(7);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public string CheckValidationUser(string userid, string ipaddress, string serialno, string scanversion)
{
string result = string.Empty;
try
{
ProcParam procPara = new ProcParam(2)
{
ProcedureName = "SCANNER_MAT_CHK_PACK.USER_VALIDATION"
};
procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Raw, 255);
procPara.AddParamInput(1, "strUSER_ID", userid);
GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara);
if (GlobalDB.Instance.DataAc.LastException != null)
{
throw GlobalDB.Instance.DataAc.LastException;
}
OracleBinary objResult = (OracleBinary)procPara.ReturnValue(0);
if (!objResult.IsNull)
{
result = UtilityBLL.GetReturnRawData(objResult);
}
else
{
result = string.Empty;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
private Bitmap ProductImage(string proSeqNo)
{
Bitmap result = null;
try
{
ProcParam param = new ProcParam(2)
{
ProcedureName = "INFO.MATERIAL_IMAGE"
};
param.AddParamReturn(0, "ReturnValue", OracleDbType.Blob, 255);
param.AddParamInput(1, "strNo", proSeqNo);
GlobalDB.Instance.DataAc.ExecuteNonQuery(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleBlob blobDB = (OracleBlob)param.ReturnValue(0);
if (!blobDB.IsNull)
{
using (MemoryStream ms = new MemoryStream(blobDB.Value))
{
result = (Bitmap)Bitmap.FromStream(ms);
}
return(result);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable GetProductList(string partyid)
{
DataTable dtbResult;
try
{
ProcParam param = new ProcParam(2)
{
ProcedureName = "MASTER_PACK.GET_PRATY_PRODUCT_LIST"
};
param.AddParamRefCursor(0, "IO_CURSOR");
param.AddParamInput(1, "strPARTY_ID", partyid);
dtbResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
}
catch (Exception ex)
{
dtbResult = null;
}
return(dtbResult);
}
public DataTable Doc_SalesOrder_List()
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(1)
{
ProcedureName = "QUERY_PACK.DOC_SO_INFO"
};
param.AddParamRefCursor(0, "IO_CURSOR");
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable GetPrintTime(int seq)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(2)
{
ProcedureName = "MTL_IN_PACK.GET_PRINTED_CARD"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strSEQ_NO", seq);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable PostSalesInvoiceInterface(string soNo, string userid, out string seqno)
{
seqno = string.Empty;
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(4)
{
ProcedureName = "INTERFACE_PACK.POST_SALES_INVOICE_SAGE50"
};
param.AddParamRefCursor(0, "IO_CURSOR");
param.AddParamOutput(1, "strSEQ_NO", OracleDbType.Varchar2, 30);
param.AddParamInput(2, "strSO_NO", soNo);
param.AddParamInput(3, "strUSER_ID", userid);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
OracleString resultDB = (OracleString)param.ReturnValue(1);
if (!resultDB.IsNull)
{
seqno = resultDB.Value;
}
else
{
seqno = string.Empty;
}
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public string GenerateJob(string planNo, string userId)
{
string resultMsg = string.Empty;
try
{
ProcParam param = new ProcParam(3)
{
ProcedureName = "UPLOAD_PLAN.GENERATE_JOB"
};
param.AddParamInput(0, "strPLAN_NO", planNo);
param.AddParamInput(1, "strUSER_ID", userId);
param.AddParamOutput(2, "RESULTMSG", OracleDbType.Varchar2, 255);
GlobalDB.Instance.DataAc.ExecuteNonQuery(param);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
OracleString result = (OracleString)param.ReturnValue(2);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public ResponseResult CheckJobOrder(string jobno)
{
response = new ResponseResult();
try
{
ProcParam procPara = new ProcParam(3)
{
ProcedureName = "SCANNER_MAT_CHK_PACK.CHK_JOB_ORDER"
};
procPara.AddParamReturn(0, "ReturnValue", OracleDbType.Varchar2, 30);
procPara.AddParamInput(1, "strJOB_NO", jobno);
procPara.AddParamOutput(2, "RESULTMSG", OracleDbType.Varchar2, 255);
GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara);
if (GlobalDB.Instance.DataAc.LastException != null)
{
throw GlobalDB.Instance.DataAc.LastException;
}
var returnValue = (OracleString)procPara.ReturnValue(0);
var resultMsg = (OracleString)procPara.ReturnValue(2);
response.Message = resultMsg.ToString();
response.Data = returnValue.ToString();
}
catch (Exception ex)
{
response.Status = false;
response.Message = ex.Message;
response.Data = string.Empty;
}
return(response);
}
public string UpdatePalletFinish(string palletno, string userid)
{
string resultMsg = string.Empty;
try
{
ProcParam procPara = new ProcParam(3)
{
ProcedureName = "SCANNER_PACK_FG.UPD_PALLET_FINISHED"
};
procPara.AddParamInput(0, "strPALLET_NO", palletno);
procPara.AddParamOutput(1, "RESULTMSG", OracleDbType.Varchar2, 255);
procPara.AddParamInput(2, "strUSER_ID", userid);
GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString result = (OracleString)procPara.ReturnValue(1);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public string UpdNGQty(string jobNo, string jobLot, int nQty, string userid)
{
string resultMsg = string.Empty;
try
{
ProcParam procPara = new ProcParam(5);
procPara.ProcedureName = "SCANNER_PACK.UPD_NG_QTY";
procPara.AddParamInput(0, "strJobNo", jobNo);
procPara.AddParamInput(1, "strJobLot", jobLot);
procPara.AddParamInput(2, "strQty", nQty);
procPara.AddParamInput(3, "strUserID", userid);
procPara.AddParamOutput(4, "RESULTMSG", OracleDbType.Varchar2, 120);
GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString result = (OracleString)procPara.ReturnValue(4);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public string FGPress_UpdateLoadingSeal(string loadNo, string userid)
{
string resultMsg = string.Empty;
try
{
ProcParam procPara = new ProcParam(3)
{
ProcedureName = "SCANNER_PACK_FG_PRESS.UPD_LOADING_SEAL"
};
procPara.AddParamInput(0, "strLOADING_NO", loadNo);
procPara.AddParamOutput(1, "resultmsg", OracleDbType.Varchar2, 255);
procPara.AddParamInput(2, "strUser_id", userid);
GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString result = (OracleString)procPara.ReturnValue(1);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public string DeleteTransferOrder(String tono, string userid)
{
string resultMsg = string.Empty;
try
{
#region "Transaction Header"
ProcParam paramHDR = new ProcParam(3);
paramHDR.ProcedureName = "TO_PACK.TO_HDR_DEL";
paramHDR.AddParamInput(0, "strTO_NO", tono);
paramHDR.AddParamInput(1, "strUSER_ID", userid);
paramHDR.AddParamOutput(2, "RESULTMSG", OracleDbType.Varchar2, 255);
#endregion
GlobalDB.Instance.DataAc.ExecuteNonQuery(paramHDR);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString result = (OracleString)paramHDR.ReturnValue(2);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public ResponseResult UpdateMixedQty(string serialno, string mixedno, decimal mixQty)
{
response = new ResponseResult();
try
{
ProcParam procPara = new ProcParam(4)
{
ProcedureName = "SCANNER_MAT_CHK_PACK.UPDATE_MIXED_QTY"
};
procPara.AddParamInput(0, "strMIXED_NO", mixedno);
procPara.AddParamInput(1, "strSERIAL_NO", serialno);
procPara.AddParamInput(2, "strMIXED_QTY", mixQty);
procPara.AddParamOutput(3, "RESULTMSG", OracleDbType.Varchar2, 255);
GlobalDB.Instance.DataAc.ExecuteNonQuery(procPara);
if (GlobalDB.Instance.DataAc.LastException != null)
{
throw GlobalDB.Instance.DataAc.LastException;
}
var resultMsg = (OracleString)procPara.ReturnValue(3);
response.Message = resultMsg.ToString();
response.Data = string.Empty;
}
catch (Exception ex)
{
response.Status = false;
response.Message = ex.Message;
response.Data = string.Empty;
}
return(response);
}
public DataTable GetCompletedTO(string tono, string userid)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(3)
{
ProcedureName = "TO_PACK.GET_TO_CSV"
};
param.AddParamRefCursor(0, "IO_CURSOR");
param.AddParamInput(1, "strTO_NO", tono);
param.AddParamInput(2, "strUSER_ID", userid);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public string UserChangePassword(string password, string userid)
{
string result = string.Empty;
try
{
ProcParam param = new ProcParam(3);
param.ProcedureName = "ADMINISTRATOR_PACK.USER_CHANGE_PASSWORD";
param.AddParamInput(0, "strUSER_ID", userid);
param.AddParamInput(1, "strNewPwd", password);
param.AddParamOutput(2, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK");
GlobalDB.Instance.DataAc.ExecuteNonQuery(param);
////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString resultDB = (OracleString)param.ReturnValue(2);
if (!resultDB.IsNull)
{
result = resultDB.Value;
}
else
{
throw GlobalDB.Instance.DataAc.LastException;
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public DataTable PrintTableResult(string procedureName, string printNo, string tableName)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(2);
param.ProcedureName = procedureName;
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strNo", printNo);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, tableName, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable StockAsOnDateDetail_Mtl(string mtl_code)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(2)
{
ProcedureName = "QUERY_PACK.STOCK_AS_ON_DATE_MTL_DTL"
};
param.AddParamRefCursor(0, "IO_CURSOR");
param.AddParamInput(1, "strMTL", mtl_code);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public string InsertMTLType(MaterialType mtlType, string userid)
{
string resultMsg = string.Empty;
try
{
ProcParam param = new ProcParam(6);
param.ProcedureName = "MASTER_PACK.M_MTL_TYPE_INS";
param.AddParamInput(0, "strSEQ_NO", mtlType.SEQ_NO);
param.AddParamInput(1, "strNAME", mtlType.NAME);
param.AddParamInput(2, "strREMARK", mtlType.REMARK);
param.AddParamInput(3, "strREC_STAT", (mtlType.REC_STAT ? "Y" : "N"));
param.AddParamInput(4, "strUSER_ID", userid);
param.AddParamOutput(5, "RESULTMSG", OracleDbType.Varchar2, 255);
GlobalDB.Instance.DataAc.ExecuteNonQuery(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString result = (OracleString)param.ReturnValue(5);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public DataTable JobTrackingDetail(string jobNo, string jobLot)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(3);
param.ProcedureName = "QUERY_PACK.JOB_TRACKING_DTL";
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strJOB_NO", jobNo);
param.AddParamInput(2, "strJOB_LOT", jobLot);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataTable StockAsOn(string whid, string product)
{
DataTable dtResult = null;
try
{
ProcParam param = new ProcParam(3);
param.ProcedureName = "QUERY_PACK.STOCK_AS_ON";
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strWH_ID", whid);
param.AddParamInput(2, "strPRODUCT", product);
dtResult = GlobalDB.Instance.DataAc.GetDataTable(param, 1000);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
}
catch (Exception ex)
{
dtResult = null;
throw ex;
}
return(dtResult);
}
public DataSet PrintProductCardReport(List <T_ARRIVAL_DTL> jobOrdNo, string prodSEQNo, List <MaterialCard> lstPrdCard, string userid, out int seqPrint)
{
//declare dataset and name.
string processSEQ = string.Empty;
//Bitmap imgProduct = null;
seqPrint = -1;
DataSet dtsResult = new DataSet("DTS_MATERIAL_CARD");
//int seqPrint = 0;
try
{
// processSEQ = this.ProductProcessSEQ(prodSEQNo);
//imgProduct = this.ProductImage(prodSEQNo);
seqPrint = PrintingBuilder.Instance.GeneratePrintSEQ();
List <ProcParam> procInsTPrintList = new List <ProcParam>();
ProcParam procInsTPrint = null;
foreach (MaterialCard 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);
}
//insert value to print transaction.
PrintingBuilder.Instance.InsertTransactionPrint(procInsTPrintList);
//get print value header
DataTable dtHeader = new DataTable("T_ARRIVAL");
dtHeader.Columns.Add(new DataColumn("ARRIVAL_NO"));
//dtHeader.Columns.Add(new DataColumn("PROD_IMAGE", typeof(System.Drawing.Bitmap)));
//dtHeader.Columns.Add(new DataColumn("PROCESS_SEQ"));
DataRow row = dtHeader.NewRow();
foreach (T_ARRIVAL_DTL labelOpt in jobOrdNo)
{
row["ARRIVAL_NO"] = labelOpt.ARRIVAL_NO;
}
//row["PROD_IMAGE"] = imgProduct;
//row["PROCESS_SEQ"] = processSEQ;
//dtHeader.Rows.Add(row);
dtHeader.Rows.Add(row);
dtHeader.AcceptChanges();
dtsResult.Tables.Add(dtHeader);
DataTable dtDetail = this.GetPrintMaterialCard(seqPrint, "T_MATERIAL_CARD");
//dtDetail.Columns.Add(new DataColumn("PROD_IMAGE", typeof(System.Drawing.Bitmap)));
//DataRow rowDT = dtDetail.NewRow();
//foreach ( MaterialCard labelOpt in lstPrdCard)
//{
// imgProduct = this.ProductImage(labelOpt.MTL_SEQ_NO);
// rowDT["PROD_IMAGE"] = imgProduct;
// //dtDetail.Rows.Add(rowDT);
//}
//foreach (DataRow dtRow in dtDetail.Rows)
//{
// imgProduct = this.ProductImage((string)dtRow["MTL_SEQ_NO"]);
// dtRow["PROD_IMAGE"] = imgProduct;
//}
dtsResult.Tables.Add(dtDetail);
//maping datatable to dataset
dtsResult.Relations.Add("T_ARRIVAL_T_MATERIAL_CARD",
dtsResult.Tables["T_ARRIVAL"].Columns["ARRIVAL_NO"],
dtsResult.Tables["T_MATERIAL_CARD"].Columns["ARRIVAL_NO"], false);
dtsResult.AcceptChanges();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(dtsResult);
}
public List <Material> GetMaterialList(string findAll, string mtl_seq_no, string supplier, string locId)
{
List <Material> lstMaterail = null;
Material material;
ProcParam param = null;
try
{
//if (findAll != string.Empty)
//{
param = new ProcParam(5)
{
ProcedureName = "LOV_PACK.GET_MATERIAL_LIST"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strFindAll", findAll);
param.AddParamInput(2, "strMTL_SEQ_NO", mtl_seq_no);
param.AddParamInput(3, "strPARTY_ID", supplier);
param.AddParamInput(4, "strLOCATION_ID", locId);
//}
//else
//{
// param = new ProcParam(1) { ProcedureName = "LOV_PACK.GET_MATERIAL_ALL_LIST" };
// param.AddParamRefCursor(0, "io_cursor");
//}
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstMaterail = new List <Material>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
material = new Material();
material.MTL_SEQ_NO = OraDataReader.Instance.GetString("MTL_SEQ_NO");
material.MTL_CODE = OraDataReader.Instance.GetString("MTL_CODE");
material.MTL_NAME = OraDataReader.Instance.GetString("MTL_NAME");
material.MTL_GRADE = OraDataReader.Instance.GetString("MTL_GRADE");
material.MTL_COLOR = OraDataReader.Instance.GetString("MTL_COLOR");
material.STD_QTY = OraDataReader.Instance.GetDecimal("STD_QTY");
material.UNIT = OraDataReader.Instance.GetString("UNIT");
//material.MTL_IMAGE = OraDataReader.Instance.GetBitmap("MTL_IMAGE");
//material.KANBAN = OraDataReader.Instance.GetLong("KANBAN");
// material.LOCATION_ID = OraDataReader.Instance.GetString("LOCATION_ID");
//material.BARCODE_SUPPLIER = OraDataReader.Instance.GetString("BARCODE_SUPPLIER");
//material.REMARK = OraDataReader.Instance.GetString("REMARK");
//material.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y");
lstMaterail.Add(material);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstMaterail = null;
throw ex;
}
return(lstMaterail);
}
