public int UpdatePeriod(InventoryPeriodDTO dto)
{
// check exist before add new
InventoryPeriodValidator val = new InventoryPeriodValidator();
val.ValidateBeforeSaveUpdate(dto);
InventoryPeriodDAO dao = new InventoryPeriodDAO(CommonLib.Common.CurrentDatabase);
List <InventoryPeriodDTO> dtoInvPeriodList = dao.LoadAll(null, true);
return(dao.UpdateWithPK(null, dto, dtoInvPeriodList[0].YEAR_MONTH));
}
public BusinessException CheckInventPeriod(NZString YearMonth)
{
InventoryPeriodDAO dao = new InventoryPeriodDAO(CommonLib.Common.CurrentDatabase);
if (dao.Exist(null, YearMonth))
{
ErrorItem errorItem = new ErrorItem(YearMonth.Owner, TKPMessages.eValidate.VLM0024.ToString());
return(new BusinessException(errorItem));
}
return(null);
}
//public ErrorItem CheckInputLot(NZString itemCode, NZString lotNo) {
// ItemBIZ biz = new ItemBIZ();
// ItemDTO dto = biz.LoadItem(itemCode);
// switch (DataDefine.ConvertValue2Enum<DataDefine.eLOT_CONTROL_CLS>(dto.LOT_CONTROL_CLS.StrongValue)) {
// case DataDefine.eLOT_CONTROL_CLS.No:
// if (!lotNo.IsNull || lotNo.StrongValue != string.Empty) {
// return new ErrorItem(lotNo.Owner, TKPMessages.eValidate.VLM0065.ToString());
// }
// break;
// case DataDefine.eLOT_CONTROL_CLS.Yes:
// if (lotNo.IsNull || lotNo.StrongValue.Trim() == String.Empty) {
// return new ErrorItem(lotNo.Owner, TKPMessages.eValidate.VLM0050.ToString(), new object[] { itemCode.StrongValue });
// }
// break;
// }
// return null;
//}
#endregion
public ErrorItem CheckAdjustDateIsInCurrentPeriod(NZDateTime adjustDate)
{
InventoryPeriodDAO inventoryPeriodDAO = new InventoryPeriodDAO(CommonLib.Common.CurrentDatabase);
InventoryPeriodDTO inventoryPeriodDTO = inventoryPeriodDAO.LoadCurrentYearMonth(null);
if (inventoryPeriodDTO == null)
{
return(new ErrorItem(adjustDate.Owner, TKPMessages.eValidate.VLM0034.ToString()));
}
if (inventoryPeriodDTO.PERIOD_BEGIN_DATE.StrongValue.Date > adjustDate.StrongValue.Date ||
inventoryPeriodDTO.PERIOD_END_DATE.StrongValue.AddMonths(1).Date < adjustDate.StrongValue.Date)
{
return(new ErrorItem(adjustDate.Owner, TKPMessages.eValidate.VLM0034.ToString()));
}
return(null);
}
public bool Exist(NZString YearMonth)
{
InventoryPeriodDAO dao = new InventoryPeriodDAO(CommonLib.Common.CurrentDatabase);
return(dao.Exist(null, YearMonth));
}
public InventoryPeriodDTO LoadPeriodByDate(NZDateTime date)
{
InventoryPeriodDAO dao = new InventoryPeriodDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadPeriodByDate(null, date));
}
/// <summary>
/// ใช้สำหรับ load inventory period โดยใช้range จาก system config ในการคำนวณด้วย
/// เพื่อให้ข้อมูลแสดงน้อยลง
/// </summary>
/// <returns></returns>
public InventoryPeriodDTO LoadCurrentPeriodWithQueryRange()
{
InventoryPeriodDAO dao = new InventoryPeriodDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadCurrentPeriodWithQueryRange(null));
}
public InventoryPeriodDTO LoadCurrentPeriod()
{
InventoryPeriodDAO dao = new InventoryPeriodDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadCurrentYearMonth(null));
}
public InventoryPeriodDTO LoadByPK(EVOFramework.NZString YearMonth)
{
InventoryPeriodDAO dao = new InventoryPeriodDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadByPK(null, YearMonth));
}