public bool AddConsignmentBill(ConsignmentBillModel consignmentBill)
{
string sql = @" insert into SJConsignmentBillUserCurrencyOperation(BillNo,UserId,SelectedStatus,CurrencyQuantity,InterId) values(@BillNo,@UserId,@SelectedStatus,@CurrencyQuantity,@InterId);";
using (var connection = SqlDb.UpdateConnection)
{
return(connection.Execute(sql, consignmentBill) > 0);
}
}
public bool DeleteConsignmentBill(ConsignmentBillModel consignmentBill)
{
string sql = @" delete from SJConsignmentBillUserCurrencyOperation where BillNo=@BillNo and UserId=@UserId and Eid=-1;";
using (var connection = SqlDb.UpdateConnection)
{
return(connection.Execute(sql, consignmentBill) > 0);
}
}
public bool UpdateConsignmentBill(ConsignmentBillModel consignmentBill)
{
string sql = @" update SJConsignmentBill set CurrencyQuantity=@CurrencyQuantity,UndoQuantity=@UndoQuantity,TotalQuantity=@TotalQuantity where InterId=@InterId ; ";
using (var connection = SqlDb.UpdateConnection)
{
return(connection.Execute(sql, consignmentBill) > 0);
}
}
