/// <summary>
/// Check date format is empty.
/// </summary>
/// <param name="dateFormat"></param>
/// <returns></returns>
public ErrorItem CheckRequireDefaultDateFormat(NZInt dateFormat)
{
if (dateFormat.IsNull)
{
return(new ErrorItem(dateFormat.Owner, Messages.eValidate.VLM9005.ToString()));
}
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="date"></param>
/// <param name="Location"></param>
/// <param name="itemCode"></param>
/// <param name="ReuseZeroQty">Lot ที่ลบทิ้ง สามารถนำมาใช้ใหม่ได้ Ex. Receive Lot 001 , 002 ,003 เข้าไปแล้ว ลบ Lot 003ทิ้ง จะสามารถใช้ Lot003 ซ้ำได้</param>
/// <returns></returns>
public NZString GetCompleteLotNo(NZDateTime date, NZString Location, NZString itemCode, NZInt ReuseZeroQty)
{
NZString strLotNoPrefix = this.GenerateLotNoPrefix(date);
NZInt iLastRunningNo = this.GetLastLotNoRunningBox(strLotNoPrefix, Location, itemCode, ReuseZeroQty);
iLastRunningNo.Value = iLastRunningNo.StrongValue + 1;
string strFinalLotNo = strLotNoPrefix.ToString() + iLastRunningNo.StrongValue.ToString("00");
return(new NZString(null, strFinalLotNo));
}
/// <summary>
///
/// </summary>
/// <param name="strLotNoPrefix"></param>
/// <param name="strLocationCode"></param>
/// <param name="strItemCode"></param>
/// <param name="ReuseZeroQty">Lot ที่ลบทิ้ง สามารถนำมาใช้ใหม่ได้ Ex. Receive Lot 001 , 002 ,003 เข้าไปแล้ว ลบ Lot 003ทิ้ง จะสามารถใช้ Lot003 ซ้ำได้</param>
/// <returns></returns>
public NZInt GetLastLotNoRunningBox(NZString strLotNoPrefix, NZString strLocationCode, NZString strItemCode, NZInt ReuseZeroQty)
{
NZInt LastRunningNo = new NZInt();
RunningNumberDAO dao = new RunningNumberDAO(CommonLib.Common.CurrentDatabase);
LastRunningNo = dao.GetLastLotNoRunningBox(strLotNoPrefix, strLocationCode, strItemCode, ReuseZeroQty);
return(LastRunningNo);
}
public static ErrorItem CheckPurchaseOrderItem(NZInt iCheck)
{
if (iCheck == 0)
{
return(new ErrorItem(iCheck.Owner, Messages.eValidate.VLM0125.ToString()));
}
else
{
return(null);
}
}
public static ErrorItem CheckRecord(NZInt iRow)
{
if (iRow == 0)
{
return(new ErrorItem(iRow.Owner, Messages.eValidate.VLM0151.ToString()));
}
else
{
return(null);
}
}
public static ErrorItem CheckEmptyDemandMonth(NZInt iNoOfMonth)
{
if (iNoOfMonth > 120 || iNoOfMonth < 1)
{
return(new ErrorItem(iNoOfMonth.Owner, Messages.eValidate.VLM0139.ToString()));
}
else
{
return(null);
}
}
/// <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="oldORDER_ID">Old Key #1</param>
/// <returns></returns>
public int UpdateWithPK(Database database, DemandOrderDTO data, NZInt oldORDER_ID)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" UPDATE " + data.TableName);
sb.AppendLine(" SET ");
sb.AppendLine(" " + DemandOrderDTO.eColumns.UPD_BY + "=:UPD_BY");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.UPD_DATE + "=GETDATE()");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.IS_ACTIVE + "=:IS_ACTIVE");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.REVISION + "=:REVISION");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.YEAR_MONTH + "=:YEAR_MONTH");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.CUSTOMER_CD + "=:CUSTOMER_CD");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.ORDER_ID + "=:ORDER_ID");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.DUE_DATE + "=:DUE_DATE");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.ITEM_CD + "=:ITEM_CD");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.ORDER_QTY + "=:ORDER_QTY");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.ORDER_TYPE + "=:ORDER_TYPE");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.PRIORITY + "=:PRIORITY");
sb.AppendLine(" ," + DemandOrderDTO.eColumns.Reserve + "=:Reserve");
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + DemandOrderDTO.eColumns.ORDER_ID + "=:oldORDER_ID");
#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("IS_ACTIVE", DataType.Default, data.IS_ACTIVE.Value);
req.Parameters.Add("REVISION", DataType.Number, data.REVISION.Value);
req.Parameters.Add("YEAR_MONTH", DataType.Default, data.YEAR_MONTH.Value);
req.Parameters.Add("CUSTOMER_CD", DataType.NVarChar, data.CUSTOMER_CD.Value);
req.Parameters.Add("ORDER_ID", DataType.Default, data.ORDER_ID.Value);
req.Parameters.Add("DUE_DATE", DataType.DateTime, data.DUE_DATE.Value);
req.Parameters.Add("ITEM_CD", DataType.NVarChar, data.ITEM_CD.Value);
req.Parameters.Add("ORDER_QTY", DataType.Number, data.ORDER_QTY.Value);
req.Parameters.Add("ORDER_TYPE", DataType.NVarChar, data.ORDER_TYPE.Value);
req.Parameters.Add("PRIORITY", DataType.NVarChar, data.PRIORITY.Value);
req.Parameters.Add("Reserve", DataType.NVarChar, data.Reserve.Value);
req.Parameters.Add("oldORDER_ID", DataType.Default, oldORDER_ID.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
/// <summary>
/// Load with specified primary key.
/// </summary>
/// <param name="database"></param>
/// <param name="ITEM_CD">Key #1</param>
/// <param name="ITEM_SEQ">Key #2</param>
/// <returns></returns>
public ItemProcessDTO LoadByPK(Database database, NZInt ITEM_CD, NZInt ITEM_SEQ)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(ItemProcessDTO));
sb.AppendLine(" SELECT ");
//sb.AppendLine(" " + ItemProcessDTO.eColumns.CRT_BY);
//sb.AppendLine(" ," + ItemProcessDTO.eColumns.CRT_DATE);
//sb.AppendLine(" ," + ItemProcessDTO.eColumns.CRT_MACHINE);
//sb.AppendLine(" ," + ItemProcessDTO.eColumns.UPD_BY);
//sb.AppendLine(" ," + ItemProcessDTO.eColumns.UPD_DATE);
//sb.AppendLine(" ," + ItemProcessDTO.eColumns.UPD_MACHINE);
//sb.AppendLine(" ," + ItemProcessDTO.eColumns.ITEM_CD);
sb.AppendLine(" ," + ItemProcessDTO.eColumns.ITEM_SEQ);
sb.AppendLine(" ," + ItemProcessDTO.eColumns.PROCESS_CD);
sb.AppendLine(" ," + ItemProcessDTO.eColumns.WEIGHT);
sb.AppendLine(" ," + ItemProcessDTO.eColumns.PRODUCTION_LEADTIME);
sb.AppendLine(" ," + ItemProcessDTO.eColumns.QTY_PER_DAY);
sb.AppendLine(" ," + ItemProcessDTO.eColumns.SUPPLIER_CD);
//sb.AppendLine(" ," + ItemProcessDTO.eColumns.OLD_DATA);
//sb.AppendLine(" ," + ItemProcessDTO.eColumns.TIME_STAMP);
sb.AppendLine(" FROM " + tableName);
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + ItemProcessDTO.eColumns.ITEM_CD + "=@ITEM_CD");
sb.AppendLine(" AND " + ItemProcessDTO.eColumns.ITEM_SEQ + "=@ITEM_SEQ");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("@ITEM_CD", DataType.Default, ITEM_CD);
req.Parameters.Add("@ITEM_SEQ", DataType.Default, ITEM_SEQ);
#endregion
List <ItemProcessDTO> list = db.ExecuteForList <ItemProcessDTO>(req);
if (list != null && list.Count > 0)
{
return(list[0]);
}
return(null);
}
/// <summary>
/// Load with specified primary key.
/// </summary>
/// <param name="database"></param>
/// <param name="ITEM_CD">Key #1</param>
/// <param name="START_EFFECTIVE_DATE">Key #2</param>
/// <param name="CURRENCY">Key #3</param>
/// <returns></returns>
public SalesUnitPriceDTO LoadByPK(Database database, NZInt ITEM_CD, NZDateTime START_EFFECTIVE_DATE, NZString CURRENCY)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(SalesUnitPriceDTO));
sb.AppendLine(" SELECT ");
sb.AppendLine(" " + SalesUnitPriceDTO.eColumns.CRT_BY);
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.CRT_DATE);
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.CRT_MACHINE);
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.UPD_BY);
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.UPD_DATE);
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.UPD_MACHINE);
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.ITEM_CD);
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.START_EFFECTIVE_DATE);
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.PRICE);
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.CURRENCY);
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.REMARK);
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.OLD_DATA);
//sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.TIME_STAMP);
sb.AppendLine(" FROM " + tableName);
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + SalesUnitPriceDTO.eColumns.ITEM_CD + "=@ITEM_CD");
sb.AppendLine(" AND " + SalesUnitPriceDTO.eColumns.START_EFFECTIVE_DATE + "=@START_EFFECTIVE_DATE");
sb.AppendLine(" AND " + SalesUnitPriceDTO.eColumns.CURRENCY + "=@CURRENCY");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("@ITEM_CD", DataType.Default, ITEM_CD.Value);
req.Parameters.Add("@START_EFFECTIVE_DATE", DataType.DateTime, START_EFFECTIVE_DATE.Value);
req.Parameters.Add("@CURRENCY", DataType.NVarChar, CURRENCY.Value);
#endregion
List <SalesUnitPriceDTO> list = db.ExecuteForList <SalesUnitPriceDTO>(req);
if (list != null && list.Count > 0)
{
return(list[0]);
}
return(null);
}
/// <summary>
/// Load with specified primary key.
/// </summary>
/// <param name="database"></param>
/// <param name="ORDER_ID">Key #1</param>
/// <returns></returns>
public DemandOrderDTO LoadByPK(Database database, NZInt ORDER_ID)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(DemandOrderDTO));
sb.AppendLine(" SELECT ");
sb.AppendLine(" " + DemandOrderDTO.eColumns.CRT_BY);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.CRT_DATE);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.CRT_MACHINE);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.UPD_BY);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.UPD_DATE);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.UPD_MACHINE);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.IS_ACTIVE);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.REVISION);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.YEAR_MONTH);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.CUSTOMER_CD);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.ORDER_ID);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.DUE_DATE);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.ITEM_CD);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.ORDER_QTY);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.ORDER_TYPE);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.PRIORITY);
sb.AppendLine(" ," + DemandOrderDTO.eColumns.Reserve);
sb.AppendLine(" FROM " + tableName);
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + DemandOrderDTO.eColumns.ORDER_ID + "=:ORDER_ID");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("ORDER_ID", DataType.Default, ORDER_ID.Value);
#endregion
List <DemandOrderDTO> list = db.ExecuteForList <DemandOrderDTO>(req);
if (list != null && list.Count > 0)
{
return(list[0]);
}
return(null);
}
private void fpView_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
if (shtView.Rows.Count == 0)
{
return;
}
if (shtView.ActiveRowIndex < 0)
{
return;
}
int ActiveRow = shtView.ActiveRowIndex;
NZString YearMonth = new NZString(null, shtView.Cells[ActiveRow, (int)eColView.YEAR_MONTH].Value);
NZString LocationCD = new NZString(null, shtView.Cells[ActiveRow, (int)eColView.LOCATION].Value);
NZString ItemCD = new NZString(null, shtView.Cells[ActiveRow, (int)eColView.ITEM_CODE].Value);
NZString LotNo = new NZString(null, shtView.Cells[ActiveRow, (int)eColView.LOT_NO].Value);
NZString PackNo = new NZString(null, shtView.Cells[ActiveRow, (int)eColView.PACK_NO].Value);
NZInt QueryType = new NZInt(null, shtView.Cells[ActiveRow, (int)eColView.QUERY_TYPE].Value);
NZDateTime BeginDate = new NZDateTime(null, dtPeriodBegin.Value);
NZDateTime EndDate = new NZDateTime(null, dtPeriodEnd.Value);
// Validate period date before show inventory movement
InventoryOnhandInquiryValidator validator = new InventoryOnhandInquiryValidator();
try
{
if (chkToEndMonth.Checked)
{
validator.ValidatePeriodDateRange(BeginDate, EndDate);
}
}
catch (ValidateException err)
{
MessageDialog.ShowBusiness(this, err.ErrorResults[0].Message);
err.ErrorResults[0].FocusOnControl();
return;
}
INV020_InventoryMovementInquiry frmInventoryMovementInquiry = new INV020_InventoryMovementInquiry(
YearMonth, LocationCD, ItemCD, LotNo, PackNo, BeginDate, EndDate, QueryType);
frmInventoryMovementInquiry.ShowDialog();
}
/// <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="oldITEM_CD">Old Key #1</param>
/// <param name="oldITEM_SEQ">Old Key #2</param>
/// <returns></returns>
public int UpdateWithPK(Database database, ItemProcessDTO data, NZInt oldITEM_CD, NZInt oldITEM_SEQ)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" UPDATE " + data.TableName);
sb.AppendLine(" SET ");
sb.AppendLine(" " + ItemProcessDTO.eColumns.UPD_BY + "=@UPD_BY");
sb.AppendLine(" ," + ItemProcessDTO.eColumns.UPD_DATE + "=GETDATE()");
sb.AppendLine(" ," + ItemProcessDTO.eColumns.UPD_MACHINE + "=@UPD_MACHINE");
sb.AppendLine(" ," + ItemProcessDTO.eColumns.ITEM_CD + "=@ITEM_CD");
sb.AppendLine(" ," + ItemProcessDTO.eColumns.ITEM_SEQ + "=@ITEM_SEQ");
sb.AppendLine(" ," + ItemProcessDTO.eColumns.PROCESS_CD + "=@PROCESS_CD");
sb.AppendLine(" ," + ItemProcessDTO.eColumns.WEIGHT + "=@WEIGHT");
sb.AppendLine(" ," + ItemProcessDTO.eColumns.PRODUCTION_LEADTIME + "=@PRODUCTION_LEADTIME");
sb.AppendLine(" ," + ItemProcessDTO.eColumns.QTY_PER_DAY + "=@QTY_PER_DAY");
sb.AppendLine(" ," + ItemProcessDTO.eColumns.SUPPLIER_CD + "=@SUPPLIER_CD");
sb.AppendLine(" ," + ItemProcessDTO.eColumns.OLD_DATA + "=@OLD_DATA");
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + ItemProcessDTO.eColumns.ITEM_CD + "=@oldITEM_CD");
sb.AppendLine(" AND " + ItemProcessDTO.eColumns.ITEM_SEQ + "=@oldItemProcess");
#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("@ITEM_CD", DataType.Default, data.ITEM_CD.Value);
req.Parameters.Add("@ITEM_SEQ", DataType.Default, data.ITEM_SEQ.Value);
req.Parameters.Add("@PROCESS_CD", DataType.NVarChar, data.PROCESS_CD.Value);
req.Parameters.Add("@WEIGHT", DataType.Number, data.WEIGHT.Value);
req.Parameters.Add("@PRODUCTION_LEADTIME", DataType.Default, data.PRODUCTION_LEADTIME.Value);
req.Parameters.Add("@QTY_PER_DAY", DataType.Number, data.QTY_PER_DAY.Value);
req.Parameters.Add("@SUPPLIER_CD", DataType.NVarChar, data.SUPPLIER_CD.Value);
req.Parameters.Add("@OLD_DATA", DataType.Default, data.OLD_DATA.Value);
req.Parameters.Add("@oldITEM_CD", DataType.Default, oldITEM_CD);
req.Parameters.Add("@oldITEM_SEQ", DataType.Default, oldITEM_SEQ);
#endregion
return(db.ExecuteNonQuery(req));
}
//private void tsbRefresh_Click(object sender, EventArgs e)
//{
// LoadData(dtPeriodBegin.NZValue, dtPeriodEnd.NZValue);
//}
public override void OnRefresh()
{
base.OnRefresh();
NZInt dateType = null;
int iDateValue = 0;
object oDateValue = cboFilterDate.SelectedValue;
if (oDateValue != null && Int32.TryParse(oDateValue.ToString(), out iDateValue))
{
dateType = new NZInt(null, iDateValue);
}
else
{
dateType = new NZInt(null, 1);
}
LoadData(dtPeriodBegin.NZValue, dtPeriodEnd.NZValue, dateType);
}
/// <summary>
/// Load with specified primary key.
/// </summary>
/// <param name="database"></param>
/// <param name="ITEM_CD">Key #1</param>
/// <param name="RUN_NO">Key #2</param>
/// <returns></returns>
public ItemMachineDTO LoadByPK(Database database, NZString ITEM_CD, NZInt RUN_NO)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(ItemMachineDTO));
sb.AppendLine(" SELECT ");
sb.AppendLine(" " + ItemMachineDTO.eColumns.CRT_BY);
sb.AppendLine(" ," + ItemMachineDTO.eColumns.CRT_DATE);
sb.AppendLine(" ," + ItemMachineDTO.eColumns.CRT_MACHINE);
sb.AppendLine(" ," + ItemMachineDTO.eColumns.UPD_BY);
sb.AppendLine(" ," + ItemMachineDTO.eColumns.UPD_DATE);
sb.AppendLine(" ," + ItemMachineDTO.eColumns.UPD_MACHINE);
sb.AppendLine(" ," + ItemMachineDTO.eColumns.ITEM_CD);
sb.AppendLine(" ," + ItemMachineDTO.eColumns.RUN_NO);
sb.AppendLine(" ," + ItemMachineDTO.eColumns.MACHINE_PROCESS);
sb.AppendLine(" ," + ItemMachineDTO.eColumns.MACHINE_TYPE);
sb.AppendLine(" ," + ItemMachineDTO.eColumns.OLD_DATA);
sb.AppendLine(" ," + ItemMachineDTO.eColumns.TIME_STAMP);
sb.AppendLine(" FROM " + tableName);
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + ItemMachineDTO.eColumns.ITEM_CD + "=@ITEM_CD");
sb.AppendLine(" AND " + ItemMachineDTO.eColumns.RUN_NO + "=@RUN_NO");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("@ITEM_CD", DataType.Default, ITEM_CD);
req.Parameters.Add("@RUN_NO", DataType.Default, RUN_NO);
#endregion
List <ItemMachineDTO> list = db.ExecuteForList <ItemMachineDTO>(req);
if (list != null && list.Count > 0)
{
return(list[0]);
}
return(null);
}
public ErrorItem CheckDefaultDateFormat(NZInt DefaultDateFormat)
{
if (DefaultDateFormat.IsNull)
{
ErrorItem item = null;
if (DefaultDateFormat.Owner is EVOFramework.Windows.Forms.EVOComboBox)
{
EVOFramework.Windows.Forms.EVOComboBox cbo = (EVOFramework.Windows.Forms.EVOComboBox)DefaultDateFormat.Owner;
if (cbo.Text != string.Empty)
{
item = new ErrorItem(DefaultDateFormat.Owner, Messages.eValidate.VLM9008.ToString());
return(item);
}
}
item = new ErrorItem(DefaultDateFormat.Owner, Messages.eValidate.VLM9005.ToString());
return(item);
}
return(null);
}
/// <summary>
/// Delete record with key.
/// </summary>
/// <param name="database"></param>
/// <param name="ORDER_ID">Key #1</param>
/// <returns></returns>
public int Delete(Database database, NZInt ORDER_ID)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(DemandOrderDTO));
sb.AppendLine(" DELETE FROM " + tableName);
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + DemandOrderDTO.eColumns.ORDER_ID + "=:ORDER_ID");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("ORDER_ID", DataType.Default, ORDER_ID.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
public void AddMenuSubItems(NZString MENU_SUB_CD, params NZString[] SCREEN_CDs)
{
Database db = CommonLib.Common.CurrentDatabase;
db.KeepConnection = true;
db.BeginTransaction();
try
{
IMenuSubItemDAO dao = DAOFactory.CreateMenuSubItemDAO(db);
for (int i = 0; i < SCREEN_CDs.Length; i++)
{
// Get new seq of MenuSubItem;
NZInt seq = dao.GetNewSequenceNo(null, MENU_SUB_CD);
MenuSubItemDTO data = new MenuSubItemDTO();
data.MENU_SUB_CD = MENU_SUB_CD;
data.SCREEN_CD = SCREEN_CDs[i];
data.DISP_SEQ = seq;
data.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
data.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
data.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
data.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
dao.AddNew(null, data);
}
db.Commit();
}
catch (Exception err)
{
db.Rollback();
throw err;
}
finally
{
if (db.DBConnectionState == ConnectionState.Open)
{
db.Close();
}
}
}
/// <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="oldITEM_CD">Old Key #1</param>
/// <param name="oldSTART_EFFECTIVE_DATE">Old Key #2</param>
/// <param name="oldCURRENCY">Old Key #3</param>
/// <returns></returns>
public int UpdateWithPK(Database database, SalesUnitPriceDTO data, NZInt oldITEM_CD, DateTime oldSTART_EFFECTIVE_DATE, String oldCURRENCY)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" UPDATE " + data.TableName);
sb.AppendLine(" SET ");
sb.AppendLine(" " + SalesUnitPriceDTO.eColumns.UPD_BY + "=@UPD_BY");
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.UPD_DATE + "=GETDATE()");
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.UPD_MACHINE + "=@UPD_MACHINE");
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.ITEM_CD + "=@ITEM_CD");
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.START_EFFECTIVE_DATE + "=@START_EFFECTIVE_DATE");
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.PRICE + "=@PRICE");
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.CURRENCY + "=@CURRENCY");
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.REMARK + "=@REMARK");
sb.AppendLine(" ," + SalesUnitPriceDTO.eColumns.OLD_DATA + "=@OLD_DATA");
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + SalesUnitPriceDTO.eColumns.ITEM_CD + "=@oldITEM_CD");
sb.AppendLine(" AND " + SalesUnitPriceDTO.eColumns.START_EFFECTIVE_DATE + "=@oldSalesUnitPrice");
sb.AppendLine(" AND " + SalesUnitPriceDTO.eColumns.CURRENCY + "=@oldSalesUnitPrice");
#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("@ITEM_CD", DataType.Default, data.ITEM_CD.Value);
req.Parameters.Add("@START_EFFECTIVE_DATE", DataType.DateTime, data.START_EFFECTIVE_DATE.Value);
req.Parameters.Add("@PRICE", DataType.Number, data.PRICE.Value);
req.Parameters.Add("@CURRENCY", DataType.NVarChar, data.CURRENCY.Value);
req.Parameters.Add("@REMARK", DataType.NVarChar, data.REMARK.Value);
req.Parameters.Add("@OLD_DATA", DataType.Default, data.OLD_DATA.Value);
req.Parameters.Add("@oldITEM_CD", DataType.Default, oldITEM_CD);
req.Parameters.Add("@oldSTART_EFFECTIVE_DATE", DataType.DateTime, oldSTART_EFFECTIVE_DATE);
req.Parameters.Add("@oldCURRENCY", DataType.NVarChar, oldCURRENCY);
#endregion
return(db.ExecuteNonQuery(req));
}
private void OnEdit()
{
if (!ActivePermission.Edit)
{
return;
}
NZString strMRPNo = new NZString(null, shtView.Cells[shtView.ActiveRowIndex, (int)eColView.MRP_NO].Value);
NZString strItemCD = new NZString(null, shtView.Cells[shtView.ActiveRowIndex, (int)eColView.ITEM_CD].Value);
NZString strLocCD = new NZString(null, shtView.Cells[shtView.ActiveRowIndex, (int)eColView.ORDER_LOC_CD].Value);
NZInt iRevision = new NZInt(null, shtView.Cells[shtView.ActiveRowIndex, (int)eColView.REVISION_NO].Value);
NZDateTime dtmPeriodFrom = new NZDateTime(null, dtPeriodBegin.Value);
NZDateTime dtmPeriodTo = new NZDateTime(null, dtPeriodEnd.Value);
MRP030_MRPMaintenance MRP020 = new MRP030_MRPMaintenance(strMRPNo, iRevision, strItemCD, strLocCD, dtmPeriodFrom, dtmPeriodTo);
if (MRP020.ShowDialog(null) == DialogResult.OK)
{
LoadData(dtPeriodBegin.NZValue, dtPeriodEnd.NZValue);
}
}
/// <summary>
/// Delete record with key.
/// </summary>
/// <param name="database"></param>
/// <param name="ITEM_CD">Key #1</param>
/// <param name="RUN_NO">Key #2</param>
/// <returns></returns>
public int Delete(Database database, NZString ITEM_CD, NZInt RUN_NO)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(ItemMachineDTO));
sb.AppendLine(" DELETE FROM " + tableName);
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + ItemMachineDTO.eColumns.ITEM_CD + "=@ITEM_CD");
sb.AppendLine(" AND " + ItemMachineDTO.eColumns.RUN_NO + "=@RUN_NO");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("@ITEM_CD", DataType.Default, ITEM_CD);
req.Parameters.Add("@RUN_NO", DataType.Default, RUN_NO);
#endregion
return(db.ExecuteNonQuery(req));
}
private void dtReceiveDate_ValueChanged(object sender, EventArgs e)
{
if (dtReceiveDate.Value.HasValue)
{
int row = shtView.Rows.Count;
if (row > 0)
{
RunningNumberBIZ runningNoBiz = new RunningNumberBIZ();
for (int i = 0; i < row; i++)
{
//shtView.Cells[i, (int)eColView.LOT_NO].Value = dtReceiveDate.Value.Value.ToString(DataDefine.LOT_NO_FORMAT);
string oLotControlCls = Convert.ToString(shtView.Cells[i, (int)eColView.LOT_CONTROL_CLS].Value);
string strItemCode = Convert.ToString(shtView.Cells[i, (int)eColView.ITEM_CD].Value);
if (oLotControlCls == DataDefine.Convert2ClassCode(DataDefine.eLOT_CONTROL_CLS.Yes))
{
//shtView.Cells[row, (int)eColView.LOT_NO].Value = dtReceiveDate.Value.Value.ToString(DataDefine.LOT_NO_FORMAT);
if (rdoReceive.Checked)
{
NZString strLotNoPrefix = runningNoBiz.GenerateLotNoPrefix(new NZDateTime(null, dtReceiveDate.Value));
NZInt iLastRunningNo = runningNoBiz.GetLastLotNoRunningBox(strLotNoPrefix, new NZString(cboStoredLoc, (string)cboStoredLoc.SelectedValue), (NZString)strItemCode, new NZInt(null, 0));
ReceivingEntryController rcvController = new ReceivingEntryController();
NZString strLotNo = rcvController.GenerateLotNo(strLotNoPrefix, ref iLastRunningNo);
shtView.Cells[i, (int)eColView.LOT_NO].Value = strLotNo.StrongValue;
}
}
else
{
shtView.Cells[i, (int)eColView.LOT_NO].Value = null;
}
}
}
}
}
public override void OnAddNew()
{
base.OnAddNew();
TRN190_CustomerOrderEntry dialog = new TRN190_CustomerOrderEntry();
if (dialog.ShowDialog(this) == DialogResult.OK)
{
NZInt dateType = null;
int iDateValue = 0;
object oDateValue = cboFilterDate.SelectedValue;
if (oDateValue != null && Int32.TryParse(oDateValue.ToString(), out iDateValue))
{
dateType = new NZInt(null, iDateValue);
}
else
{
dateType = new NZInt(null, 1);
}
LoadData(dtPeriodBegin.NZValue, dtPeriodEnd.NZValue, dateType);
}
}
private void LoadData(NZDateTime from, NZDateTime to, NZInt filterType)
{
if (dtPeriodBegin.NZValue.IsNull || dtPeriodEnd.NZValue.IsNull)
{
if (dtPeriodBegin.NZValue.IsNull && dtPeriodEnd.NZValue.IsNull)
{
MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Period date begin and Delivery date end" }));
}
else if (dtPeriodBegin.NZValue.IsNull)
{
MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Period date begin" }));
}
else
{
MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Period date end" }));
}
return;
}
CustomerOrderBIZ biz = new CustomerOrderBIZ();
DataTable dt = DTOUtility.ConvertListToDataTable <CustomerOrderViewDTO>(biz.LoadCustomerOrderList(from, to, filterType, false));
shtCustomerOrderList.RowCount = 0;
shtCustomerOrderList.DataSource = null;
m_dtAllData = dt;
FindDataFromMemory();
CalculateTotal();
//List<InventoryTransactionViewDTO> list = m_controller.LoadReceivingList(from, to);
////DataTable dt = DTOUtility.ConvertListToDataTable(list);
//m_dtAllData = DTOUtility.ConvertListToDataTable(list);
//shtCustomerOrderList.RowCount = 0;
//shtCustomerOrderList.DataSource = null;
//FindDataFromMemory();
//shtView.DataSource = m_dtAllData;
// CtrlUtil.SpreadUpdateColumnSorting(shtView);
}
/// <summary>
/// Check exists the specified key.
/// </summary>
public bool Exist(Database database, NZString ITEM_CD, NZInt ITEM_SEQ)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(ItemProcessDTO));
sb.AppendLine(" SELECT TOP 1 1 ");
sb.AppendLine(" FROM " + tableName);
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + ItemProcessDTO.eColumns.ITEM_CD + "=@ITEM_CD");
sb.AppendLine(" AND " + ItemProcessDTO.eColumns.ITEM_SEQ + "=@ITEM_SEQ");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("@ITEM_CD", DataType.Default, ITEM_CD);
req.Parameters.Add("@ITEM_SEQ", DataType.Default, ITEM_SEQ);
#endregion
return(db.ExecuteQuery(req).Rows.Count > 0);
}
/// <summary>
/// Delete record with key.
/// </summary>
/// <param name="database"></param>
/// <param name="ITEM_CD">Key #1</param>
/// <param name="START_EFFECTIVE_DATE">Key #2</param>
/// <param name="CURRENCY">Key #3</param>
/// <returns></returns>
public int Delete(Database database, NZInt ITEM_CD, DateTime START_EFFECTIVE_DATE, String CURRENCY)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(SalesUnitPriceDTO));
sb.AppendLine(" DELETE FROM " + tableName);
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + SalesUnitPriceDTO.eColumns.ITEM_CD + "=@ITEM_CD");
sb.AppendLine(" AND " + SalesUnitPriceDTO.eColumns.START_EFFECTIVE_DATE + "=@START_EFFECTIVE_DATE");
sb.AppendLine(" AND " + SalesUnitPriceDTO.eColumns.CURRENCY + "=@CURRENCY");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("@ITEM_CD", DataType.Default, ITEM_CD);
req.Parameters.Add("@START_EFFECTIVE_DATE", DataType.DateTime, START_EFFECTIVE_DATE);
req.Parameters.Add("@CURRENCY", DataType.NVarChar, CURRENCY);
#endregion
return(db.ExecuteNonQuery(req));
}
/// <summary>
/// Update menu item sequence.
/// </summary>
/// <param name="menuSubCD"></param>
/// <param name="screenCD"></param>
/// <param name="newSequence"></param>
/// <returns></returns>
public int UpdateMenuItemSequence(NZString menuSubCD, NZString screenCD, NZInt newSequence)
{
MenuSubItemDAO dao = new MenuSubItemDAO(CommonLib.Common.CurrentDatabase);
return(dao.UpdateSequence(null, menuSubCD, screenCD, CommonLib.Common.CurrentUserInfomation.UserCD, CommonLib.Common.CurrentUserInfomation.Machine, newSequence));
}
public void GeneratePO(Database database, NZDateTime dtmFrom, NZDateTime dtmTo, NZString strItemCDFrom, NZString strItemCDTo,
NZString strLocCDFrom, NZString strLocCDTo, NZString strUser, NZString strMachine, NZInt iPOInterval)
{
Database db = UseDatabase(database);
DataRequest req = new DataRequest();
req.CommandText = "S_MRP022_GenerateTmpPO";
req.CommandType = CommandType.StoredProcedure;
req.Parameters.Add("@pDtm_DATE_FROM", DataType.DateTime, dtmFrom.IsNull ? (object)DBNull.Value : dtmFrom.Value);
req.Parameters.Add("@pDtm_DATE_TO", DataType.DateTime, dtmTo.IsNull ? (object)DBNull.Value : dtmTo.Value);
req.Parameters.Add("@pVar_ITEM_CD_FROM", DataType.NVarChar, strItemCDFrom.IsNull ? (object)DBNull.Value : strItemCDFrom.Value);
req.Parameters.Add("@pVar_ITEM_CD_TO", DataType.NVarChar, strItemCDTo.IsNull ? (object)DBNull.Value : strItemCDTo.Value);
req.Parameters.Add("@pVar_LOC_CD_FROM", DataType.NVarChar, strLocCDFrom.IsNull ? (object)DBNull.Value : strLocCDFrom.Value);
req.Parameters.Add("@pVar_LOC_CD_TO", DataType.NVarChar, strLocCDTo.IsNull ? (object)DBNull.Value : strLocCDTo.Value);
req.Parameters.Add("@pInt_PO_INTERVAL", DataType.Int32, iPOInterval.IsNull || "".Equals(iPOInterval.Value) ? (object)DBNull.Value : iPOInterval.Value);
req.Parameters.Add("@pVar_USER_CD", DataType.NVarChar, strUser.Value);
req.Parameters.Add("@pVar_MACHINE", DataType.NVarChar, strMachine.Value);
db.ExecuteNonQuery(req);
}
public bool checkDup(Database database, NZString CLS_INFO_CD, NZString CLS_CD, NZInt SEQ)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(ClassListDTO));
sb.AppendLine(" SELECT CLS_INFO_CD,CLS_CD,CLS_DESC,SEQ ");
sb.AppendLine(" FROM " + tableName);
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + ClassListDTO.eColumns.CLS_INFO_CD + "=:CLS_INFO_CD");
sb.AppendLine(" AND (" + ClassListDTO.eColumns.CLS_CD + "=:CLS_CD");
sb.AppendLine(" OR " + ClassListDTO.eColumns.SEQ + "=:SEQ )");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("CLS_INFO_CD", DataType.VarChar, CLS_INFO_CD.Value);
req.Parameters.Add("CLS_CD", DataType.VarChar, CLS_CD.Value);
req.Parameters.Add("SEQ", DataType.Int32, SEQ.Value);
#endregion
return(db.ExecuteQuery(req).Rows.Count > 0);
}
/// <summary>
///
/// </summary>
/// <param name="userCD"></param>
/// <param name="username"></param>
/// <param name="oldPassword"></param>
/// <param name="newPassword"></param>
/// <param name="confirmNewPassword"></param>
/// <param name="dateFormat"></param>
/// <param name="langCD"></param>
/// <returns></returns>
/// <exception cref="EVOFramework.ValidationException"><c>ValidateException</c>.</exception>
/// <exception cref="EVOFramework.BusinessException"><c>BusinessException</c>.</exception>
public bool ValidateChangeUserProfile(NZString userCD, NZString username, NZString oldPassword, NZString newPassword, NZString confirmNewPassword, NZInt dateFormat, NZInt langCD)
{
ValidateException validateException = new ValidateException();
ErrorItem errorItem = null;
errorItem = CheckRequireUsername(username);
if (errorItem != null)
{
validateException.AddError(errorItem);
}
errorItem = CheckRequireDefaultDateFormat(dateFormat);
if (errorItem != null)
{
validateException.AddError(errorItem);
}
errorItem = CheckRequireDefaultLanguage(langCD);
if (errorItem != null)
{
validateException.AddError(errorItem);
}
validateException.ThrowIfHasError();
//==== Business Checker
BizCheckChangePassword(userCD, oldPassword, newPassword, confirmNewPassword);
return(true);
}
private void GeneratePO(NZDateTime dtmFrom, NZDateTime dtmTo, NZString strItemCDFrom, NZString strItemCDTo, NZString strLocCDFrom, NZString strLocCDTo, NZInt iPOInterval)
{
Database db = null;
TmpPurchaseOrderDAO dao = null;
try {
db = Common.CurrentDatabase;
db.KeepConnection = true;
db.BeginTransaction(IsolationLevel.Serializable);
dao = new TmpPurchaseOrderDAO(db);
dao.GeneratePO(null, dtmFrom, dtmTo, strItemCDFrom, strItemCDTo, strLocCDFrom, strLocCDTo, Common.CurrentUserInfomation.UserCD, Common.CurrentUserInfomation.Machine, iPOInterval);
db.Commit();
}
catch (Exception) {
db.Rollback();
throw;
}
finally {
if (db.DBConnectionState == ConnectionState.Open)
{
db.Close();
}
}
}
