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