public static bool InsertLogMsg(BillNoticeHistory billNotice, string operer)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("@UserName", billNotice.UserName),
new MySqlParameter("@Names", billNotice.Names),
new MySqlParameter("@Type", billNotice.Type),
new MySqlParameter("@Amount", billNotice.Amount),
new MySqlParameter("@SubmitTime", billNotice.SubmitTime),
new MySqlParameter("@UpdateTime", billNotice.UpdateTime),
new MySqlParameter("@Status", billNotice.Status),
new MySqlParameter("@Reasoncn", billNotice.Reasoncn),
new MySqlParameter("@Reasontw", billNotice.Reasontw),
new MySqlParameter("@Reasonen", billNotice.Reasonen),
new MySqlParameter("@Reasonth", billNotice.Reasonth),
new MySqlParameter("@Reasonvn", billNotice.Reasonvn),
new MySqlParameter("@bankcn", billNotice.Bankcn),
new MySqlParameter("@banktw", billNotice.Banktw),
new MySqlParameter("@banken", billNotice.Banken),
new MySqlParameter("@bankth", billNotice.Bankth),
new MySqlParameter("@bankaccount", billNotice.Bankaccount),
new MySqlParameter("@bankno", billNotice.Bankno),
new MySqlParameter("@cardno", billNotice.CardNo),
new MySqlParameter("@operator", operer),
new MySqlParameter("@operationtime", DateTime.Now),
new MySqlParameter("@ip", Util.RequestHelper.GetIP())
};
return(MySqlHelper.ExecuteNonQuery(INSERT, param) > 0);
}
public static bool InsertLogMsg2(BillNoticeHistory billNotice, string operer)
{
string INSERT2 = "insert into BillLog(UserName,Names,Type,Amount,SubmitTime,UpdateTime,Status,Reasoncn,Reasontw,Reasonen,Reasonth,Reasonvn,bankcn,banktw,banken,bankth,bankaccount,bankno,cardno,operator,operationtime,ip) values(@UserName,@Names,@Type,@Amount,@SubmitTime,@UpdateTime,@Status,@Reasoncn,@Reasontw,@Reasonen,@Reasonth,@Reasonvn,@bankcn,@banktw,@banken,@bankth,@bankaccount,@bankno,@cardno,@operator,@operationtime,@ip);";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("@UserName", billNotice.UserName),
new MySqlParameter("@Names", billNotice.Names),
new MySqlParameter("@Type", billNotice.Type),
new MySqlParameter("@Amount", billNotice.Amount),
new MySqlParameter("@SubmitTime", billNotice.SubmitTime),
new MySqlParameter("@UpdateTime", billNotice.UpdateTime),
new MySqlParameter("@Status", billNotice.Status),
new MySqlParameter("@Reasoncn", billNotice.Reasoncn),
new MySqlParameter("@Reasontw", billNotice.Reasontw),
new MySqlParameter("@Reasonen", billNotice.Reasonen),
new MySqlParameter("@Reasonth", billNotice.Reasonth),
new MySqlParameter("@Reasonvn", billNotice.Reasonvn),
new MySqlParameter("@bankcn", billNotice.Bankcn),
new MySqlParameter("@banktw", billNotice.Banktw),
new MySqlParameter("@banken", billNotice.Banken),
new MySqlParameter("@bankth", billNotice.Bankth),
new MySqlParameter("@bankaccount", billNotice.Bankaccount),
new MySqlParameter("@bankno", billNotice.Bankno),
new MySqlParameter("@cardno", billNotice.CardNo),
new MySqlParameter("@operator", operer),
new MySqlParameter("@operationtime", DateTime.Now),
new MySqlParameter("@ip", "127.0.0.1")
};
return(MySqlHelper.ExecuteNonQuery(INSERT2, param) > 0);
}
public bool InsertBillNoticeManagentC(BillNoticeHistory billNoticeHistory)
{
string sqlInsert = "insert into yafa.billnoticehistory (Currency,bankc,banknamec,banknoc,cardnoc,Bankcn,Reasoncn,UserName,CardNo,Amount,sfee,Type,Status,Mark,Names,SubmitTime,UpdateTime,bankamount1,bankamount2)values(?Currency,?bankc,?banknamec,?banknoc,?cardnoc,?Bankcn,?Reasoncn,?UserName,?CardNo,?Amount,?sfee,?Type,?Status,?Mark,?Names,?SubmitTime,?UpdateTime,?bankamount1,?bankamount2)";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Currency", billNoticeHistory.Currency),
new MySqlParameter("?bankc", billNoticeHistory.bankc),
new MySqlParameter("?banknamec", billNoticeHistory.banknamec),
new MySqlParameter("?banknoc", billNoticeHistory.banknoc),
new MySqlParameter("?cardnoc", billNoticeHistory.cardnoc),
new MySqlParameter("?Bankcn", billNoticeHistory.Bankcn),
new MySqlParameter("?Reasoncn", billNoticeHistory.Reasoncn),
new MySqlParameter("?UserName", billNoticeHistory.UserName),
new MySqlParameter("?CardNo", billNoticeHistory.CardNo),
new MySqlParameter("?Amount", billNoticeHistory.Amount),
new MySqlParameter("?sfee", billNoticeHistory.sfee),
new MySqlParameter("?Type", billNoticeHistory.Type),
new MySqlParameter("?Status", billNoticeHistory.Status),
new MySqlParameter("?Mark", billNoticeHistory.Mark),
new MySqlParameter("?Names", billNoticeHistory.Names),
new MySqlParameter("?SubmitTime", billNoticeHistory.SubmitTime),
new MySqlParameter("?UpdateTime", billNoticeHistory.UpdateTime),
new MySqlParameter("?bankamount1", billNoticeHistory.bankamount1),
new MySqlParameter("?bankamount2", billNoticeHistory.bankamount2)
};
return(MySqlHelper.ExecuteNonQuery(sqlInsert, param) > 0);
}
/// <summary>
/// 添加赢币
/// </summary>
/// <param name="yingb"></param>
/// <param name="mark"></param>
/// <param name="username"></param>
/// <returns></returns>
public static bool AddYingb(decimal yingb, string type, string mark, string username)
{
bool reval = true;
//更新赢币
try
{
if (DAL.UserService.UpdateYingb(yingb, username))
{
//插入赠送赢币记录
BillNoticeHistory billHistory = new BillNoticeHistory();
billHistory.UserName = username;
billHistory.Type = type;
billHistory.Amount = yingb;
billHistory.ValidAmount = yingb;
billHistory.SubmitTime = DateTime.Now;
billHistory.UpdateTime = DateTime.Now;
billHistory.Status = "2";
billHistory.Mark = mark;
reval = BLL.BankManager.InsertBillNoticeHistory(billHistory);
}
}
catch
{
reval = false;
}
return(reval);
}
public static bool InsertBillNoticeManagent(BillNoticeHistory billNoticeHistory)
{
try
{
return(bankhistoryService.InsertBillNoticeManagent(billNoticeHistory));
}
catch (Exception ex)
{
//可以记录到异常日志
return(false);
}
}
/// <summary>
/// EZUN与EA相转时失败记录
/// </summary>
/// <param name="billNoticeHistory"></param>
/// <returns></returns>
public static bool InBillNoticeHistoryWrong(BillNoticeHistory billNoticeHistory)
{
string sqlInsert = "insert into yafa.billnoticehistory (Currency,UserName,Type,SubmitTime,UpdateTime,Status,Reasoncn,Names,Mark)values(?Currency,?UserName,?Type,?SubmitTime,?UpdateTime,?Status,?Reasoncn,?Names,?Mark)";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Currency", billNoticeHistory.Currency),
new MySqlParameter("?UserName", billNoticeHistory.UserName),
new MySqlParameter("?Type", billNoticeHistory.Type),
new MySqlParameter("?SubmitTime", billNoticeHistory.SubmitTime),
new MySqlParameter("?UpdateTime", billNoticeHistory.UpdateTime),
new MySqlParameter("?Status", billNoticeHistory.Status),
new MySqlParameter("?Reasoncn", billNoticeHistory.Reasoncn),
new MySqlParameter("?Names", billNoticeHistory.Names),
new MySqlParameter("?Mark", billNoticeHistory.Mark)
};
return(MySqlHelper.ExecuteNonQuery(sqlInsert, param) > 0);
}
public string Updatebillnoticehistory(string status, int ID)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return("-1");
}
Manager manager = Session[Util.ProjectConfig.ADMINUSER] as Manager;
//return DAL.UserService.Updatebillnoticehistory(status, ID) ? "1" : "0";
BillNotice billNotice = BLL.BankManager.GetBillNotice(ID.ToString());
Model.BillNoticeHistory billHistory = new BillNoticeHistory();
billHistory.UserName = billNotice.UserName;
billHistory.Type = billNotice.Type;
billHistory.Amount = billNotice.Amount;
billHistory.SubmitTime = billNotice.SubmitTime;
billHistory.UpdateTime = DateTime.Now;
billHistory.Status = status;
bool rebit = BLL.BankManager.InsertBillNoticeHistory(billHistory);
if (rebit)
{
bool reb = BLL.BankManager.DeleteBillNoticeByID(ID.ToString());
if (status == "3")
{
//拒绝
if (reb)
{
BLL.BankManager.UpdateBalance(billNotice.Amount.ToString(), billNotice.UserName, "1");
}
}
else
{
string operers = manager.ManagerId;
BLL.BankManager.InsertPTLog2(billNotice.UserName, billNotice.Amount, operers);
}
}
return(rebit ? "1" : "0");
}
public static bool InsertBillNoticeManagentC(BillNoticeHistory billNoticeHistory)
{
return(bankhistoryService.InsertBillNoticeManagentC(billNoticeHistory));
}
public static bool InsertBillNoticeHistory(BillNoticeHistory billNoticeHistory)
{
return(bankservice.InsertBillNoticeHistory(billNoticeHistory));
}
public static bool CancelBNH(BillNoticeHistory bnh)
{
return(bankservice.CancelBNH(bnh));
}
public static bool InsertOperateLog2(BillNoticeHistory billNotice, string operer)
{
return(bankservice.InsertOperateLog2(billNotice, operer));
}
