private void LoadData(NZDateTime from, NZDateTime to)
{
m_dtAllData = m_controller.LoadMovePartList(from, to);
shtMovePartList.RowCount = 0;
shtMovePartList.DataSource = null;
FindDataFromMemory();
}
private void LoadData(NZDateTime dtPeriod, string keyFilter)
{
try
{
//== Start to search data.
InventoryOnhandController ctlInvent = new InventoryOnhandController();
//== 20091203 Add by Teerayt S.
//NZString yearMonth = GetLatestYearMonthInInvOnhand();
NZString yearMonth = dtMonth.Value.Value.ToString("yyyyMM").ToNZString();
//== 20091203 End Add by Teerayt S.
//List<InventorySummaryViewDTO> dtoView = ctlInvent.LoadInventorySummary(yearMonth);
//m_dtAllData = DTOUtility.ConvertListToDataTable(dtoView);
m_dtAllData = ctlInvent.LoadInventorySummary(yearMonth);
FindDataFromMemory(keyFilter);
CtrlUtil.SpreadUpdateColumnSorting(shtInventorySummary);
}
catch (Exception ex)
{
MessageDialog.ShowBusiness(this, ex.Message);
}
}
public RPT010_PREVIEW(DataTable ReportData, NZDateTime BeginDate, NZDateTime EndDate)
{
InitializeComponent();
m_dt = ReportData;
m_BeginDate = BeginDate;
m_EndDate = EndDate;
}
public DataTable LoadCustomerOrderList(NZDateTime DateBegin, NZDateTime DateEnd, NZInt filterType, bool IncludeOldData)
{
DataTable dt = null;
Database db = m_db;
DataRequest req = new DataRequest("S_TRN180_LoadCustomerOrderList");
req.CommandType = CommandType.StoredProcedure;
req.Parameters.Add("@PERIOD_BEGIN_DATE", DataType.DateTime, CheckNull(DateBegin.StrongValue.Date));
req.Parameters.Add("@PERIOD_END_DATE", DataType.DateTime, CheckNull(DateEnd.StrongValue.Date));
req.Parameters.Add("@FILTER_TYPE", DataType.Int32, filterType.StrongValue);
if (!IncludeOldData)
{
req.Parameters.Add("@OLD_DATA", DataType.Int16, 0); //not include old value
}
DataSet ds = db.ExecuteDataSet(req);
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return(dt);
}
private bool SaveData()
{
try
{
InventoryPeriodController ctlInv = new InventoryPeriodController();
NZString YearMonth = new NZString(null, dtInventoryMonth.Value.Value.ToString("yyyyMM"));
NZDateTime PeriodBegin = new NZDateTime(null, dtPeriodFrom.Value);
NZDateTime PeriodEnd = new NZDateTime(null, dtPeriodTo.Value);
ctlInv.UpdatePeriod(YearMonth, PeriodBegin, PeriodEnd);
return(true);
}
catch (BusinessException err)
{
MessageDialog.ShowBusiness(this, err.Error.Message);
err.Error.FocusOnControl();
}
catch (ValidateException err)
{
MessageDialog.ShowBusiness(this, err.ErrorResults[0].Message);
err.ErrorResults[0].FocusOnControl();
}
catch (Exception err)
{
MessageDialog.ShowBusiness(this, err.Message);
}
return(false);
}
public ErrorItem CheckWorkResultDate(NZDateTime date)
{
if (date.IsNull)
{
return(new ErrorItem(date.Owner, TKPMessages.eValidate.VLM0046.ToString()));
}
InventoryPeriodBIZ biz = new InventoryPeriodBIZ();
InventoryPeriodDTO dto = biz.LoadCurrentPeriod();
if (dto == null)
{
return(new ErrorItem(date.Owner, TKPMessages.eValidate.VLM0047.ToString()));
}
// edit by tar
// AddMonths(1) to period end date
if (date.StrongValue.Date.CompareTo(dto.PERIOD_BEGIN_DATE.StrongValue.Date) < 0 ||
date.StrongValue.Date.CompareTo(dto.PERIOD_END_DATE.StrongValue.AddMonths(1).Date) > 0)
{
return(new ErrorItem(date.Owner, TKPMessages.eValidate.VLM0047.ToString()));
}
return(null);
}
/// <summary>
/// Check exists the specified key.
/// </summary>
public bool Exist(Database database, NZString CUSTOMER_CD, NZDateTime DUE_DATE, NZString ITEM_CD)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
string tableName = EVOFramework.Data.DTOUtility.ReadTableName(typeof(TmpDemandOrderDTO));
sb.AppendLine(" SELECT TOP 1 1 ");
sb.AppendLine(" FROM " + tableName);
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + TmpDemandOrderDTO.eColumns.CUSTOMER_CD + "=:CUSTOMER_CD");
sb.AppendLine(" AND " + TmpDemandOrderDTO.eColumns.DUE_DATE + "=:DUE_DATE");
sb.AppendLine(" AND " + TmpDemandOrderDTO.eColumns.ITEM_CD + "=:ITEM_CD");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("CUSTOMER_CD", DataType.NVarChar, CUSTOMER_CD.Value);
req.Parameters.Add("DUE_DATE", DataType.DateTime, DUE_DATE.Value);
req.Parameters.Add("ITEM_CD", DataType.NVarChar, ITEM_CD.Value);
#endregion
return(db.ExecuteQuery(req).Rows.Count > 0);
}
private void LoadData(NZDateTime from, NZDateTime to)
{
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[] { "Return date begin and Delivery date end" }));
}
else if (dtPeriodBegin.NZValue.IsNull)
{
MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Return date begin" }));
}
else
{
MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Return date end" }));
}
return;
}
DataTable dt = m_controller.Load_ReturnProductionList(from, to, false);
//DataTable dt = DTOUtility.ConvertListToDataTable(list);
m_dtAllData = dt;
shtReturnProductList.RowCount = 0;
shtReturnProductList.DataSource = null;
FindDataFromMemory();
//shtReturnProductList.DataSource = m_dtAllData;
CtrlUtil.SpreadUpdateColumnSorting(shtReturnProductList);
}
private void LoadData(NZDateTime dtDateFrom, string keyFilter)
{
try
{
if (dtDateFrom.IsNull)
{
shtInventorySummary.RowCount = 0;
MessageDialog.ShowBusiness(this, EVOFramework.Message.LoadMessage(TKPMessages.eValidate.VLM0224.ToString()));
return;
}
//== Start to search data.
SalesSummaryController ctlInvent = new SalesSummaryController();
//== 20091203 Add by Teerayt S.
//NZString yearMonth = GetLatestYearMonthInInvOnhand();
//== 20091203 End Add by Teerayt S.
//List<InventorySummaryViewDTO> dtoView = ctlInvent.LoadInventorySummary(yearMonth);
//m_dtAllData = DTOUtility.ConvertListToDataTable(dtoView);
m_dtAllData = ctlInvent.LoadSalesSummary(dtDateBegin.NZValue);
FindDataFromMemory(keyFilter);
}
catch (Exception ex)
{
MessageDialog.ShowBusiness(this, ex.Message);
}
}
private void LoadData(NZDateTime dtDateFrom, NZDateTime dtDateTo, string keyFilter)
{
try
{
//== Start to search data.
SalesSummaryController ctlInvent = new SalesSummaryController();
//== 20091203 Add by Teerayt S.
//NZString yearMonth = GetLatestYearMonthInInvOnhand();
//== 20091203 End Add by Teerayt S.
//List<InventorySummaryViewDTO> dtoView = ctlInvent.LoadInventorySummary(yearMonth);
//m_dtAllData = DTOUtility.ConvertListToDataTable(dtoView);
m_dtAllData = ctlInvent.LoadSalesSummary(dtDateBegin.NZValue, dtDateEnd.NZValue);
FindDataFromMemory(keyFilter);
}
catch (Exception ex)
{
MessageDialog.ShowBusiness(this, ex.Message);
}
}
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();
}
}
}
private void fpView_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
if (shtViewHeader.RowCount <= 0)
{
return;
}
NZString strMRPNo = new NZString(null, shtViewHeader.Cells[shtViewHeader.ActiveRowIndex, (int)eHeader.MRPNo].Value);
NZString strItemCD = new NZString(null, shtViewHeader.Cells[shtViewHeader.ActiveRowIndex, (int)eHeader.ItemCD].Value);
NZString strLocCD = new NZString(null, shtViewHeader.Cells[shtViewHeader.ActiveRowIndex, (int)eHeader.OrderLocCD].Value);
NZInt iRevision = new NZInt(null, shtViewHeader.Cells[shtViewHeader.ActiveRowIndex, (int)eHeader.Revision].Value);
DateTime dtm = new DateTime(dtpStartDate.Value.Value.Year, dtpStartDate.Value.Value.Month, 1);
NZDateTime dtmPeriodFrom = new NZDateTime(null, (dtm));
MRPBIZ biz = new MRPBIZ();
NZDateTime dtmPeriodTo = biz.GetMaxMRPDate();
MRP030_MRPMaintenance MRP030 = new MRP030_MRPMaintenance(strMRPNo, iRevision, strItemCD, strLocCD, dtmPeriodFrom, dtmPeriodTo);
if (MRP030.ShowDialog(null) == DialogResult.OK)
{
//Load New Data
if (!(string.Empty.Equals(txtMRPNo.Text)))
{
LoadData(txtMRPNo.Text.Trim());
}
}
}
public ErrorItem CheckIssueDate(NZDateTime IssueDate)
{
if (IssueDate.IsNull)
{
return(new ErrorItem(IssueDate.Owner, TKPMessages.eValidate.VLM0031.ToString()));
}
InventoryPeriodBIZ biz = new InventoryPeriodBIZ();
//NZString YearMonth = new NZString(IssueDate.Owner, IssueDate.StrongValue.ToString("yyyyMM"));
InventoryPeriodDTO dto = biz.LoadCurrentPeriod();
if (dto == null)
{
return(new ErrorItem(IssueDate.Owner, TKPMessages.eValidate.VLM0032.ToString()));
}
// edit by tar
// AddMonths(1) to period end date
if (dto.PERIOD_BEGIN_DATE.StrongValue.Date > IssueDate.StrongValue.Date ||
dto.PERIOD_END_DATE.StrongValue.AddMonths(1).Date < IssueDate.StrongValue.Date)
{
return(new ErrorItem(IssueDate.Owner, TKPMessages.eValidate.VLM0032.ToString()));
}
return(null);
}
private void fpView_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
if (shtInventorySummary.Rows.Count == 0)
{
return;
}
if (shtInventorySummary.ActiveRowIndex < 0)
{
return;
}
int ActiveRow = shtInventorySummary.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 ItemType = new NZString(null, shtView.Cells[ActiveRow, (int)eColView.ITEM_CLS].Value);
//NZInt QueryType = new NZInt(null, shtView.Cells[ActiveRow, (int)eColView.QUERY_TYPE].Value);
NZDateTime BeginDate = new NZDateTime(null, dtMonth.Value);
// Validate period date before show inventory movement
//InventoryOnhandInquiryValidator validator = new InventoryOnhandInquiryValidator();
//INV020_InventoryMovementInquiry frmInventoryMovementInquiry = new INV020_InventoryMovementInquiry(
// YearMonth, LocationCD, ItemCD, LotNo, BeginDate, EndDate, ItemType, QueryType);
//frmInventoryMovementInquiry.ShowDialog();
}
public List <DeliveryViewDTO> Load_OrderMaintenance(NZDateTime DateBegin
, NZDateTime DateEnd
, NZString CustomerCd
, NZString Currency
, NZString SlipNo
, bool IncludeOldData)
{
Database db = m_db;
DataRequest req = new DataRequest("S_TRN120_OrderMaintenance_Load");
req.CommandType = CommandType.StoredProcedure;
req.Parameters.Add("@PERIOD_BEGIN_DATE", DataType.DateTime, CheckNull(DateBegin.StrongValue.Date));
req.Parameters.Add("@PERIOD_END_DATE", DataType.DateTime, CheckNull(DateEnd.StrongValue.Date));
req.Parameters.Add("@CUSTOMER_CD", DataType.NVarChar, CheckNull(CustomerCd.StrongValue));
req.Parameters.Add("@CURRENCY", DataType.NVarChar, CheckNull(Currency.StrongValue));
if (!SlipNo.IsNull)
{
req.Parameters.Add("@SLIP_NO", DataType.NVarChar, CheckNull(SlipNo.StrongValue));
}
; //not include old value
if (!IncludeOldData)
{
req.Parameters.Add("@OLD_DATA", DataType.Int16, 0); //not include old value
}
return(db.ExecuteForList <DeliveryViewDTO>(req));
}
public DataTable LoadSalesSummary(Database database, NZDateTime dtDateFrom)
{
DataTable dtRet = null;
Database db = UseDatabase(database);
//StringBuilder sb = new StringBuilder();
DataRequest req = new DataRequest();
req.CommandType = CommandType.StoredProcedure;
req.CommandText = "S_SUM020_SalesSummaryReport";
req.Parameters.Add("@pDtm_YearMonth", DataType.DateTime, dtDateFrom.Value);
DataSet ds = db.ExecuteDataSet(req);
if (ds != null && ds.Tables.Count > 0)
{
dtRet = ds.Tables[0];
}
return(dtRet);
}
/// <summary>
///
/// </summary>
/// <param name="yearMonth"></param>
/// <param name="locationCD"></param>
/// <param name="itemCD"></param>
/// <param name="lotNo"></param>
/// <param name="periodBeginDate"></param>
/// <param name="periodEndDate"></param>
public INV020_InventoryMovementInquiry(NZString yearMonth, NZString locationCD, NZString itemCD, NZString lotNo, NZString packNo, NZDateTime periodBeginDate, NZDateTime periodEndDate, NZInt QueryType)
{
InitializeComponent();
m_yearMonth = yearMonth;
m_wareHouseCode = locationCD;
m_itemCode = itemCD;
m_lotNo = lotNo;
m_packNo = packNo;
m_periodBeginDate = periodBeginDate;
m_periodEndDate = periodEndDate;
m_QueryType = QueryType;
ItemDTO dtoItem = m_bizItem.LoadItem(itemCD);
txtUnitMeasure.Text = string.Empty;
if (dtoItem != null)
{
//ClassListDTO dtoClassList = m_bizClassList.LoadByPK((NZString)DataDefine.UM_CLS, dtoItem.INV_UM_CLS);
//if (dtoClassList != null)
//{
// txtUnitMeasure.Text = String.Format("{0}{1}{2}", dtoItem.INV_UM_CLS.Value, Common.COMBOBOX_SEPERATOR_SYMBOL, dtoClassList.CLS_DESC.Value);
//}
}
//InitializeScreen();
}
public ErrorItem CheckPackingDate(NZDateTime PackingDate)
{
if (PackingDate.IsNull)
{
return(new ErrorItem(PackingDate.Owner, TKPMessages.eValidate.VLM0187.ToString()));
}
return(null);
}
public ErrorItem CheckEmptyStartEffeciveDate(NZDateTime StartEffiveDate)
{
if (StartEffiveDate.IsNull)
{
return(new ErrorItem(StartEffiveDate.Owner, TKPMessages.eValidate.VLM0167.ToString()));
}
return(null);
}
public ErrorItem CheckUnpackingDate(NZDateTime UnpackingDate)
{
if (UnpackingDate.IsNull)
{
return(new ErrorItem(UnpackingDate.Owner, TKPMessages.eValidate.VLM0216.ToString()));
}
return(null);
}
public ReceivingEntryUIDM()
{
m_RECEIVE_DATE = new NZDateTime(null, CommonLib.Common.GetDatabaseDateTime());
InventoryTransactionViewDTO dto = new InventoryTransactionViewDTO();
dto.CreateDataTableSchema(out m_dtView);
}
public ErrorItem CheckEmptyMoveDate(NZDateTime MoveDate)
{
if (MoveDate.IsNull)
{
return(new ErrorItem(MoveDate.Owner, TKPMessages.eValidate.VLM0171.ToString()));
}
return(null);
}
/// <summary>
/// Generate PO Header.
/// </summary>
/// <param name="strPONo">PO No of PO Header.</param>
/// <returns>PO Header</returns>
private PurchaseOrderHDTO GeneratePurchaseOrderHDTO(NZString strPONo)
{
NZDateTime dtmPO = new NZDateTime(dtmPODate, dtmPODate.Value);
NZString strSupplierCD = new NZString(cboSupplierCode, cboSupplierCode.SelectedValue);
NZString strDeliveryTo = chkOurFactory.Checked ? new NZString(cboDelivery, cboDelivery.Text) : new NZString(cboDelivery, cboDelivery.SelectedValue);
NZString strCurrency = new NZString(cboCurrency, cboCurrency.SelectedValue);
NZString strVatRate = new NZString(txtVatRate, txtVatRate.Text);
string strVatType = (Convert.ToInt32(strVatRate) > 0) ? "02" : "01";
#region validation
ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckDateTimeValue(dtmPO, Messages.eValidate.VLM0116));
ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckEmptyString(strSupplierCD, Messages.eValidate.VLM0118));
if (!chkOurFactory.Checked)
{
ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckEmptyString((NZString)strDeliveryTo, Messages.eValidate.VLM0119));
}
ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckEmptyString((NZString)strCurrency, Messages.eValidate.VLM0121));
if (this.m_ScreenStateEnum == eScreenState.Add)
{
ValidateException.ThrowErrorItem(PurchaseOrderEntryValidation.CheckPurchaseOrderItem((NZInt)shtView.Rows.Count));
}
#endregion
PurchaseOrderHDTO hDTO = new PurchaseOrderHDTO
{
CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD,
CRT_DATE = (NZDateTime)DateTime.UtcNow,
CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine,
UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD,
UPD_DATE = (NZDateTime)DateTime.UtcNow,
UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine,
PO_NO = strPONo,
PO_DATE = (NZDateTime)dtmPO,
IS_ACTIVE = (NZBoolean)m_bIsActived, //(NZBoolean)((m_iPOStatus == 1) ? true : false),
PO_TYPE = (NZString)"01", //(NZString)(cboPOType.SelectedValue.ToString()),
IS_EXPORT = (NZBoolean)false, //(NZBoolean)chkExport.Checked,
ADDRESS = (NZString)"", // (NZString)txtAddress.Text,
SUPPLIER_CD = (NZString)strSupplierCD,
DELIVERY_TO = (NZString)strDeliveryTo,
TERM_OF_PAYMENT = (NZString)(Convert.ToString(cboTermOfPayment.SelectedValue)),
STATUS = (NZString)"0",
VAT_TYPE = (NZString)strVatType,
VAT_RATE = (NZDecimal)Convert.ToDecimal(strVatRate),
CURRENCY = (NZString)(cboCurrency.SelectedValue.ToString()),
REMARK = (NZString)txtRemark.Text,
};
return(hDTO);
}
public ErrorItem CheckEmptyBeginDate(NZDateTime date)
{
if (date.IsNull)
{
return(new ErrorItem(date.Owner, TKPMessages.eValidate.VLM0021.ToString()));
}
return(null);
}
public ErrorItem CheckBetweenDate(NZDateTime fromDate, NZDateTime toDate)
{
if (toDate.StrongValue.Date.CompareTo(fromDate.StrongValue.Date) < 0)
{
return(new ErrorItem(toDate.Owner, TKPMessages.eValidate.VLM0023.ToString()));
}
return(null);
}
public MultiWorkResultEntryUIDM()
{
m_workResultDate = new NZDateTime(null, CommonLib.Common.GetDatabaseDateTime());
m_TRAN_SUB_CLS = (NZString)DataDefine.eTRAN_SUB_CLS.WR.ToString();
MultiWorkResultEntryViewDTO dto = new MultiWorkResultEntryViewDTO();
dto.CreateDataTableSchema(out m_dataView);
}
public ErrorItem CheckEmptyPeriodEndDate(NZDateTime PeriodEndDate)
{
if (PeriodEndDate.IsNull)
{
return(new ErrorItem(PeriodEndDate.Owner, TKPMessages.eValidate.VLM0022.ToString()));
}
return(null);
}
public DataTable LoadGeneratePO(NZDateTime dtmFrom, NZDateTime dtmTo, NZString strItemCDFrom, NZString strItemCDTo, NZString strLocCDFrom, NZString strLocCDTo, NZInt iPOInterval)
{
GeneratePO(dtmFrom, dtmTo, strItemCDFrom, strItemCDTo, strLocCDFrom, strLocCDTo, iPOInterval);
TmpPurchaseOrderDAO dao = new TmpPurchaseOrderDAO(Common.CurrentDatabase);
DataTable dt = dao.LoadTmpGeneratePO(null, Common.CurrentUserInfomation.UserCD, Common.CurrentUserInfomation.Machine);
return(dt);
}
public ErrorItem CheckEmptyAdjustDate(NZDateTime adjustDate)
{
if (adjustDate.IsNull)
{
return(new ErrorItem(adjustDate.Owner, TKPMessages.eValidate.VLM0033.ToString()));
}
return(null);
}
public ErrorItem CheckPeriodBeginToEndDate(NZDateTime PeriodBeginDate, NZDateTime PeriodEndDate)
{
if (PeriodBeginDate.StrongValue > PeriodEndDate.StrongValue)
{
return(new ErrorItem(PeriodEndDate.Owner, TKPMessages.eValidate.VLM0023.ToString()));
}
return(null);
}
