//审核通过
protected void btn_pass_Click(object sender, EventArgs e)
{
int id = payback.Id;
if (new PayBackApplyDAO().agreePayBack(id))
{
//跟新用户的债务表
UserDebt userdebt = new UserDebt();
userdebt = new UserDebtDAO().getUserDebt(payback.User_name);
userdebt.Amount = userdebt.Amount - payback.Amount;
new UserDebtDAO().updateUserDebt(userdebt);
//向用户债务交易记录表中添加交易记录
UserDebtTrans userdebttrans = new UserDebtTrans();
userdebttrans.Amount = -payback.Amount;
userdebttrans.Operation_time = DateTime.Now;
userdebttrans.Operation = "还款";
userdebttrans.Note = payback.Note;
userdebttrans.User_name = payback.User_name;
new UserDebtTransDAO().addUserDebtTrans(userdebttrans);
alert("通过申请！！");
}
else
{
alert("系统繁忙，请稍后再提交!!");
}
}
//添加欠款交易记录
public bool addUserDebtTrans(UserDebtTrans userdebttrans)
{
bool flag = false;
string sql = "insert into tb_user_debt_trans values('" + userdebttrans.User_name + "'," + userdebttrans.Amount + ",'" + userdebttrans.Operation + "','" + userdebttrans.Operation_time.ToString() + "','" + userdebttrans.Note + "')";
if (new DBOperateCommon().excuteNoQuery(sql))
{
flag = true;
}
return(flag);
}
//用户还款的具体实现
protected void btn_user_repay_right_Click(object sender, EventArgs e)
{
string account = user_account.Text;
string money_str = Request.Form["repay_money"];
string note = Request.Form["note_repay"];
//首先判断该用户是否欠
UserDebt user_debt = new UserDebtDAO().getUserDebt(account);
if (user_debt != null)
{
if (user_debt.Amount >= Convert.ToSingle(money_str))
{
// 跟新用户的 欠款表
UserDebt userdebt = new UserDebt();
userdebt.Amount = -Convert.ToSingle(money_str);
userdebt.User_name = account;
if (new UserDebtDAO().updateUserDebt(userdebt))
{
//还款成功
// 记录交易信息
UserDebtTrans userdebttrans = new UserDebtTrans();
userdebttrans.Operation = "还款";
userdebttrans.Operation_time = DateTime.Now;
userdebttrans.User_name = account;
userdebttrans.Amount = -Convert.ToSingle(money_str);
userdebttrans.Note = note;
new UserDebtTransDAO().addUserDebtTrans(userdebttrans);
alert("还款成功！！");
}
else
{
alert("还款失败！！");
}
}
else
{
alert("用户欠款金额为：" + user_debt.Amount + " ；还款金额为：" + money_str + "，无法进行还款！！");
}
}
else
{
alert("该用户不欠款，请确认用户信息！！");
}
}
/// <summary>
/// 分页获取交易记录
/// </summary>
/// <param name="pageNow">当前页</param>
/// <param name="pageSize">每页显示条数</param>
/// <returns></returns>
public ArrayList getChargeRecords(int pageNow, int pageSize)
{
ArrayList record_array = new ArrayList();
string sql = "select top " + pageSize + " * from tb_user_debt_trans where id not in(select top " + (pageNow - 1) * pageSize + " id from tb_user_debt_trans order by operation_time desc) order by operation_time desc";
DataTable table = new DBOperateCommon().excuteQuery(sql);
for (int i = 0; i < table.Rows.Count; i++)
{
UserDebtTrans usertrans = new UserDebtTrans();
usertrans.Id = Convert.ToInt32(table.Rows[i]["id"].ToString());
usertrans.User_name = table.Rows[i]["user_name"].ToString();
usertrans.Amount = Convert.ToSingle(table.Rows[i]["amount"].ToString());
usertrans.Operation = table.Rows[i]["operation"].ToString();
usertrans.Operation_time = Convert.ToDateTime(table.Rows[i]["operation_time"].ToString());
usertrans.Note = table.Rows[i]["note"].ToString();
record_array.Add(usertrans);
}
return(record_array);
}
/// <summary>
/// 获取给定用户的欠款交易信息
/// </summary>
/// <param name="name">用户名</param>
/// <returns></returns>
public ArrayList getUserDebtTransInfo(string name)
{
ArrayList debtTransInfo = new ArrayList();
string sql = "select * from tb_user_debt_trans where user_name='" + name + "' order by operation_time desc";
DataTable table = new DBOperateCommon().excuteQuery(sql);
for (int i = 0; i < table.Rows.Count; i++)
{
UserDebtTrans usertrans = new UserDebtTrans();
usertrans.Id = Convert.ToInt32(table.Rows[i]["id"].ToString());
usertrans.User_name = table.Rows[i]["user_name"].ToString();
usertrans.Amount = Convert.ToSingle(table.Rows[i]["amount"].ToString());
usertrans.Operation = table.Rows[i]["operation"].ToString();
usertrans.Operation_time = Convert.ToDateTime(table.Rows[i]["operation_time"].ToString());
usertrans.Note = table.Rows[i]["note"].ToString();
debtTransInfo.Add(usertrans);
}
return(debtTransInfo);
}
/// <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);
}
