public void InsertStockTakingTemp(ImportStockTakingDTO dtoImportData)
{
Database db = m_db;
DataRequest req = new DataRequest();
req.CommandText = "S_STK060_InsertImportStockTaking";
req.Parameters.Add("@pInt_LINE_NO", DataType.Number, dtoImportData.LINE_NO.Value);
req.Parameters.Add("@pVar_FILENAME", DataType.NVarChar, dtoImportData.IMPORT_FILE_NAME.Value);
req.Parameters.Add("@pVar_PROCESS_CD", DataType.NVarChar, dtoImportData.PROCESS_CD.Value);
req.Parameters.Add("@pVar_ITEM_CD", DataType.Number, dtoImportData.ITEM_CD.Value);
req.Parameters.Add("@pVar_WEIGHT", DataType.NVarChar, dtoImportData.WEIGHT.Value);
req.Parameters.Add("@pVar_QTY", DataType.NVarChar, dtoImportData.QTY.Value);
req.Parameters.Add("@pVar_TAG_NO", DataType.NVarChar, dtoImportData.TAG_NO.Value);
req.Parameters.Add("@pVar_REMARK", DataType.NVarChar, dtoImportData.REMARK.Value);
req.Parameters.Add("@pVar_CREATE_BY", DataType.NVarChar, dtoImportData.CREATE_BY.Value);
req.Parameters.Add("@pVar_CREATE_MACHINE", DataType.NVarChar, dtoImportData.CREATE_MACHINE.Value);
req.CommandType = System.Data.CommandType.StoredProcedure;
db.ExecuteNonQuery(req);
}
private void btnImport_Click(object sender, EventArgs e)
{
try
{
if (string.Empty.Equals(txtLastPreProcessBy.Text))
{
MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0086.ToString()));
return;
}
MessageDialogResult dialog = MessageDialog.ShowConfirmation(this, Message.LoadMessage(TKPMessages.eConfirm.CFM0005.ToString()));
if (dialog == MessageDialogResult.Cancel || dialog == MessageDialogResult.No)
{
return;
}
string strFilePath = txtFileName.Text.Trim();
//Check found data in file
DataTable dt = ImportUtil.ImportExcel(strFilePath, CONST_B_DATA_INCLUDE_HEADER, 0);
if (dt == null || dt.Rows.Count == 0)
{
ErrorItem error = new ErrorItem(null, TKPMessages.eValidate.VLM0156.ToString());
ValidateException.ThrowErrorItem(error);
}
if (dt.Columns.Count < ((int)eImportFile.Remark) + 1)
{
ErrorItem error = new ErrorItem(null, TKPMessages.eValidate.VLM0178.ToString());
ValidateException.ThrowErrorItem(error);
}
List <ImportStockTakingDTO> dtoList = new List <ImportStockTakingDTO>();
int iLineNo = CONST_B_DATA_INCLUDE_HEADER ? CONST_INT_START_RECORD_NO : 0;
foreach (DataRow dr in dt.Rows)
{
if (("".Equals(dr[(int)eImportFile.Process]) &&
"".Equals(dr[(int)eImportFile.MasterNo]) &&
"".Equals(dr[(int)eImportFile.Weight]) &&
"".Equals(dr[(int)eImportFile.Qty]) &&
"".Equals(dr[(int)eImportFile.TagNo]) &&
"".Equals(dr[(int)eImportFile.Remark]))
|| (DBNull.Value.Equals(dr[(int)eImportFile.Process]) &&
DBNull.Value.Equals(dr[(int)eImportFile.MasterNo]) &&
DBNull.Value.Equals(dr[(int)eImportFile.Weight]) &&
DBNull.Value.Equals(dr[(int)eImportFile.Qty]) &&
DBNull.Value.Equals(dr[(int)eImportFile.TagNo]) &&
DBNull.Value.Equals(dr[(int)eImportFile.Remark])
))
{
continue;
}
iLineNo = iLineNo + 1;
ImportStockTakingDTO dto = new ImportStockTakingDTO();
dto.CREATE_BY = Common.CurrentUserInfomation.UserCD;
dto.CREATE_MACHINE = Common.CurrentUserInfomation.Machine;
dto.IMPORT_FILE_NAME = new NZString(txtFileName, txtFileName.Text.Trim());
dto.LINE_NO = new NZInt(null, iLineNo);
dto.PROCESS_CD = new NZString(null, dr[(int)eImportFile.Process]);
dto.ITEM_CD = new NZString(null, dr[(int)eImportFile.MasterNo]);
dto.WEIGHT = new NZString(null, dr[(int)eImportFile.Weight]);
dto.QTY = new NZString(null, dr[(int)eImportFile.Qty]);
dto.TAG_NO = new NZString(null, dr[(int)eImportFile.TagNo]);
dto.REMARK = new NZString(null, dr[(int)eImportFile.Remark]);
dtoList.Add(dto);
}
bool bSuccess = m_controller.ImportStockTakingTemp(strFilePath, ((int)eImportFile.Remark) + 1, dtoList);
if (bSuccess)
{
MessageDialog.ShowInformation(this, null, Message.LoadMessage(Messages.eInformation.INF9003.ToString()).MessageDescription);
InitialScreen();
return;
}
}
catch (ValidateException err)
{
for (int i = 0; i < err.ErrorResults.Count; i++)
{
MessageDialog.ShowBusiness(this, err.ErrorResults[i].Message);
err.ErrorResults[i].FocusOnControl();
}
}
catch (BusinessException err)
{
MessageDialog.ShowBusiness(this, err.Error.Message);
err.Error.FocusOnControl();
}
catch (Exception ex)
{
MessageDialog.ShowBusiness(this, ex.Message);
}
}
