public bool DeleteBalanceDrawRequestById(bool IsPass, decimal balance, SupplierBalanceDrawRequestInfo balanceDrawRequest, string manageName, DbTransaction dbTran, string sReason = "")
{
StringBuilder stringBuilder = new StringBuilder("UPDATE Hishop_SupplierBalanceDrawRequest SET ISPASS = @ISPASS, AccountDate = @AccountDate, ManagerRemark = @ManagerRemark, ManagerUserName = @ManagerUserName WHERE ID=@ID;");
if (IsPass)
{
SupplierBalanceDetailInfo supplierBalanceDetailInfo = new SupplierBalanceDetailInfo();
stringBuilder.Append("UPDATE Hishop_Supplier SET Balance = Balance - @Balance WHERE SupplierId = @SupplierId");
supplierBalanceDetailInfo.SupplierId = balanceDrawRequest.SupplierId;
supplierBalanceDetailInfo.UserName = balanceDrawRequest.UserName;
supplierBalanceDetailInfo.TradeDate = DateTime.Now;
supplierBalanceDetailInfo.TradeType = SupplierTradeTypes.DrawRequest;
supplierBalanceDetailInfo.Expenses = balanceDrawRequest.Amount;
supplierBalanceDetailInfo.Balance = balance - balanceDrawRequest.Amount;
supplierBalanceDetailInfo.Remark = balanceDrawRequest.Remark;
supplierBalanceDetailInfo.ManagerUserName = manageName;
supplierBalanceDetailInfo.OrderId = balanceDrawRequest.ID.ToString();
if (this.Add(supplierBalanceDetailInfo, dbTran) <= 0)
{
return(false);
}
}
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());
base.database.AddInParameter(sqlStringCommand, "ID", DbType.Int32, balanceDrawRequest.ID);
base.database.AddInParameter(sqlStringCommand, "SupplierId", DbType.Int32, balanceDrawRequest.SupplierId);
base.database.AddInParameter(sqlStringCommand, "ISPASS", DbType.Boolean, IsPass);
base.database.AddInParameter(sqlStringCommand, "AccountDate", DbType.DateTime, DateTime.Now);
base.database.AddInParameter(sqlStringCommand, "ManagerRemark", DbType.String, sReason);
base.database.AddInParameter(sqlStringCommand, "Balance", DbType.Decimal, balanceDrawRequest.Amount);
base.database.AddInParameter(sqlStringCommand, "ManagerUserName", DbType.String, manageName);
return(base.database.ExecuteNonQuery(sqlStringCommand, dbTran) > 0);
}
private DataGridViewModel <Dictionary <string, object> > GetBalanceDetails(BalanceDetailSupplierQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
string empty = string.Empty;
if (query != null)
{
DbQueryResult balanceDetails = BalanceHelper.GetBalanceDetails(query);
List <Dictionary <string, object> > list = DataHelper.DataTableToDictionary(balanceDetails.Data);
foreach (Dictionary <string, object> item in list)
{
SupplierBalanceDetailInfo supplierBalanceDetailInfo = item.ToObject <SupplierBalanceDetailInfo>();
if (supplierBalanceDetailInfo.TradeType == SupplierTradeTypes.DrawRequest)
{
item.Add("TradeTypeStr", "提现");
}
else
{
item.Add("TradeTypeStr", "商品交易");
}
if (string.IsNullOrEmpty(supplierBalanceDetailInfo.OrderId))
{
item.Add("OrderIdStr", "--");
}
else
{
item.Add("OrderIdStr", supplierBalanceDetailInfo.OrderId);
}
if (supplierBalanceDetailInfo.Income == decimal.Zero)
{
item.Add("IncomeStr", "--");
}
else
{
item.Add("IncomeStr", supplierBalanceDetailInfo.Income.F2ToString("f2"));
}
if (supplierBalanceDetailInfo.Expenses == decimal.Zero)
{
item.Add("ExpensesStr", "--");
}
else
{
item.Add("ExpensesStr", supplierBalanceDetailInfo.Expenses.F2ToString("f2"));
}
}
dataGridViewModel.rows = list;
dataGridViewModel.total = balanceDetails.TotalRecords;
}
return(dataGridViewModel);
}
