public int UpdateWithoutPK(Database database, ItemEquivalentDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" UPDATE " + data.TableName);
sb.AppendLine(" SET ");
sb.AppendLine(" " + ItemEquivalentDTO.eColumns.ORDER_LOC_CD + "=@ORDER_LOC_CD");
sb.AppendLine(" ," + ItemEquivalentDTO.eColumns.UPD_BY + "=@UPD_BY");
sb.AppendLine(" ," + ItemEquivalentDTO.eColumns.UPD_DATE + "=GETDATE()");
sb.AppendLine(" ," + ItemEquivalentDTO.eColumns.UPD_MACHINE + "=@UPD_MACHINE");
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + ItemEquivalentDTO.eColumns.ITEM_CD + "=@ITEM_CD");
sb.AppendLine(" AND " + ItemEquivalentDTO.eColumns.EQUIVALENT_ITEM_CD + "=@EQUIVALENT_ITEM_CD");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("@ITEM_CD", DataType.NVarChar, data.ITEM_CD.Value);
req.Parameters.Add("@EQUIVALENT_ITEM_CD", DataType.NVarChar, data.EQUIVALENT_ITEM_CD.Value);
req.Parameters.Add("@ORDER_LOC_CD", DataType.NVarChar, data.ORDER_LOC_CD.Value);
req.Parameters.Add("@UPD_BY", DataType.NVarChar, data.UPD_BY.Value);
req.Parameters.Add("@UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
public int AddNew(Database database, ItemEquivalentDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" INSERT INTO " + data.TableName + "(");
sb.AppendLine(" " + ItemEquivalentDTO.eColumns.ITEM_CD);
sb.AppendLine(" ," + ItemEquivalentDTO.eColumns.EQUIVALENT_ITEM_CD);
sb.AppendLine(" ," + ItemEquivalentDTO.eColumns.ORDER_LOC_CD);
sb.AppendLine(" ," + ItemEquivalentDTO.eColumns.CRT_BY);
sb.AppendLine(" ," + ItemEquivalentDTO.eColumns.CRT_DATE);
sb.AppendLine(" ," + ItemEquivalentDTO.eColumns.CRT_MACHINE);
sb.AppendLine(" ," + ItemEquivalentDTO.eColumns.UPD_BY);
sb.AppendLine(" ," + ItemEquivalentDTO.eColumns.UPD_DATE);
sb.AppendLine(" ," + ItemEquivalentDTO.eColumns.UPD_MACHINE);
sb.AppendLine(") VALUES(");
sb.AppendLine(" @ITEM_CD");
sb.AppendLine(" ,@EQUIVALENT_ITEM_CD");
sb.AppendLine(" ,@ORDER_LOC_CD");
sb.AppendLine(" ,@CRT_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,@CRT_MACHINE");
sb.AppendLine(" ,@UPD_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,@UPD_MACHINE");
sb.AppendLine(" )");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("@ITEM_CD", DataType.NVarChar, data.ITEM_CD.Value);
req.Parameters.Add("@EQUIVALENT_ITEM_CD", DataType.NVarChar, data.EQUIVALENT_ITEM_CD.Value);
req.Parameters.Add("@ORDER_LOC_CD", DataType.NVarChar, data.ORDER_LOC_CD.Value);
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);
#endregion
return(db.ExecuteNonQuery(req));
}
public int Delete(Database database, ItemEquivalentDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" DELETE FROM " + data.TableName);
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + ItemEquivalentDTO.eColumns.ITEM_CD + "=@ITEM_CD");
sb.AppendLine(" AND " + ItemEquivalentDTO.eColumns.EQUIVALENT_ITEM_CD + "=@EQUIVALENT_ITEM_CD");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("@ITEM_CD", DataType.NVarChar, data.ITEM_CD.Value);
req.Parameters.Add("@EQUIVALENT_ITEM_CD", DataType.NVarChar, data.EQUIVALENT_ITEM_CD.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
