public ItemDescriptionDTO LoadItemDescription(NZString MasterNo, NZString PartNo)
{
ItemDescriptionDTO dtoItemDesc = new ItemDescriptionDTO();
ItemDTO dtoItem = LoadItem(MasterNo, PartNo);
if (dtoItem == null)
{
return(null);
}
dtoItemDesc.MASTER_NO = dtoItem.ITEM_CD;
dtoItemDesc.PART_NO = dtoItem.SHORT_NAME;
//get customer
DealingBIZ bizCust = new DealingBIZ();
DealingDTO dtoCust = bizCust.LoadLocation(dtoItem.CUSTOMER_CD);
if (dtoCust != null)
{
dtoItemDesc.CUSTOMER_CD = dtoCust.LOC_CD;
dtoItemDesc.CUSTOMER_NAME = dtoCust.LOC_DESC;
}
return(dtoItemDesc);
}
public DealingUIDM LoadLocation(NZString locationCode)
{
DealingBIZ biz = new DealingBIZ();
DealingDTO dto = biz.LoadLocation(locationCode);
return(MapDTOToModel(dto));
}
public ErrorItem CheckOnhandQty_AfterTR(Database db, EVOFramework.Windows.Forms.IControlIdentify owner, NZString ItemCD, NZString LocationCD, NZString LotNo)
{
// FIRST CHECK FOR LOCATION IF IT ALLOW NEGATIVE STOCK
DealingBIZ bizLoc = new DealingBIZ();
DealingDTO dtoLoc = bizLoc.LoadLocation(LocationCD);
if (!dtoLoc.ALLOW_NEGATIVE.IsNull && dtoLoc.ALLOW_NEGATIVE.StrongValue == DataDefine.Convert2ClassCode(DataDefine.eALLOW_NEGATIVE.Yes))
{
// IF THE LOCATION IS ALLOW FOR NEGATIVE THEN NOT CHECK ONHAND
return(null);
}
InventoryBIZ biz = new InventoryBIZ();
ActualOnhandViewDTO dto = biz.LoadActualInventoryOnHand(db, ItemCD, LocationCD, LotNo);
SysConfigBIZ bizConfig = new SysConfigBIZ();
SysConfigDTO dtoMinusQty = bizConfig.LoadByPK(DataDefine.eSYSTEM_CONFIG.LOCATION.SYS_GROUP_ID, (NZString)DataDefine.eSYSTEM_CONFIG.LOCATION.SYS_KEY.MINUS_QTY.ToString());
decimal decMinusQty = 0;
decimal.TryParse(dtoMinusQty.CHAR_DATA.StrongValue, out decMinusQty);
if (dto.ONHAND_QTY < decMinusQty)
{
return(new ErrorItem(owner, TKPMessages.eValidate.VLM0063.ToString(), new[] { ItemCD, LocationCD }));
}
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="data"></param>
/// <exception cref="ValidateException"><c>ValidateException</c>.</exception>
/// <exception cref="BusinessException"><c>BusinessException</c>.</exception>
public void ValidateBeforeSaveNew(DealingDTO data)
{
ValidateException validateException = new ValidateException();
ErrorItem errorItem = null;
#region mandatory check
errorItem = CheckEmptyLocationCode(data.LOC_CD);
if (errorItem != null)
{
validateException.AddError(errorItem);
}
errorItem = CheckEmptyLocationName(data.LOC_DESC);
if (errorItem != null)
{
validateException.AddError(errorItem);
}
errorItem = CheckEmptyLocationType(data.LOC_CLS);
if (errorItem != null)
{
validateException.AddError(errorItem);
}
validateException.ThrowIfHasError();
#endregion
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
if (dao.Exist(null, data.LOC_CD))
{
errorItem = new ErrorItem(data.LOC_CD.Owner, TKPMessages.eValidate.VLM0005.ToString());
BusinessException businessException = new BusinessException(errorItem);
throw businessException;
}
}
/// <summary>
/// Check On hand Inventory function follow business rule
/// </summary>
/// <param name="eOperation"></param>
/// <param name="eInoutCls"></param>
/// <param name="QTY"></param>
/// <param name="ItemCD"></param>
/// <param name="LocationCD"></param>
/// <param name="LotNo"></param>
/// <param name="strTranID">in case of Update, this value must be sent, the others send null.</param>
/// <returns></returns>
public ErrorItem CheckOnhandQty(DataDefine.eOperationClass eOperation, DataDefine.eIN_OUT_CLASS eInoutCls, NZDecimal QTY, NZString ItemCD, NZString LocationCD, NZString LotNo, NZString strTranID)
{
// FIRST CHECK FOR LOCATION IF IT ALLOW NEGATIVE STOCK
DealingBIZ bizLoc = new DealingBIZ();
DealingDTO dtoLoc = bizLoc.LoadLocation(LocationCD);
if (!dtoLoc.ALLOW_NEGATIVE.IsNull && dtoLoc.ALLOW_NEGATIVE.StrongValue == DataDefine.Convert2ClassCode(DataDefine.eALLOW_NEGATIVE.Yes))
{
// IF THE LOCATION IS ALLOW FOR NEGATIVE THEN NOT CHECK ONHAND
return(null);
}
//Operation Class
switch (eOperation)
{
case DataDefine.eOperationClass.Add:
//Do notting
break;
case DataDefine.eOperationClass.Update:
//Find Diff Qty
InventoryTransBIZ biz = new InventoryTransBIZ();
InventoryTransactionDTO dto = biz.LoadByTransactionID(strTranID);
if (dto != null)
{
QTY = (QTY - dto.QTY).ToNZDecimal();
}
break;
case DataDefine.eOperationClass.Delete:
//Delete Inverse Qty
QTY = (-1 * QTY.StrongValue).ToNZDecimal();
break;
}
//inout Class
if (eInoutCls == DataDefine.eIN_OUT_CLASS.Out)
{
QTY = (-1 * QTY.StrongValue).ToNZDecimal();
}
// CHECK FOR ONHAND WITH ACTUAL INVENTORY ONHAND
InventoryBIZ bizInv = new InventoryBIZ();
ActualOnhandViewDTO dtoActOnhand = bizInv.LoadActualInventoryOnHand(ItemCD, LocationCD, LotNo);
decimal decActualOnhandQty = 0;
if (dtoActOnhand != null && !dtoActOnhand.ONHAND_QTY.IsNull)
{
decActualOnhandQty = dtoActOnhand.ONHAND_QTY.StrongValue;
}
decActualOnhandQty = decActualOnhandQty + QTY;
if (decActualOnhandQty < 0)
{
return(new ErrorItem(QTY.Owner, TKPMessages.eValidate.VLM0063.ToString(), new[] { ItemCD, LocationCD }));
}
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="data"></param>
/// <exception cref="EVOFramework.ValidateException"><c>ValidateException</c>.</exception>
/// <exception cref="EVOFramework.BusinessException"><c>BusinessException</c>.</exception>
public void SaveNew(DealingUIDM data)
{
DealingDTO dto = MapModelToDTO(data);
DealingBIZ biz = new DealingBIZ();
biz.SaveNew(dto);
}
private void LoadItemData(string keyFilter)
{
//set ให้ show column ทั้งหมด
//shtView.Columns[0, shtView.Columns.Count - 1].Visible = true;
DealingBIZ biz = new DealingBIZ();
DealingDTO dto = new DealingDTO();
//DataTable dt = null;
if (m_LocationType != null && m_LocationType.Length > 0)
{
m_dtAllData = biz.LoadByLocationType(m_LocationType);
}
else
{
m_dtAllData = DTOUtility.ConvertListToDataTable <DealingDTO>(biz.LoadAllLocations(false));
}
FindDataFromMemory();
//shtView.Columns[(int)eColView.CRT_BY].Visible = false;
//shtView.Columns[(int)eColView.CRT_DATE].Visible = false;
//shtView.Columns[(int)eColView.CRT_MACHINE].Visible = false;
//shtView.Columns[(int)eColView.UPD_BY].Visible = false;
//shtView.Columns[(int)eColView.UPD_DATE].Visible = false;
//shtView.Columns[(int)eColView.UPD_MACHINE].Visible = false;
//shtView.Columns[(int)eColView.ALLOW_NEGATIVE].Visible = false;
//shtView.Columns[(int)eColView.MRP_LOCATION].Visible = false;
//DataTable dtView = dt.Clone();
//if (keyFilter != string.Empty)
//{
// string [] colNames = Enum.GetNames(typeof(eColView));
// string filterString = string.Empty;
// for (int i = 0; i < colNames.Length; i++) {
// filterString += string.Format(@"CONVERT({0},'System.String') LIKE '%{1}%' ", colNames[i], keyFilter);
// if (i != colNames.Length - 1)
// filterString += " OR ";
// }
// //get only the rows you want
// DataRow [] results = dt.Select(filterString);
// //populate new destination table
// foreach (DataRow dr in results)
// dtView.ImportRow(dr);
//}
//else
//{
// foreach (DataRow dr in dt.Rows)
// dtView.ImportRow(dr);
//}
//fpView.DataSource = dtView;
}
/// <summary>
///
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <exception cref="EVOFramework.ValidateException"><c>ValidateException</c>.</exception>
/// <exception cref="EVOFramework.BusinessException"><c>BusinessException</c>.</exception>
public int SaveUpdate(DealingDTO data)
{
DealingValidator validator = new DealingValidator();
validator.ValidateBeforeSaveUpdate(data);
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
return(dao.UpdateWithoutPK(null, data));
}
/// <summary>
///
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <exception cref="EVOFramework.ValidateException"><c>ValidateException</c>.</exception>
/// <exception cref="EVOFramework.BusinessException"><c>BusinessException</c>.</exception>
public int SaveNew(DealingDTO data)
{
DealingValidator validator = new DealingValidator();
validator.ValidateBeforeSaveNew(data);
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
return(dao.AddNew(null, data));
}
/// <summary>
/// Check exist before manipulate data. If found record will update data. Otherwise insert new data.
/// </summary>
/// <param name="database"></param>
/// <param name="data"></param>
/// <returns></returns>
public int AddNewOrUpdate(Database database, DealingDTO data)
{
Database db = UseDatabase(database);
if (Exist(database, data.LOC_CD))
{
return(UpdateWithoutPK(db, data));
}
return(AddNew(db, data));
}
private List <InventoryTransactionDTO> CreateConsumptionDTO(InventoryTransactionDTO dto)
{
List <InventoryTransactionDTO> dtoConList = new List <InventoryTransactionDTO>();
InventoryTransactionDTO dtoCon;
InventoryBIZ biz = new InventoryBIZ();
// GET LOCATION INFORMATION
DealingBIZ bizLoc = new DealingBIZ();
DealingDTO dtoLoc = bizLoc.LoadLocation(dto.DEALING_NO);
bool AllowNegative = dtoLoc.ALLOW_NEGATIVE.StrongValue == "01";
//WorkResultController ctrlWR=new WorkResultController ();
List <WorkResultEntryViewDTO> dtoChildItem = biz.LoadConsumptionListFromItemCode(dto.ITEM_CD, dto.DEALING_NO, dto.QTY);
for (int j = 0; j < dtoChildItem.Count; j++)
{
// GET CONSUMPTION ITEM FROM FIFO PROCESS WRITE BY KIMMIK.
List <ActualOnhandViewDTO> dtoListActOnhand = biz.FifoListingProcess(Common.CurrentDatabase
, dtoChildItem[j].ITEM_CD.StrongValue, dtoChildItem[j].LOC_CD.StrongValue, dtoChildItem[j].CONSUMPTION_QTY.StrongValue
, !AllowNegative, AllowNegative);
if (dtoListActOnhand != null && dtoListActOnhand.Count > 0)
{
for (int i = 0; i < dtoListActOnhand.Count; i++)
{
dtoCon = new InventoryTransactionDTO();
dtoCon.ITEM_CD = dtoListActOnhand[i].ITEM_CD;
dtoCon.LOC_CD = dtoListActOnhand[i].LOC_CD;
dtoCon.LOT_NO = dtoListActOnhand[i].LOT_NO;
dtoCon.DEALING_NO = dto.DEALING_NO;
dtoCon.TRANS_DATE = dto.TRANS_DATE;
dtoCon.TRANS_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Consumption);
dtoCon.IN_OUT_CLS.Value = DataDefine.Convert2ClassCode(DataDefine.eIN_OUT_CLASS.Out);
dtoCon.QTY = dtoListActOnhand[i].ONHAND_QTY;
dtoCon.OBJ_ORDER_QTY = dto.QTY;
dtoCon.OBJ_ITEM_CD = dto.ITEM_CD;
dtoCon.REMARK = dto.REMARK;
dtoCon.CRT_BY = Common.CurrentUserInfomation.UserCD;
dtoCon.CRT_MACHINE = Common.CurrentUserInfomation.Machine;
dtoCon.UPD_BY = Common.CurrentUserInfomation.UserCD;
dtoCon.UPD_MACHINE = Common.CurrentUserInfomation.Machine;
dtoCon.SCREEN_TYPE = DataDefine.ScreenType.ReceivingEntry.ToNZString();
dtoCon.REF_NO = dto.REF_NO;
dtoConList.Add(dtoCon);
}
}
}
return(dtoConList);
}
private void InitialComboBox()
{
cboLocation.Format += Common.ComboBox_Format;
LookupDataBIZ bizLookup = new LookupDataBIZ();
DealingDTO dto = new DealingDTO();
dto.LOC_CD = "All".ToNZString();
dto.LOC_DESC = "All Location".ToNZString();
LookupData lookupLocation = bizLookup.LoadLookupLocation_AddDummy(dto);
cboLocation.LoadLookupData(lookupLocation);
}
public AdjustmentEntryUIDM ConvertDTOToUIDM(InventoryTransactionDTO dto)
{
AdjustmentEntryUIDM model = new AdjustmentEntryUIDM();
model.TransactionID = dto.TRANS_ID;
model.AdjustNo = dto.SLIP_NO;
model.AdjustDate = dto.TRANS_DATE;
model.AdjustType = dto.IN_OUT_CLS;
model.ItemCode = dto.ITEM_CD;
model.StoredLoc = dto.LOC_CD;
model.LotNo = dto.LOT_NO;
model.PackNo = dto.PACK_NO;
model.FGNo = dto.FG_NO;
model.ExternalLotNo = dto.EXTERNAL_LOT_NO;
model.AdjustWeight = dto.WEIGHT;
model.AdjustQty = dto.QTY;
model.Remark = dto.REMARK;
model.ReasonCode = dto.TRAN_SUB_CLS;
//== Get Item Description.
ItemBIZ biz = new ItemBIZ();
ItemDTO itemDTO = biz.LoadItem(dto.ITEM_CD);
model.ItemDesc = itemDTO.SHORT_NAME;
//-- Get Customer Name
DealingBIZ bizCust = new DealingBIZ();
DealingDTO dtoCust = bizCust.LoadLocation(itemDTO.CUSTOMER_CD);
model.CustomerName = dtoCust.LOC_DESC;
//== Get OnHand.
InventoryBIZ inventoryBIZ = new InventoryBIZ();
InventoryPeriodBIZ inventoryPeriodBIZ = new InventoryPeriodBIZ();
InventoryPeriodDTO inventoryPeriodDTO = inventoryPeriodBIZ.LoadCurrentPeriod();
InventoryOnhandDTO inventoryOnhandDTO = inventoryBIZ.LoadInventoryOnHandByDate(inventoryPeriodDTO.YEAR_MONTH, dto.TRANS_DATE, dto.ITEM_CD, dto.LOC_CD, dto.LOT_NO, dto.PACK_NO);
if (inventoryOnhandDTO == null)
{
model.OnHandQty.Value = 0;
}
else
{
model.OnHandQty = inventoryOnhandDTO.ON_HAND_QTY;
}
return(model);
}
private void txtCusCD_Leave(object sender, EventArgs e)
{
DealingBIZ bizLocation = new DealingBIZ();
DealingDTO dtoLocation = bizLocation.LoadLocation((NZString)Convert.ToString(txtCusCD.Text));
if (dtoLocation != null)
{
txtCusName.Text = Convert.ToString(dtoLocation.LOC_DESC);
}
else
{
txtCusName.Text = string.Empty;
}
}
/// <summary>
/// Load All Location
/// </summary>
/// <param name="dtoAddedLocation">Dummy Location to Added and Set to first Row</param>
/// <returns></returns>
public LookupData LoadLookupLocation_AddDummy(DealingDTO dtoAddedLocation)
{
DealingDAO dao = new DealingDAO(CommonLib.Common.CurrentDatabase);
List <DealingDTO> dtoLocations = dao.LoadAll(null, true);
//add Dummy Location and Set to first Row
dtoLocations.Insert(0, dtoAddedLocation);
DataTable dt = DTOUtility.ConvertListToDataTable(dtoLocations);
LookupData lookupData = new LookupData(dt,
DealingDTO.eColumns.LOC_DESC.ToString(),
DealingDTO.eColumns.LOC_CD.ToString());
return(lookupData);
}
private void CheckCustomer(DemandOrderDTO dtoOrder)
{
ErrorItem errorItem;
DealingBIZ bizCustomer = new DealingBIZ();
DealingDTO dtoCustomer = bizCustomer.LoadLocation(dtoOrder.CUSTOMER_CD);
if (dtoCustomer == null)
{
errorItem = new ErrorItem(null, TKPMessages.eValidate.VLM0108.ToString());
throw new BusinessException(errorItem);
}
//check customer is exists
//CustomerBIZ bizCustomer = new CustomerBIZ();
//CustomerDTO dtoCustomer = new CustomerDTO();
//dtoCustomer.CUSTOMER_CODE = dtoOrder.CUSTOMER_CD;
//if (!bizCustomer.IsExists(dtoCustomer)) {
// errorItem = new ErrorItem(null, TKPMessages.eValidate.VLM0108.ToString());
// throw new BusinessException(errorItem);
//}
}
private DealingUIDM MapDTOToModel(DealingDTO data)
{
DealingUIDM model = new DealingUIDM();
model.LOC_CD = data.LOC_CD;
model.LOC_DESC = data.LOC_DESC;
model.LOC_CLS = data.LOC_CLS;
model.TERM_OF_PAYMENT = data.TERM_OF_PAYMENT;
model.INVOICE_PATTERN = data.INVOICE_PATTERN;
model.ADDRESS1 = data.ADDRESS1;
model.TEL1 = data.TEL1;
model.FAX1 = data.FAX1;
model.EMAIL1 = data.EMAIL1;
model.CONTACT_PERSON1 = data.CONTACT_PERSON1;
model.REMARK1 = data.REMARK1;
model.ADDRESS2 = data.ADDRESS2;
model.TEL2 = data.TEL2;
model.FAX2 = data.FAX2;
model.EMAIL2 = data.EMAIL2;
model.CONTACT_PERSON2 = data.CONTACT_PERSON2;
model.REMARK2 = data.REMARK2;
model.ADDRESS3 = data.ADDRESS3;
model.TEL3 = data.TEL3;
model.FAX3 = data.FAX3;
model.EMAIL3 = data.EMAIL3;
model.CONTACT_PERSON3 = data.CONTACT_PERSON3;
model.REMARK3 = data.REMARK3;
model.ALLOW_NEGATIVE = data.ALLOW_NEGATIVE;
model.OLD_DATA = data.OLD_DATA;
model.CRT_BY = data.CRT_BY;
model.CRT_MACHINE = data.CRT_MACHINE;
model.CRT_DATE = data.CRT_DATE;
model.UPD_BY = data.UPD_BY;
model.UPD_MACHINE = data.UPD_MACHINE;
model.UPD_DATE = data.UPD_DATE;
return(model);
}
public string GetCustomerData(NZString ItemCD)
{
ItemBIZ bizItem = new ItemBIZ();
ItemDTO dtoItem = bizItem.LoadItem(ItemCD);
if (dtoItem == null || dtoItem.ITEM_DESC.IsNull)
{
return(string.Empty);
}
//get customer
DealingBIZ bizCust = new DealingBIZ();
DealingDTO dtoCust = bizCust.LoadLocation(dtoItem.CUSTOMER_CD);
if (dtoCust == null || dtoCust.LOC_DESC.IsNull)
{
return(string.Empty);
}
SelectedCustomerData = dtoCust;
return(dtoCust.LOC_DESC.StrongValue);
}
public SalesUnitPriceUIDM LoadSalesUnitPriceWithItemInfo(NZString ITEM_CD, NZDateTime START_EFF_DATE, NZString CURRENCY)
{
SalesUnitPriceBIZ bizPrice = new SalesUnitPriceBIZ();
SalesUnitPriceDTO dtoPrice = bizPrice.LoadSalesUnitPriceByPK(ITEM_CD, START_EFF_DATE, CURRENCY);
if (dtoPrice == null)
{
return(null);
}
ItemBIZ bizItem = new ItemBIZ();
ItemDTO dtoItem = bizItem.LoadItem(ITEM_CD);
DealingBIZ bizCust = new DealingBIZ();
DealingDTO dtoCust = null;
if (dtoItem != null && !dtoItem.CUSTOMER_CD.IsNull)
{
dtoCust = bizCust.LoadLocation(dtoItem.CUSTOMER_CD);
}
return(MapDTOToModel(dtoPrice, dtoItem, dtoCust));
}
private DealingDTO MapModelToDTO(DealingUIDM data)
{
DealingDTO dto = new DealingDTO();
dto.LOC_CD = data.LOC_CD;
dto.LOC_DESC = data.LOC_DESC;
dto.LOC_CLS = data.LOC_CLS;
dto.TERM_OF_PAYMENT = data.TERM_OF_PAYMENT;
dto.INVOICE_PATTERN = data.INVOICE_PATTERN;
dto.ADDRESS1 = data.ADDRESS1;
dto.TEL1 = data.TEL1;
dto.FAX1 = data.FAX1;
dto.EMAIL1 = data.EMAIL1;
dto.CONTACT_PERSON1 = data.CONTACT_PERSON1;
dto.REMARK1 = data.REMARK1;
dto.ADDRESS2 = data.ADDRESS2;
dto.TEL2 = data.TEL2;
dto.FAX2 = data.FAX2;
dto.EMAIL2 = data.EMAIL2;
dto.CONTACT_PERSON2 = data.CONTACT_PERSON2;
dto.REMARK2 = data.REMARK2;
dto.ADDRESS3 = data.ADDRESS3;
dto.TEL3 = data.TEL3;
dto.FAX3 = data.FAX3;
dto.EMAIL3 = data.EMAIL3;
dto.CONTACT_PERSON3 = data.CONTACT_PERSON3;
dto.REMARK3 = data.REMARK3;
dto.ALLOW_NEGATIVE = "01".ToNZString(); // yes
dto.OLD_DATA = (0).ToNZInt();
dto.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dto.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dto.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dto.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
return(dto);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns>If save data operation completed will return true. Otherwise return false.</returns>
public bool SaveData(WorkResultEntryUIDM model, DataDefine.eCONSUMPTION_CLS ConsumptionClass)
{
ItemBIZ bizItem = new ItemBIZ();
ClassListBIZ bizClassList = new ClassListBIZ();
InventoryBIZ biz = new InventoryBIZ();
IssueEntryValidator valLot = new IssueEntryValidator();
// Load default over consumption checking.
ClassListDTO dtoOverConsumptionCheck = bizClassList.LoadByPK((NZString)DataDefine.OVER_CONSUME_CHK, (NZString)DataDefine.Convert2ClassCode(DataDefine.eOVER_CONSUME_CHK.DEFAULT));
bool bOverConsumeChk = false;
if (dtoOverConsumptionCheck != null && dtoOverConsumptionCheck.CLS_DESC.NVL(String.Empty) == "1")
{
bOverConsumeChk = true;
}
//string mode = "UPD";
//if (model.WorkOrderNo.IsNull)
//{
// mode = "ADD";
//}
#region Validate data
//== Validate Header, contain: ItemCode, Order Location and Qty.
#region Validate mandatory
WorkResultEntryValidator workResultEntryValidator = new WorkResultEntryValidator();
ItemValidator itemValidator = new ItemValidator();
DealingValidator locationValidator = new DealingValidator();
CommonBizValidator commonVal = new CommonBizValidator();
ValidateException.ThrowErrorItem(workResultEntryValidator.CheckWorkResultDate(model.WorkResultDate));
ValidateException.ThrowErrorItem(itemValidator.CheckEmptyItemCode(model.ItemCode));
ValidateException.ThrowErrorItem(workResultEntryValidator.CheckEmptyShiftType(model.ShipClass));
ValidateException.ThrowErrorItem(workResultEntryValidator.CheckDifferentLocationOfItem(model.DataView));
BusinessException itemFound = itemValidator.CheckItemNotExist(model.ItemCode);
if (itemFound != null)
{
ValidateException.ThrowErrorItem(itemFound.Error);
}
if (ConsumptionClass != DataDefine.eCONSUMPTION_CLS.No)
{
ValidateException.ThrowErrorItem(locationValidator.CheckEmptyLocationCode(model.OrderLoc));
ValidateException.ThrowErrorItem(locationValidator.CheckNotExistsLocationCode(model.OrderLoc));
}
ValidateException.ThrowErrorItem(locationValidator.CheckEmptyLocationCode(model.StoredLoc));
ValidateException.ThrowErrorItem(locationValidator.CheckNotExistsLocationCode(model.StoredLoc));
ValidateException.ThrowErrorItem(workResultEntryValidator.CheckWorkResultQty(model.WorkResultQty));
ValidateException.ThrowErrorItem(workResultEntryValidator.CheckWorkResultGoodQty((NZDecimal)(model.WorkResultQty.StrongValue - model.NGQty.StrongValue)));
// Check LotNo
ValidateException.ThrowErrorItem(commonVal.CheckInputLot(model.ItemCode, new NZString(), model.LotNo, false));
#endregion
//== Validate Detail list.
if (ConsumptionClass == DataDefine.eCONSUMPTION_CLS.Manual)
{
List <WorkResultEntryViewDTO> listItems = DTOUtility.ConvertDataTableToList <WorkResultEntryViewDTO>(model.DataView);
#region Validate detail list.
// Check ItemCD & LotNo
List <string> listInvalidLotNo = new List <string>();
List <string> listInvalidConsumptionQty = new List <string>();
for (int i = 0; i < listItems.Count; i++)
{
BusinessException itemChildNotFound = itemValidator.CheckItemNotExist(listItems[i].ITEM_CD);
if (itemChildNotFound != null)
{
ValidateException.ThrowErrorItem(itemChildNotFound.Error);
}
ItemDTO dtoItem = bizItem.LoadItem(listItems[i].ITEM_CD);
WorkResultEntryViewDTO line = listItems[i];
//line.LOT_CONTROL_CLS = dtoItem.LOT_CONTROL_CLS;
if (line.LOT_CONTROL_CLS.StrongValue == DataDefine.Convert2ClassCode(DataDefine.eLOT_CONTROL_CLS.Yes) &&
(line.LOT_NO.IsNull || line.LOT_NO.StrongValue.Trim() == string.Empty))
{
if (listInvalidLotNo.Contains(line.ITEM_CD.StrongValue))
{
continue;
}
listInvalidLotNo.Add(line.ITEM_CD.StrongValue);
}
if (bOverConsumeChk)
{
if (line.CONSUMPTION_QTY.StrongValue > line.ON_HAND_QTY.StrongValue)
{
if (listInvalidConsumptionQty.Contains(line.ITEM_CD.StrongValue))
{
continue;
}
listInvalidConsumptionQty.Add(line.ITEM_CD.StrongValue);
}
}
ValidateException.ThrowErrorItem(commonVal.CheckInputLot(line.ITEM_CD, line.LOC_CD, line.LOT_NO, true));
}
// Generate item doesn't input LOT_NO
if (listInvalidLotNo.Count > 0)
{
listInvalidLotNo.Sort();
string errorItems = string.Empty;
for (int i = 0; i < listInvalidLotNo.Count; i++)
{
if (i != 0)
{
errorItems += ", ";
}
errorItems += listInvalidLotNo[i];
}
ValidateException.ThrowErrorItem(new ErrorItem(null, TKPMessages.eValidate.VLM0050.ToString(), new object[] { errorItems }));
return(false);
}
// Generate list item that input consumption qty more than stock onhand qty.
if (listInvalidConsumptionQty.Count > 0)
{
listInvalidConsumptionQty.Sort();
string errorItems = string.Empty;
for (int i = 0; i < listInvalidConsumptionQty.Count; i++)
{
if (i != 0)
{
errorItems += ", ";
}
errorItems += listInvalidConsumptionQty[i];
}
ValidateException.ThrowErrorItem(new ErrorItem(null, TKPMessages.eValidate.VLM0051.ToString(), new object[] { errorItems }));
return(false);
}
#endregion
// Validate Child Item to support Parent Item.
#region Validate Child Item to support Parent item.
// Summary Consumption Qty by Item (not include LotNo) and then check compare with RequestQty.
InventoryBIZ bizInventory = new InventoryBIZ();
List <WorkResultEntryViewDTO> listSourceChildItems = bizInventory.LoadConsumptionListFromItemCode(model.ItemCode, model.OrderLoc, model.WorkResultQty);
for (int i = 0; i < listSourceChildItems.Count; i++)
{
object objSumByItem = model.DataView.Compute(
String.Format("SUM({0})", WorkResultEntryViewDTO.eColumns.CONSUMPTION_QTY),
String.Format("{0} = '{1}'", WorkResultEntryViewDTO.eColumns.ITEM_CD, listSourceChildItems[i].ITEM_CD.StrongValue)
);
decimal sumConsumptionQty = 0;
if (objSumByItem != null && objSumByItem != DBNull.Value)
{
sumConsumptionQty = Convert.ToDecimal(objSumByItem);
}
decimal diffQty = Math.Abs(sumConsumptionQty - listSourceChildItems[i].CONSUMPTION_QTY.StrongValue);
if (sumConsumptionQty < listSourceChildItems[i].REQUEST_QTY.StrongValue) // Total of ConsumtpionQty < RequestQty
{
// Confirmation to continue save.
MessageDialogResult dr = MessageDialog.ShowConfirmation(null, Message.LoadMessage(TKPMessages.eConfirm.CFM0001.ToString(),
new object[]
{
listSourceChildItems[i].ITEM_CD.StrongValue,
model.ItemCode.StrongValue,
diffQty.ToString(DataDefine.DEFAULT_FORMAT_NUMBER)
}),
MessageDialogButtons.YesNo);
if (dr == MessageDialogResult.No)
{
return(false);
}
}
else if (sumConsumptionQty > listSourceChildItems[i].REQUEST_QTY.StrongValue) // Total of ConsumtpionQty > RequestQty
{
// Confirmation to continue save.
MessageDialogResult dr = MessageDialog.ShowConfirmation(null, Message.LoadMessage(TKPMessages.eConfirm.CFM0002.ToString(),
new object[]
{
listSourceChildItems[i].ITEM_CD.StrongValue,
model.ItemCode.StrongValue,
diffQty.ToString(DataDefine.DEFAULT_FORMAT_NUMBER)
}),
MessageDialogButtons.YesNo);
if (dr == MessageDialogResult.No)
{
return(false);
}
}
}
#endregion
}
#endregion
DataTable dtData;
if (model.DataView == null)
{
WorkResultEntryViewDTO dto = new WorkResultEntryViewDTO();
dto.CreateDataTableSchema(out dtData);
}
else
{
dtData = model.DataView;
}
DataTable dtAdd = dtData.GetChanges(DataRowState.Added);
DataTable dtUpdate = dtData.GetChanges(DataRowState.Modified);
DataTable dtDelete = dtData.GetChanges(DataRowState.Deleted);
List <InventoryTransactionDTO> listAdd = new List <InventoryTransactionDTO>();
List <InventoryTransactionDTO> listUpdate = new List <InventoryTransactionDTO>();
List <InventoryTransactionDTO> listDelete = new List <InventoryTransactionDTO>();
Database db = null;
try
{
db = Common.CurrentDatabase;
db.KeepConnection = true;
db.BeginTransaction();
//TransactionValidator valTran = new TransactionValidator();
//InventoryTransBIZ bizTran = new InventoryTransBIZ();
//bizTran.l
#region Header
NZString runningNo = new NZString();
//ให้ generate lot ใหม่อีกครั้ง กรณีกรอกพร้อมกัน 2 เครื่อง ไม่งั้นมันจะ insert ข้อมูลมั่ว
// ที่ใส่ตรงนี้เพราะว่า จะได้แก้ model.LotNo ก่อนที่จะสร้าง object dto
//เนื่องจาก reserve ก็มีดึง lot no ไปใช้
if (model.WorkResultNo.IsNull)
{
RunningNumberBIZ runnningBiz = new RunningNumberBIZ();
NZString strCompleteLotNo = runnningBiz.GetCompleteLotNo(new NZDateTime(null, model.WorkResultDate.StrongValue), model.StoredLoc, model.ItemCode, new NZInt(null, 0));
model.LotNo = strCompleteLotNo;
}
InventoryTransactionDTO dtoWorkResult = CreateDTOForWorkResult(model);
InventoryTransactionDTO dtoNGResult = CreateDTOForNGResult(model);
InventoryTransactionDTO dtoReserveResult = CreateDTOForReserveResult(model);
InventoryTransBIZ bizTran = new InventoryTransBIZ();
bizTran.LockRefSlipNumber(dtoWorkResult.REF_SLIP_NO);
if (model.WorkResultNo.IsNull)
{
RunningNumberBIZ runningNumberBIZ = new RunningNumberBIZ();
runningNo = runningNumberBIZ.GetCompleteRunningNo((NZString)"WORK_RESULT_SLIP_NO", (NZString)"TB_INV_TRANS_TR");
// Create new transaction.
dtoWorkResult.SLIP_NO = runningNo;
dtoNGResult.SLIP_NO = runningNo;
dtoReserveResult.SLIP_NO = runningNo;
listAdd.Add(dtoWorkResult);
if (model.NGQty.NVL(0) > 0)
{
listAdd.Add(dtoNGResult);
}
if (model.ReserveQty.NVL(0) > 0)
{
listAdd.Add(dtoReserveResult);
}
}
else
{
// Update old transaction
runningNo = model.WorkResultNo;
listUpdate.Add(dtoWorkResult);
if (!model.NGTransactionID.IsNull) // UPDATE NG IF IT ALREADY HAS NG QTY
{
listUpdate.Add(dtoNGResult);
}
else if (model.NGQty.NVL(0) > 0) // ADD NEW NG TRANS IF NEW NG IS INPUT
{
//dtoNGResult.SLIP_NO = dtoWorkResult.SLIP_NO;
listAdd.Add(dtoNGResult);
}
if (!model.ReserveTransactionID.IsNull) // UPDATE Reserve IF IT ALREADY HAS Reserve QTY
{
listUpdate.Add(dtoReserveResult);
}
else if (model.ReserveQty.NVL(0) > 0) // ADD NEW Reserve TRANS IF NEW NG IS INPUT
{
//dtoReserveResult.SLIP_NO = dtoWorkResult.SLIP_NO;
listAdd.Add(dtoNGResult);
}
}
#endregion
#region Detail
#region Do Auto Consumption
if (ConsumptionClass == DataDefine.eCONSUMPTION_CLS.Auto)
{
// WHEN CONSUMPTION IS AUTO
// DELETE ALL OLD TRANSACTION FIRST THEN ADD NEW
//Modify by Bunyapat L.
//28 Apr 2011
//ให้สั่ง ClearConsumption ไปเลย
List <WorkResultEntryViewDTO> listTMPDelete = null;
List <InventoryTransactionDTO> listTmpDelete = null;
if (dtData != null && dtData.Rows.Count > 0)
{
listTMPDelete = DTOUtility.ConvertDataTableToList <WorkResultEntryViewDTO>(dtData);
listTmpDelete = new List <InventoryTransactionDTO>();
for (int i = 0; i < listTMPDelete.Count; i++)
{
WorkResultEntryViewDTO line = listTMPDelete[i];
InventoryTransactionDTO dto = CreateDTOForConsumption(model, line);
dto.REF_NO = runningNo;
listTmpDelete.Add(dto);
}
// Move to delete below section
//biz.WorkResultItems(Common.CurrentDatabase, null, null, listTmpDelete);
}
biz.ClearConsumption(Common.CurrentDatabase, dtoWorkResult);
if (dtData != null && dtData.Rows.Count > 0)
{
List <WorkResultEntryViewDTO> listTMPAdd = DTOUtility.ConvertDataTableToList <WorkResultEntryViewDTO>(dtData);
// GET LOCATION INFORMATION
DealingBIZ bizLoc = new DealingBIZ();
for (int i = 0; i < listTMPAdd.Count; i++)
{
DealingDTO dtoLoc = bizLoc.LoadLocation(listTMPAdd[i].LOC_CD);
bool AllowNegative = dtoLoc.ALLOW_NEGATIVE.StrongValue == "01";
// GET CONSUMPTION ITEM FROM FIFO PROCESS WRITE BY KIMMIK.
List <ActualOnhandViewDTO> dtoListActOnhand = biz.FifoListingProcess(Common.CurrentDatabase
, listTMPAdd[i].ITEM_CD.StrongValue, listTMPAdd[i].LOC_CD.StrongValue
, listTMPAdd[i].CONSUMPTION_QTY.StrongValue
, !AllowNegative, AllowNegative);
if (dtoListActOnhand != null && dtoListActOnhand.Count > 0)
{
for (int j = 0; j < dtoListActOnhand.Count; j++)
{
InventoryTransactionDTO dto = CreateDTOForConsumption(model, dtoListActOnhand[j]);
dto.REF_NO = runningNo;
listAdd.Add(dto);
}
}
}
}
biz.WorkResultItems(Common.CurrentDatabase, listAdd, listUpdate, listDelete);
}
#endregion
#region Do Manual Consumption
if (ConsumptionClass == DataDefine.eCONSUMPTION_CLS.Manual)
{
List <InventoryTransactionDTO> listTmpDelete = new List <InventoryTransactionDTO>();
//== Update process.
//Modify by Bunyapat L.
//28 Apr 2011
//Manual consumption ให้ใช้การ insert เข้า Delete ทุกตัวที่เป็นตัวเก่า
//แล้วค่อย Add ตัวใหม่แทน เพราะข้างใน function มันจะทำการ clear consumption ทั้งหมด ไม่งั้นจะเกิด bug ตอน update
if (dtUpdate != null && dtUpdate.Rows.Count > 0)
{
List <WorkResultEntryViewDTO> listViewUpdate = DTOUtility.ConvertDataTableToList <WorkResultEntryViewDTO>(dtUpdate);
for (int i = 0; i < listViewUpdate.Count; i++)
{
WorkResultEntryViewDTO line = listViewUpdate[i];
// Copy ค่า Header จาก Model ไปยัง DTO แต่ละตัว
InventoryTransactionDTO dto = CreateDTOForConsumption(model, line);
dto.REF_NO = runningNo;
//listUpdate.Add(dto);
listAdd.Add(dto);
listTmpDelete.Add((InventoryTransactionDTO)dto.Clone());
}
}
//== Insert process.
if (dtAdd != null && dtAdd.Rows.Count > 0)
{
List <WorkResultEntryViewDTO> listViewAdd = DTOUtility.ConvertDataTableToList <WorkResultEntryViewDTO>(dtAdd);
for (int i = 0; i < listViewAdd.Count; i++)
{
WorkResultEntryViewDTO line = listViewAdd[i];
InventoryTransactionDTO dto = CreateDTOForConsumption(model, line);
dto.REF_NO = runningNo;
listAdd.Add(dto);
}
}
//== Delete process.
if (dtDelete != null && dtDelete.Rows.Count > 0)
{
List <WorkResultEntryViewDTO> listViewDelete = DTOUtility.ConvertDataTableToList <WorkResultEntryViewDTO>(dtDelete);
for (int i = 0; i < dtDelete.Rows.Count; i++)
{
WorkResultEntryViewDTO line = listViewDelete[i];
// Copy ค่า Header จาก Model ไปยัง DTO แต่ละตัว
InventoryTransactionDTO dto = CreateDTOForConsumption(model, line);
dto.REF_NO = runningNo;
listDelete.Add(dto);
}
}
biz.WorkResultItems(Common.CurrentDatabase, null, null, listTmpDelete);
biz.WorkResultItems(Common.CurrentDatabase, listAdd, listUpdate, listDelete);
}
#endregion
#region Do No Consumption
if (ConsumptionClass == DataDefine.eCONSUMPTION_CLS.No)
{
biz.WorkResultItems(Common.CurrentDatabase, listAdd, listUpdate, listDelete);
}
#endregion
#endregion
db.Commit();
}
catch (Exception)
{
db.Rollback();
throw;
}
finally
{
if (db.DBConnectionState == ConnectionState.Open)
{
db.Close();
}
}
return(true);
}
/// <summary>
/// Insert new record into database.
/// </summary>
/// <param name="database"></param>
/// <param name="data"></param>
/// <returns></returns>
public int AddNew(Database database, DealingDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" INSERT INTO " + data.TableName + "(");
sb.AppendLine(" " + DealingDTO.eColumns.CRT_BY);
sb.AppendLine(" ," + DealingDTO.eColumns.CRT_DATE);
sb.AppendLine(" ," + DealingDTO.eColumns.CRT_MACHINE);
sb.AppendLine(" ," + DealingDTO.eColumns.UPD_BY);
sb.AppendLine(" ," + DealingDTO.eColumns.UPD_DATE);
sb.AppendLine(" ," + DealingDTO.eColumns.UPD_MACHINE);
sb.AppendLine(" ," + DealingDTO.eColumns.LOC_CD);
sb.AppendLine(" ," + DealingDTO.eColumns.LOC_DESC);
sb.AppendLine(" ," + DealingDTO.eColumns.LOC_CLS);
sb.AppendLine(" ," + DealingDTO.eColumns.TERM_OF_PAYMENT);
sb.AppendLine(" ," + DealingDTO.eColumns.INVOICE_PATTERN);
sb.AppendLine(" ," + DealingDTO.eColumns.ADDRESS1);
sb.AppendLine(" ," + DealingDTO.eColumns.TEL1);
sb.AppendLine(" ," + DealingDTO.eColumns.FAX1);
sb.AppendLine(" ," + DealingDTO.eColumns.EMAIL1);
sb.AppendLine(" ," + DealingDTO.eColumns.CONTACT_PERSON1);
sb.AppendLine(" ," + DealingDTO.eColumns.REMARK1);
sb.AppendLine(" ," + DealingDTO.eColumns.ADDRESS2);
sb.AppendLine(" ," + DealingDTO.eColumns.TEL2);
sb.AppendLine(" ," + DealingDTO.eColumns.FAX2);
sb.AppendLine(" ," + DealingDTO.eColumns.EMAIL2);
sb.AppendLine(" ," + DealingDTO.eColumns.CONTACT_PERSON2);
sb.AppendLine(" ," + DealingDTO.eColumns.REMARK2);
sb.AppendLine(" ," + DealingDTO.eColumns.ADDRESS3);
sb.AppendLine(" ," + DealingDTO.eColumns.TEL3);
sb.AppendLine(" ," + DealingDTO.eColumns.FAX3);
sb.AppendLine(" ," + DealingDTO.eColumns.EMAIL3);
sb.AppendLine(" ," + DealingDTO.eColumns.CONTACT_PERSON3);
sb.AppendLine(" ," + DealingDTO.eColumns.REMARK3);
sb.AppendLine(" ," + DealingDTO.eColumns.ALLOW_NEGATIVE);
sb.AppendLine(" ," + DealingDTO.eColumns.OLD_DATA);
sb.AppendLine(") VALUES(");
sb.AppendLine(" @CRT_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,@CRT_MACHINE");
sb.AppendLine(" ,@UPD_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,@UPD_MACHINE");
sb.AppendLine(" ,@LOC_CD");
sb.AppendLine(" ,@LOC_DESC");
sb.AppendLine(" ,@LOC_CLS");
sb.AppendLine(" ,@TERM_OF_PAYMENT");
sb.AppendLine(" ,@INVOICE_PATTERN");
sb.AppendLine(" ,@ADDRESS1");
sb.AppendLine(" ,@TEL1");
sb.AppendLine(" ,@FAX1");
sb.AppendLine(" ,@EMAIL1");
sb.AppendLine(" ,@CONTACT_PERSON1");
sb.AppendLine(" ,@REMARK1");
sb.AppendLine(" ,@ADDRESS2");
sb.AppendLine(" ,@TEL2");
sb.AppendLine(" ,@FAX2");
sb.AppendLine(" ,@EMAIL2");
sb.AppendLine(" ,@CONTACT_PERSON2");
sb.AppendLine(" ,@REMARK2");
sb.AppendLine(" ,@ADDRESS3");
sb.AppendLine(" ,@TEL3");
sb.AppendLine(" ,@FAX3");
sb.AppendLine(" ,@EMAIL3");
sb.AppendLine(" ,@CONTACT_PERSON3");
sb.AppendLine(" ,@REMARK3");
sb.AppendLine(" ,@ALLOW_NEGATIVE");
sb.AppendLine(" ,@OLD_DATA");
sb.AppendLine(" )");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("@CRT_BY", DataType.NVarChar, data.CRT_BY.Value);
req.Parameters.Add("@CRT_MACHINE", DataType.NVarChar, data.CRT_MACHINE.Value);
req.Parameters.Add("@UPD_BY", DataType.NVarChar, data.UPD_BY.Value);
req.Parameters.Add("@UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value);
req.Parameters.Add("@LOC_CD", DataType.NVarChar, data.LOC_CD.Value);
req.Parameters.Add("@LOC_DESC", DataType.NVarChar, data.LOC_DESC.Value);
req.Parameters.Add("@LOC_CLS", DataType.NVarChar, data.LOC_CLS.Value);
req.Parameters.Add("@TERM_OF_PAYMENT", DataType.NVarChar, data.TERM_OF_PAYMENT.Value);
req.Parameters.Add("@INVOICE_PATTERN", DataType.NVarChar, data.INVOICE_PATTERN.Value);
req.Parameters.Add("@ADDRESS1", DataType.NVarChar, data.ADDRESS1.Value);
req.Parameters.Add("@TEL1", DataType.NVarChar, data.TEL1.Value);
req.Parameters.Add("@FAX1", DataType.NVarChar, data.FAX1.Value);
req.Parameters.Add("@EMAIL1", DataType.NVarChar, data.EMAIL1.Value);
req.Parameters.Add("@CONTACT_PERSON1", DataType.NVarChar, data.CONTACT_PERSON1.Value);
req.Parameters.Add("@REMARK1", DataType.NVarChar, data.REMARK1.Value);
req.Parameters.Add("@ADDRESS2", DataType.NVarChar, data.ADDRESS2.Value);
req.Parameters.Add("@TEL2", DataType.NVarChar, data.TEL2.Value);
req.Parameters.Add("@FAX2", DataType.NVarChar, data.FAX2.Value);
req.Parameters.Add("@EMAIL2", DataType.NVarChar, data.EMAIL2.Value);
req.Parameters.Add("@CONTACT_PERSON2", DataType.NVarChar, data.CONTACT_PERSON2.Value);
req.Parameters.Add("@REMARK2", DataType.NVarChar, data.REMARK2.Value);
req.Parameters.Add("@ADDRESS3", DataType.NVarChar, data.ADDRESS3.Value);
req.Parameters.Add("@TEL3", DataType.NVarChar, data.TEL3.Value);
req.Parameters.Add("@FAX3", DataType.NVarChar, data.FAX3.Value);
req.Parameters.Add("@EMAIL3", DataType.NVarChar, data.EMAIL3.Value);
req.Parameters.Add("@CONTACT_PERSON3", DataType.NVarChar, data.CONTACT_PERSON3.Value);
req.Parameters.Add("@REMARK3", DataType.NVarChar, data.REMARK3.Value);
req.Parameters.Add("@ALLOW_NEGATIVE", DataType.NVarChar, data.ALLOW_NEGATIVE.Value);
req.Parameters.Add("@OLD_DATA", DataType.Default, data.OLD_DATA.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
/// <summary>
/// Update record by using the table's primary key.
/// </summary>
/// <param name="database"></param>
/// <param name="data">Data which to update.</param>
/// <param name="oldLOC_CD">Old Key #1</param>
/// <returns></returns>
public int UpdateWithPK(Database database, DealingDTO data, String oldLOC_CD)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" UPDATE " + data.TableName);
sb.AppendLine(" SET ");
sb.AppendLine(" " + DealingDTO.eColumns.UPD_BY + "=@UPD_BY");
sb.AppendLine(" ," + DealingDTO.eColumns.UPD_DATE + "=GETDATE()");
sb.AppendLine(" ," + DealingDTO.eColumns.UPD_MACHINE + "=@UPD_MACHINE");
sb.AppendLine(" ," + DealingDTO.eColumns.LOC_CD + "=@LOC_CD");
sb.AppendLine(" ," + DealingDTO.eColumns.LOC_DESC + "=@LOC_DESC");
sb.AppendLine(" ," + DealingDTO.eColumns.LOC_CLS + "=@LOC_CLS");
sb.AppendLine(" ," + DealingDTO.eColumns.TERM_OF_PAYMENT + "=@TERM_OF_PAYMENT");
sb.AppendLine(" ," + DealingDTO.eColumns.INVOICE_PATTERN + "=@INVOICE_PATTERN");
sb.AppendLine(" ," + DealingDTO.eColumns.ADDRESS1 + "=@ADDRESS1");
sb.AppendLine(" ," + DealingDTO.eColumns.TEL1 + "=@TEL1");
sb.AppendLine(" ," + DealingDTO.eColumns.FAX1 + "=@FAX1");
sb.AppendLine(" ," + DealingDTO.eColumns.EMAIL1 + "=@EMAIL1");
sb.AppendLine(" ," + DealingDTO.eColumns.CONTACT_PERSON1 + "=@CONTACT_PERSON1");
sb.AppendLine(" ," + DealingDTO.eColumns.REMARK1 + "=@REMARK1");
sb.AppendLine(" ," + DealingDTO.eColumns.ADDRESS2 + "=@ADDRESS2");
sb.AppendLine(" ," + DealingDTO.eColumns.TEL2 + "=@TEL2");
sb.AppendLine(" ," + DealingDTO.eColumns.FAX2 + "=@FAX2");
sb.AppendLine(" ," + DealingDTO.eColumns.EMAIL2 + "=@EMAIL2");
sb.AppendLine(" ," + DealingDTO.eColumns.CONTACT_PERSON2 + "=@CONTACT_PERSON2");
sb.AppendLine(" ," + DealingDTO.eColumns.REMARK2 + "=@REMARK2");
sb.AppendLine(" ," + DealingDTO.eColumns.ADDRESS3 + "=@ADDRESS3");
sb.AppendLine(" ," + DealingDTO.eColumns.TEL3 + "=@TEL3");
sb.AppendLine(" ," + DealingDTO.eColumns.FAX3 + "=@FAX3");
sb.AppendLine(" ," + DealingDTO.eColumns.EMAIL3 + "=@EMAIL3");
sb.AppendLine(" ," + DealingDTO.eColumns.CONTACT_PERSON3 + "=@CONTACT_PERSON3");
sb.AppendLine(" ," + DealingDTO.eColumns.REMARK3 + "=@REMARK3");
sb.AppendLine(" ," + DealingDTO.eColumns.ALLOW_NEGATIVE + "=@ALLOW_NEGATIVE");
sb.AppendLine(" ," + DealingDTO.eColumns.OLD_DATA + "=@OLD_DATA");
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + DealingDTO.eColumns.LOC_CD + "=@oldLOC_CD");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("@UPD_BY", DataType.NVarChar, data.UPD_BY.Value);
req.Parameters.Add("@UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value);
req.Parameters.Add("@LOC_CD", DataType.NVarChar, data.LOC_CD.Value);
req.Parameters.Add("@LOC_DESC", DataType.NVarChar, data.LOC_DESC.Value);
req.Parameters.Add("@LOC_CLS", DataType.NVarChar, data.LOC_CLS.Value);
req.Parameters.Add("@TERM_OF_PAYMENT", DataType.NVarChar, data.TERM_OF_PAYMENT.Value);
req.Parameters.Add("@INVOICE_PATTERN", DataType.NVarChar, data.INVOICE_PATTERN.Value);
req.Parameters.Add("@ADDRESS1", DataType.NVarChar, data.ADDRESS1.Value);
req.Parameters.Add("@TEL1", DataType.NVarChar, data.TEL1.Value);
req.Parameters.Add("@FAX1", DataType.NVarChar, data.FAX1.Value);
req.Parameters.Add("@EMAIL1", DataType.NVarChar, data.EMAIL1.Value);
req.Parameters.Add("@CONTACT_PERSON1", DataType.NVarChar, data.CONTACT_PERSON1.Value);
req.Parameters.Add("@REMARK1", DataType.NVarChar, data.REMARK1.Value);
req.Parameters.Add("@ADDRESS2", DataType.NVarChar, data.ADDRESS2.Value);
req.Parameters.Add("@TEL2", DataType.NVarChar, data.TEL2.Value);
req.Parameters.Add("@FAX2", DataType.NVarChar, data.FAX2.Value);
req.Parameters.Add("@EMAIL2", DataType.NVarChar, data.EMAIL2.Value);
req.Parameters.Add("@CONTACT_PERSON2", DataType.NVarChar, data.CONTACT_PERSON2.Value);
req.Parameters.Add("@REMARK2", DataType.NVarChar, data.REMARK2.Value);
req.Parameters.Add("@ADDRESS3", DataType.NVarChar, data.ADDRESS3.Value);
req.Parameters.Add("@TEL3", DataType.NVarChar, data.TEL3.Value);
req.Parameters.Add("@FAX3", DataType.NVarChar, data.FAX3.Value);
req.Parameters.Add("@EMAIL3", DataType.NVarChar, data.EMAIL3.Value);
req.Parameters.Add("@CONTACT_PERSON3", DataType.NVarChar, data.CONTACT_PERSON3.Value);
req.Parameters.Add("@REMARK3", DataType.NVarChar, data.REMARK3.Value);
req.Parameters.Add("@ALLOW_NEGATIVE", DataType.NVarChar, data.ALLOW_NEGATIVE.Value);
req.Parameters.Add("@OLD_DATA", DataType.Default, data.OLD_DATA.Value);
req.Parameters.Add("@oldLOC_CD", DataType.NVarChar, oldLOC_CD);
#endregion
return(db.ExecuteNonQuery(req));
}
private SalesUnitPriceUIDM MapDTOToModel(SalesUnitPriceDTO Price, ItemDTO Item, DealingDTO Customer)
{
SalesUnitPriceUIDM model = new SalesUnitPriceUIDM();
model.CRT_BY = Price.CRT_BY;
model.CRT_DATE = Price.CRT_DATE;
model.CRT_MACHINE = Price.CRT_MACHINE;
model.UPD_BY = Price.UPD_BY;
model.UPD_DATE = Price.UPD_DATE;
model.UPD_MACHINE = Price.UPD_MACHINE;
model.ITEM_CD = Price.ITEM_CD;
model.START_EFFECTIVE_DATE = Price.START_EFFECTIVE_DATE;
model.PRICE = Price.PRICE;
model.CURRENCY = Price.CURRENCY;
model.REMARK = Price.REMARK;
model.OLD_DATA = Price.OLD_DATA;
if (Item != null && !Item.ITEM_DESC.IsNull)
{
model.SHORT_NAME = Item.SHORT_NAME;
}
if (Customer != null && !Customer.LOC_DESC.IsNull)
{
model.CUSTOMER_NAME = Customer.LOC_DESC;
}
return(model);
}
