public bool AddBillNotice2(BillNotice billNotice)
{
string SQL_INSERTBILLNOTICE = "insert into BillNotice(UserName,Type,Amount,SubmitTime,Status,CardNo,bankcn,banktw,banken,bankth,bankno,Currency,Names,banktime,tel,Mark) values(?UserName,?Type,?Amount,?SubmitTime,?Status,?CardNo,?bankcn,?banktw,?banken,?bankth,?bankno,?Currency,?Names,?BankTime,?Tel,?Mark)";
MySqlParameter[] parm = new MySqlParameter[] {
new MySqlParameter("?UserName", MySqlDbType.VarChar, 30),
new MySqlParameter("?Type", MySqlDbType.VarChar, 1),
new MySqlParameter("?Amount", MySqlDbType.Decimal),
new MySqlParameter("?SubmitTime", MySqlDbType.DateTime),
new MySqlParameter("?Status", MySqlDbType.VarChar, 1),
new MySqlParameter("?CardNo", MySqlDbType.VarChar, 30),
new MySqlParameter("?bankcn", MySqlDbType.VarChar, 100),
new MySqlParameter("?banktw", MySqlDbType.VarChar, 100),
new MySqlParameter("?banken", MySqlDbType.VarChar, 100),
new MySqlParameter("?bankth", MySqlDbType.VarChar, 100),
new MySqlParameter("?bankno", MySqlDbType.VarChar, 100),
new MySqlParameter("?Currency", MySqlDbType.VarChar, 10),
new MySqlParameter("?Names", MySqlDbType.VarChar, 30),
new MySqlParameter("?BankTime", MySqlDbType.VarChar, 30),
new MySqlParameter("?Tel", MySqlDbType.VarChar, 30),
new MySqlParameter("?Mark", MySqlDbType.VarChar, 30)
};
parm[0].Value = billNotice.UserName;
parm[1].Value = billNotice.Type;
parm[2].Value = billNotice.Amount;
parm[3].Value = billNotice.SubmitTime;
parm[4].Value = billNotice.Status;
parm[5].Value = billNotice.CardNo;
parm[6].Value = billNotice.Bankcn;
parm[7].Value = billNotice.Banktw;
parm[8].Value = billNotice.Banken;
parm[9].Value = billNotice.Bankth;
parm[10].Value = billNotice.Bankno;
parm[11].Value = billNotice.Currency;
parm[12].Value = billNotice.Names;
parm[13].Value = billNotice.BankTime;
parm[14].Value = billNotice.Tel;
parm[15].Value = billNotice.Mark;
return(MySqlHelper.ExecuteNonQuery(SQL_INSERTBILLNOTICE, parm) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="billNotice"></param>
/// <returns></returns>
public static string AddBillNotice1(BillNotice billNotice)
{
string sql = "insert into BillNotice(payType,UserName,Type,Amount,SubmitTime,Status,CardNo,bankcn,banktw,banken,bankth,bankaccount,bankno,Currency,Names,banktime,tel) values(?payType,?UserName,?Type,?Amount,?SubmitTime,?Status,?CardNo,?bankcn,?banktw,?banken,?bankth,?bankaccount,?bankno,?Currency,?Names,?BankTime,?Tel);SELECT LAST_INSERT_ID();";
MySqlParameter[] parm = new MySqlParameter[] {
new MySqlParameter("?UserName", MySqlDbType.VarChar, 30),
new MySqlParameter("?Type", MySqlDbType.VarChar, 1),
new MySqlParameter("?Amount", MySqlDbType.Decimal),
new MySqlParameter("?SubmitTime", MySqlDbType.DateTime),
new MySqlParameter("?Status", MySqlDbType.VarChar, 1),
new MySqlParameter("?CardNo", MySqlDbType.VarChar, 30),
new MySqlParameter("?bankcn", MySqlDbType.VarChar, 100),
new MySqlParameter("?banktw", MySqlDbType.VarChar, 100),
new MySqlParameter("?banken", MySqlDbType.VarChar, 100),
new MySqlParameter("?bankth", MySqlDbType.VarChar, 100),
new MySqlParameter("?bankaccount", MySqlDbType.VarChar, 100),
new MySqlParameter("?bankno", MySqlDbType.VarChar, 100),
new MySqlParameter("?Currency", MySqlDbType.VarChar, 10),
new MySqlParameter("?Names", MySqlDbType.VarChar, 30),
new MySqlParameter("?BankTime", MySqlDbType.VarChar, 30),
new MySqlParameter("?Tel", MySqlDbType.VarChar, 30),
new MySqlParameter("?payType", MySqlDbType.VarChar, 30)
};
parm[0].Value = billNotice.UserName;
parm[1].Value = billNotice.Type;
parm[2].Value = billNotice.Amount;
parm[3].Value = billNotice.SubmitTime;
parm[4].Value = billNotice.Status;
parm[5].Value = billNotice.CardNo;
parm[6].Value = billNotice.Bankcn;
parm[7].Value = billNotice.Banktw;
parm[8].Value = billNotice.Banken;
parm[9].Value = billNotice.Bankth;
parm[10].Value = billNotice.Bankaccount;
parm[11].Value = billNotice.Bankno;
parm[12].Value = billNotice.Currency;
parm[13].Value = billNotice.Names;
parm[14].Value = billNotice.BankTime;
parm[15].Value = billNotice.Tel;
parm[16].Value = billNotice.payType;
return(MySqlHelper.ExecuteScalar(sql, parm).ToString());
}
/// <summary>
/// 插入一条新的存取款通知
/// </summary>
/// <param name="billNotice"></param>
/// <returns></returns>
public bool AddBillNotice(BillNotice billNotice)
{
MySqlParameter[] parm = new MySqlParameter[] {
new MySqlParameter("?UserName", MySqlDbType.VarChar, 30),
new MySqlParameter("?Type", MySqlDbType.VarChar, 1),
new MySqlParameter("?Amount", MySqlDbType.Decimal),
new MySqlParameter("?SubmitTime", MySqlDbType.DateTime),
new MySqlParameter("?Status", MySqlDbType.VarChar, 1),
new MySqlParameter("?CardNo", MySqlDbType.VarChar, 30),
new MySqlParameter("?bankcn", MySqlDbType.VarChar, 100),
new MySqlParameter("?banktw", MySqlDbType.VarChar, 100),
new MySqlParameter("?banken", MySqlDbType.VarChar, 100),
new MySqlParameter("?bankth", MySqlDbType.VarChar, 100),
new MySqlParameter("?bankno", MySqlDbType.VarChar, 100),
new MySqlParameter("?Currency", MySqlDbType.VarChar, 10),
new MySqlParameter("?Names", MySqlDbType.VarChar, 30),
new MySqlParameter("?BankTime", MySqlDbType.VarChar, 30),
new MySqlParameter("?Tel", MySqlDbType.VarChar, 30),
};
parm[0].Value = billNotice.UserName;
parm[1].Value = billNotice.Type;
parm[2].Value = billNotice.Amount;
parm[3].Value = billNotice.SubmitTime;
parm[4].Value = billNotice.Status;
parm[5].Value = billNotice.CardNo;
parm[6].Value = billNotice.Bankcn;
parm[7].Value = billNotice.Banktw;
parm[8].Value = billNotice.Banken;
parm[9].Value = billNotice.Bankth;
parm[10].Value = billNotice.Bankno;
parm[11].Value = billNotice.Currency;
parm[12].Value = billNotice.Names;
parm[13].Value = billNotice.BankTime;
parm[14].Value = billNotice.Tel;
return(MySqlHelper.ExecuteNonQuery(SQL_INSERTBILLNOTICE, parm) > 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 AddBillNotice2(BillNotice billNotice)
{
return(bankService.AddBillNotice2(billNotice));
}