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