/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_systemMoney model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_systemMoney set ");
strSql.Append("MoneyAccount=@MoneyAccount,");
strSql.Append("AllBonusAccount=@AllBonusAccount,");
strSql.Append("Money001=@Money001,");
strSql.Append("Money002=@Money002");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@MoneyAccount", SqlDbType.Decimal, 9),
new SqlParameter("@AllBonusAccount", SqlDbType.Decimal, 9),
new SqlParameter("@Money001", SqlDbType.Decimal, 9),
new SqlParameter("@Money002", SqlDbType.Decimal, 9),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.MoneyAccount;
parameters[1].Value = model.AllBonusAccount;
parameters[2].Value = model.Money001;
parameters[3].Value = model.Money002;
parameters[4].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_systemMoney model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_systemMoney(");
strSql.Append("MoneyAccount,AllBonusAccount,Money001,Money002)");
strSql.Append(" values (");
strSql.Append("@MoneyAccount,@AllBonusAccount,@Money001,@Money002)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MoneyAccount", SqlDbType.Decimal, 9),
new SqlParameter("@AllBonusAccount", SqlDbType.Decimal, 9),
new SqlParameter("@Money001", SqlDbType.Decimal, 9),
new SqlParameter("@Money002", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.MoneyAccount;
parameters[1].Value = model.AllBonusAccount;
parameters[2].Value = model.Money001;
parameters[3].Value = model.Money002;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <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>
public lgk.Model.tb_systemMoney GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,MoneyAccount,AllBonusAccount,Money001,Money002 from tb_systemMoney ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
lgk.Model.tb_systemMoney model = new lgk.Model.tb_systemMoney();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["MoneyAccount"] != null && ds.Tables[0].Rows[0]["MoneyAccount"].ToString() != "")
{
model.MoneyAccount = decimal.Parse(ds.Tables[0].Rows[0]["MoneyAccount"].ToString());
}
if (ds.Tables[0].Rows[0]["AllBonusAccount"] != null && ds.Tables[0].Rows[0]["AllBonusAccount"].ToString() != "")
{
model.AllBonusAccount = decimal.Parse(ds.Tables[0].Rows[0]["AllBonusAccount"].ToString());
}
if (ds.Tables[0].Rows[0]["Money001"] != null && ds.Tables[0].Rows[0]["Money001"].ToString() != "")
{
model.Money001 = decimal.Parse(ds.Tables[0].Rows[0]["Money001"].ToString());
}
if (ds.Tables[0].Rows[0]["Money002"] != null && ds.Tables[0].Rows[0]["Money002"].ToString() != "")
{
model.Money002 = decimal.Parse(ds.Tables[0].Rows[0]["Money002"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_systemMoney GetModel()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,MoneyAccount,AllBonusAccount,Money001,Money002 from tb_systemMoney ");
lgk.Model.tb_systemMoney model = new lgk.Model.tb_systemMoney();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), null);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["MoneyAccount"] != null && ds.Tables[0].Rows[0]["MoneyAccount"].ToString() != "")
{
model.MoneyAccount = decimal.Parse(ds.Tables[0].Rows[0]["MoneyAccount"].ToString());
}
if (ds.Tables[0].Rows[0]["AllBonusAccount"] != null && ds.Tables[0].Rows[0]["AllBonusAccount"].ToString() != "")
{
model.AllBonusAccount = decimal.Parse(ds.Tables[0].Rows[0]["AllBonusAccount"].ToString());
}
if (ds.Tables[0].Rows[0]["Money001"] != null && ds.Tables[0].Rows[0]["Money001"].ToString() != "")
{
model.Money001 = decimal.Parse(ds.Tables[0].Rows[0]["Money001"].ToString());
}
if (ds.Tables[0].Rows[0]["Money002"] != null && ds.Tables[0].Rows[0]["Money002"].ToString() != "")
{
model.Money002 = decimal.Parse(ds.Tables[0].Rows[0]["Money002"].ToString());
}
return(model);
}
else
{
return(null);
}
}
protected void lbtnSubmit_Click(object sender, EventArgs e)
{
#region 充值金额验证
if (this.txtMoney.Text == "")
{
MessageBox.MyShow(this, "充值金额不能为空!");
return;
}
else if (Convert.ToDouble(this.txtMoney.Text.Trim()) <= 0)
{
MessageBox.MyShow(this, "金额需大于零!");
return;
}
#endregion
lgk.Model.tb_recharge rechargeInfo = new lgk.Model.tb_recharge();
lgk.Model.tb_systemMoney userInfo = systemBll.GetModel(1);
#region 充值实体
rechargeInfo.RechargeStyle = Convert.ToInt32(dropRechargeStyle.SelectedValue);
rechargeInfo.RechargeableMoney = Convert.ToDecimal(this.txtMoney.Text.Trim());
rechargeInfo.RechargeDate = DateTime.Now;
#endregion
#region 加入流水账表
lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal();
jmodel.JournalDate = DateTime.Now;
jmodel.JournalType = 3;
jmodel.UserID = Convert.ToInt32("system");
if (rechargeInfo.RechargeStyle == 1)
{
rechargeInfo.RechargeType = 2;
rechargeInfo.YuAmount = Convert.ToDecimal(userInfo.Money001) + Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.InAmount = Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.OutAmount = 0;
jmodel.BalanceAmount = Convert.ToDecimal(userInfo.Money001) + Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.Remark = "后台充值慈善(增加)";
}
if (rechargeInfo.RechargeStyle == 0)
{
if (Convert.ToDecimal(this.txtMoney.Text) > userInfo.Money001)
{
MessageBox.MyShow(this, "慈善余额不足!");
return;
}
rechargeInfo.RechargeType = 2;
rechargeInfo.YuAmount = Convert.ToDecimal(userInfo.Money001) - Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.InAmount = 0;
jmodel.OutAmount = Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.BalanceAmount = Convert.ToDecimal(userInfo.Money001) - Convert.ToDecimal(this.txtMoney.Text.Trim());
jmodel.Remark = "后台充值慈善(扣除)";
}
#endregion
if (rechargeBLL.Add(rechargeInfo) > 0 && journalBLL.Add(jmodel) > 0)
{
if (rechargeInfo.RechargeStyle == 1)
{
UpdateSystemAccount("Money001", Convert.ToDecimal(rechargeInfo.RechargeableMoney), 0);//公司账户减少
}
else
{
UpdateSystemAccount("Money001", Convert.ToDecimal(rechargeInfo.RechargeableMoney), 1);//公司账户增加
}
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('操作成功！');window.location.href='Addcishan.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, "取消失败");
}
}
}
}
}
