/// <summary>
/// 分页获取交易记录
/// </summary>
/// <param name="pageNow">当前页数</param>
/// <param name="pageSize">每页显示的条数</param>
/// <returns></returns>
public ArrayList getMyAccountTrans(int pageNow, int pageSize, string name)
{
ArrayList trans = new ArrayList();
string sql = "select top " + pageSize + " * from tb_my_account_trans where user_name='" + name + "' and id not in(select top " + (pageNow - 1) * pageSize + " id from tb_my_account_trans where user_name='" + name + "' order by trans_time desc ) order by trans_time desc";
DataTable table = new DBOperateCommon().excuteQuery(sql);
for (int i = 0; i < table.Rows.Count; i++)
{
MyAccountTrans myaccounttans = new MyAccountTrans();
myaccounttans.User_name = table.Rows[i]["user_name"].ToString();
myaccounttans.Amout = Convert.ToSingle(table.Rows[i]["amount"].ToString());
myaccounttans.Operation = table.Rows[i]["operation"].ToString();
myaccounttans.Ratio = Convert.ToSingle(table.Rows[i]["ratio"].ToString());
myaccounttans.Charge_way = table.Rows[i]["charge_way"].ToString();
myaccounttans.Bank_account_number = table.Rows[i]["bank_account_number"].ToString();
myaccounttans.Order_number = table.Rows[i]["order_number"].ToString();
myaccounttans.Time = Convert.ToDateTime(table.Rows[i]["trans_time"].ToString());
trans.Add(myaccounttans);
}
return(trans);
}
/// <summary>
/// 用户使用账户付款
/// </summary>
/// <param name="account">账户</param>
/// <param name="money">付款金额</param>
/// <returns></returns>
public bool userPayUseMyAccount(string account, float money)
{
bool flag = false;
string sql = "select * from tb_my_account where name='" + account + "'";
DataTable table = new DBOperateCommon().excuteQuery(sql);
float old_balance = Convert.ToSingle(table.Rows[0]["balance"].ToString());
float new_balance = old_balance - money;
// 跟新账户表
string update = "update tb_my_account set balance=" + new_balance + " where name='" + account + "'";
if (new DBOperateCommon().excuteNoQuery(update))
{
// 付款成功
flag = true;
// 向账户交易记录表中添加交易记录
MyAccountTrans myaccounttrans = new MyAccountTrans();
myaccounttrans.Amout = -money;
myaccounttrans.Operation = "下单付款";
myaccounttrans.User_name = account;
myaccounttrans.Time = DateTime.Now;
new MyAccountTransDAO().addMyAccountTrans(myaccounttrans);
}
return(flag);
}
/// <summary>
/// 向我的账户交易记录表中添加交易记录
/// </summary>
/// <param name="myaccounttrans">账户交易对象</param>
/// <returns>添加成功返回 true，否则返回 false</returns>
public bool addMyAccountTrans(MyAccountTrans myaccounttrans)
{
bool flag = false;
string sql = "insert into tb_my_account_trans values('" + myaccounttrans.User_name + "'," + myaccounttrans.Amout + ",'" + myaccounttrans.Operation + "'," + myaccounttrans.Ratio + ",'" + myaccounttrans.Charge_way + "','" + myaccounttrans.Bank_account_number + "','" + myaccounttrans.Order_number + "','" + myaccounttrans.Time.ToString() + "')";
if (new DBOperateCommon().excuteNoQuery(sql))
{
flag = true;
}
return(flag);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
name = Request.QueryString["username"];
string code = Request.QueryString["code"];
string pay_way = Request.QueryString["chargemethod"];
if (Session["name"] == null && name != null)
{
Session["name"] = name;
}
if (Session["name"] != null && code != null)
{
if (new UserDAO().isCodeRight(Session["name"].ToString(), code))
{
User user = new UserDAO().getUser(Session["name"].ToString());
float charge_amount = user.Charge_amount;
//生成支付成功码
string success_code1 = (new Random().Next(100000000, 1000000000)).ToString();
string success_code2 = (new Random().Next(1000000, 10000000)).ToString();
string success_code3 = (new Random().Next(10000000, 100000000)).ToString();
string success_code = success_code1 + success_code2 + success_code3;
//将成功码插入到用户表中，支付成功是进行验证
new UserDAO().updateChargeCode(Session["name"].ToString(), success_code, 0);
//确实付款成功
//更新我的账户
MyAccount myaccount = new MyAccountDAO().getMyAccount(Session["name"].ToString());
if (myaccount == null)
{
myaccount = new MyAccount();
myaccount.Name = Session["name"].ToString();
myaccount.Balance = charge_amount;
new MyAccountDAO().addMyAccount(myaccount);
}
else
{
myaccount.Balance = myaccount.Balance + charge_amount;
new MyAccountDAO().updateMyAccount(myaccount.Name, myaccount.Balance);
}
//添加账户交易信息
MyAccountTrans myaccounttrans = new MyAccountTrans();
myaccounttrans.Amout = charge_amount;
myaccounttrans.Charge_way = pay_way;
myaccounttrans.Operation = "自己给账户充值";
myaccounttrans.User_name = Session["name"].ToString();
myaccounttrans.Time = DateTime.Now;
new MyAccountTransDAO().addMyAccountTrans(myaccounttrans);
}
else
{
Response.Redirect("error-page.aspx");
}
}
else
{
Response.Redirect("error-page.aspx");
}
}
}
/// <summary>
/// 为用户充值
/// </summary>
/// <param name="username">用户名</param>
/// <param name="money">充值金额</param>
/// <returns>充值成功返回 true,否则返回 false</returns>
public bool chargeForUser(string account, float money)
{
bool flag = false;
string sql = "select * from tb_my_account where name='" + account + "'";
DataTable table = new DBOperateCommon().excuteQuery(sql);
//说明
if (table.Rows.Count > 0)
{
float old_balance = Convert.ToSingle(table.Rows[0]["balance"].ToString());
float new_balance = old_balance + money;
string update = "update tb_my_account set balance=" + new_balance + " where name='" + account + "'";
if (new DBOperateCommon().excuteNoQuery(update))
{
flag = true;
//添加成功时向账户交易记录表中添加交易记录
MyAccountTrans myaccounttrans = new MyAccountTrans();
myaccounttrans.User_name = account;
myaccounttrans.Amout = money;
myaccounttrans.Charge_way = "ukchinesecentre-account";
myaccounttrans.Operation = "森林运输为客户预充值";
myaccounttrans.Time = DateTime.Now;
new MyAccountTransDAO().addMyAccountTrans(myaccounttrans);
// 跟新用户的 欠款表
UserDebt userdebt = new UserDebt();
userdebt.User_name = account;
userdebt.Amount = money;
new UserDebtDAO().updateUserDebt(userdebt);
//添加 欠款交易信息
UserDebtTrans userdebttrans = new UserDebtTrans();
userdebttrans.Amount = money;
userdebttrans.User_name = account;
userdebttrans.Operation = "借款";
userdebttrans.Operation_time = DateTime.Now;
new UserDebtTransDAO().addUserDebtTrans(userdebttrans);
}
}
else
{
string insert = "insert into tb_my_account values('" + account + "'," + money + ",0,0,0,0,'',0,0)";
if (new DBOperateCommon().excuteNoQuery(insert))
{
flag = true;
//添加成功时向账户交易记录表中添加交易记录
MyAccountTrans myaccounttrans = new MyAccountTrans();
myaccounttrans.User_name = account;
myaccounttrans.Amout = money;
myaccounttrans.Charge_way = "ukchinesecentre-account";
myaccounttrans.Operation = "森林运输为客户预充值";
myaccounttrans.Time = DateTime.Now;
new MyAccountTransDAO().addMyAccountTrans(myaccounttrans);
// 跟新用户的 欠款表
UserDebt userdebt = new UserDebt();
userdebt.User_name = account;
userdebt.Amount = money;
new UserDebtDAO().updateUserDebt(userdebt);
//添加 欠款交易信息
UserDebtTrans userdebttrans = new UserDebtTrans();
userdebttrans.Amount = money;
userdebttrans.User_name = account;
userdebttrans.Operation = "借款";
userdebttrans.Operation_time = DateTime.Now;
new UserDebtTransDAO().addUserDebtTrans(userdebttrans);
}
}
return(flag);
}
