public bool Update(BankrollItemInfo bankrollItemInfo)
{
Parameters cmdParams = GetParameters(bankrollItemInfo);
cmdParams.AddInParameter("@ItemId", DbType.Int32, bankrollItemInfo.ItemId);
return(DBHelper.ExecuteProc("PR_Accessories_BankrollItem_Update", cmdParams));
}
public bool Add(BankrollItemInfo bankrollItemInfo)
{
Parameters cmdParams = GetParameters(bankrollItemInfo);
cmdParams.AddInParameter("@Memo", DbType.String, bankrollItemInfo.Memo);
return(DBHelper.ExecuteProc("PR_Accessories_BankrollItem_Add", cmdParams));
}
protected void EgdvBankrollItem_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
BankrollItemInfo dataItem = e.Row.DataItem as BankrollItemInfo;
if (dataItem != null)
{
if (dataItem.Status == BankrollItemStatus.Confirm)
{
if (dataItem.Money > 0M)
{
this.m_CurrentPageIncome += dataItem.Money;
}
else
{
this.m_CurrentPagePayout += dataItem.Money;
}
}
else
{
LinkButton button = (LinkButton)e.Row.FindControl("LBtnDel");
button.OnClientClick = "return confirm('是否确定要删除这条汇款通知记录？')";
}
Label label = e.Row.FindControl("LblRemark") as Label;
if (label != null)
{
label.Text = StringHelper.SubString(dataItem.Remark, 30, "...");
label.ToolTip = dataItem.Remark;
}
}
}
}
public IList <BankrollItemInfo> GetList(int startRowIndexId, int maxNumberRows, int searchType, int field, string keyword)
{
Database db = DatabaseFactory.CreateDatabase();
IList <BankrollItemInfo> list = new List <BankrollItemInfo>();
DbCommand storedProcCommand = db.GetStoredProcCommand("PR_Common_GetList");
db.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
db.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
db.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "B.ItemID");
db.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "B.*, C.ShortedForm AS ClientName");
db.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
db.AddInParameter(storedProcCommand, "@Filter", DbType.String, "");
db.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_BankrollItem B LEFT JOIN PE_Client C ON B.ClientID = C.ClientID");
db.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, maxNumberRows);
switch (searchType)
{
case 1:
db.SetParameterValue(storedProcCommand, "@Filter", " DATEDIFF(dd, B.DateAndTime, GETDATE()) < 10 ");
break;
case 2:
db.SetParameterValue(storedProcCommand, "@Filter", " DATEDIFF(mm, B.DateAndTime, GETDATE()) < 1 ");
break;
case 3:
db.SetParameterValue(storedProcCommand, "@Filter", " B.Money > 0 ");
break;
case 4:
db.SetParameterValue(storedProcCommand, "@Filter", " B.Money<0 ");
break;
case 5:
db.SetParameterValue(storedProcCommand, "@Filter", " B.Status = 1");
break;
case 6:
db.SetParameterValue(storedProcCommand, "@Filter", " B.Status = 0");
break;
case 10:
HighLevelSearch(field, keyword, db, storedProcCommand);
break;
case 11:
ComplexSearch(keyword, db, storedProcCommand);
break;
}
using (NullableDataReader reader = new NullableDataReader(db.ExecuteReader(storedProcCommand)))
{
while (reader.Read())
{
BankrollItemInfo item = BankrollItemFromrdr(reader);
item.ClientName = reader.GetString("ClientName");
list.Add(item);
}
}
this.m_TotalOfBankrollItem = (int)db.GetParameterValue(storedProcCommand, "@Total");
return(list);
}
protected void EgvBankrollItem_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
BankrollItemInfo dataItem = e.Row.DataItem as BankrollItemInfo;
if (dataItem != null)
{
if (dataItem.Status == BankrollItemStatus.Confirm)
{
if (dataItem.Money > 0M)
{
this.m_CurrentPageIncome += dataItem.Money;
}
else
{
this.m_CurrentPagePayout += dataItem.Money;
}
}
Label label = e.Row.FindControl("LblRemark") as Label;
if (label != null)
{
dataItem.Remark = dataItem.Remark;
label.Text = StringHelper.SubString(dataItem.Remark, 40, "...");
label.ToolTip = dataItem.Remark;
}
}
}
}
protected void BtnSubmitMoney_Click(object sender, EventArgs e)
{
if (this.Page.IsValid)
{
UserInfo usersByUserName = Users.GetUsersByUserName(PEContext.Current.User.UserName);
int howMany = 0;
decimal d = Convert.ToDecimal(this.TxtMoney.Text);
decimal num3 = DataConverter.CDecimal(usersByUserName.UserPurview.Overdraft);
if (d > (usersByUserName.Balance + num3))
{
DynamicPage.WriteErrMsg("<li>您的余额不足以进行此次兑换！</li>");
}
if (SiteConfig.UserConfig.MoneyExchangePoint <= 0.0)
{
DynamicPage.WriteErrMsg("<li>兑换功能关闭，请与管理员联系！</li>", "../Default.aspx");
}
if (d <= 0M)
{
DynamicPage.WriteErrMsg("<li>填写资金必须大于0！</li>");
}
howMany = (int)(((double)d) / SiteConfig.UserConfig.MoneyExchangePoint);
if (((howMany == 0) || (howMany < 0)) || (howMany > 0x5f5e100))
{
DynamicPage.WriteErrMsg("<li>输入资金有误或兑换比率有误！</li>");
}
usersByUserName.Balance -= d;
if (Users.Update(usersByUserName))
{
UserPoint point = new UserPoint();
string reason = string.Concat(new object[] { PEContext.Current.User.UserName, "用", d, "元资金兑换", howMany, SiteConfig.UserConfig.PointName });
if (point.IncreaseForUsers(usersByUserName.UserId.ToString(), howMany, reason, true, ""))
{
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.UserName = usersByUserName.UserName;
bankrollItemInfo.MoneyType = 4;
bankrollItemInfo.CurrencyType = 3;
bankrollItemInfo.DateAndTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Inputer = PEContext.Current.User.UserName;
bankrollItemInfo.IP = PEContext.Current.UserHostAddress;
bankrollItemInfo.LogTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Money = -(d);
bankrollItemInfo.Remark = string.Concat(new object[] { "用于", SiteConfig.UserConfig.PointName, "兑换，消费", d, "元资金，增加", SiteConfig.UserConfig.PointName, howMany, SiteConfig.UserConfig.PointUnit });
bankrollItemInfo.Status = BankrollItemStatus.Confirm;
BankrollItem.Add(bankrollItemInfo);
DynamicPage.WriteSuccessMsg("<li>会员" + SiteConfig.UserConfig.PointName + "兑换成功！</li>", "ExchangePoint.aspx");
}
else
{
DynamicPage.WriteErrMsg("<li>会员" + SiteConfig.UserConfig.PointName + "兑换失败！</li>");
}
}
}
}
public static bool Update(BankrollItemInfo bankrollItemInfo)
{
if (bankrollItemInfo == null)
{
return(false);
}
if (bankrollItemInfo.OrderId == 0)
{
bankrollItemInfo.OrderId = -RandomManage.GetFormatedNumeric(1, 0x7fffffff);
}
return(dal.Update(bankrollItemInfo));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
BankrollItemInfo bankrollItemById = BankrollItem.GetBankrollItemById(BasePage.RequestInt32("BankrollItemID"));
if (!bankrollItemById.IsNull)
{
this.LblDateAndTime.Text = bankrollItemById.DateAndTime.ToString();
this.LblClientName.Text = Client.GetClientNameById(bankrollItemById.ClientId);
this.LblUserName.Text = bankrollItemById.UserName;
this.LblMoneyType.Text = BankrollItem.GetMoneyType(bankrollItemById.MoneyType);
this.LblCurrencyType.Text = BankrollItem.GetCurrencyType(bankrollItemById.CurrencyType);
if (bankrollItemById.Money > 0M)
{
this.LblIncomeMoney.Text = bankrollItemById.Money.ToString("N2");
}
else if (bankrollItemById.Money < 0M)
{
this.LblPaymentMoney.Text = Math.Abs(bankrollItemById.Money).ToString("N2");
}
if (bankrollItemById.MoneyType == 3)
{
this.LblBank.Text = PayPlatform.GetPayPlatformById(bankrollItemById.EBankId).PayPlatformName;
}
else
{
this.LblBank.Text = bankrollItemById.Bank;
}
if (bankrollItemById.Status == BankrollItemStatus.NoConfirm)
{
this.LblStatus.Text = "未确认";
this.BtnConfirm.Visible = true;
this.BtnDelete.Visible = true;
}
else
{
this.LblStatus.Text = "已确认";
}
this.LblIP.Text = bankrollItemById.IP;
this.LblInputer.Text = bankrollItemById.Inputer;
this.LblLogTime.Text = bankrollItemById.LogTime.ToString();
this.LblRemark.Text = bankrollItemById.Remark;
this.LblMemo.Text = bankrollItemById.Memo;
}
else
{
AdminPage.WriteErrMsg("<li>未找到对应的资金明细记录</li>");
}
}
}
protected void BtnMoneySubmit_Click(object sender, EventArgs e)
{
if (this.Page.IsValid)
{
UserInfo usersByUserName = Users.GetUsersByUserName(PEContext.Current.User.UserName);
double input = 0.0;
decimal d = Convert.ToDecimal(this.TxtMoney.Text);
decimal num3 = DataConverter.CDecimal(usersByUserName.UserPurview.Overdraft);
if (d > (usersByUserName.Balance + num3))
{
DynamicPage.WriteErrMsg("<li>您的余额不足以进行此次兑换！</li>");
}
if (SiteConfig.UserConfig.MoneyExchangeValidDay <= 0.0)
{
DynamicPage.WriteErrMsg("<li>兑换功能关闭，请与管理员联系！</li>");
}
if (d <= 0M)
{
DynamicPage.WriteErrMsg("<li>填写资金必须大于0！</li>");
}
input = ((double)d) / SiteConfig.UserConfig.MoneyExchangeValidDay;
if (input <= 0.0)
{
DynamicPage.WriteErrMsg("<li>有效期兑换比率有误！</li>");
}
usersByUserName.Balance -= d;
if (Users.Update(usersByUserName))
{
UserDate date = new UserDate();
string reason = string.Concat(new object[] { PEContext.Current.User.UserName, "用", d, "元资金兑换", input, "天有效期" });
if (date.IncreaseForUsers(usersByUserName.UserId.ToString(), DataConverter.CLng(input), reason, true, ""))
{
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.Inputer = "System";
bankrollItemInfo.UserName = PEContext.Current.User.UserName;
bankrollItemInfo.ClientId = usersByUserName.ClientId;
bankrollItemInfo.Money = -(d);
bankrollItemInfo.MoneyType = 4;
bankrollItemInfo.Remark = string.Concat(new object[] { PEContext.Current.User.UserName, "用", d, "元资金兑换", input, "天有效期" });
bankrollItemInfo.DateAndTime = new DateTime?(DateTime.Now);
BankrollItem.Add(bankrollItemInfo);
DynamicPage.WriteSuccessMsg("<li>会员有效期兑换成功！</li>", "ExchangeValidDate.aspx");
}
else
{
DynamicPage.WriteErrMsg("<li>会员有效期兑换失败！</li>");
}
}
}
}
protected void EgvBankroll_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
BankrollItemInfo dataItem = e.Row.DataItem as BankrollItemInfo;
if (this.ShowOptions == 1)
{
HyperLink link = (HyperLink)e.Row.FindControl("LnkUserName");
link.NavigateUrl = string.Empty;
}
e.Row.Cells[3].Text = BankrollItem.GetMoneyType(dataItem.MoneyType);
e.Row.Cells[4].Text = BankrollItem.GetCurrencyType(dataItem.CurrencyType);
e.Row.Cells[6].Text = (dataItem.Money > 0M) ? "收入" : "支出";
this.m_TotalPayout += dataItem.Money;
}
}
public static bool Add(BankrollItemInfo bankrollItemInfo)
{
if (bankrollItemInfo == null)
{
return(false);
}
if (string.IsNullOrEmpty(bankrollItemInfo.IP))
{
bankrollItemInfo.IP = PEContext.Current.UserHostAddress;
}
if (bankrollItemInfo.OrderId == 0)
{
bankrollItemInfo.OrderId = -RandomManage.GetFormatedNumeric(1, 0x7fffffff);
}
return(dal.Add(bankrollItemInfo));
}
private void AddBankroll(OrderInfo orderInfo, decimal money)
{
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.ClientId = orderInfo.ClientId;
bankrollItemInfo.UserName = orderInfo.UserName;
bankrollItemInfo.CurrencyType = 1;
bankrollItemInfo.MoneyType = 4;
bankrollItemInfo.Inputer = PEContext.Current.Admin.AdminName;
bankrollItemInfo.LogTime = new DateTime?(DateTime.Now);
bankrollItemInfo.DateAndTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Money = (money > 0M) ? (-1M * money) : money;
bankrollItemInfo.OrderId = orderInfo.OrderId;
bankrollItemInfo.Remark = this.TxtRemark.Text.Trim();
bankrollItemInfo.Memo = this.TxtMemo.Text;
BankrollItem.Add(bankrollItemInfo);
}
private static void GetBankrollItemInfo(TransferLogInfo info, OrderInfo orderInfo, UserInfo usersInfo, int payerClientID, out BankrollItemInfo bankrollItemInfo)
{
bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.UserName = info.PayerUserName;
bankrollItemInfo.ClientId = payerClientID;
bankrollItemInfo.Money = (info.Poundage > 0M) ? (-1M * info.Poundage) : info.Poundage;
bankrollItemInfo.MoneyType = 4;
bankrollItemInfo.CurrencyType = 1;
bankrollItemInfo.Bank = "";
bankrollItemInfo.EBankId = 0;
bankrollItemInfo.OrderId = info.OrderId;
bankrollItemInfo.PaymentId = 0;
bankrollItemInfo.Remark = "支付订单过户费用，订单号：" + orderInfo.OrderNum + "。由" + orderInfo.UserName + "过户给" + usersInfo.UserName;
bankrollItemInfo.LogTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Inputer = info.Inputer;
bankrollItemInfo.IP = PEContext.Current.UserHostAddress;
bankrollItemInfo.DateAndTime = new DateTime?(DateTime.Now);
}
private void SaveBankrollItemInfo(int point, decimal balance, UserInfo userInfo)
{
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.UserName = userInfo.UserName;
bankrollItemInfo.MoneyType = 4;
bankrollItemInfo.CurrencyType = 3;
bankrollItemInfo.DateAndTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Inputer = PEContext.Current.Admin.AdminName;
bankrollItemInfo.Bank = "";
bankrollItemInfo.ClientName = "";
bankrollItemInfo.IP = PEContext.Current.UserHostAddress;
bankrollItemInfo.LogTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Money = -balance;
bankrollItemInfo.Remark = string.Concat(new object[] { "用于", this.m_PointName, "兑换，消费", balance, "资金，增加", this.m_PointName, point, SiteConfig.UserConfig.PointUnit });
bankrollItemInfo.Status = BankrollItemStatus.Confirm;
BankrollItem.Add(bankrollItemInfo);
}
private void SaveBankrollItemInfo(decimal balance, UserInfo userInfo)
{
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.UserName = userInfo.UserName;
bankrollItemInfo.MoneyType = 4;
bankrollItemInfo.CurrencyType = 3;
bankrollItemInfo.DateAndTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Inputer = PEContext.Current.Admin.AdminName;
bankrollItemInfo.Bank = "";
bankrollItemInfo.ClientName = "";
bankrollItemInfo.IP = PEContext.Current.UserHostAddress;
bankrollItemInfo.LogTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Money = -(balance);
bankrollItemInfo.Remark = string.Concat(new object[] { "消费", balance, "资金，有效期截至日期为", userInfo.EndTime.Value.ToString() });
bankrollItemInfo.Status = BankrollItemStatus.Confirm;
BankrollItem.Add(bankrollItemInfo);
}
private static void UpdateUserInfo(OrderInfo orderinfo, int TotalPresentExp, int TotalPresentPoint, int TotalPresentMoney)
{
if ((((orderinfo.PresentExp != 0) || (orderinfo.PresentMoney != 0M)) || ((orderinfo.PresentPoint != 0) || (TotalPresentExp != 0))) || ((TotalPresentMoney != 0) || (TotalPresentPoint != 0)))
{
UserInfo usersByUserName = Users.GetUsersByUserName(orderinfo.UserName);
if ((orderinfo.PresentMoney > 0M) || (TotalPresentMoney > 0))
{
usersByUserName.Balance = (usersByUserName.Balance + orderinfo.PresentMoney) + TotalPresentMoney;
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.Inputer = "";
bankrollItemInfo.UserName = orderinfo.UserName;
bankrollItemInfo.ClientId = orderinfo.ClientId;
bankrollItemInfo.Money = orderinfo.PresentMoney + TotalPresentMoney;
bankrollItemInfo.MoneyType = 4;
bankrollItemInfo.Bank = "";
bankrollItemInfo.EBankId = 0;
bankrollItemInfo.OrderId = orderinfo.OrderId;
bankrollItemInfo.PaymentId = 0;
bankrollItemInfo.Remark = "购物返还现金券";
bankrollItemInfo.LogTime = new DateTime?(DateTime.Now);
bankrollItemInfo.DateAndTime = new DateTime?(DateTime.Now);
bankrollItemInfo.CurrencyType = 1;
BankrollItem.Add(bankrollItemInfo);
}
if ((orderinfo.PresentExp > 0) || (TotalPresentExp > 0))
{
usersByUserName.UserExp = (usersByUserName.UserExp + orderinfo.PresentExp) + TotalPresentExp;
}
if ((orderinfo.PresentPoint > 0) || (TotalPresentPoint > 0))
{
usersByUserName.UserPoint = (usersByUserName.UserPoint + orderinfo.PresentPoint) + TotalPresentPoint;
UserPointLogInfo userPointLogInfo = new UserPointLogInfo();
userPointLogInfo.UserName = usersByUserName.UserName;
userPointLogInfo.IncomePayOut = 1;
userPointLogInfo.LogTime = DateTime.Now;
userPointLogInfo.Point = orderinfo.PresentPoint + TotalPresentPoint;
userPointLogInfo.Remark = "购物返还" + SiteConfig.UserConfig.PointName;
UserPointLog.Add(userPointLogInfo);
}
Users.Update(usersByUserName);
}
}
private static Parameters GetParameters(BankrollItemInfo bankrollItemInfo)
{
Parameters parameters = new Parameters();
parameters.AddInParameter("@UserName", DbType.String, bankrollItemInfo.UserName);
parameters.AddInParameter("@ClientID", DbType.Int32, bankrollItemInfo.ClientId);
parameters.AddInParameter("@DateAndTime", DbType.DateTime, bankrollItemInfo.DateAndTime);
parameters.AddInParameter("@Money", DbType.Currency, bankrollItemInfo.Money);
parameters.AddInParameter("@MoneyType", DbType.Int32, bankrollItemInfo.MoneyType);
parameters.AddInParameter("@CurrencyType", DbType.Int32, bankrollItemInfo.CurrencyType);
parameters.AddInParameter("@eBankID", DbType.Int32, bankrollItemInfo.EBankId);
parameters.AddInParameter("@Bank", DbType.String, bankrollItemInfo.Bank);
parameters.AddInParameter("@OrderID", DbType.Int32, bankrollItemInfo.OrderId);
parameters.AddInParameter("@PaymentID", DbType.Int32, bankrollItemInfo.PaymentId);
parameters.AddInParameter("@Remark", DbType.String, bankrollItemInfo.Remark);
parameters.AddInParameter("@LogTime", DbType.DateTime, bankrollItemInfo.LogTime);
parameters.AddInParameter("@Inputer", DbType.String, bankrollItemInfo.Inputer);
parameters.AddInParameter("@IP", DbType.String, bankrollItemInfo.IP);
parameters.AddInParameter("@Status", DbType.Int32, bankrollItemInfo.Status);
return(parameters);
}
private static void AddBankroll(AgentInfo agentInfo, int incomePayOut, string inputer, string remark)
{
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.ClientId = agentInfo.ClientId;
bankrollItemInfo.UserName = agentInfo.AgentName;
bankrollItemInfo.CurrencyType = 1;
bankrollItemInfo.Inputer = inputer;
bankrollItemInfo.LogTime = new DateTime?(DateTime.Now);
bankrollItemInfo.DateAndTime = new DateTime?(DateTime.Now);
decimal money = agentInfo.Money;
if (incomePayOut == 2)
{
money = (money > 0M) ? (-1M * money) : money;
}
bankrollItemInfo.Money = money;
bankrollItemInfo.MoneyType = 4;
bankrollItemInfo.OrderId = agentInfo.OrderId;
bankrollItemInfo.Remark = remark;
BankrollItem.Add(bankrollItemInfo);
}
public static bool Payment(int clientId, decimal money, string remark, string inputer, string memo)
{
bool flag = false;
if (dal.Payment(clientId, money))
{
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.Inputer = inputer;
bankrollItemInfo.UserName = "";
bankrollItemInfo.ClientId = clientId;
bankrollItemInfo.CurrencyType = 1;
bankrollItemInfo.LogTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Money = (money > 0M) ? (-1M * money) : money;
bankrollItemInfo.MoneyType = 4;
bankrollItemInfo.OrderId = 0;
bankrollItemInfo.Remark = remark;
bankrollItemInfo.DateAndTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Memo = memo;
flag = BankrollItem.Add(bankrollItemInfo);
}
return(flag);
}
public static bool Remit(int clientId, decimal money, DateTime receiptDate, string bank, string remark, string inputer, string memo)
{
bool flag = false;
if (dal.Income(clientId, money))
{
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.Inputer = inputer;
bankrollItemInfo.UserName = "";
bankrollItemInfo.ClientId = clientId;
bankrollItemInfo.CurrencyType = 1;
bankrollItemInfo.LogTime = new DateTime?(DateTime.Now);
bankrollItemInfo.DateAndTime = new DateTime?(receiptDate);
bankrollItemInfo.Money = money;
bankrollItemInfo.MoneyType = 4;
bankrollItemInfo.OrderId = 0;
bankrollItemInfo.Bank = bank;
bankrollItemInfo.Remark = remark;
bankrollItemInfo.Memo = memo;
flag = BankrollItem.Add(bankrollItemInfo);
}
return(flag);
}
private void AddMoneyLog(decimal money, IList <UserInfo> userList, string reason, string memo)
{
foreach (UserInfo info in userList)
{
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.Inputer = this.m_FromUser;
bankrollItemInfo.UserName = info.UserName;
bankrollItemInfo.ClientId = info.ClientId;
bankrollItemInfo.MoneyType = 4;
bankrollItemInfo.CurrencyType = 3;
bankrollItemInfo.DateAndTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Inputer = this.m_FromUser;
bankrollItemInfo.Bank = "";
bankrollItemInfo.ClientName = "";
bankrollItemInfo.IP = this.m_FromUserIp;
bankrollItemInfo.LogTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Money = money;
bankrollItemInfo.Remark = reason;
bankrollItemInfo.Status = BankrollItemStatus.Confirm;
bankrollItemInfo.Memo = memo;
s_Bank.Add(bankrollItemInfo);
}
}
private static BankrollItemInfo BankrollItemFromrdr(NullableDataReader rdr)
{
BankrollItemInfo info = new BankrollItemInfo();
info.ItemId = rdr.GetInt32("ItemID");
info.UserName = rdr.GetString("UserName");
info.ClientId = rdr.GetInt32("ClientID");
info.DateAndTime = rdr.GetNullableDateTime("DateAndTime");
info.Money = rdr.GetDecimal("Money");
info.MoneyType = rdr.GetInt32("MoneyType");
info.CurrencyType = rdr.GetInt32("CurrencyType");
info.EBankId = rdr.GetInt32("eBankID");
info.Bank = rdr.GetString("Bank");
info.OrderId = rdr.GetInt32("OrderID");
info.PaymentId = rdr.GetInt32("PaymentID");
info.Remark = rdr.GetString("Remark");
info.LogTime = rdr.GetNullableDateTime("LogTime");
info.Inputer = rdr.GetString("Inputer");
info.IP = rdr.GetString("IP");
info.Status = (BankrollItemStatus)rdr.GetInt32("Status");
info.Memo = rdr.GetString("Memo");
return(info);
}
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
if (this.Page.IsValid)
{
decimal num = DataConverter.CDecimal(this.TxtMoney.Text);
UserInfo userInfo = this.ShowUserInfo.UserInfo;
if (userInfo == null)
{
AdminPage.WriteErrMsg("<li>找不到指定的会员！</li>");
}
else
{
if (string.IsNullOrEmpty(this.DropBankShortName.SelectedValue))
{
AdminPage.WriteErrMsg("<li>请选择汇入银行！如果没有请到系统设置下的银行账户管理中添加银行账户 ！</li>", "UserShow.aspx?UserID=" + userInfo.UserId);
}
userInfo.Balance += num;
if (Users.Update(userInfo))
{
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.UserName = userInfo.UserName;
bankrollItemInfo.ClientId = userInfo.ClientId;
bankrollItemInfo.DateAndTime = new DateTime?(this.DpkReceipt.Date);
bankrollItemInfo.Money = num;
bankrollItemInfo.MoneyType = 2;
bankrollItemInfo.CurrencyType = 1;
bankrollItemInfo.Bank = this.DropBankShortName.SelectedItem.Text;
bankrollItemInfo.EBankId = 0;
bankrollItemInfo.PaymentId = 0;
bankrollItemInfo.OrderId = 0;
bankrollItemInfo.Remark = this.TxtRemark.Text.Trim();
bankrollItemInfo.LogTime = new DateTime?(DateTime.Now);
bankrollItemInfo.Inputer = PEContext.Current.Admin.AdminName;
bankrollItemInfo.IP = PEContext.Current.UserHostAddress;
bankrollItemInfo.Memo = this.TxtMemo.Text;
if (this.ChkPoint.Checked && !string.IsNullOrEmpty(userInfo.UserName))
{
int infoPoint = DataConverter.CLng(this.TxtPoint.Text);
if (Users.AddPoint(infoPoint, userInfo.UserName))
{
UserPointLogInfo userPointLogInfo = new UserPointLogInfo();
userPointLogInfo.Inputer = PEContext.Current.Admin.AdminName;
userPointLogInfo.IP = PEContext.Current.UserHostAddress;
userPointLogInfo.UserName = userInfo.UserName;
userPointLogInfo.LogTime = DateTime.Now;
userPointLogInfo.Remark = "银行汇款赠送" + SiteConfig.UserConfig.PointName;
userPointLogInfo.Memo = "";
userPointLogInfo.IncomePayOut = 1;
userPointLogInfo.Point = infoPoint;
UserPointLog.Add(userPointLogInfo);
}
}
if (BankrollItem.Add(bankrollItemInfo))
{
StringBuilder builder = new StringBuilder();
builder.Append("<li>给会员添加银行汇款记录成功！</li>");
if (this.ChkIsSendMessage.Checked)
{
string sendContent = SiteConfig.SmsConfig.BankLogMessage.Replace("{$Money}", Math.Abs(bankrollItemInfo.Money).ToString()).Replace("{$BankName}", bankrollItemInfo.Bank).Replace("{$ReceiptDate}", this.DpkReceipt.Date.ToString());
builder.Append(Users.SendMessageToUser(userInfo, sendContent));
}
AdminPage.WriteSuccessMsg(builder.ToString(), "UserShow.aspx?UserID=" + userInfo.UserId);
}
else
{
AdminPage.WriteErrMsg("<li>向资金明细表中添加收入记录失败！</li>", "UserShow.aspx?UserID=" + userInfo.UserId);
}
}
else
{
AdminPage.WriteErrMsg("<li>给会员添加银行汇款记录失败！</li>");
}
}
}
}
public PayOnlineState UpdateOrder(string paymentNum, decimal amount, string eBankInfo, int status, string remark, bool updateDeliverStatus, bool updateOrderStatus)
{
if (Convert.ToString(PEContext.Current.Context.Session["PaymentNum"]) != paymentNum)
{
PEContext.Current.Context.Session["PaymentNum"] = paymentNum;
StringBuilder payOnlineMessage = new StringBuilder(0x40);
paymentNum = DataSecurity.FilterBadChar(paymentNum);
eBankInfo = DataSecurity.FilterBadChar(eBankInfo);
remark = DataSecurity.FilterBadChar(remark);
PayOnlineState state = this.UpdatePaymentLog(paymentNum, amount, eBankInfo, status, remark);
if (state != PayOnlineState.Ok)
{
PEContext.Current.Context.Session["PaymentNum"] = "";
return(state);
}
if (!updateDeliverStatus)
{
PEContext.Current.Context.Session["PaymentNum"] = "";
return(PayOnlineState.Ok);
}
bool doUpdate = !BankrollItem.ExistsPaymentLog(this.m_PaymentLogId);
if (!doUpdate)
{
PEContext.Current.Context.Session["PaymentNum"] = "";
return(PayOnlineState.AccountPaid);
}
bool isok = false;
IEncourageStrategy <decimal> strategy = new UserMoney();
if (updateOrderStatus)
{
if (this.m_UserId > 0)
{
strategy.IncreaseForUsers(this.m_UserId.ToString(), this.m_MoneyReceipt, "", false, "");
}
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.UserName = this.m_UserName;
bankrollItemInfo.ClientId = this.m_ClientID;
bankrollItemInfo.Money = this.m_MoneyReceipt;
bankrollItemInfo.MoneyType = 3;
bankrollItemInfo.EBankId = this.m_PlatformId;
bankrollItemInfo.OrderId = this.m_OrderInfo.OrderId;
bankrollItemInfo.PaymentId = this.m_PaymentLogId;
bankrollItemInfo.Remark = "在线支付单号：" + paymentNum;
bankrollItemInfo.DateAndTime = new DateTime?(DateTime.Now);
bankrollItemInfo.CurrencyType = 1;
isok = BankrollItem.Add(bankrollItemInfo);
}
if (this.m_OrderInfo.IsNull)
{
if (this.m_Point > 0)
{
IEncourageStrategy <int> strategy2 = new UserPoint();
strategy2.IncreaseForUsers(this.m_UserId.ToString(), this.m_Point, "购买" + SiteConfig.UserConfig.PointName, true, "");
BankrollItemInfo info2 = new BankrollItemInfo();
info2.UserName = this.m_UserName;
info2.ClientId = this.m_ClientID;
info2.Money = (this.m_MoneyReceipt > 0M) ? (-1M * this.m_MoneyReceipt) : this.m_MoneyReceipt;
info2.MoneyType = 4;
info2.EBankId = 0;
info2.OrderId = this.m_OrderInfo.OrderId;
info2.PaymentId = 0;
info2.Remark = "购买" + SiteConfig.UserConfig.PointName + "，购买数：" + this.m_Point.ToString() + SiteConfig.UserConfig.PointUnit;
info2.DateAndTime = new DateTime?(DateTime.Now);
info2.CurrencyType = 1;
isok = BankrollItem.Add(info2);
if (this.m_UserId > 0)
{
isok = strategy.IncreaseForUsers(this.m_UserId.ToString(), -(this.m_MoneyReceipt), "", false, "");//将decimal.op_UnaryNegation
}
}
PEContext.Current.Context.Session["PaymentNum"] = "";
if (!isok)
{
return(PayOnlineState.Fail);
}
return(PayOnlineState.Ok);
}
if (updateDeliverStatus && ((this.m_OrderInfo.MoneyTotal - this.m_OrderInfo.MoneyReceipt) <= this.m_MoneyReceipt))
{
this.m_OrderInfo.EnableDownload = true;
isok = Order.Update(this.m_OrderInfo);
}
if ((this.m_OrderInfo.MoneyReceipt < this.m_OrderInfo.MoneyTotal) && updateOrderStatus)
{
bool flag3 = false;
if ((this.m_OrderInfo.MoneyTotal - this.m_OrderInfo.MoneyReceipt) <= this.m_MoneyReceipt)
{
this.m_MoneyPayout = this.m_OrderInfo.MoneyTotal - this.m_OrderInfo.MoneyReceipt;
this.m_OrderInfo.MoneyReceipt = this.m_OrderInfo.MoneyTotal;
flag3 = true;
}
else if (SiteConfig.ShopConfig.EnablePartPay)
{
this.m_MoneyPayout = this.m_MoneyReceipt;
this.m_OrderInfo.MoneyReceipt += this.m_MoneyReceipt;
flag3 = true;
}
if (flag3)
{
if (this.m_OrderInfo.Status <= OrderStatus.WaitForConfirm)
{
this.m_OrderInfo.Status = OrderStatus.Confirmed;
}
isok = Order.Update(this.m_OrderInfo);
BankrollItemInfo info3 = new BankrollItemInfo();
info3.UserName = this.m_UserName;
info3.ClientId = this.m_ClientID;
info3.Money = (this.m_MoneyPayout > 0M) ? (-1M * this.m_MoneyPayout) : this.m_MoneyPayout;
info3.MoneyType = 4;
info3.EBankId = 0;
info3.OrderId = this.m_OrderInfo.OrderId;
info3.PaymentId = 0;
info3.Remark = "支付订单费用，订单号：" + this.m_OrderInfo.OrderNum;
info3.DateAndTime = new DateTime?(DateTime.Now);
info3.CurrencyType = 1;
isok = BankrollItem.Add(info3);
if (this.m_UserId > 0)
{
isok = strategy.IncreaseForUsers(this.m_UserId.ToString(), -(this.m_MoneyPayout), "", false, "");//将decimal.op_UnaryNegation改为了-
}
payOnlineMessage.Append("同时已经为您的订单编号为 " + this.m_OrderInfo.OrderNum + " 的订单支付了 " + this.m_MoneyPayout.ToString("N2") + "元。<br />");
}
else
{
payOnlineMessage.Append("您的支付金额小于订单金额，不能对订单进行支付，资金已经打入您的帐户中做为预付款。<br />");
updateDeliverStatus = false;
}
}
if (updateDeliverStatus)
{
this.ShowCardInfo(payOnlineMessage, doUpdate, isok);
}
payOnlineMessage.Append("<a href='../User/Shop/ShowOrder.aspx?OrderId=" + this.m_OrderInfo.OrderId.ToString() + "'>点此查看订单信息</a>");
this.m_Message = payOnlineMessage.ToString();
PEContext.Current.Context.Session["PaymentNum"] = "";
if (!isok)
{
return(PayOnlineState.Fail);
}
}
return(PayOnlineState.Ok);
}
private void AddBankroll(int paymentLogId)
{
if (!BankrollItem.ExistsPaymentLog(paymentLogId))
{
PaymentLogInfo paymentLogById = PaymentLog.GetPaymentLogById(paymentLogId);
if (!paymentLogById.IsNull)
{
IEncourageStrategy <decimal> strategy = new UserMoney();
int userId = 0;
UserInfo usersByUserName = new UserInfo(true);
if (!string.IsNullOrEmpty(paymentLogById.UserName))
{
usersByUserName = Users.GetUsersByUserName(paymentLogById.UserName);
userId = usersByUserName.UserId;
if (userId > 0)
{
strategy.IncreaseForUsers(userId.ToString(), paymentLogById.MoneyPay, "", false, "");
BankrollItemInfo bankrollItemInfo = new BankrollItemInfo();
bankrollItemInfo.UserName = paymentLogById.UserName;
bankrollItemInfo.Money = paymentLogById.MoneyPay;
bankrollItemInfo.MoneyType = 3;
bankrollItemInfo.EBankId = paymentLogById.PlatformId;
bankrollItemInfo.OrderId = paymentLogById.OrderId;
bankrollItemInfo.PaymentId = paymentLogId;
bankrollItemInfo.Remark = "在线支付单号：" + paymentLogById.PaymentNum;
bankrollItemInfo.DateAndTime = DateTime.Now;
bankrollItemInfo.CurrencyType = 1;
bankrollItemInfo.ClientId = usersByUserName.ClientId;
BankrollItem.Add(bankrollItemInfo);
}
}
if (paymentLogById.OrderId > 0)
{
OrderInfo orderById = Order.GetOrderById(paymentLogById.OrderId);
if (!orderById.IsNull)
{
decimal d = 0M;
if (orderById.MoneyTotal > orderById.MoneyReceipt)
{
if ((orderById.MoneyTotal - orderById.MoneyReceipt) > paymentLogById.MoneyPay)
{
if (SiteConfig.ShopConfig.EnablePartPay)
{
d = paymentLogById.MoneyPay;
orderById.MoneyReceipt += paymentLogById.MoneyPay;
}
}
else
{
d = orderById.MoneyTotal - orderById.MoneyReceipt;
orderById.MoneyReceipt = orderById.MoneyTotal;
}
orderById.Status = OrderStatus.Confirmed;
Order.Update(orderById);
}
if (d > 0M)
{
strategy.IncreaseForUsers(userId.ToString(), -d, "", false, "");
BankrollItemInfo info5 = new BankrollItemInfo();
info5.UserName = usersByUserName.UserName;
info5.ClientId = usersByUserName.ClientId;
info5.Money = -d;
info5.MoneyType = 4;
info5.EBankId = 0;
info5.OrderId = orderById.OrderId;
info5.PaymentId = 0;
info5.Remark = "支付订单费用，订单号：" + orderById.OrderNum;
info5.DateAndTime = DateTime.Now;
info5.CurrencyType = 1;
BankrollItem.Add(info5);
}
}
}
else if (paymentLogById.Point > 0)
{
IEncourageStrategy <int> strategy2 = new UserPoint();
strategy2.IncreaseForUsers(userId.ToString(), paymentLogById.Point, "购买" + SiteConfig.UserConfig.PointName, true, "");
BankrollItemInfo info6 = new BankrollItemInfo();
info6.UserName = usersByUserName.UserName;
info6.ClientId = usersByUserName.ClientId;
info6.Money = (paymentLogById.MoneyPay > 0M) ? (-1M * paymentLogById.MoneyPay) : paymentLogById.MoneyPay;
info6.MoneyType = 4;
info6.EBankId = 0;
info6.OrderId = 0;
info6.PaymentId = 0;
info6.Remark = "购买" + SiteConfig.UserConfig.PointName + "，购买数：" + paymentLogById.Point.ToString() + SiteConfig.UserConfig.PointUnit;
info6.DateAndTime = new DateTime?(DateTime.Now);
info6.CurrencyType = 1;
BankrollItem.Add(info6);
if (usersByUserName.UserId > 0)
{
strategy.IncreaseForUsers(usersByUserName.UserId.ToString(), -(paymentLogById.MoneyPay), "", false, "");
}
}
}
}
}
