/// <summary>
/// คัดลอกค่าที่เป็น Header ของ Model ไปเก็บไว้ใน DTO
/// </summary>
/// <param name="model"></param>
/// <param name="dto"></param>
///
private void AssignHeaderToDTO(IssueByOrderUIDM model, InventoryTransactionDTO dto, DataDefine.eIN_OUT_CLASS in_out)
{
dto.TRANS_DATE = model.TRANS_DATE;
//dto.REF_SLIP_NO = model.SLIP_NO;
dto.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issuing).ToNZString();//model.TRANS_CLS;
//dto.REF_SLIP_NO = model.INVOICE_NO;
//dto.OTHER_DL_NO = model.INVOICE_NO;
dto.REMARK = model.REMARK;
dto.OBJ_ITEM_CD = model.OBJ_ITEM_CD;
dto.OBJ_ORDER_QTY = model.OBJ_ORDER_QTY;
dto.REF_SLIP_CLS = (NZString)DataDefine.Convert2ClassCode(DataDefine.eREF_SLIP_CLS.Issue);
dto.FOR_CUSTOMER = model.FOR_CUSTOMER;
dto.FOR_MACHINE = model.FOR_MACHINE;
dto.REF_SLIP_NO2 = model.REF_SLIP_NO2;
dto.REF_SLIP_NO = model.REF_SLIP_NO;
dto.TRAN_SUB_CLS = model.TRAN_SUB_CLS;
dto.SCREEN_TYPE = DataDefine.ScreenType.IssueByOrder.ToNZString();
if (in_out == DataDefine.eIN_OUT_CLASS.In)
{
dto.REF_SLIP_NO = model.SLIP_NO;
dto.LOC_CD = model.TO_LOC_CD;
dto.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.In);
}
else
{
dto.SLIP_NO = model.SLIP_NO;
dto.LOC_CD = model.FROM_LOC_CD;
dto.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out);
}
}
private void OpenIssueScreen(bool CanEdit)
{
int activeRow = shtView.ActiveRowIndex;
IssueByOrderUIDM uidm = new IssueByOrderUIDM();
uidm.TRANS_ID.Value = shtView.Cells[activeRow, (int)eColView.ISSUE_NO].Value;
//uidm.REF_NO.Value = shtView.Cells[activeRow, (int)eColView.REF_ID].Value;
uidm.OBJ_ITEM_CD.Value = shtView.Cells[activeRow, (int)eColView.OBJ_ITEM_CD].Value;
uidm.OBJ_ORDER_QTY.Value = shtView.Cells[activeRow, (int)eColView.OBJ_ORDER_QTY].Value;
//uidm.ITEM_DESC.Value = shtView.Cells[activeRow, (int)eColView.PART_NAME].Value;
uidm.FROM_LOC_CD.Value = shtView.Cells[activeRow, (int)eColView.FROM_LOC].Value;
uidm.TO_LOC_CD.Value = shtView.Cells[activeRow, (int)eColView.TO_LOC].Value;
uidm.LOT_NO.Value = shtView.Cells[activeRow, (int)eColView.LOT_NO].Value;
// uidm.ONHAND_QTY.Value = shtView.Cells[activeRow, (int) eColView.TRANS_ID].Value;
uidm.QTY.Value = shtView.Cells[activeRow, (int)eColView.ISSUE_QTY].Value;
uidm.REMARK.Value = shtView.Cells[activeRow, (int)eColView.REMARK].Value;
uidm.TRANS_DATE.Value = Convert.ToDateTime(shtView.Cells[activeRow, (int)eColView.ISSUE_DATE].Value);
uidm.TRANS_CLS.Value = shtView.Cells[activeRow, (int)eColView.ISSUE_TYPE].Value;
uidm.SLIP_NO.Value = shtView.Cells[activeRow, (int)eColView.SLIP_NO].Value;
uidm.REF_SLIP_NO.Value = shtView.Cells[activeRow, (int)eColView.REF_SLIP_NO].Text;
uidm.REF_SLIP_NO2.Value = shtView.Cells[activeRow, (int)eColView.REF_SLIP_NO2].Text;
uidm.FOR_CUSTOMER.Value = shtView.Cells[activeRow, (int)eColView.FOR_CUSTOMER].Text;
uidm.FOR_MACHINE.Value = shtView.Cells[activeRow, (int)eColView.FOR_MACHINE].Text;
uidm.TRAN_SUB_CLS.Value = shtView.Cells[activeRow, (int)eColView.TRAN_SUB_CLS].Text;
TRN060 frmTRN060 = new TRN060(uidm, CanEdit);
frmTRN060.ShowDialog();
}
public TRN170_TransferEntry(IssueByOrderUIDM uidm, bool CanEdit)
{
InitializeComponent();
if (CanEdit)
{
m_Mode = eSaveMode.UPDATE;
}
else
{
m_Mode = eSaveMode.VIEW;
}
m_uidm = uidm;
}
private bool SaveData()
{
IssueByEntryController ctlIssue = new IssueByEntryController();
List <IssueByOrderUIDM> uidmIssueList = new List <IssueByOrderUIDM>();
NZString FromLocCD = new NZString(cboFromLoc, cboFromLoc.SelectedValue);
NZString ToLocCD = new NZString(cboToLoc, cboToLoc.SelectedValue);
NZString TranSubCls = new NZString(cboSubType, cboSubType.SelectedValue);
NZString RefSlipNo = new NZString(txtRefDocNo, txtRefDocNo.Text);
NZString RefSlipNo2 = new NZString(txtJobOrderNo, txtJobOrderNo.Text);
NZString ForCustomer = new NZString(cboForCustomer, cboForCustomer.SelectedValue);
int row = shtIssueList.Rows.Count;
for (int i = 0; i < row; i++)
{
IssueByOrderUIDM uidm = new IssueByOrderUIDM();
NZString ItemCD = new NZString(null,
shtIssueList.Cells[i, (int)eColView.ITEM_CODE].
Text);
NZString LotNo = new NZString(null, shtIssueList.Cells[i, (int)eColView.LOT_NO].Value);
NZDecimal Qty = new NZDecimal(null, shtIssueList.Cells[i, (int)eColView.ISSUE_QTY].Value);
NZString Remark = new NZString(txtRemark, txtRemark.Text.Trim());
NZDateTime TransDate = new NZDateTime(dtIssueDate, dtIssueDate.Value);
uidm.ITEM_CD = ItemCD;
uidm.FROM_LOC_CD = FromLocCD;
uidm.TO_LOC_CD = ToLocCD;
uidm.LOT_NO = LotNo;
uidm.QTY = Qty;
uidm.REMARK = Remark;
uidm.TRANS_DATE = TransDate;
uidm.TRANS_CLS = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Issuing).ToNZString();//TransCls;
uidm.TRAN_SUB_CLS = TranSubCls;
uidm.REF_SLIP_NO = RefSlipNo;
uidm.REF_SLIP_NO2 = RefSlipNo2;
uidm.FOR_CUSTOMER = ForCustomer;
uidmIssueList.Add(uidm);
}
ctlIssue.SaveAddIssue(uidmIssueList);
return(true);
}
private bool SaveDataEditMode()
{
RemoveRowUnused();
// ต้องเรียกก่อน Save เสมอ เพื่อ Commit ข้อมูลการแก้ไขล่าสุดบน Grid
// ใช้ได้เฉพาะกับ Sheet ที่ผูก DataSource
//int row = shtIssueList.Rows.Count;
for (int i = 0; i < shtIssueList.Rows.Count; i++)
{
CtrlUtil.SpreadSheetRowEndEdit(shtIssueList, shtIssueList.ActiveRowIndex);
}
IssueByOrderUIDM newModel = dmcIssue.SaveData(new IssueByOrderUIDM());
newModel.DATA_VIEW = m_uidm.DATA_VIEW;
//== Save Process
IssueByEntryController ctl = new IssueByEntryController();
ctl.SaveDataEditMode(newModel);
return(true);
}
internal void SaveDataEditMode(IssueByOrderUIDM model)
{
//== If data not has to processing.
if (model.DATA_VIEW == null || model.DATA_VIEW.Rows.Count == 0)
{
ValidateException.ThrowErrorItem(new ErrorItem(null, TKPMessages.eValidate.VLM0055.ToString()));
}
//model.DATA_VIEW.AcceptChanges();
// 20100324 11:44 Add by Teerayut S.
// Comment: Move begin transaction from business class to controller class.
// add try..catch block to control transaction scope.
Common.CurrentDatabase.KeepConnection = true;
Common.CurrentDatabase.BeginTransaction(IsolationLevel.Serializable);
// 20100324 End Teerayut S.
try
{
DataTable dtData = model.DATA_VIEW;
DataTable dtAdd = dtData.GetChanges(DataRowState.Added);
DataTable dtModify = dtData.GetChanges(DataRowState.Modified);
DataTable dtDelete = dtData.GetChanges(DataRowState.Deleted);
InventoryBIZ biz = new InventoryBIZ();
List <InventoryTransactionDTO> listAdd_from = null;
List <InventoryTransactionDTO> listUpdate_from = null;
List <InventoryTransactionDTO> listDelete_from = null;
List <InventoryTransactionDTO> listAdd_to = null;
List <InventoryTransactionDTO> listUpdate_to = null;
List <InventoryTransactionDTO> listDelete_to = null;
//== Insert process.
if (dtAdd != null && dtAdd.Rows.Count > 0)
{
listAdd_from = ConvertDataTableToList(dtAdd, DataDefine.eIN_OUT_CLASS.Out);
listAdd_to = ConvertDataTableToList(dtAdd, DataDefine.eIN_OUT_CLASS.In);
NZString runningNo;
if (model.SLIP_NO.IsNull)
{
RunningNumberBIZ runningNumberBIZ = new RunningNumberBIZ();
runningNo = runningNumberBIZ.GetCompleteRunningNo((NZString)"ISSUE_SLIP_NO", (NZString)"TB_INV_TRANS_TR");
}
else
{
runningNo = model.SLIP_NO;
}
for (int i = 0; i < listAdd_from.Count; i++)
{
InventoryTransactionDTO dto_from = listAdd_from[i];
InventoryTransactionDTO dto_to = listAdd_to[i];
// Copy ค่า Header จาก Model ไปยัง DTO แต่ละตัว
AssignHeaderToDTO(model, dto_from, DataDefine.eIN_OUT_CLASS.Out);
AssignHeaderToDTO(model, dto_to, DataDefine.eIN_OUT_CLASS.In);
dto_from.SLIP_NO = runningNo;
dto_from.CRT_BY = Common.CurrentUserInfomation.UserCD;
dto_from.CRT_MACHINE = Common.CurrentUserInfomation.Machine;
dto_from.UPD_BY = Common.CurrentUserInfomation.UserCD;
dto_from.UPD_MACHINE = Common.CurrentUserInfomation.Machine;
dto_to.REF_SLIP_NO = runningNo;
dto_to.CRT_BY = Common.CurrentUserInfomation.UserCD;
dto_to.CRT_MACHINE = Common.CurrentUserInfomation.Machine;
dto_to.UPD_BY = Common.CurrentUserInfomation.UserCD;
dto_to.UPD_MACHINE = Common.CurrentUserInfomation.Machine;
}
}
//== Update process.
if (dtModify != null && dtModify.Rows.Count > 0)
{
listUpdate_from = ConvertDataTableToList(dtModify, DataDefine.eIN_OUT_CLASS.Out);
listUpdate_to = ConvertDataTableToList(dtModify, DataDefine.eIN_OUT_CLASS.In);
for (int i = 0; i < listUpdate_from.Count; i++)
{
InventoryTransactionDTO dto_from = listUpdate_from[i];
InventoryTransactionDTO dto_to = listUpdate_to[i];
// Copy ค่า Header จาก Model ไปยัง DTO แต่ละตัว
AssignHeaderToDTO(model, dto_from, DataDefine.eIN_OUT_CLASS.Out);
AssignHeaderToDTO(model, dto_to, DataDefine.eIN_OUT_CLASS.In);
dto_from.CRT_BY = Common.CurrentUserInfomation.UserCD;
dto_from.CRT_MACHINE = Common.CurrentUserInfomation.Machine;
dto_from.UPD_BY = Common.CurrentUserInfomation.UserCD;
dto_from.UPD_MACHINE = Common.CurrentUserInfomation.Machine;
dto_to.CRT_BY = Common.CurrentUserInfomation.UserCD;
dto_to.CRT_MACHINE = Common.CurrentUserInfomation.Machine;
dto_to.UPD_BY = Common.CurrentUserInfomation.UserCD;
dto_to.UPD_MACHINE = Common.CurrentUserInfomation.Machine;
}
}
//== Delete process.
if (dtDelete != null && dtDelete.Rows.Count > 0)
{
listDelete_from = ConvertDataTableToList(dtDelete, DataDefine.eIN_OUT_CLASS.Out);
listDelete_to = ConvertDataTableToList(dtDelete, DataDefine.eIN_OUT_CLASS.In);
for (int i = 0; i < listDelete_from.Count; i++)
{
InventoryTransactionDTO dto_from = listDelete_from[i];
InventoryTransactionDTO dto_to = listDelete_to[i];
// Copy ค่า Header จาก Model ไปยัง DTO แต่ละตัว
AssignHeaderToDTO(model, dto_from, DataDefine.eIN_OUT_CLASS.Out);
AssignHeaderToDTO(model, dto_to, DataDefine.eIN_OUT_CLASS.In);
}
}
// ------ Update Header Process -------------
List <InventoryTransactionDTO> listUpdateHeader_from = new List <InventoryTransactionDTO>();
List <InventoryTransactionDTO> listUpdateHeader_to = new List <InventoryTransactionDTO>();
if (dtData != null && dtData.Rows.Count > 0)
{
listUpdateHeader_from = ConvertDataTableToList(dtData, DataDefine.eIN_OUT_CLASS.Out);
listUpdateHeader_to = ConvertDataTableToList(dtData, DataDefine.eIN_OUT_CLASS.In);
for (int i = 0; i < listUpdateHeader_from.Count; i++)
{
InventoryTransactionDTO dto_from = listUpdateHeader_from[i];
InventoryTransactionDTO dto_to = listUpdateHeader_to[i];
// Copy ค่า Header จาก Model ไปยัง DTO แต่ละตัว
AssignHeaderToDTO(model, dto_from, DataDefine.eIN_OUT_CLASS.Out);
AssignHeaderToDTO(model, dto_to, DataDefine.eIN_OUT_CLASS.In);
dto_from.CRT_BY = Common.CurrentUserInfomation.UserCD;
dto_from.CRT_MACHINE = Common.CurrentUserInfomation.Machine;
dto_from.UPD_BY = Common.CurrentUserInfomation.UserCD;
dto_from.UPD_MACHINE = Common.CurrentUserInfomation.Machine;
dto_to.CRT_BY = Common.CurrentUserInfomation.UserCD;
dto_to.CRT_MACHINE = Common.CurrentUserInfomation.Machine;
dto_to.UPD_BY = Common.CurrentUserInfomation.UserCD;
dto_to.UPD_MACHINE = Common.CurrentUserInfomation.Machine;
biz.UpdateIssueHeader(listUpdateHeader_from[i]);
biz.UpdateIssueHeader(listUpdateHeader_to[i]);
}
}
// --------- End ----------------------
biz.UpdateIssueByOrder(listAdd_from, listAdd_to, listUpdate_from, listUpdate_to, listDelete_from, listDelete_to);
CommonLib.Common.CurrentDatabase.Commit();
}
catch (Exception err)
{
CommonLib.Common.CurrentDatabase.Rollback();
throw;
}
}
