public CustomerOrderViewDTO CustomerOrderHDTO2CustomerOrderViewDTO(CustomerOrderHDTO dtoCustomerOrderHDTO) { CustomerOrderViewDTO dtoCustomerOrderView = new CustomerOrderViewDTO(); dtoCustomerOrderView.CRT_BY = dtoCustomerOrderHDTO.CRT_BY; dtoCustomerOrderView.CRT_DATE = dtoCustomerOrderHDTO.CRT_DATE; dtoCustomerOrderView.CRT_MACHINE = dtoCustomerOrderHDTO.CRT_MACHINE; dtoCustomerOrderView.UPD_BY = dtoCustomerOrderHDTO.UPD_BY; dtoCustomerOrderView.UPD_DATE = dtoCustomerOrderHDTO.UPD_DATE; dtoCustomerOrderView.UPD_MACHINE = dtoCustomerOrderHDTO.UPD_MACHINE; dtoCustomerOrderView.ORDER_NO = dtoCustomerOrderHDTO.ORDER_NO; dtoCustomerOrderView.RECEIVE_DATE = dtoCustomerOrderHDTO.RECEIVE_DATE; dtoCustomerOrderView.CUSTOMER_CD = dtoCustomerOrderHDTO.CUSTOMER_CD; dtoCustomerOrderView.ORDER_TYPE = dtoCustomerOrderHDTO.ORDER_TYPE; dtoCustomerOrderView.CURRENCY = dtoCustomerOrderHDTO.CURRENCY; dtoCustomerOrderView.PO_NO = dtoCustomerOrderHDTO.PO_NO; dtoCustomerOrderView.PO_DATE = dtoCustomerOrderHDTO.PO_DATE; dtoCustomerOrderView.EXCHANGE_RATE = dtoCustomerOrderHDTO.EXCHANGE_RATE; dtoCustomerOrderView.REMARK = dtoCustomerOrderHDTO.REMARK; dtoCustomerOrderView.TOTAL_QTY = dtoCustomerOrderHDTO.TOTAL_QTY; dtoCustomerOrderView.TOTAL_AMOUNT = dtoCustomerOrderHDTO.TOTAL_AMOUNT; dtoCustomerOrderView.TOTAL_AMOUNT_THB = dtoCustomerOrderHDTO.TOTAL_AMOUNT_THB; dtoCustomerOrderView.OLD_DATA = dtoCustomerOrderHDTO.OLD_DATA; return(dtoCustomerOrderView); }
public int AddNewH(Database database, CustomerOrderHDTO data) { Database db = UseDatabase(database); CustomerOrderHDAO daoCustomerOrderH = new CustomerOrderHDAO(); return(daoCustomerOrderH.AddNew(database, data)); }
/// <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, CustomerOrderHDTO data) { Database db = UseDatabase(database); if (Exist(database, data.ORDER_NO)) { return(UpdateWithoutPK(db, data)); } return(AddNew(db, data)); }
/// <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_NO">Old Key #1</param> /// <returns></returns> public int UpdateWithPK(Database database, CustomerOrderHDTO data, String oldORDER_NO) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" UPDATE " + data.TableName); sb.AppendLine(" SET "); sb.AppendLine(" " + CustomerOrderHDTO.eColumns.UPD_BY + "=@UPD_BY"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.UPD_DATE + "=GETDATE()"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.UPD_MACHINE + "=@UPD_MACHINE"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.ORDER_NO + "=@ORDER_NO"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.RECEIVE_DATE + "=@RECEIVE_DATE"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.CUSTOMER_CD + "=@CUSTOMER_CD"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.ORDER_TYPE + "=@ORDER_TYPE"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.CURRENCY + "=@CURRENCY"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.PO_NO + "=@PO_NO"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.PO_DATE + "=@PO_DATE"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.EXCHANGE_RATE + "=@EXCHANGE_RATE"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.REMARK + "=@REMARK"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.TOTAL_QTY + "=@TOTAL_QTY"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.TOTAL_AMOUNT + "=@TOTAL_AMOUNT"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.TOTAL_AMOUNT_THB + "=@TOTAL_AMOUNT_THB"); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.OLD_DATA + "=@OLD_DATA"); sb.AppendLine(" WHERE "); sb.AppendLine(" " + CustomerOrderHDTO.eColumns.ORDER_NO + "=@oldORDER_NO"); #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("@ORDER_NO", DataType.NVarChar, data.ORDER_NO.Value); req.Parameters.Add("@RECEIVE_DATE", DataType.DateTime, data.RECEIVE_DATE.Value); req.Parameters.Add("@CUSTOMER_CD", DataType.NVarChar, data.CUSTOMER_CD.Value); req.Parameters.Add("@ORDER_TYPE", DataType.NVarChar, data.ORDER_TYPE.Value); req.Parameters.Add("@CURRENCY", DataType.NVarChar, data.CURRENCY.Value); req.Parameters.Add("@PO_NO", DataType.NVarChar, data.PO_NO.Value); req.Parameters.Add("@PO_DATE", DataType.DateTime, data.PO_DATE.Value); req.Parameters.Add("@EXCHANGE_RATE", DataType.Number, data.EXCHANGE_RATE.Value); req.Parameters.Add("@REMARK", DataType.NVarChar, data.REMARK.Value); req.Parameters.Add("@TOTAL_QTY", DataType.Number, data.TOTAL_QTY.Value); req.Parameters.Add("@TOTAL_AMOUNT", DataType.Number, data.TOTAL_AMOUNT.Value); req.Parameters.Add("@TOTAL_AMOUNT_THB", DataType.Number, data.TOTAL_AMOUNT_THB.Value); req.Parameters.Add("@OLD_DATA", DataType.Default, 0); req.Parameters.Add("@oldORDER_NO", DataType.NVarChar, oldORDER_NO); #endregion return(db.ExecuteNonQuery(req)); }
/// <summary> /// Insert new record into database. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNew(Database database, CustomerOrderHDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" INSERT INTO " + data.TableName + "("); sb.AppendLine(" " + CustomerOrderHDTO.eColumns.CRT_BY); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.CRT_DATE); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.CRT_MACHINE); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.UPD_BY); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.UPD_DATE); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.UPD_MACHINE); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.ORDER_NO); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.RECEIVE_DATE); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.CUSTOMER_CD); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.ORDER_TYPE); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.CURRENCY); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.PO_NO); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.PO_DATE); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.EXCHANGE_RATE); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.REMARK); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.TOTAL_QTY); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.TOTAL_AMOUNT); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.TOTAL_AMOUNT_THB); sb.AppendLine(" ," + CustomerOrderHDTO.eColumns.OLD_DATA); 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(" ,@ORDER_NO"); sb.AppendLine(" ,@RECEIVE_DATE"); sb.AppendLine(" ,@CUSTOMER_CD"); sb.AppendLine(" ,@ORDER_TYPE"); sb.AppendLine(" ,@CURRENCY"); sb.AppendLine(" ,@PO_NO"); sb.AppendLine(" ,@PO_DATE"); sb.AppendLine(" ,@EXCHANGE_RATE"); sb.AppendLine(" ,@REMARK"); sb.AppendLine(" ,@TOTAL_QTY"); sb.AppendLine(" ,@TOTAL_AMOUNT"); sb.AppendLine(" ,@TOTAL_AMOUNT_THB"); sb.AppendLine(" ,@OLD_DATA"); 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("@ORDER_NO", DataType.NVarChar, data.ORDER_NO.Value); req.Parameters.Add("@RECEIVE_DATE", DataType.DateTime, data.RECEIVE_DATE.Value); req.Parameters.Add("@CUSTOMER_CD", DataType.NVarChar, data.CUSTOMER_CD.Value); req.Parameters.Add("@ORDER_TYPE", DataType.NVarChar, data.ORDER_TYPE.Value); req.Parameters.Add("@CURRENCY", DataType.NVarChar, data.CURRENCY.Value); req.Parameters.Add("@PO_NO", DataType.NVarChar, data.PO_NO.Value); req.Parameters.Add("@PO_DATE", DataType.DateTime, data.PO_DATE.Value); req.Parameters.Add("@EXCHANGE_RATE", DataType.Number, data.EXCHANGE_RATE.Value); req.Parameters.Add("@REMARK", DataType.NVarChar, data.REMARK.Value); req.Parameters.Add("@TOTAL_QTY", DataType.Number, data.TOTAL_QTY.Value); req.Parameters.Add("@TOTAL_AMOUNT", DataType.Number, data.TOTAL_AMOUNT.Value); req.Parameters.Add("@TOTAL_AMOUNT_THB", DataType.Number, data.TOTAL_AMOUNT_THB.Value); req.Parameters.Add("@OLD_DATA", DataType.Default, 0); #endregion return(db.ExecuteNonQuery(req)); }