private void tsbDelete_Click(object sender, EventArgs e)
{
if (!IsDoOperation(Messages.eConfirm.CFM9002))
{
return;
}
try
{
DemandOrderDTO dtoDO = GenerateHeaderDemandOrderDTO();
m_BIZDemandOrder.DeleteDemandOrder(dtoDO);
shtView.DataSource = SearchData(dtoDO);
//SetScreenState(eScreenState.View);
MessageDialog.ShowInformation(this, "Information", new EVOFramework.Message(Messages.eInformation.INF9003.ToString()).MessageDescription);
m_Result = DialogResult.OK;
this.Close();
}
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();
}
}
public int DeleteDemandOrder(DemandOrderDTO dto)
{
int iResult = -1;
Database db = null;
try {
CheckBeforeDelete(dto);
db = Common.CurrentDatabase;
db.KeepConnection = true;
db.BeginTransaction(IsolationLevel.Serializable);
DemandOrderDAO daoOrder = new DemandOrderDAO(db);
iResult = daoOrder.DeleteOrder(null, dto);
db.Commit();
}
catch (Exception) {
db.Rollback();
throw;
}
finally {
if (db.DBConnectionState == ConnectionState.Open)
{
db.Close();
}
}
return(iResult);
}
public bool CheckBeforeUpdate(DemandOrderDTO dtoOrder, List <TmpDemandOrderDTO> dtoItems)
{
CheckCustomer(dtoOrder);
CheckOrderItem(dtoItems);
return(true);
}
private void tsbSaveAndNew_Click(object sender, EventArgs e)
{
if (Save())
{
this.m_DTODemandOrder = null;
this.SetScreenState(eScreenState.Add);
}
}
private DataTable SearchData(DemandOrderDTO dtoDO)
{
SetHolidayColor();
shtView.Rows.Count = 0;
DataTable dt = m_BIZDemandOrder.LoadDemandOrderSummary(dtoDO);
return(dt);
}
/// <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, DemandOrderDTO data)
{
Database db = UseDatabase(database);
if (Exist(database, data.ORDER_ID))
{
return(UpdateWithoutPK(db, data));
}
return(AddNew(db, data));
}
public int DeleteTargetOrder(Database database, DemandOrderDTO dto)
{
Database db = UseDatabase(database);
DataRequest req = new DataRequest();
req.CommandText = "S_MRP020_DeleteTargetDemandOrder";
req.CommandType = CommandType.StoredProcedure;
req.Parameters.Add("@pVar_UPD_BY", DataType.NVarChar, dto.CRT_BY.Value);
req.Parameters.Add("@pVar_UPD_MACHINE", DataType.NVarChar, dto.CRT_MACHINE.Value);
req.Parameters.Add("@pVar_ORDER_ID", DataType.Int32, dto.ORDER_ID.Value);
return(db.ExecuteNonQuery(req));
}
private void CheckOrder(DemandOrderDTO dtoOrder)
{
ErrorItem errorItem;
//check customer and year/month is exists
if (IsExists(dtoOrder))
{
string[] param = new string[2];
param[0] = dtoOrder.YEAR_MONTH.ToString();
param[1] = dtoOrder.CUSTOMER_CD;
errorItem = new ErrorItem(null, TKPMessages.eValidate.VLM0107.ToString(), param);
throw new BusinessException(errorItem);
}
}
public int DeleteTempDemandOrder(Database database, DemandOrderDTO dto)
{
Database db = UseDatabase(database);
DataRequest req = new DataRequest();
req.CommandText = "S_MRP020_DeleteTmpDemandOrder";
req.CommandType = CommandType.StoredProcedure;
req.Parameters.Add("@pVar_CRT_BY", DataType.NVarChar, dto.CRT_BY.Value);
req.Parameters.Add("@pVar_CRT_MACHINE", DataType.NVarChar, dto.CRT_MACHINE.Value);
req.Parameters.Add("@pDtm_YEAR_MONTH", DataType.DateTime, dto.YEAR_MONTH.Value);
req.Parameters.Add("@pVar_CUSTOMER_CD", DataType.NVarChar, dto.CUSTOMER_CD.Value);
return(db.ExecuteNonQuery(req));
}
private void EditDemandOrder()
{
List <TmpDemandOrderDTO> dtoListDemandOrderUpdate = new List <TmpDemandOrderDTO>();
GenerateTmpDemandOrderDTOList(dtoListDemandOrderUpdate);
ValidateException.ThrowErrorItem(DemandOrderSimpleValidation.CheckRecord(new NZInt(null, dtoListDemandOrderUpdate.Count)));
DemandOrderDTO dtoDemandOrder = GenerateHeaderDemandOrderDTO();
if (dtoListDemandOrderUpdate.Count > 0)
{
m_BIZDemandOrder.Update(dtoDemandOrder, dtoListDemandOrderUpdate);
}
}
private void OnEdit()
{
if (!ActivePermission.Edit)
{
return;
}
DemandOrderDTO dto = GenerateDemandOrderDTO();
ORD020_DemandOrder ORD020 = new ORD020_DemandOrder(dto);
if (ORD020.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
LoadData(dtPeriodBegin.NZValue, dtPeriodEnd.NZValue);
}
}
/// <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));
}
private bool CanSearchandShowData(DemandOrderDTO doDTO)
{
DataTable dt = SearchData(doDTO);
if (dt.Rows.Count > 0)
{
shtView.DataSource = dt;
this.SetScreenState(eScreenState.Idle);
return(true);
}
else if (this.m_ScreenStateEnum != eScreenState.Edit)
{
if (IsDoOperation(Messages.eConfirm.CFM9013))
{
SetScreenState(eScreenState.Add);
}
}
return(false);
}
public void SaveData(DemandOrderDTO dtoOrder, List <TmpDemandOrderDTO> dtoItems)
{
Database db = null;
try {
db = Common.CurrentDatabase;
db.KeepConnection = true;
db.BeginTransaction(IsolationLevel.Serializable);
TmpDemandOrderDAO daoTmpOrder = new TmpDemandOrderDAO(db);
DemandOrderDAO daoOrder = new DemandOrderDAO(db);
//add all record to temp table
daoTmpOrder.DeleteTempDemandOrder(null, dtoOrder);
foreach (TmpDemandOrderDTO dto in dtoItems)
{
daoTmpOrder.InsertTempDemandOrder(null, dto);
}
//set all record to in-active and update data for item in table
daoOrder.DeleteOrder(null, dtoOrder);
daoOrder.UpdateOrder(null, dtoOrder);
//delete data in tmp
daoTmpOrder.DeleteTempDemandOrder(null, dtoOrder);
db.Commit();
}
catch (Exception)
{
db.Rollback();
throw;
}
finally
{
if (db.DBConnectionState == ConnectionState.Open)
{
db.Close();
}
}
}
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);
//}
}
public bool CheckBeforeDelete(DemandOrderDTO dto)
{
return(true);
}
/// <summary>
/// Insert new record into database.
/// </summary>
/// <param name="database"></param>
/// <param name="data"></param>
/// <returns></returns>
public int AddNew(Database database, DemandOrderDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" INSERT INTO " + data.TableName + "(");
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(") 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(" ,:IS_ACTIVE");
sb.AppendLine(" ,:REVISION");
sb.AppendLine(" ,:YEAR_MONTH");
sb.AppendLine(" ,:CUSTOMER_CD");
sb.AppendLine(" ,:ORDER_ID");
sb.AppendLine(" ,:DUE_DATE");
sb.AppendLine(" ,:ITEM_CD");
sb.AppendLine(" ,:ORDER_QTY");
sb.AppendLine(" ,:ORDER_TYPE");
sb.AppendLine(" ,:PRIORITY");
sb.AppendLine(" ,:Reserve");
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("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);
#endregion
return(db.ExecuteNonQuery(req));
}
public List <DemandOrderDTO> LoadDemandOrder(DemandOrderDTO dto)
{
DemandOrderDAO dao = new DemandOrderDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadDemandOrder(null, dto.YEAR_MONTH, dto.CUSTOMER_CD));
}
public bool IsExists(DemandOrderDTO dto)
{
DemandOrderDAO dao = new DemandOrderDAO(CommonLib.Common.CurrentDatabase);
return(dao.ExistsByHeader(null, dto.YEAR_MONTH, dto.CUSTOMER_CD));
}
public ORD020_DemandOrder(DemandOrderDTO dtoDemandOrder) : this()
{
m_DTODemandOrder = dtoDemandOrder;
}
public bool CanEditing(DemandOrderDTO dto)
{
return(DateTime.Compare(dto.YEAR_MONTH, DateTime.Now.Date) > 1);
}
public void Update(DemandOrderDTO dtoOrder, List <TmpDemandOrderDTO> dtoItems)
{
CheckBeforeUpdate(dtoOrder, dtoItems);
SaveData(dtoOrder, dtoItems);
}
public void Add(DemandOrderDTO dtoOrder, List <TmpDemandOrderDTO> dtoItems)
{
CheckBeforeAdd(dtoOrder, dtoItems);
SaveData(dtoOrder, dtoItems);
}
public DataTable LoadDemandOrderSummary(DemandOrderDTO dto)
{
DemandOrderDAO dao = new DemandOrderDAO(CommonLib.Common.CurrentDatabase);
return(dao.LoadDemandOrderSummary(null, dto.YEAR_MONTH, dto.CUSTOMER_CD));
}
