public async Task <int> Update(CFShipping shipping)
{
var cmd = QueriesCreatingHelper.CreateQueryUpdate(shipping);
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
public async Task <int> Add(CFShipping shipping)
{
var cmd = QueriesCreatingHelper.CreateQueryInsert(shipping);
cmd += ";SELECT LAST_INSERT_ID();";
return((await DALHelper.ExecuteQuery <int>(cmd, dbTransaction: DbTransaction, connection: DbConnection)).First());
}
public async Task <int> Delete(CFShipping shipping)
{
var cmd = $@"UPDATE `cf_shipping`
SET
`is_deleted` = 1,
`modified_by` = {shipping.ModifiedBy},
`modified_date` = '{shipping.ModifiedDate?.ToString("yyyyMMddHHmmss")}'
WHERE `id` = {shipping.Id}";
var rs = await DALHelper.Execute(cmd, dbTransaction : DbTransaction, connection : DbConnection);
return(rs == 0 ? -1 : 0);
}
public UpdateCommand(CFShipping shipping)
{
Shipping = shipping;
}
public AddCommand(CFShipping shipping)
{
Shipping = shipping;
}
