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)); }