/// <summary>
/// 审核分页申请记录
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
long ID = Convert.ToInt64(e.CommandArgument); //ID
string filename = "";
lgk.BLL.tb_systemMoney sy = new lgk.BLL.tb_systemMoney();
lgk.Model.tb_systemMoney system = sy.GetModel(1);
if (e.CommandName.Equals("Open")) //确认
{
string sql1 = "update tb_takeMoney1 set Flag=1 where ID= '" + ID + "'";
SqlConnection conn = new SqlConnection(sconn);
conn.Open();
SqlCommand cmd = new SqlCommand(sql1, conn);
int reInt = cmd.ExecuteNonQuery();
conn.Close();
if (reInt >= 1)
{
MessageBox.MyShow(this, "操作成功！");
BindData();
return;
}
else
{
MessageBox.MyShow(this, "数据不存在！");
return;
}
}
if (e.CommandName.Equals("Remove")) //删除
{
//加入流水账表
string sql1 = "delete from tb_takeMoney1 where ID= '" + ID + "'";
SqlConnection conn = new SqlConnection(sconn);
conn.Open();
SqlCommand cmd = new SqlCommand(sql1, conn);
int reInt = cmd.ExecuteNonQuery();
conn.Close();
if (reInt > 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('取消成功！');window.location.href='TakeMoney.aspx';", true); //取消成功
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('取消失败！');", true); //取消失败
}
}
}
/// <summary>
/// 审核分页申请记录
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
long ID = Convert.ToInt64(e.CommandArgument); //ID
string filename = "";
lgk.Model.tb_takeMoney cModel = takeBLL.GetModel(ID);
lgk.BLL.tb_systemMoney sy = new lgk.BLL.tb_systemMoney();
//lgk.BLL.tb_rechargeable dotx = new lgk.BLL.tb_rechargeable();
lgk.Model.tb_systemMoney system = sy.GetModel(1);
if (cModel == null)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('该记录已删除,无法再进行此操作！');window.location.href='TakeMoney.aspx';", true);
}
else
{
if (cModel.Flag == 1)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('该记录已审核,无法再进行此操作！');window.location.href='TakeMoney.aspx';", true);
}
else
{
lgk.Model.tb_user user = userBLL.GetModel(Convert.ToInt32(cModel.UserID));
if (e.CommandName.Equals("Open"))//确认
{
cModel.Flag = 1;
cModel.Take006 = DateTime.Now;
if (takeBLL.Update(cModel) && UpdateSystemAccount("MoneyAccount", Convert.ToDecimal(cModel.RealityMoney), 0) > 0)
{
if (cModel.Take001 == 6)
{
user.Batch = 0;
userBLL.Update(user);
}
//发送短信通知
string content = GetLanguage("MessageTakeMoneyOK").Replace("{username}", user.UserCode).Replace("{time}", Convert.ToDateTime(cModel.TakeTime).ToString("yyyy年MM月dd日HH时mm分")).Replace("{timeEn}", Convert.ToDateTime(cModel.TakeTime).ToString("yyyy/MM/dd HH:mm"));
SendMessage(Convert.ToInt32(cModel.UserID), user.PhoneNum, content);
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('操作成功！');", true);//window.location.href='TakeMoney.aspx';
BindData();
}
}
if (e.CommandName.Equals("Remove"))//删除
{
//加入流水账表
lgk.Model.tb_journal model = new lgk.Model.tb_journal();
lgk.Model.tb_user users = userBLL.GetModel(cModel.UserID);
model.UserID = cModel.UserID;
model.Remark = "取消提现";
model.InAmount = cModel.TakeMoney;
model.OutAmount = 0;
if (cModel.Take001 == 1)
{
model.BalanceAmount = user.Emoney + cModel.TakeMoney;
filename = "emoney";
// model.Journal02 = 2;//奖励分
model.JournalType = 1;
}
if (cModel.Take001 == 2)
{
model.BalanceAmount = user.BonusAccount + cModel.TakeMoney;
filename = "BonusAccount";
// users.Emoney = users.Emoney + cModel.RealityMoney + cModel.TakePoundage;
// users.StockMoney = users.BonusAccount + cModel.TakeMoney + cModel.TakePoundage;
// model.Journal02 = 4; //原始积分
model.JournalType = 2;
}
//if (cModel.Take001 == 3)
//{
// model.BalanceAmount = user.StockMoney + cModel.TakeMoney + cModel.TakePoundage;
// filename = "StockMoney";
// //users.BonusAccount = users.BonusAccount + cModel.TakeMoney + cModel.TakePoundage;
// model.Journal02 = cModel.Take001;
//}
//if (cModel.Take001 == 4)
//{
// model.BalanceAmount = user.ShopAccount + cModel.TakeMoney + cModel.TakePoundage;
// filename = "ShopAccount";
// users.Emoney = users.Emoney + cModel.RealityMoney;
// users.BonusAccount = users.BonusAccount + cModel.TakeMoney + cModel.TakePoundage;
// model.Journal02 = cModel.Take001;
//}
//if (cModel.Take001 == 5)
//{
// model.BalanceAmount = user.GLmoney + cModel.TakeMoney + cModel.TakePoundage;
// filename = "GLmoney";
// users.BonusAccount = users.BonusAccount + cModel.TakeMoney + cModel.TakePoundage;
// model.Journal02 = cModel.Take001;
//}
//if (cModel.Take001 == 6)
//{
// model.BalanceAmount = user.RegMoney + cModel.TakeMoney + cModel.TakePoundage;
// filename = "RegMoney";
// users.Batch = 0;
// model.Journal02 = cModel.Take001;
//}
model.JournalDate = DateTime.Now;
model.Journal01 = cModel.UserID;
if (journalBLL.Add(model) > 0 && userBLL.Update(users) && UpdateAccount(filename, user.UserID, cModel.TakeMoney, 1) > 0 && takeBLL.Delete(ID))
{
MessageBox.MyShow(this, "取消成功");
BindData();
}
else
{
MessageBox.MyShow(this, "取消失败");
}
}
}
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int ID = Convert.ToInt32(e.CommandArgument); //ID
lgk.Model.tb_takeMoney takeMoneyInfo = takeBLL.GetModel(ID);
lgk.BLL.tb_systemMoney sy = new lgk.BLL.tb_systemMoney();
lgk.Model.tb_systemMoney system = sy.GetModel(1);
if (takeMoneyInfo == null)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('该记录已删除,无法再进行此操作！');window.location.href='TakeMoney.aspx';", true);
}
else
{
if (takeMoneyInfo.Flag == 1)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('该记录已审核,无法再进行此操作！');window.location.href='TakeMoney.aspx';", true);
}
else
{
lgk.Model.tb_Stock stockInfo = stockBLL.GetModel("UserID=" + takeMoneyInfo.UserID);
lgk.Model.tb_user userInfo = userBLL.GetModel(Convert.ToInt32(takeMoneyInfo.UserID));
decimal dProfit = stockInfo.Number * (getParamAmount("shares5") - stockInfo.Price);
if (e.CommandName.Equals("Open"))//确认
{
takeMoneyInfo.Flag = 1;
takeMoneyInfo.Take006 = DateTime.Now;
if (takeBLL.Update(takeMoneyInfo) && UpdateSystemAccount("MoneyAccount", Convert.ToDecimal(takeMoneyInfo.RealityMoney), 0) > 0)
{
//发送短信通知
string content = GetLanguage("MessageTakeMoneyOK").Replace("{username}", userInfo.UserCode).Replace("{time}", Convert.ToDateTime(takeMoneyInfo.TakeTime).ToString("yyyy年MM月dd日HH时mm分")).Replace("{timeEn}", Convert.ToDateTime(takeMoneyInfo.TakeTime).ToString("yyyy/MM/dd HH:mm"));
SendMessage(Convert.ToInt32(takeMoneyInfo.UserID), userInfo.PhoneNum, content);
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('操作成功！');window.location.href='TakeMoney.aspx';", true);
}
}
if (e.CommandName.Equals("Remove"))//删除
{
//加入流水账表
lgk.Model.tb_journal model = new lgk.Model.tb_journal();
model.UserID = takeMoneyInfo.UserID;
model.Remark = "取消提现";
model.InAmount = takeMoneyInfo.TakeMoney;
model.OutAmount = 0;
model.BalanceAmount = dProfit + takeMoneyInfo.TakeMoney;
model.JournalDate = DateTime.Now;
model.JournalType = 1;
model.Journal01 = takeMoneyInfo.UserID;
bool bFalg = stockBLL.UpdateStockNumber(stockInfo.StockID, Convert.ToDecimal(takeMoneyInfo.TakeMoney), getParamAmount("shares5"), 1);
if (journalBLL.Add(model) > 0 && bFalg && takeBLL.Delete(ID))
{
MessageBox.MyShow(this, "取消成功");
BindData();
}
else
{
MessageBox.MyShow(this, "取消失败");
}
}
}
}
}
