/// <summary>
/// 增加账户记录
/// </summary>
/// <param name="userid"></param>
/// <param name="breakm"></param>
/// <param name="type"></param>
/// <param name="price"></param>
/// <returns></returns>
public bool JournalAdd(long userid, string breakm, int type, decimal price)
{
lgk.Model.tb_journal jounlmodel = new lgk.Model.tb_journal();
jounlmodel.UserID = userid;
jounlmodel.Remark = breakm;
if (type == 1)
{
jounlmodel.InAmount = price;
jounlmodel.OutAmount = 0;
}
if (type == 2)
{
jounlmodel.OutAmount = price;
jounlmodel.InAmount = 0;
}
jounlmodel.JournalDate = DateTime.Now;
jounlmodel.JournalType = 2;
jounlmodel.BalanceAmount = userBLL.GetBonusAccount(userid);
if (journalBLL.Add(jounlmodel) > 0)
{
return(true);
}
else
{
return(false);
}
}
//取消会员提现
public bool ItemCommand(long userid, long txid, string paypassword, out string message)
{
lgk.Model.tb_takeMoney takeMoneyInfo = takeBLL.GetModel(txid);
if (takeMoneyInfo == null)
{
message = GetLanguage("recordDeleted");
return(false);
}
if (takeMoneyInfo.Flag != 0)
{
message = GetLanguage("recordApproved");
return(false);
}
//提现账户 1:云盾，2：原始积分
int AccountType = takeMoneyInfo.Take001;
lgk.Model.tb_user userInfo = userBLL.GetModel(takeMoneyInfo.UserID);
if (paypassword != userInfo.SecondPassword)
{
message = "支付密码错误";
return(false);
}
if (userInfo.IsLock == 1)
{
message = "账户已冻结，取消提现失败";
return(false);
}
//加入流水账表
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 = (AccountType == 1? userInfo.Emoney : userInfo.StockAccount) + takeMoneyInfo.TakeMoney;
model.JournalDate = DateTime.Now;
model.JournalType = (AccountType == 1 ? (int)Library.AccountType.云盾 : (int)Library.AccountType.云图);
model.Journal01 = takeMoneyInfo.UserID;
if (journalBLL.Add(model) > 0 && takeBLL.UpdateFlag(Convert.ToInt64(userid), Convert.ToInt64(txid)) > 0)
{
if (AccountType == 1)
{
UpdateAccount("Emoney", takeMoneyInfo.UserID, takeMoneyInfo.TakeMoney, 1);
}
else if (AccountType == 2)
{
UpdateAccount("StockAccount", takeMoneyInfo.UserID, takeMoneyInfo.TakeMoney, 1);
}
message = GetLanguage("CancellationSuccess");//取消成功
return(true);
}
else
{
message = GetLanguage("FailedToCancel");//取消失败
return(false);
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "cancel")
{
long iCashsellID = Convert.ToInt64(e.CommandArgument);
lgk.Model.Cashsell cashsellInfo = cashsellBLL.GetModel(iCashsellID);
lgk.Model.tb_user userInfo = userBLL.GetModel(cashsellInfo.UserID);
if (cashsellInfo == null)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("recordDeleted") + "');", true);//该记录已删除，无法再进行此操作
return;
}
if (cashsellInfo.IsSell > 1)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("GoldUnable") + "');", true); //金币已卖出，无法再进行此操作
return; //GoldUnable
}
#region 加入流水账表
//现金积分
//decimal dNumber = (cashsellInfo.Number + cashsellInfo.Charge) * cashsellInfo.UnitNum;
decimal dNumber = (cashsellInfo.Number);
lgk.Model.tb_journal model = new lgk.Model.tb_journal();
model.UserID = cashsellInfo.UserID;
model.Remark = "取消订单,返回交易币";
model.InAmount = dNumber;
model.OutAmount = 0;
model.BalanceAmount = userInfo.ShopAccount + dNumber;
model.JournalDate = DateTime.Now;
model.JournalType = (int)Library.AccountType.交易钱包;
model.Journal01 = cashsellInfo.UserID;
//交易码
lgk.Model.tb_journal modelTrans = new lgk.Model.tb_journal();
modelTrans.UserID = cashsellInfo.UserID;
modelTrans.Remark = "取消订单，返回保证金";
modelTrans.InAmount = cashsellInfo.Charge;
modelTrans.OutAmount = 0;
modelTrans.BalanceAmount = userInfo.ShopAccount + dNumber + cashsellInfo.Charge;
modelTrans.JournalDate = DateTime.Now;
modelTrans.JournalType = (int)Library.AccountType.交易钱包;
modelTrans.Journal01 = cashsellInfo.UserID;
#endregion
if (journalBLL.Add(model) > 0 && journalBLL.Add(modelTrans) > 0 && cashsellBLL.UpdateUndo(iCashsellID, 1) && UpdateAccount("ShopAccount", getLoginID(), dNumber + cashsellInfo.Charge, 1) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("CancellationSuccess") + "');window.location.href='CashsellList.aspx';", true);//取消成功
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("FailedToCancel") + "');", true);//取消失败
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.tb_journal model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_journal(");
strSql.Append("UserID,Remark,RemarkEn,InAmount,OutAmount,BalanceAmount,JournalDate,JournalType,Journal01,Journal02,Journal03,Journal04,Journal05,Journal06,Journal07)");
strSql.Append(" values (");
strSql.Append("@UserID,@Remark,@RemarkEn,@InAmount,@OutAmount,@BalanceAmount,@JournalDate,@JournalType,@Journal01,@Journal02,@Journal03,@Journal04,@Journal05,@Journal06,@Journal07)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@Remark", SqlDbType.VarChar, 500),
new SqlParameter("@RemarkEn", SqlDbType.VarChar, 500),
new SqlParameter("@InAmount", SqlDbType.Decimal, 9),
new SqlParameter("@OutAmount", SqlDbType.Decimal, 9),
new SqlParameter("@BalanceAmount", SqlDbType.Decimal, 9),
new SqlParameter("@JournalDate", SqlDbType.DateTime),
new SqlParameter("@JournalType", SqlDbType.Int, 4),
new SqlParameter("@Journal01", SqlDbType.BigInt, 8),
new SqlParameter("@Journal02", SqlDbType.Int, 4),
new SqlParameter("@Journal03", SqlDbType.VarChar, 50),
new SqlParameter("@Journal04", SqlDbType.VarChar, 50),
new SqlParameter("@Journal05", SqlDbType.Decimal, 9),
new SqlParameter("@Journal06", SqlDbType.Decimal, 9),
new SqlParameter("@Journal07", SqlDbType.DateTime)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.Remark;
parameters[2].Value = model.RemarkEn;
parameters[3].Value = model.InAmount;
parameters[4].Value = model.OutAmount;
parameters[5].Value = model.BalanceAmount;
parameters[6].Value = model.JournalDate;
parameters[7].Value = model.JournalType;
parameters[8].Value = model.Journal01;
parameters[9].Value = model.Journal02;
parameters[10].Value = model.Journal03;
parameters[11].Value = model.Journal04;
parameters[12].Value = model.Journal05;
parameters[13].Value = model.Journal06;
parameters[14].Value = model.Journal07;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string filename = "";
if (e.CommandName == "change")
{
long iID = Convert.ToInt64(e.CommandArgument);
lgk.Model.tb_takeMoney take = takeBLL.GetModel(iID);
if (take == null)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("recordDeleted") + "');", true);//该记录已删除，无法再进行此操作
return;
}
if (take.Flag != 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("recordApproved") + "');", true);//该记录已审核，无法再进行此操作
return;
}
lgk.Model.tb_user userModel = userBLL.GetModel(Convert.ToInt32(take.UserID));
//加入流水账表
lgk.Model.tb_journal model = new lgk.Model.tb_journal();
if (take.Take001 == 1)
{
model.BalanceAmount = userModel.Emoney + take.TakeMoney;
filename = "Emoney";
}
else
{
model.BalanceAmount = userModel.BonusAccount + take.TakeMoney;
filename = "BonusAccount";
}
model.UserID = take.UserID;
model.Remark = "取消提现";
model.RemarkEn = "Cancellation of cash";
model.InAmount = take.TakeMoney;
model.OutAmount = 0;
model.JournalDate = DateTime.Now;
model.JournalType = take.Take001;
model.Journal01 = take.UserID;
if (journalBLL.Add(model) > 0 && UpdateAccount(filename, take.UserID, take.TakeMoney, 1) > 0 && takeBLL.Delete(iID))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("CancellationSuccess") + "');window.location.href='TakeMoney.aspx';", true);//取消成功
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("FailedToCancel") + "');", true);//取消失败
}
}
}
/// <summary>
/// 加入流水账表
/// </summary>
/// <param name="iUserID">用户编号</param>
/// <param name="dAccount">收发货数量</param>
/// <param name="strRemark">备注</param>
private void SetAccount(long iBUserID, decimal dAccount, string strRemark, string strRemarkEn, long iFromUserID, int JournalType)
{
#region 加入流水账表
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
lgk.Model.tb_user userInfo = userBLL.GetModel(iBUserID);
journalInfo.UserID = iBUserID;
journalInfo.Remark = strRemark;
journalInfo.RemarkEn = strRemarkEn;
journalInfo.InAmount = dAccount;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userInfo.Emoney;
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = JournalType;
journalInfo.Journal01 = iFromUserID;
journalBLL.Add(journalInfo);
#endregion
}
protected void btnSearch_Click(object sender, EventArgs e)
{
lgk.Model.tb_user umodel = userBLL.GetModel(getIntRequest("userid"));
if (this.txtMoney.Value == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改金额不能为空!');", true);
return;
}
if (Convert.ToDecimal(this.txtMoney.Value.Trim()) < 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改金额需大于零!');", true);
return;
}
if (Convert.ToDecimal(this.txtMoney.Value.Trim()) > umodel.BonusAccount)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改金额不能大于会员重消账户余额!');", true);
return;
}
lgk.Model.tb_mix model = new lgk.Model.tb_mix();
model.UserID = umodel.UserID;
model.Amount = umodel.BonusAccount;
model.AddTime = DateTime.Now;
model.Mix005 = umodel.BonusAccount - Convert.ToDecimal(txtMoney.Value.Trim());
model.Mix006 = Convert.ToDecimal(txtMoney.Value.Trim());
//加入流水账表
lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal();
jmodel.UserID = getIntRequest("userid");
jmodel.JournalDate = DateTime.Now;
jmodel.JournalType = 1;
jmodel.InAmount = 0;
jmodel.OutAmount = umodel.BonusAccount - Convert.ToDecimal(txtMoney.Value.Trim());
jmodel.BalanceAmount = Convert.ToDecimal(txtMoney.Value.Trim());
jmodel.Remark = "B网消费";
umodel.BonusAccount = Convert.ToDecimal(txtMoney.Value.Trim());
if (userBLL.Update(umodel) && mixBLL.Add(model) > 0 && journalBLL.Add(jmodel) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改成功！');window.location.href='chongxiaoList.aspx'", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('修改失败!');", true);
}
}
/// <summary>
/// 加入流水账表
/// </summary>
/// <param name="iUserID">用户编号</param>
/// <param name="dAccount">终止交易货物数量</param>
/// <param name="strRemark">备注(终止原因)</param>
private void SetAccount(long iUserID, decimal dAccount, string strRemark, int JournalType)
{
#region 加入流水账表
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
lgk.Model.tb_user userInfo = userBLL.GetModel(iUserID);
journalInfo.UserID = iUserID;
journalInfo.Remark = strRemark;
journalInfo.RemarkEn = "Trading halt!";
journalInfo.InAmount = dAccount;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userInfo.BonusAccount + dAccount;
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = JournalType;
journalInfo.Journal01 = iUserID;
#endregion
journalBLL.Add(journalInfo);
}
/// <summary>
/// 加入流水账表
/// </summary>
/// <param name="iUserID">用户编号</param>
/// <param name="dAccount">收发货数量</param>
/// <param name="strRemark">备注</param>
private void SetAccount(long iBUserID, decimal dAccount, string strRemark, long iSUserID, int JournalType)
{
#region 加入流水账表
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
lgk.Model.tb_user userInfo = userBLL.GetModel(iBUserID);
journalInfo.UserID = iBUserID;
journalInfo.Remark = strRemark;//"EP币发货";
journalInfo.RemarkEn = "Gold coin receipt!";
journalInfo.InAmount = dAccount;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userInfo.Emoney;//EP币收货！
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = JournalType;
journalInfo.Journal01 = iSUserID;
#endregion
journalBLL.Add(journalInfo);
}
public string Bonus(lgk.Model.tb_user usermodel, decimal price)
{
try
{
usermodel.Emoney = usermodel.Emoney - price;
userBLL.Update(usermodel);
lgk.Model.tb_journal jounlmodel = new lgk.Model.tb_journal();
jounlmodel.UserID = usermodel.UserID;
jounlmodel.Remark = "充值话费扣除注册分：" + price;
jounlmodel.OutAmount = price;
jounlmodel.InAmount = 0;
jounlmodel.JournalDate = DateTime.Now;
jounlmodel.JournalType = 1;
jounlmodel.BalanceAmount = userBLL.GetBonusAccount(usermodel.UserID);
journalBLL.Add(jounlmodel);
return("success");
}
catch (Exception)
{
return("error");
}
}
protected void rpRemit_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string s = "\r\n" + "\r\n" + "\r\n" + "\r\n" + "记录时间" + DateTime.Now.ToString() + "\r\n";
string ip = Page.Request.UserHostAddress;
try
{
long id = Convert.ToInt64(e.CommandArgument);
lgk.Model.tb_remit remit = remitBLL.GetModel(id);
if (remit == null)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('该记录已删除，无法再进行此操作!');window.location.href='RemitManage.aspx';", true);
}
else
{
if (remit.State == 1)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('该记录已审核，无法再进行此操作!');window.location.href='RemitManage.aspx';", true);
}
if (remit.State == -1)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('该记录已撤销，无法再进行此操作!');window.location.href='RemitManage.aspx';", true);
}
else
{
if (e.CommandName.Equals("verify"))//确认
{
remit.State = 1;
remit.PassDate = DateTime.Now;
lgk.Model.tb_user user = userBLL.GetModel(remit.UserID);
user.Emoney = user.Emoney + remit.RemitMoney;
//加入流水账表
lgk.Model.tb_journal jmodelEmoney = new lgk.Model.tb_journal();
jmodelEmoney.UserID = remit.UserID;
jmodelEmoney.Remark = "云盾汇款充值";
jmodelEmoney.InAmount = remit.RemitMoney;
jmodelEmoney.OutAmount = 0;
jmodelEmoney.BalanceAmount = user.Emoney;
jmodelEmoney.JournalDate = DateTime.Now;
jmodelEmoney.JournalType = (int)Library.AccountType.云盾;
jmodelEmoney.Journal02 = 0;
jmodelEmoney.Journal01 = 0;
if (remitBLL.Update(remit) && userBLL.Update(user) && UpdateSystemAccount("MoneyAccount", remit.RemitMoney, 1) > 0 && journalBLL.Add(jmodelEmoney) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('确认成功!');", true);
bind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('确认失败!');", true);
}
}
}
if (e.CommandName.Equals("Remove"))//撤销
{
string type = "";
string res = "撤销失败";
if (remitBLL.Cancel(id))
{
res = "撤销成功";
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('撤销成功!');", true);
bind();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('撤销失败!');", true);
}
s = s + "操作人IP：:" + ip + "，操作人ID：" + getLoginID() + ",操作类型：撤销数据，撤销类型：" + type + "，撤销会员ID：" + remit.UserID + "，撤销结果：" + res + "\r\n";
}
if (e.CommandName.Equals("Query"))//查看凭证
{
Response.Redirect("RemitVoucher.aspx?ID=" + id);
}
}
}
catch (Exception ex)
{
s = s + "操作人IP：:" + ip + "，操作人ID：" + getLoginID() + ",程序异常：" + ex.Message + "\r\n";
}
LogHelper.SaveLog(s, "ManageRemit");
}
public bool GoodsCartPay(long userid, int paytype, long addrid, string strcid, string aa, out string msg)
{
string[] arr = strcid.Split(',');
LogHelper.SaveLog(strcid, "GoodsCartPay");
if (arr.Length <= 0)
{
msg = "传递的ID无数据";
return(false);
}
Random rand = new Random();
string orderCode = DateTime.Now.ToString("yyyyMMddhhmmss") + rand.Next(10000, 99999); //订单编号
string goodsname = string.Format("订单号{0}，", orderCode);
decimal totalMoney = 0;
int orderSum = 0;
int insert = 0;
DateTime dtime = DateTime.Now;
if (!userBLL.Exists(userid))
{
msg = "用户不存在";
return(false);
}
if (paytype != 1)
{
msg = "支付类型错误";
return(false);
}
lgk.Model.tb_Address addrModel = addressBLL.GetModel(addrid);
if (addrModel == null)
{
msg = "请选择收货地址";
return(false);
}
IList <lgk.Model.tb_goodsCar> listCar = new List <lgk.Model.tb_goodsCar>();
#region 验证商品
string errmsg = "";
foreach (var strID in arr)
{
long id = 0;
long.TryParse(strID, out id);
lgk.Model.tb_goodsCar carModel = goodsCarBLL.GetModel(id);
if (carModel != null)
{
lgk.Model.tb_goods goodsModel = goodsBLL.GetModelAndOneName(carModel.GoodsID); //根据发布商品编号找到充值账号密码
if (goodsModel.StateType == 0) //判断是否 审核通过 0未审核
{
errmsg = "商品" + goodsModel.GoodsName + "审核未通过,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods003 == "1") //判断是否 删除 1已经删除
{
errmsg = "商品" + goodsModel.GoodsName + "已被删除,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods001 == 0) //判断是否 0下架
{
errmsg = "商品" + goodsModel.GoodsName + "已经下架,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods002 < carModel.Goods006) //判断库存量
{
errmsg = "商品" + goodsModel.GoodsName + "库存不足,请重新修改数量!";
insert = 0;
break;
}
else if (carModel.BuyUser != userid) //判断库存量
{
errmsg = "用户不匹配，请刷新购物车再提交!";
insert = 0;
break;
}
listCar.Add(carModel);
insert += 1;
}
else
{
msg = "购物出为空";
LogHelper.SaveLog(id.ToString() + "," + errmsg, "GoodsCartPay");
return(false);
}
}
if (insert == 0)
{
msg = errmsg;
return(false);
}
#endregion
//总金额
totalMoney += listCar.Sum(s => s.TotalMoney);
lgk.Model.tb_user userModel = userBLL.GetModel(userid);
//支付方式
string[] aw = aa.Split('-');
//if (!userBLL.Exists(long.Parse(aw[2])))
//{
// msg = "运营中心不存在";
// return false;
//}
string sql = "select OrderID from tb_Order where UserID=" + userModel.UserID;
var mo = userBLL.getData_Chaxun(sql, "").Tables[0];
if (aw[0] == "1")
{
//if (mo.Rows.Count > 0)
//{
// msg = "请选择复投产品";
// return false;
//}
if (aw[1] == "2")
{
if (userModel.StockMoney < totalMoney / 2 || userModel.StockAccount < totalMoney / 2)
{
msg = "报单积分、电子积分余额不足";
return(false);
}
}
else
{
if (userModel.StockAccount < totalMoney)
{
msg = "报单积分余额不足";
return(false);
}
}
}
else if (aw[0] == "2")
{
if (userModel.AllBonusAccount < totalMoney)
{
msg = "种子积分余额不足";
return(false);
}
}
else if (aw[0] == "3")
{
if (userModel.StockMoney < totalMoney / 2 || userModel.StockAccount < totalMoney / 2)
{
msg = "报单积分、电子积分余额不足";
return(false);
}
}
else if (aw[0] == "4")
{
if (userModel.BonusAccount < totalMoney)
{
msg = "消费积分余额不足";
return(false);
}
}
#region 订单处理
//总订单
lgk.Model.tb_Order orderModel = new lgk.Model.tb_Order(); //订单
orderModel.UserID = userid; //用户
orderModel.OrderCode = orderCode; //订单编号
orderModel.OrderSum = orderSum; //订单数--
orderModel.OrderTotal = totalMoney; //购买总金
orderModel.PVTotal = totalMoney * getParamAmount("hongbao1"); //
orderModel.OrderDate = dtime;
orderModel.IsSend = 1;
orderModel.PayMethod = 1; //--
orderModel.Order5 = ""; //运营中心UserID
orderModel.UserAddr = addrModel.Address; //发货地址
orderModel.Order6 = addrModel.PhoneNum; //收货电话
orderModel.Order7 = addrModel.MemberName; //收货姓名
orderModel.OrderType = int.Parse(aw[0]); //1:
int fenrun = 0;
foreach (var carModel in listCar)
{
lgk.Model.tb_goods goodsModel = goodsBLL.GetModelAndOneName(carModel.GoodsID); //根据发布商品编号找到充值账号密码
lgk.Model.tb_goods goodsModel1 = goodsBLL.GetModel(carModel.GoodsID); //插入订单详细表
lgk.Model.tb_OrderDetail orderDetailModel = new lgk.Model.tb_OrderDetail();
orderDetailModel.OrderCode = orderCode;
orderDetailModel.Price = carModel.RealityPrice; //单价--
orderDetailModel.OrderSum = carModel.Goods006; //数量--
orderDetailModel.OrderTotal = carModel.Goods006 * carModel.RealityPrice; //订单金额
orderDetailModel.PV = 0; //
orderDetailModel.PVTotal = 0;
orderDetailModel.ProcudeID = carModel.GoodsID; //产品编号--
orderDetailModel.ProcudeName = carModel.GoodsName; //名称--
orderDetailModel.gColor = carModel.gColor;
orderDetailModel.gSize = carModel.gSize;
orderDetailModel.OrderDate = dtime; //
orderDetailBLL.Add(orderDetailModel); //加入订单详情
fenrun += goodsModel1.IsHave * carModel.Goods006; //计算分润单位
//修改库存
goodsModel.Goods002 = goodsModel.Goods002 - carModel.Goods006; //修改库存
goodsModel.SaleNum += carModel.Goods006;
goodsBLL.Update(goodsModel);
//从购物篮减掉
goodsCarBLL.Delete(carModel.ID);
//商品名称 流水表记录用
goodsname += orderDetailModel.ProcudeName + "|";
orderSum += carModel.Goods006;
}
orderModel.BaodanOrder = fenrun;
//if (aw[3]=="1")//自提
//{
// orderModel.Order3 = "自提";
// orderModel.Order4 = "自提";
//}
#endregion
//if (aw[1]=="2")//种子积分
//{
// orderModel.Order3 = "种子积分购买无发货信息！";
// orderModel.Order4= "种子积分购买无发货信息！";
// orderModel.IsSend = 3;
// long iOrderID = orderBLL.Add(orderModel);//加入订单表
//}
//else
//{
long iOrderID = orderBLL.Add(orderModel);//加入订单表
//}
#region 写入到明细表
if (aw[0] == "1")
{
if (aw[1] == "2")
{
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney / 2; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
if (aw[0] == "2") //50%电子积分+50%消费积分
{
joModel.JournalType = 2; //币种
joModel.BalanceAmount = userModel.StockMoney - totalMoney / 2; //余额
}
journalBLL.Add(joModel);
///---------------------------
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney / 2; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
if (aw[0] == "2") //50%电子积分+50%消费积分
{
joModel.JournalType = 5; //币种
joModel.BalanceAmount = userModel.StockAccount - totalMoney / 2; //余额
}
journalBLL.Add(joModel);
UpdateAccount("StockMoney", userModel.UserID, totalMoney / 2, 0);
UpdateAccount("StockAccount", userModel.UserID, totalMoney / 2, 0);
}
else
{
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
joModel.JournalType = 5; //币种
joModel.BalanceAmount = userModel.StockAccount - totalMoney; //余额
journalBLL.Add(joModel);
UpdateAccount("StockAccount", userModel.UserID, totalMoney, 0);
}
}
else if (aw[0] == "2")
{
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
joModel.JournalType = 4; //币种
joModel.BalanceAmount = userModel.AllBonusAccount - totalMoney; //余额
UpdateAccount("AllBonusAccount", userModel.UserID, totalMoney, 0);
journalBLL.Add(joModel);
}
else if (aw[0] == "3")
{
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney / 2; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
joModel.JournalType = 2; //币种子电子积分
joModel.BalanceAmount = userModel.StockMoney - totalMoney / 2; //余额
journalBLL.Add(joModel);
///---------------------------报单积分扣钱
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney / 2; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
joModel.JournalType = 5; //币种
joModel.BalanceAmount = userModel.StockAccount - totalMoney / 2; //余额
journalBLL.Add(joModel);
UpdateAccount("StockMoney", userModel.UserID, totalMoney / 2, 0);
UpdateAccount("StockAccount", userModel.UserID, totalMoney / 2, 0);
}
else if (aw[0] == "4")
{
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
joModel.JournalType = 3; //币种
joModel.BalanceAmount = userModel.BonusAccount - totalMoney; //余额
UpdateAccount("BonusAccount", userModel.UserID, totalMoney, 0);
journalBLL.Add(joModel);
}
else
{
msg = "支付失败，支付方式不正确！";
return(false);
}
//---激活会员
lgk.Model.tb_user user = userBLL.GetModel(orderModel.UserID);
if (user.IsOpend != 2)
{
string a = Luodian(orderModel.UserID);
string[] ID = a.Split('-');//ID[0]=UserID ID[1]=Location ID[2]=ParentID ID[3]=ParentCode ID[4]=Layer
var l = userBLL.GetModel(int.Parse(ID[2]));
//user.RecommendPath = model_1.RecommendPath + "-" + user.UserID.ToString();
user.ParentID = 0; //父节点ID
user.ParentCode = ""; //父节点編號
user.UserPath = "";
user.Layer = 0; //属于多少层
user.Location = 0;
user.ParentID = int.Parse(ID[2]); //父节点ID
user.ParentCode = ID[3]; //父节点編號
user.UserPath = l.UserPath + "-" + user.UserID;
user.Layer = int.Parse(ID[4]); //属于多少层
user.Location = int.Parse(ID[1]);
user.OpenTime = DateTime.Now;
user.IsOpend = 2;
userBLL.Update(user);
}
//开关报单
MySQL(string.Format(" exec proc_Kaiguan " + orderModel.UserID + "," + orderModel.OrderCode + ""));
//报单开关
//---激活会员
if (aw[0] != "4")
{
MySQL(string.Format(" exec proc_YejiUp " + orderModel.UserID + "," + orderModel.OrderTotal + ""));//加业绩
MySQL(string.Format(" exec proc_Fenxiangjiang " + orderModel.UserID + "," + orderModel.OrderTotal + ""));
MySQL(string.Format(" exec proc_Xiaocengjiang " + orderModel.UserID + ""));
MySQL(string.Format(" exec proc_Xiaoliangjiang " + orderModel.UserID + ""));
MySQL(string.Format(" exec proc_Jiandianjiang " + orderModel.UserID + "," + orderModel.OrderTotal + ",1"));
//发奖
#region 报单中心（20套）改为4万元
if (orderModel.OrderTotal >= getParamInt("Fuwu2"))//报单中心（20套）
{
int t = agentBLL.GetIDByIDUser(orderModel.UserID);
if (t == 0)//插入用户
{
var userModel1 = userBLL.GetModel(orderModel.UserID);
lgk.Model.tb_agent model = new lgk.Model.tb_agent();
model.UserID = userModel1.UserID;
model.AgentCode = userModel1.UserCode;
model.Flag = 1;
model.AgentType = 1;
model.Agent003 = userModel1.TrueName;
model.AppliTime = DateTime.Now;
model.JoinMoney = 0;
model.Agent004 = "";
model.Agent001 = 0;
model.Agent002 = 0;
model.PicLink = "";
agentBLL.Add(model);
var model1 = userBLL.GetModel(userModel1.UserID);
model1.AgentsID = agentBLL.GetIDByIDUser(userModel1.UserID);
model1.IsAgent = 1;
userBLL.Update(model1);
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = userModel1.UserID;
journalInfo.Remark = "一次性购买 " + getParamInt("Fuwu2") + "元的产品，成为服务网点";
journalInfo.RemarkEn = "Cash withdrawal";
journalInfo.InAmount = 0;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(userModel1.UserID, "StockMoney");
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = 2;
journalInfo.Journal01 = userModel1.UserID;
journalBLL.Add(journalInfo);
}
}
userid = orderModel.UserID;
totalMoney = orderModel.OrderTotal;
#endregion
if (getParamInt("Fuwu") == 1)
{
//报单中心奖
long BD_UserID = userBLL.GetUserID(userBLL.GetModel(orderModel.UserID).User006);
decimal BD = getParamAmount("Fuwu1") / 100 * totalMoney;
int isLock = userBLL.GetModel(BD_UserID).IsLock;
int Ag = userBLL.GetModel(BD_UserID).IsAgent;
if (isLock == 0 && Ag == 1)
{
decimal shouxufei = BD * getParamAmount("PingTai") / 100;
BD -= shouxufei;
decimal Gongyi = BD * getParamAmount("PingTai1") / 100;
BD -= Gongyi;
decimal jiangjin = getParamAmount("JJ");
decimal zhongzi = getParamAmount("ZZ");
decimal xiaofei = getParamAmount("XF");
decimal JJ = BD * jiangjin / 100;
decimal ZZ = BD * zhongzi / 100;
decimal XF = BD * xiaofei / 100;
UpdateAccount("Emoney", BD_UserID, JJ, 1); //奖金
UpdateAccount("StockMoney", BD_UserID, ZZ, 1); //电子
UpdateAccount("ShopAccount", BD_UserID, shouxufei, 1); //奖金
UpdateAccount("GLmoney", BD_UserID, Gongyi, 1); //电子
if (XF > 0)
{
UpdateAccount("BonusAccount", BD_UserID, XF, 1);//消费
lgk.Model.tb_journal journal1 = new lgk.Model.tb_journal();
journal1.UserID = BD_UserID;
journal1.Remark = "服务网点获得" + (BD + shouxufei + Gongyi) + ",其中扣除平台手续费" + shouxufei + ",扣除公益基金" + Gongyi + " ,剩余" + xiaofei + "%进入消费积分";
journal1.RemarkEn = "";
journal1.InAmount = XF;
journal1.OutAmount = 0;
journal1.BalanceAmount = userBLL.GetMoney(BD_UserID, "BonusAccount");;
journal1.JournalDate = DateTime.Now;
journal1.JournalType = 3;
journal1.Journal01 = 0;
journalBLL.Add(journal1);
}
lgk.Model.tb_journal journal = new lgk.Model.tb_journal();
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei + Gongyi) + ",其中扣除平台手续费" + shouxufei + ",扣除公益基金" + Gongyi + " ,剩余" + jiangjin + "%进入奖金积分";
journal.RemarkEn = "";
journal.InAmount = JJ;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "Emoney");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 1;
journal.Journal01 = 0;
journalBLL.Add(journal);
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei + Gongyi) + ",其中扣除平台手续费" + shouxufei + ",扣除公益基金" + Gongyi + " ,剩余" + zhongzi + "%进入电子积分";
journal.RemarkEn = "";
journal.InAmount = ZZ;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "StockMoney");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 2;
journal.Journal01 = 0;
journalBLL.Add(journal);
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei + Gongyi) + ",其中扣除平台手续费" + shouxufei + "";
journal.RemarkEn = "";
journal.InAmount = shouxufei;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "ShopAccount");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 6;
journal.Journal01 = 0;
journalBLL.Add(journal);
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei + Gongyi) + ",其中扣除公益基金" + Gongyi + "";
journal.RemarkEn = "";
journal.InAmount = Gongyi;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "GLmoney");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 7;
journal.Journal01 = 0;
journalBLL.Add(journal);
SqlConnection conn = new SqlConnection(sconn);
conn.Open();
string sql_Add = "insert into tb_bonus(UserID,TypeID,Amount,Revenue,sf,AddTime,IsSettled,Source,SourceEn,SttleTime,FromUserID,Bonus005,Bonus006)";
sql_Add += "values (" + BD_UserID + ",5," + (BD + shouxufei + Gongyi) + "," + shouxufei + "," + BD + ",getdate(),1,'" + journal.Remark + "','',getdate()," + userid + "," + jiangjin + "," + zhongzi + ");";
SqlCommand cmd = new SqlCommand(sql_Add, conn);
int reInt = cmd.ExecuteNonQuery();
conn.Close();
}
}
}
else
{
MySQL(string.Format(" exec proc_Jiandianjiang " + orderModel.UserID + "," + orderModel.OrderTotal + ",2"));
}
msg = "支付成功";
return(true);
}
public bool Transfer(long userid, string toUserCode, string txtMoney, string dropCurrency, string Phone, string paypassword, out string message)
{
if (RegValidate(userid, toUserCode, txtMoney, dropCurrency, Phone, paypassword, out message))
{
long toUserID = 0;
decimal fee = 0, balance = 0;
lgk.Model.tb_user userInfo = userBLL.GetModel(userid);
if (userInfo.IsLock == 1)
{
message = "账户已冻结，转账失败";
return(false);
}
lgk.Model.tb_user touserInfo = userBLL.GetModelByUserCode(toUserCode.Trim());
if (touserInfo == null)
{
message = "接收账户不存在";
return(false);
}
toUserID = touserInfo.UserID;
lgk.Model.tb_change changeInfo = new lgk.Model.tb_change();
changeInfo.UserID = userInfo.UserID;
changeInfo.ToUserID = toUserID;
changeInfo.ToUserType = 0;
changeInfo.MoneyType = 0;
changeInfo.Amount = decimal.Parse(txtMoney);
changeInfo.ChangeType = Convert.ToInt32(dropCurrency);
changeInfo.Change003 = Util.CreateNo();//订单号
changeInfo.ChangeDate = DateTime.Now;
//if (dropCurrency != "3")
//{
changeInfo.Change005 = changeInfo.Amount - changeInfo.Amount * getParamAmount("Transfer3") / 100; //到账金额
changeInfo.Change006 = getParamAmount("Transfer3"); // 转账手续费
//}
//else
//{
// changeInfo.Change006 = getParamAmount("TransferRateBTE");//奖励分转换注册币比例
// changeInfo.Change005 = Math.Round(changeInfo.Amount / getParamAmount("TransferRateBTE"), 2); //奖励分转换注册币比例 ,Change005 奖励分，Amount 注册币
//}
if (changeBLL.Add(changeInfo) > 0)
{
try
{
if (changeInfo.ChangeType == 1)//注册分转给其他会员
{
#region 注册分转给其他会员
decimal dBonusAccount = userBLL.GetMoney(userid, "Emoney ");
if (dBonusAccount >= changeInfo.Amount)
{
UpdateAccount("Emoney ", userInfo.UserID, changeInfo.Amount, 0); //
UpdateAccount("Emoney ", toUserID, changeInfo.Change005, 1); //
balance = userBLL.GetMoney(userid, "Emoney ");
fee = changeInfo.Amount - changeInfo.Change005;
//加入流水账表（佣金币减少）
lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal();
jmodel.UserID = userInfo.UserID;
jmodel.Remark = "注册分转给" + toUserCode;
jmodel.RemarkEn = "Currency to shopping currency";
jmodel.InAmount = 0;
jmodel.OutAmount = changeInfo.Change005;
jmodel.BalanceAmount = balance + fee;
jmodel.JournalDate = DateTime.Now;
jmodel.JournalType = (int)Library.AccountType.注册分;
jmodel.Journal01 = toUserID;
journalBLL.Add(jmodel);
//转账手续费
if (fee > 0)
{
lgk.Model.tb_journal jmodelfee = new lgk.Model.tb_journal();
jmodelfee.UserID = userInfo.UserID;
jmodelfee.Remark = "注册分转给" + toUserCode + ",手续费";
jmodelfee.RemarkEn = "Currency to shopping currency";
jmodelfee.InAmount = 0;
jmodelfee.OutAmount = fee;
jmodelfee.BalanceAmount = balance;
jmodelfee.JournalDate = DateTime.Now;
jmodelfee.JournalType = (int)Library.AccountType.注册分;
jmodelfee.Journal01 = toUserID;
journalBLL.Add(jmodelfee);
}
//加入流水账表(现金币增加)
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = toUserID;
journalInfo.Remark = "获得" + userInfo.UserCode + "转来注册分";
journalInfo.RemarkEn = "Currency to shopping currency";
journalInfo.InAmount = changeInfo.Change005;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(toUserID, "Emoney ");
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = (int)Library.AccountType.注册分;
journalInfo.Journal01 = userInfo.UserID;
journalBLL.Add(journalInfo);
}
else
{
message = GetLanguage("objectExist");//转帐对象不存在
}
#endregion
}
else if (changeInfo.ChangeType == 2)//奖励分转给其他会员
{
#region 奖励分转给其他会员
decimal dBonusAccount = userBLL.GetMoney(userid, "BonusAccount ");
if (dBonusAccount >= changeInfo.Amount)
{
UpdateAccount("BonusAccount ", userInfo.UserID, changeInfo.Amount, 0); //
UpdateAccount("BonusAccount ", toUserID, changeInfo.Change005, 1); //
balance = userBLL.GetMoney(userid, "BonusAccount ");
fee = changeInfo.Amount - changeInfo.Change005;
//加入流水账表（佣金币减少）
lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal();
jmodel.UserID = userInfo.UserID;
jmodel.Remark = "奖励分转给" + toUserCode;
jmodel.RemarkEn = "Currency to shopping currency";
jmodel.InAmount = 0;
jmodel.OutAmount = changeInfo.Change005;
jmodel.BalanceAmount = balance + fee;
jmodel.JournalDate = DateTime.Now;
jmodel.JournalType = (int)Library.AccountType.奖励分;
jmodel.Journal01 = toUserID;
journalBLL.Add(jmodel);
//转账手续费
if (fee > 0)
{
lgk.Model.tb_journal jmodelfee = new lgk.Model.tb_journal();
jmodelfee.UserID = userInfo.UserID;
jmodelfee.Remark = "奖励分转给" + toUserCode + ",手续费";
jmodelfee.RemarkEn = "Currency to shopping currency";
jmodelfee.InAmount = 0;
jmodelfee.OutAmount = fee;
jmodelfee.BalanceAmount = balance;
jmodelfee.JournalDate = DateTime.Now;
jmodelfee.JournalType = (int)Library.AccountType.奖励分;
jmodelfee.Journal01 = toUserID;
journalBLL.Add(jmodelfee);
}
//加入流水账表(现金币增加)
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = toUserID;
journalInfo.Remark = "获得" + userInfo.UserCode + "转来奖励分";
journalInfo.RemarkEn = "Currency to shopping currency";
journalInfo.InAmount = changeInfo.Change005;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(toUserID, "BonusAccount ");
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = (int)Library.AccountType.奖励分;
journalInfo.Journal01 = userInfo.UserID;
journalBLL.Add(journalInfo);
//如果冻结奖励分账户大于0，激活矿机时转入明细
if (touserInfo.User016 > 0)
{
UpdateAccount("User016", toUserID, touserInfo.User016, 0); //
UpdateAccount("BonusAccount", toUserID, touserInfo.User016, 1); //
lgk.Model.tb_journal jourInfo = new lgk.Model.tb_journal();
jourInfo.UserID = touserInfo.UserID;
jourInfo.Remark = "奖励分账户进账，冻结奖励分转入奖励分账户";
jourInfo.RemarkEn = "Cash withdrawal";
jourInfo.InAmount = touserInfo.User016;
jourInfo.OutAmount = 0;
jourInfo.BalanceAmount = userBLL.GetMoney(toUserID, "BonusAccount");
jourInfo.JournalDate = DateTime.Now;
jourInfo.JournalType = (int)Library.AccountType.奖励分;
jourInfo.Journal01 = touserInfo.UserID;
journalBLL.Add(jourInfo);
}
}
else
{
message = GetLanguage("objectExist");//转帐对象不存在
}
#endregion
}
else if (changeInfo.ChangeType == 3)//复利分转给其他会员
{
#region 奖励分转给其他会员
decimal dBonusAccount = userBLL.GetMoney(userid, "User018 ");
if (dBonusAccount >= changeInfo.Amount)
{
UpdateAccount("User018 ", userInfo.UserID, changeInfo.Amount, 0); //
UpdateAccount("User018 ", toUserID, changeInfo.Change005, 1); //
balance = userBLL.GetMoney(userid, "User018 ");
fee = changeInfo.Amount - changeInfo.Change005;
//加入流水账表（佣金币减少）
lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal();
jmodel.UserID = userInfo.UserID;
jmodel.Remark = "复利分转给" + toUserCode;
jmodel.RemarkEn = "Currency to shopping currency";
jmodel.InAmount = 0;
jmodel.OutAmount = changeInfo.Change005;
jmodel.BalanceAmount = balance + fee;
jmodel.JournalDate = DateTime.Now;
jmodel.JournalType = (int)Library.AccountType.利分;
jmodel.Journal01 = toUserID;
journalBLL.Add(jmodel);
//转账手续费
if (fee > 0)
{
lgk.Model.tb_journal jmodelfee = new lgk.Model.tb_journal();
jmodelfee.UserID = userInfo.UserID;
jmodelfee.Remark = "复利分转给" + toUserCode + ",手续费";
jmodelfee.RemarkEn = "Currency to shopping currency";
jmodelfee.InAmount = 0;
jmodelfee.OutAmount = fee;
jmodelfee.BalanceAmount = balance;
jmodelfee.JournalDate = DateTime.Now;
jmodelfee.JournalType = (int)Library.AccountType.利分;
jmodelfee.Journal01 = toUserID;
journalBLL.Add(jmodelfee);
}
//加入流水账表(现金币增加)
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = toUserID;
journalInfo.Remark = "获得" + userInfo.UserCode + "转来复利分";
journalInfo.RemarkEn = "Currency to shopping currency";
journalInfo.InAmount = changeInfo.Change005;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(toUserID, "User018 ");
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = (int)Library.AccountType.利分;
journalInfo.Journal01 = userInfo.UserID;
journalBLL.Add(journalInfo);
}
else
{
message = GetLanguage("objectExist");//转帐对象不存在
}
#endregion
}
}
catch
{
message = GetLanguage("addError"); //添加流水账错误
}
message = GetLanguage("TransferSuccess"); //转账成功
}
else
{
message = GetLanguage("addError");//操作失败
}
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 前台激活会员
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int OpenCheckFront(lgk.Model.tb_user model)
{
int iFalg = 0;
decimal regMoney = 0;
lgk.Model.tb_user userInfo = new lgk.Model.tb_user();
regMoney = getParamAmount("Level" + model.LevelID) * getParamAmount("billMoney"); //注册金额
userInfo = userBLL.GetModel(getLoginID()); //服务中心实体
//if (model.IsReport == 1)//使用报单币注册
//{
// lgk.Model.tb_user recommendInfo = userBLL.GetModel(model.RecommendID);
// if (Convert.ToDecimal(userInfo.BankAccount) > regMoney / 2 && Convert.ToDecimal(recommendInfo.BankAccount) > regMoney / 2)
// {
// recommendInfo.Emoney = recommendInfo.Emoney - regMoney / 2;//使用注册币支付一半的注册费
// userInfo.BankAccount = (Convert.ToDecimal(userInfo.BankAccount) - regMoney).ToString();//使用金钱支付一半的注册费
// if (userBLL.Update(userInfo) && userBLL.Update(recommendInfo))
// {
// //加入流水账表扣除注册币
// lgk.Model.tb_journal data = new lgk.Model.tb_journal();
// data.Remark = "激活会员" + model.UserCode;
// data.RemarkEn = "open user " + model.UserCode;
// data.InAmount = 0;
// data.OutAmount = regMoney;
// data.BalanceAmount = userInfo.Emoney;
// data.JournalDate = DateTime.Now;
// data.JournalType = 2;
// data.TakeType = 3;
// data.Journal01 = int.Parse(model.UserID.ToString());
// data.UserID = int.Parse(userInfo.UserID.ToString());
// journalBLL.Add(data);
// data.UserID = int.Parse(recommendInfo.UserID.ToString());
// journalBLL.Add(data);
// }
// else
// {
// iFalg = 1;
// }
// UpdateSystemAccount("MoneyAccount", regMoney, 1);
// }
// else
// iFalg = 2;
//}
//if (model.IsReport == 0)
//{
if (Convert.ToDecimal(userInfo.BonusAccount) >= regMoney)
{
userInfo.BonusAccount = Convert.ToDecimal(userInfo.BonusAccount) - regMoney;
if (userBLL.Update(userInfo))
{
//加入流水账表扣除E币
lgk.Model.tb_journal data = new lgk.Model.tb_journal();
data.UserID = int.Parse(userInfo.UserID.ToString());
data.Remark = "激活会员" + model.UserCode;
data.RemarkEn = "open user " + model.UserCode;
data.InAmount = 0;
data.OutAmount = regMoney;
data.BalanceAmount = Convert.ToDecimal(userInfo.BonusAccount);
data.JournalDate = DateTime.Now;
data.JournalType = 1;
data.Journal01 = int.Parse(model.UserID.ToString());
journalBLL.Add(data);
}
else
{
iFalg = 1;
}
//UpdateSystemAccount("MoneyAccount", regMoney, 1);
}
else
{
iFalg = 2;
}
return(iFalg);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (getParamInt("Gold1") == 0)
{
MessageBox.Show(this, GetLanguage("Feature"));//该功能未开放
return;
}
if (LoginUser.IsOpend == 0)
{
MessageBox.ShowBox(this.Page, GetLanguage("AccountNoActiveInfo"), Library.Enums.ModalTypes.error);//您的帐号未激活
return;
}
if (LoginUser.IsLock == 1)
{
MessageBox.ShowBox(this.Page, GetLanguage("AccountLock"), GetLanguage("AccountLockInfo"), Library.Enums.ModalTypes.error);//您的帐号已冻结，不能进行操作
return;
}
int receivaAccount = dorpReceiveAccount.SelectedValue.ToInt();
if (receivaAccount == 0)
{
MessageBox.ShowBox(this.Page, GetLanguage("SelectReceiveAccount"), Library.Enums.ModalTypes.error);//请选择收款账户
return;
}
#region 金额验证
if (txtNumber.Text.Trim() == "")
{
MessageBox.ShowBox(this.Page, GetLanguage("AmountNoEmpty"), Library.Enums.ModalTypes.warning);//卖出金额不能为空
return;
}
decimal dNumber = 0;
if (decimal.TryParse(txtNumber.Text.Trim(), out dNumber))
{
decimal dGold1 = getParamAmount("Gold1");
if (dNumber < dGold1)
{
MessageBox.ShowBox(this.Page, GetLanguage("Minimum"), Library.Enums.ModalTypes.warning);//最小交易额
return;
}
}
else
{
MessageBox.ShowBox(this.Page, GetLanguage("NumberThanZero"), Library.Enums.ModalTypes.error);//金额格式输入错误
return;
}
int mul = getParamInt("Gold7");
if (dNumber % mul != 0)
{
MessageBox.ShowBox(this.Page, string.Format(GetLanguage("CashSellMul"), mul), Library.Enums.ModalTypes.warning);//出售金额必须为 7 的整数倍
return;
}
decimal dMaxNumber = 0; //每日最大挂卖数量
decimal dBNumber = 0, dBaseNumber = 0; //每日挂卖基数
decimal dANumber = 0; //今日已挂卖数量
dBaseNumber = getParamAmount("Gold6");
// dBNumber = getParamAmount("Gold7");
dMaxNumber = dBaseNumber;// dBaseNumber + dBNumber * userBLL.GetCount("RecommendID = " + LoginUser.UserID + " AND IsOpend = 2");//每日挂卖基数
dANumber = cashsellBLL.GetAlready(LoginUser.UserID) + dNumber;
if (dANumber > dMaxNumber)
{
MessageBox.ShowBox(this.Page, GetLanguage("ConsignmentOver"), Library.Enums.ModalTypes.warning);// 寄售数量已超额
return;
}
//if (txtPrice.Text.Trim() == "")
//{
// MessageBox.MyShow(this, GetLanguage("PriceEmpty"));//价格不能为空
// return;
//}
decimal dPrice = 1;
//if (decimal.TryParse(txtPrice.Text.Trim(), out dPrice))
//{
// decimal dGoldMin = getParamAmount("GoldMin");//最低价格
// decimal dGoldMax = getParamAmount("GoldMax");//最高价格
// if (dPrice < dGoldMin)
// {
// MessageBox.MyShow(this, GetLanguage("PriceBetween"));
// return;
// }
// else if (dPrice > dGoldMax)
// {
// MessageBox.MyShow(this, GetLanguage("PriceBetween"));
// return;
// }
//}
//else
//{
// MessageBox.MyShow(this, GetLanguage("PriceFormat"));//价格格式错误
// return;
//}
#endregion
if (txtThreePassword.Value.Trim() == "")
{
MessageBox.ShowBox(this.Page, GetLanguage("Pleasepassword"), Library.Enums.ModalTypes.warning);// 请输入二级密码
return;
}
string strPassword = PageValidate.GetMd5(txtThreePassword.Value.Trim());
int re = spd.findSecondpws(strPassword, 1, getLoginID());
if (re == 0)
{
MessageBox.ShowBox(this.Page, GetLanguage("PasswordError"), Library.Enums.ModalTypes.error);// >密码输入错误!
return;
}
// int iUnitNum = Convert.ToInt32(txtUnitNum.Value.Trim());//发布件数1
decimal dFactorage = dNumber * getParamAmount("Gold2") / 100;//保证金
lgk.Model.tb_user userInfo = new lgk.Model.tb_user();
lgk.Model.Cashsell cashsellInfo = new lgk.Model.Cashsell();
decimal dAmount = dNumber * dPrice;
userInfo = userBLL.GetModel(getLoginID());
#region 赋值给金币销售表实体
cashsellInfo.Title = Util.CreateNo();
cashsellInfo.UserID = getLoginID();
cashsellInfo.Amount = dAmount; //商品价格
cashsellInfo.Number = Convert.ToInt32(dNumber); //单件数量
cashsellInfo.Price = dPrice; //商品单价
cashsellInfo.UnitNum = getParamAmount("Gold2"); //手续费率
cashsellInfo.SaleNum = 0; //已卖件数
cashsellInfo.Charge = dFactorage; //每件所需手续费
cashsellInfo.SellDate = DateTime.Now; //提交时间
cashsellInfo.Remark = "";
cashsellInfo.PurchaseID = receivaAccount; //收款账户ID
cashsellInfo.IsSell = 1;
#endregion
#region 加入流水账表
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = cashsellInfo.UserID;
journalInfo.Remark = "卖出交易币";
journalInfo.RemarkEn = "Sell Circulating gold";
journalInfo.InAmount = 0;
journalInfo.OutAmount = cashsellInfo.Number; // cashsellInfo.Number * iUnitNum + dFactorage;
journalInfo.BalanceAmount = userInfo.ShopAccount - dNumber; // userInfo.BonusAccount - dNumber - dFactorage;
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = (int)Library.AccountType.交易钱包;
journalInfo.Journal01 = cashsellInfo.UserID;
#endregion
#region 保证金 加入流水账表
lgk.Model.tb_journal journalInfoTrans = new lgk.Model.tb_journal()
{
UserID = cashsellInfo.UserID,
Remark = "卖出交易币,扣除保证金",
RemarkEn = "Sell gold points, consumption code",
InAmount = 0,
OutAmount = dFactorage, // cashsellInfo.Number * iUnitNum + dFactorage;
BalanceAmount = userInfo.ShopAccount - dNumber - dFactorage, // userInfo.BonusAccount - dNumber - dFactorage;
JournalDate = DateTime.Now,
JournalType = (int)Library.AccountType.交易钱包,
Journal01 = cashsellInfo.UserID
};
#endregion
decimal dBonusAccount = dNumber;// + dFactorage;
if (userInfo.ShopAccount < dBonusAccount + dFactorage)
{
MessageBox.ShowBox(this.Page, GetLanguage("GoldInsufficient"), Library.Enums.ModalTypes.warning);// 金币不足，请重新填写数据之后再试！!
return;
}
//if (userInfo.ShopAccount < dFactorage)
//{
// MessageBox.ShowBox(this.Page, GetLanguage("GoldTransInsufficient"), Library.Enums.ModalTypes.warning);//交易码不足！
// return;
//}
// UpdateAccount("ShopAccount", getLoginID(), dFactorage, 0);
if (cashsellBLL.Add(cashsellInfo) > 0 && journalBLL.Add(journalInfoTrans) > 0 && journalBLL.Add(journalInfo) > 0 && UpdateAccount("ShopAccount", getLoginID(), dBonusAccount + dFactorage, 0) > 0)
{
SetCashcredit();
MessageBox.ShowBox(this.Page, GetLanguage("Successful"), Library.Enums.ModalTypes.success, "CashsellList.aspx");//注册成功!
}
else
{
MessageBox.ShowBox(this.Page, GetLanguage("OperationFailed"), Library.Enums.ModalTypes.error);//操作失败!
}
}
//取消会员提现
public bool ItemCommand(long userid, long txid, string paypassword, out string message)
{
lgk.Model.tb_takeMoney takeMoneyInfo = takeBLL.GetModel(txid);
if (takeMoneyInfo == null)
{
message = GetLanguage("recordDeleted");
return(false);
}
if (takeMoneyInfo.Flag != 0)
{
message = GetLanguage("recordApproved");
return(false);
}
//提现账户 1:原始币，2：原始积分
int AccountType = takeMoneyInfo.Take001;
lgk.Model.tb_user userInfo = userBLL.GetModel(takeMoneyInfo.UserID);
if (!ValidPassword(userInfo.SecondPassword, paypassword))
{
message = "支付密码错误";
return(false);
}
if (userInfo.IsLock == 1)
{
message = "账户已冻结，取消提现失败";
return(false);
}
//加入流水账表
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 = (AccountType == 1? userInfo.Emoney : userInfo.StockAccount) + takeMoneyInfo.TakeMoney;
model.JournalDate = DateTime.Now;
model.JournalType = (AccountType == 1 ? 1 : 2);
model.Journal01 = takeMoneyInfo.UserID;
//如果冻结释放币账户大于0，激活矿机时转入明细
if (userInfo.User016 > 0)
{
UpdateAccount("User016", userInfo.UserID, userInfo.User016, 0); //
UpdateAccount("BonusAccount", userInfo.UserID, userInfo.User016, 1); //
lgk.Model.tb_journal jourInfo = new lgk.Model.tb_journal();
jourInfo.UserID = userInfo.UserID;
jourInfo.Remark = "释放币账户进账，冻结释放币转入释放币账户";
jourInfo.RemarkEn = "Cash withdrawal";
jourInfo.InAmount = userInfo.User016;
jourInfo.OutAmount = 0;
jourInfo.BalanceAmount = userBLL.GetMoney(userInfo.UserID, "BonusAccount");
jourInfo.JournalDate = DateTime.Now;
jourInfo.JournalType = 2;
jourInfo.Journal01 = userInfo.UserID;
journalBLL.Add(jourInfo);
}
if (journalBLL.Add(model) > 0 && takeBLL.UpdateFlag(Convert.ToInt64(userid), Convert.ToInt64(txid)) > 0)
{
if (AccountType == 1)
{
UpdateAccount("Emoney", takeMoneyInfo.UserID, takeMoneyInfo.TakeMoney, 1);
}
else if (AccountType == 2)
{
UpdateAccount("StockAccount", takeMoneyInfo.UserID, takeMoneyInfo.TakeMoney, 1);
}
message = GetLanguage("CancellationSuccess");//取消成功
return(true);
}
else
{
message = GetLanguage("FailedToCancel");//取消失败
return(false);
}
}
/// <summary>
/// 提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
//string[] Day = new string[] { "星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六" };
//week = Convert.ToInt32(DateTime.Now.DayOfWeek.ToString("d"));
//var open2 = getParamAmount("extract4");
//if (week != open2)
//{
// ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('请在提现日进行此功能操作，谢谢!');", true);
// return;
//}
string filename = "";
#region 提现金额验证
int iTypeID = Convert.ToInt32(dropType.SelectedValue);
if (iTypeID == 0)
{
MessageBox.ShowBox(this.Page, "请选择提现类型", Library.Enums.ModalTypes.warning);
return;
}
string strMoney = txtTake.Text.Trim();
if (string.IsNullOrEmpty(strMoney))
{
MessageBox.ShowBox(this.Page, GetLanguage("WithdrawalIsnull"), Library.Enums.ModalTypes.warning);//提现金额不能为空
return;
}
decimal resultNum = 0;
if (!decimal.TryParse(strMoney, out resultNum))
{
MessageBox.ShowBox(this.Page, GetLanguage("AmountErrors"), Library.Enums.ModalTypes.warning);//金额格式输入错误
return;
}
decimal MinMoney = getParamAmount("ATM1"); //最小金额
decimal Multiple = getParamAmount("ATM2"); //倍数基数
if (resultNum < MinMoney)
{
MessageBox.ShowBox(this.Page, "提现金额必须大于最低提现金额", Library.Enums.ModalTypes.warning);//金额格式输入错误
return;
}
if (Multiple != 0 && resultNum % Multiple != 0)
{
MessageBox.ShowBox(this.Page, "提现金额必须是" + Multiple + "的整数倍", Library.Enums.ModalTypes.warning);//金额格式输入错误
return;
}
lgk.Model.tb_user userModel = userBLL.GetModel(getLoginID());
if (iTypeID == 1)
{
if (userModel.Emoney < resultNum)
{
MessageBox.ShowBox(this.Page, "注册分余额不足", Library.Enums.ModalTypes.warning);
return;
}
filename = "Emoney";
}
if (iTypeID == 2)
{
if (userModel.BonusAccount < resultNum)
{
MessageBox.ShowBox(this.Page, "奖励分余额不足", Library.Enums.ModalTypes.warning);
return;
}
filename = "BonusAccount";
}
lgk.Model.tb_takeMoney takemodel = takeBLL.GetModel(" UserID=" + LoginUser.UserID + " and Flag=0");
if (takemodel != null)
{
MessageBox.MyShow(this, "您有待审核的申请记录，请等待后台审核后再申请！");//提现金额必须大于最低提现金额!
return;
}
#endregion
#region 提现申请
decimal Fee = resultNum * getParamAmount("ATM3") / 100;//手续费
lgk.Model.tb_takeMoney takeMoneyInfo = new lgk.Model.tb_takeMoney();
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
takeMoneyInfo.TakeTime = DateTime.Now;
takeMoneyInfo.TakePoundage = Fee;
takeMoneyInfo.TakeMoney = resultNum;
takeMoneyInfo.RealityMoney = resultNum - Fee;
takeMoneyInfo.Flag = 0;
takeMoneyInfo.UserID = getLoginID();
if (iTypeID == 1)//YD
{
takeMoneyInfo.BonusBalance = userModel.Emoney - takeMoneyInfo.TakeMoney;
}
else//YT
{
takeMoneyInfo.BonusBalance = userModel.BonusAccount - takeMoneyInfo.TakeMoney;
}
takeMoneyInfo.BankName = userModel.BankName;
takeMoneyInfo.Take003 = userModel.BankBranch;
takeMoneyInfo.BankAccount = userModel.BankAccount;
takeMoneyInfo.BankAccountUser = userModel.BankAccountUser;
takeMoneyInfo.Take001 = iTypeID; //提现币种：1、注册分，2、奖励分
takeMoneyInfo.Take002 = 0; //dropOutAccount.SelectedValue.ToInt();
#endregion
#region 加入流水账表
journalInfo.UserID = takeMoneyInfo.UserID;
journalInfo.Remark = "会员提现";
journalInfo.RemarkEn = "Cash withdrawal";
journalInfo.InAmount = 0;
journalInfo.OutAmount = takeMoneyInfo.TakeMoney;
journalInfo.BalanceAmount = takeMoneyInfo.BonusBalance;
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = iTypeID;
journalInfo.Journal01 = takeMoneyInfo.UserID;
#endregion
if (takeBLL.Add(takeMoneyInfo) > 0 && journalBLL.Add(journalInfo) > 0 && UpdateAccount(filename, getLoginID(), takeMoneyInfo.TakeMoney, 0) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("successful") + "');window.location.href='TakeMoney.aspx';", true);//申请提现成功
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("OperationFailed") + "');", true);//操作失败
}
}
public void AddJournal(long iUserID, decimal inamount, decimal outamount, decimal banlance, int jourtype, int type, string remark, string remarken, long iFromUserID)
{
lgk.Model.tb_journal jModel = new lgk.Model.tb_journal();
jModel.UserID = iUserID;
}
/// <summary>
/// 提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
#region 数据验证
//string[] Day = new string[] { "星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六" };
//week = Convert.ToInt32(DateTime.Now.DayOfWeek.ToString("d"));
//var open2 = getParamAmount("extract4");
//if (week != open2)
//{
// ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('请在提现日进行此功能操作，谢谢!');", true);
// return;
//}
string filename = "";
lgk.Model.tb_user user = userBLL.GetModel(LoginUser.UserID);
#region 提现金额验证
if (txtTake.Text.Trim() == "")
{
MessageBox.MyShow(this, GetLanguage("WithdrawalIsnull"));//提现金额不能为空
return;
}
decimal resultNum = 0;
int Journal02 = 0;
decimal tx_bs = getParamAmount("ATM2");//倍数基数
if (user.Emoney == 0)
{
MessageBox.MyShow(this, "消费金为0，无法提现");//提现金额不能为空
return;
}
if (decimal.TryParse(txtTake.Text.Trim(), out resultNum))
{
if (resultNum < getParamAmount("ATM1"))
{
MessageBox.MyShow(this, "提现金额必须大于最低提现金额");//提现金额必须大于最低提现金额!
return;
}
if (resultNum > user.Emoney)
{
MessageBox.MyShow(this, "云盾余额不足"); //提现金额必须小于消费金金额!
return;
}
lgk.Model.tb_takeMoney takemodel = takeBLL.GetModel(" UserID=" + LoginUser.UserID + " and Flag=0");
if (takemodel != null)
{
MessageBox.MyShow(this, "您有待审核的申请记录，请等待后台审核后再申请！"); //提现金额必须大于最低提现金额!
return;
}
user.Emoney = user.Emoney - resultNum;
userBLL.Update(user);
}
else
{
MessageBox.MyShow(this, GetLanguage("AmountErrors"));//金额格式输入错误
return;
}
#endregion
#endregion
#region 提现申请
lgk.Model.tb_takeMoney takeMoneyInfo = new lgk.Model.tb_takeMoney();
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
takeMoneyInfo.TakeTime = DateTime.Now;
takeMoneyInfo.TakePoundage = getParamAmount("ATM3") / 100;
takeMoneyInfo.TakeMoney = resultNum;
takeMoneyInfo.RealityMoney = Convert.ToDecimal(txtExtMoney.Value);
takeMoneyInfo.Flag = 0;
takeMoneyInfo.UserID = getLoginID();
takeMoneyInfo.BonusBalance = user.Emoney - takeMoneyInfo.TakeMoney;
takeMoneyInfo.BankName = user.BankName;
takeMoneyInfo.Take003 = user.BankBranch;
takeMoneyInfo.BankAccount = user.BankAccount;
takeMoneyInfo.BankAccountUser = user.BankAccountUser;
takeMoneyInfo.Take001 = Journal02;
#endregion
#region 加入流水账表
journalInfo.UserID = takeMoneyInfo.UserID;
journalInfo.Remark = "会员提现";
journalInfo.RemarkEn = "Cash withdrawal";
journalInfo.InAmount = 0;
journalInfo.OutAmount = takeMoneyInfo.TakeMoney;
journalInfo.BalanceAmount = takeMoneyInfo.BonusBalance;
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = 1;
journalInfo.Journal01 = takeMoneyInfo.UserID;
journalInfo.Journal02 = Journal02;
#endregion
if (takeBLL.Add(takeMoneyInfo) > 0 && journalBLL.Add(journalInfo) > 0 && UpdateAccount(filename, getLoginID(), takeMoneyInfo.TakeMoney, 0) > 0)
{
//string ss = (GetLanguage("MessageTakeMoney").Replace("{username}", LoginUser.UserCode)).Replace("{time}", Convert.ToDateTime(journalInfo.JournalDate).ToString("yyyy年MM月dd日HH时mm分")).Replace("{timeEn}", Convert.ToDateTime(journalInfo.JournalDate).ToString("yyyy/MM/dd HH:mm"));//添加短信内容
//SendMessage((int)LoginUser.UserID, LoginUser.PhoneNum, ss);
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("successful") + "');window.location.href='TakeMoney.aspx';", true);//申请提现成功
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('" + GetLanguage("OperationFailed") + "');", true);//操作失败
}
}
public bool GoodsCartPay(long userid, int paytype, long addrid, string strcid, int shtype, out string msg)
{
if (paytype != 4)
{
msg = "请选择正确的支付方式";
return(false);
}
if (shtype <= 0)
{
msg = "请选择正确的收货方式";
return(false);
}
if (!userBLL.Exists(userid))
{
msg = "请重新登录再支付";
return(false);
}
JavaScriptSerializer js = new JavaScriptSerializer();
var list = js.Deserialize <List <GetGoods> >(strcid);
LogHelper.SaveLog(strcid, "GoodsCartPay");
if (list.Count <= 0)
{
msg = "请选择购物车中的商品";
return(false);
}
Random rand = new Random();
string orderCode = DateTime.Now.ToString("yyyyMMddhhmmss") + rand.Next(10000, 99999); //订单编号
string goodsname = string.Format("订单号{0}，", orderCode);
decimal totalMoney = 0;
int orderSum = 0;
int insert = 0;
DateTime dtime = DateTime.Now;
if (!userBLL.Exists(userid))
{
msg = "用户不存在";
}
//if (addrid!=1)
//{
// lgk.Model.tb_Address addrModel = addressBLL.GetModel(addrid);
// if(addrModel == null)
// {
// msg = "请选择收货地址";
// return false;
// }
//}
IList <lgk.Model.tb_goodsCar> listCar = new List <lgk.Model.tb_goodsCar>();
#region 验证商品
string errmsg = "";
foreach (GetGoods g in list)
{
lgk.Model.tb_goodsCar carModel = goodsCarBLL.GetModel(g.ID);
if (carModel != null)
{
lgk.Model.tb_goods goodsModel = goodsBLL.GetModelAndOneName(carModel.GoodsID);//根据发布商品编号找到充值账号密码
if (goodsModel == null)
{
errmsg = "商品" + goodsModel.GoodsName + "不存在!";
insert = 0;
break;
}
if (g.num <= 0)
{
errmsg = "商品" + goodsModel.GoodsName + "的购买数量必须大于0!";
insert = 0;
break;
}
if (goodsModel.StateType == 0) //判断是否 审核通过 0未审核
{
errmsg = "商品" + goodsModel.GoodsName + "审核未通过,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods003 == "1") //判断是否 删除 1已经删除
{
errmsg = "商品" + goodsModel.GoodsName + "已被删除,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods001 == 0) //判断是否 0下架
{
errmsg = "商品" + goodsModel.GoodsName + "已经下架,请删除该商品!";
insert = 0;
break;
}
else if (goodsModel.Goods002 < g.num) //判断库存量
{
errmsg = "商品" + goodsModel.GoodsName + "库存不足,请重新修改数量!";
insert = 0;
break;
}
else if (carModel.BuyUser != userid) //
{
errmsg = "用户不匹配，请刷新购物车再提交!";
insert = 0;
break;
}
carModel.Goods006 = g.num;//以最中传输的数量为准
listCar.Add(carModel);
insert += 1;
}
else
{
msg = "购物出为空";
LogHelper.SaveLog(g.ID.ToString() + "," + errmsg, "GoodsCartPay");
return(false);
}
}
if (insert == 0)
{
msg = errmsg;
return(false);
}
#endregion
//总金额
totalMoney += listCar.Sum(s => s.TotalMoney);
orderSum += listCar.Sum(s => s.Goods006);
lgk.Model.tb_user userModel = userBLL.GetModel(userid);
//var dt = orderBLL.GetList(" UserID=" + userid ).Tables[0];
//if (pay == 1 && dt.Rows.Count>0)
//{
//} sss
//else if (pay == 2 && dt.Rows.Count == 0)
//{
//}
if (paytype == 4 && userModel.GLmoney < totalMoney)
{
msg = "购物分余额不足";
return(false);
}
#region 订单处理
//总订单
lgk.Model.tb_Order orderModel = new lgk.Model.tb_Order(); //订单
orderModel.UserID = userid; //用户
orderModel.OrderCode = orderCode; //订单编号
orderModel.OrderSum = orderSum; //订单数--
orderModel.OrderTotal = totalMoney; //购买总金
orderModel.PVTotal = 0; //
orderModel.OrderDate = dtime;
orderModel.IsSend = 1;
orderModel.PayMethod = 3; //--2、复投 1注册激活,3购物分
orderModel.Order5 = ""; //备用电话
orderModel.UserAddr = userModel.Address; //addrModel.Address;//发货地址
orderModel.Order6 = userModel.PhoneNum; //addrModel.PhoneNum;//收货电话
orderModel.Order7 = userModel.NiceName; //addrModel.MemberName;//收货姓名
orderModel.OrderType = paytype; //购物分
orderModel.ReceiveType = shtype;
long iOrderID = orderBLL.Add(orderModel); //加入订单表
foreach (var carModel in listCar)
{
lgk.Model.tb_goods goodsModel = goodsBLL.GetModelAndOneName(carModel.GoodsID);//根据发布商品编号找到充值账号密码
//插入订单详细表
lgk.Model.tb_OrderDetail orderDetailModel = new lgk.Model.tb_OrderDetail();
orderDetailModel.OrderCode = orderCode;
orderDetailModel.Price = carModel.RealityPrice; //单价--
orderDetailModel.OrderSum = carModel.Goods006; //数量--
orderDetailModel.OrderTotal = carModel.Goods006 * carModel.RealityPrice; //订单金额
orderDetailModel.PV = 0; //
orderDetailModel.PVTotal = 0;
orderDetailModel.ProcudeID = carModel.GoodsID; //产品编号--
orderDetailModel.ProcudeName = carModel.GoodsName; //名称--
orderDetailModel.gColor = carModel.gColor;
orderDetailModel.gSize = carModel.gSize;
orderDetailModel.OrderDate = dtime; //
orderDetailBLL.Add(orderDetailModel); //加入订单详情
//修改库存
goodsModel.Goods002 = goodsModel.Goods002 - carModel.Goods006;//修改库存
goodsModel.SaleNum += carModel.Goods006;
goodsBLL.Update(goodsModel);
//从购物篮减掉
goodsCarBLL.Delete(carModel.ID);
//商品名称 流水表记录用
goodsname += orderDetailModel.ProcudeName + "|";
orderSum += carModel.Goods006;
}
#endregion
#region 写入到明细表
lgk.Model.tb_journal joModel = new lgk.Model.tb_journal();
joModel.UserID = userModel.UserID;
joModel.Remark = goodsname; //名称--;
joModel.InAmount = 0; //收入0;
joModel.OutAmount = totalMoney; //购买价(支出金币)
joModel.JournalDate = DateTime.Now;
joModel.Journal01 = userModel.UserID; //
joModel.Journal02 = 99; //消费
joModel.Journal03 = orderCode; //订单编号
if (paytype == 4) //购物分
{
joModel.JournalType = 5; //币种
joModel.BalanceAmount = userModel.GLmoney - totalMoney; //余额
journalBLL.Add(joModel);
UpdateAccount("GLmoney", userModel.UserID, totalMoney, 0);
}
//用户账户更新
#endregion
//购物积分购买不给分红点
//执行存储过程
//string procmsg = string.Empty;
//procmsg = proc_BuyOrder(userid, orderModel.OrderSum, orderCode, 4, totalMoney);
//LogHelper.SaveLog("procmsg:" + procmsg, "proc_BuyOrder");
msg = "支付成功";
return(true);
}
protected void btnSub_Click(object sender, EventArgs e)
{
lgk.Model.tb_recharge Model = new lgk.Model.tb_recharge();
lgk.Model.tb_user user = new lgk.Model.tb_user();
user = userBLL.GetModel(" usercode='" + SafeHelper.GetSafeSqlandHtml(this.txtUserCode.Text.Trim()) + "' ");
string usercode = txtUserCode.Text.Trim();
if (string.IsNullOrEmpty(usercode))
{
MessageBox.MyShow(this, "请填写要充值的会员账号!");
return;
}
if (user == null)
{
MessageBox.MyShow(this, "该会员账号不存在!");
return;
}
//if (user.IsOpend == 0)
//{
// MessageBox.MyShow(this, "会员未开通!");
// return;
//}
Model.UserID = user.UserID;
if (Convert.ToInt32(dropMoneyType.SelectedValue) == 0)
{
MessageBox.MyShow(this, "请选择账户类型!");
return;
}
Model.RechargeType = Convert.ToInt32(dropMoneyType.SelectedValue);
if (Convert.ToInt32(dropRechargeStyle.SelectedValue) == 0)
{
MessageBox.MyShow(this, "请选择充值类型!");
return;
}
Model.RechargeStyle = Convert.ToInt32(dropRechargeStyle.SelectedValue);
string tMoney = this.txtMoney.Text.Trim();
if (string.IsNullOrEmpty(tMoney))
{
MessageBox.MyShow(this, "充值金额不能为空!");
return;
}
else if (Convert.ToDecimal(tMoney) <= 0)
{
MessageBox.MyShow(this, "金额需大于零!");
return;
}
decimal reMoney = Convert.ToDecimal(tMoney);
//加入流水账表
lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal();
jmodel.UserID = Convert.ToInt32(user.UserID);
jmodel.JournalDate = DateTime.Now;
jmodel.JournalType = Model.RechargeType;
jmodel.Remark = "后台充值" + AccountTypeHelper.GetName((int)Model.RechargeType) + "(增加)";
if (Model.RechargeStyle == 1)
{
jmodel.OutAmount = 0;
jmodel.JournalType = Model.RechargeType;
jmodel.InAmount = reMoney;
if (Model.RechargeType == 1)//注册分
{
Model.YuAmount = user.Emoney + reMoney;
jmodel.BalanceAmount = user.Emoney + reMoney;
}
if (Model.RechargeType == 2)//奖励分
{
Model.YuAmount = user.BonusAccount + reMoney;
jmodel.BalanceAmount = user.BonusAccount + reMoney;
}
if (Model.RechargeType == 3)//复利分
{
Model.YuAmount = user.StockMoney + reMoney;
jmodel.BalanceAmount = user.StockMoney + reMoney;
}
if (Model.RechargeType == 4)//激活分
{
Model.YuAmount = user.StockAccount + reMoney;
jmodel.BalanceAmount = user.StockAccount + reMoney;
}
if (Model.RechargeType == 5)//购物分
{
Model.YuAmount = user.GLmoney + reMoney;
jmodel.BalanceAmount = user.GLmoney + reMoney;
}
}
if (Model.RechargeStyle == 2)
{
jmodel.InAmount = 0;
jmodel.JournalType = Model.RechargeType;
jmodel.OutAmount = reMoney;
jmodel.Remark = "后台充值" + AccountTypeHelper.GetName((int)Model.RechargeType) + "(扣除)";
if (Model.RechargeType == 1)
{
if (reMoney > user.Emoney)
{
MessageBox.MyShow(this, AccountTypeHelper.GetName((int)Model.RechargeType) + "余额不足!");
return;
}
Model.YuAmount = user.Emoney - reMoney;
jmodel.BalanceAmount = user.Emoney - reMoney;
}
if (Model.RechargeType == 2)
{
if (reMoney > user.BonusAccount)
{
MessageBox.MyShow(this, AccountTypeHelper.GetName((int)Model.RechargeType) + "余额不足!");
return;
}
Model.YuAmount = user.BonusAccount - reMoney;
jmodel.BalanceAmount = user.BonusAccount - reMoney;
}
if (Model.RechargeType == 3)
{
if (reMoney > user.StockAccount)
{
MessageBox.MyShow(this, AccountTypeHelper.GetName((int)Model.RechargeType) + "余额不足!");
return;
}
Model.YuAmount = user.StockMoney - reMoney;
jmodel.BalanceAmount = user.StockMoney - reMoney;
}
if (Model.RechargeType == 4)
{
if (reMoney > user.StockMoney)
{
MessageBox.MyShow(this, AccountTypeHelper.GetName((int)Model.RechargeType) + "余额不足!");
return;
}
Model.YuAmount = user.StockAccount - reMoney;
jmodel.BalanceAmount = user.StockAccount - reMoney;
}
if (Model.RechargeType == 5)
{
if (reMoney > user.GLmoney)
{
MessageBox.MyShow(this, AccountTypeHelper.GetName((int)Model.RechargeType) + "余额不足!");
return;
}
Model.YuAmount = user.GLmoney - reMoney;
jmodel.BalanceAmount = user.GLmoney - reMoney;
}
}
Model.RechargeableMoney = reMoney;
Model.RechargeDate = DateTime.Now;
Model.Flag = 1;
if (rechargeBLL.Add(Model) > 0 && journalBLL.Add(jmodel) > 0)
{
string fieldName = "";
if (Model.RechargeType == 1)
{
fieldName = "Emoney";
}
else if (Model.RechargeType == 2)
{
fieldName = "BonusAccount";
}
else if (Model.RechargeType == 3)
{
fieldName = "StockMoney";
}
else if (Model.RechargeType == 4)
{
fieldName = "StockAccount";
}
else if (Model.RechargeType == 5)
{
fieldName = "GLmoney";
}
if (Model.RechargeStyle == 1)
{
UpdateAccount(fieldName, Convert.ToInt32(Model.UserID), reMoney, 1);
UpdateSystemAccount("MoneyAccount", reMoney, 1);//公司账户增加
}
else
{
UpdateAccount(fieldName, Convert.ToInt32(Model.UserID), reMoney, 0);
UpdateSystemAccount("MoneyAccount", reMoney, 0);//公司账户减少
}
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('操作成功！');window.location.href='AddMoney.aspx';", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('充值失败!');", true);
}
}
//卖出
public bool Sell(long UserID, string Number, string phone, long bankid, string paypassword, out string message)
{
var user = userBLL.GetModel(UserID);
if (user == null)
{
message = "该账号不存在";
return(false);
}
if (user.SecondPassword != paypassword)
{
message = "支付密码错误";
return(false);
}
if (user.IsLock == 1)
{
message = "账户已冻结，挂卖失败";
return(false);
}
if (getParamInt("Gold") == 0)
{
message = GetLanguage("Feature");//该功能未开放
return(false);
}
var bank = userBankBLL.GetModel(bankid);
if (bank == null)
{
message = "请选择收款账户";
return(false);
}
if (bank.UserID != UserID)
{
message = "收款账户不存在";
return(false);
}
#region 金额验证
if (Number.Trim() == "")
{
message = GetLanguage("AmountNoEmpty");//卖出金额不能为空
return(false);
}
int dNumber = 0;
if (int.TryParse(Number.Trim(), out dNumber))
{
decimal dGold1 = getParamAmount("Gold1");
if (dNumber < dGold1)
{
message = GetLanguage("Minimum");//最小交易额
return(false);
}
}
else
{
message = GetLanguage("NumberThanZero");//金额格式输入错误
return(false);
}
int mul = getParamInt("Gold7");
if (dNumber % mul != 0)
{
message = string.Format(GetLanguage("CashSellMul"), mul);//出售金额必须为 7 的整数倍
return(false);
}
decimal dMaxNumber = 0; //每日最大挂卖数量
decimal dBaseNumber = 0; //每日挂卖基数 dBNumber = 0,
decimal dANumber = 0; //今日已挂卖数量
dBaseNumber = getParamAmount("Gold6");
// dBNumber = getParamAmount("Gold7");
dMaxNumber = dBaseNumber;// dBaseNumber + dBNumber * userBLL.GetCount("RecommendID = " + LoginUser.UserID + " AND IsOpend = 2");//每日挂卖基数
dANumber = cashsellBLL.GetAlready(UserID) + dNumber;
if (dANumber > dMaxNumber)
{
message = GetLanguage("ConsignmentOver");// 寄售数量已超额
return(false);
}
//decimal dPrice = getParamAmount("GoldPrice");
decimal dPrice = getParamAmount("Exchange");
#endregion
//if (txtThreePassword.Value.Trim() == "")
//{
// MessageBox.ShowBox(this.Page, GetLanguage("Pleasepassword"), Library.Enums.ModalTypes.warning);// 请输入二级密码
// return;
//}
//string strPassword = PageValidate.GetMd5(txtThreePassword.Value.Trim());
//int re = spd.findSecondpws(strPassword, 1, getLoginID());
//if (re == 0)
//{
// MessageBox.ShowBox(this.Page, GetLanguage("PasswordError"), Library.Enums.ModalTypes.error);// >密码输入错误!
// return;
//}
// int iUnitNum = Convert.ToInt32(txtUnitNum.Value.Trim());//发布件数1
decimal dFactorage = dNumber * getParamAmount("Gold2") / 100;//手续费
lgk.Model.tb_user userInfo = new lgk.Model.tb_user();
lgk.Model.Cashsell cashsellInfo = new lgk.Model.Cashsell();
decimal dAmount = dNumber * dPrice;
userInfo = userBLL.GetModel(UserID);
#region 赋值给金币销售表实体
cashsellInfo.Title = Util.CreateNo();
cashsellInfo.UserID = UserID;
cashsellInfo.Amount = dAmount; //总金额
cashsellInfo.Number = dNumber; //单件数量
cashsellInfo.Price = dPrice; //商品单价
cashsellInfo.UnitNum = getParamAmount("Gold2"); //手续费率
cashsellInfo.SaleNum = 0; //已卖件数
cashsellInfo.Charge = dFactorage; //所需手续费
cashsellInfo.SellDate = DateTime.Now; //提交时间
cashsellInfo.Remark = "";
// cashsellInfo.PurchaseID = 0;
cashsellInfo.IsSell = 1;
cashsellInfo.Phone = phone;
cashsellInfo.PurchaseID = bankid; //收款账户ID
#endregion
#region 加入流水账表
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = cashsellInfo.UserID;
journalInfo.Remark = "卖出交易币";
journalInfo.RemarkEn = "Sell Circulating gold";
journalInfo.InAmount = 0;
journalInfo.OutAmount = cashsellInfo.Number; // cashsellInfo.Number * iUnitNum + dFactorage;
journalInfo.BalanceAmount = userInfo.ShopAccount - dNumber; // userInfo.BonusAccount - dNumber - dFactorage;
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = (int)Library.AccountType.购物分;
journalInfo.Journal01 = cashsellInfo.UserID;
#endregion
#region 保证金 加入流水账表
lgk.Model.tb_journal journalInfoTrans = new lgk.Model.tb_journal()
{
UserID = cashsellInfo.UserID,
Remark = "卖出交易币,扣除保证金",
RemarkEn = "Sell gold points, consumption code",
InAmount = 0,
OutAmount = dFactorage, // cashsellInfo.Number * iUnitNum + dFactorage;
BalanceAmount = userInfo.ShopAccount - dFactorage, // userInfo.BonusAccount - dNumber - dFactorage;
JournalDate = DateTime.Now,
JournalType = (int)Library.AccountType.购物分,
Journal01 = cashsellInfo.UserID
};
#endregion
decimal dBonusAccount = dNumber;// + dFactorage;
if (userInfo.ShopAccount < (dBonusAccount + dFactorage))
{
message = GetLanguage("GoldInsufficient");// 金币不足，请重新填写数据之后再试！!
return(false);
}
//if (userInfo.ShopAccount < dFactorage)
//{
// message = GetLanguage("GoldTransInsufficient");//交易码不足！
// return false;
//}
journalBLL.Add(journalInfoTrans);
// UpdateAccount("ShopAccount", UserID, dBonusAccount+ dFactorage, 0); //扣除保证金
if (cashsellBLL.Add(cashsellInfo) > 0 && journalBLL.Add(journalInfo) > 0 && UpdateAccount("ShopAccount", UserID, dBonusAccount + dFactorage, 0) > 0)
{
message = GetLanguage("Successful");//卖出成功!
return(true);
}
else
{
message = GetLanguage("OperationFailed");//操作失败!
}
return(false);
}
public bool Transfer(long userid, string toUserCode, string txtMoney, string dropCurrency, string Phone, string paypassword, out string message)
{
if (RegValidate(userid, toUserCode, txtMoney, dropCurrency, Phone, paypassword, out message))
{
long toUserID = 0;
decimal fee = 0, balance = 0;
lgk.Model.tb_user userInfo = userBLL.GetModel(userid);
if (userInfo.IsLock == 1)
{
message = "账户已冻结，转账失败";
return(false);
}
if (dropCurrency != "3")
{
lgk.Model.tb_user touserInfo = userBLL.GetModel(userBLL.GetUserID(toUserCode.Trim()));
toUserID = touserInfo.UserID;
}
else
{
toUserID = userid;
}
lgk.Model.tb_change changeInfo = new lgk.Model.tb_change();
changeInfo.UserID = userInfo.UserID;
changeInfo.ToUserID = toUserID;
changeInfo.ToUserType = 0;
changeInfo.MoneyType = 0;
changeInfo.Amount = decimal.Parse(txtMoney);
changeInfo.ChangeType = Convert.ToInt32(dropCurrency);
changeInfo.Change003 = Util.CreateNo();//订单号
changeInfo.ChangeDate = DateTime.Now;
if (dropCurrency != "3")
{
changeInfo.Change005 = changeInfo.Amount - changeInfo.Amount * getParamAmount("Transfer3") / 100; //到账金额
changeInfo.Change006 = getParamAmount("Transfer3"); // 转账手续费
}
else
{
//注册币 = 云图*比例b
//云图 = 注册币 / 比例b
changeInfo.Change006 = getParamAmount("TransferRateBTE"); //云图转换注册币比例
changeInfo.Change005 = Math.Round(changeInfo.Amount / getParamAmount("TransferRateBTE"), 2); //云图转换注册币比例 ,Change005 云图，Amount 注册币
}
if (changeBLL.Add(changeInfo) > 0)
{
try
{
if (changeInfo.ChangeType == 1)//云盾转给其他会员
{
#region 云盾转给其他会员
decimal dBonusAccount = userBLL.GetMoney(userid, "Emoney ");
if (dBonusAccount >= changeInfo.Amount)
{
UpdateAccount("Emoney ", userInfo.UserID, changeInfo.Amount, 0); //
UpdateAccount("Emoney ", toUserID, changeInfo.Change005, 1); //
balance = userBLL.GetMoney(userid, "Emoney ");
fee = changeInfo.Amount - changeInfo.Change005;
//加入流水账表（佣金币减少）
lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal();
jmodel.UserID = userInfo.UserID;
jmodel.Remark = "云盾转给" + toUserCode;
jmodel.RemarkEn = "Currency to shopping currency";
jmodel.InAmount = 0;
jmodel.OutAmount = changeInfo.Change005;
jmodel.BalanceAmount = balance + fee;
jmodel.JournalDate = DateTime.Now;
jmodel.JournalType = (int)Library.AccountType.云盾;
jmodel.Journal01 = toUserID;
journalBLL.Add(jmodel);
//转账手续费
if (fee > 0)
{
lgk.Model.tb_journal jmodelfee = new lgk.Model.tb_journal();
jmodelfee.UserID = userInfo.UserID;
jmodelfee.Remark = "云盾转给" + toUserCode + ",手续费";
jmodelfee.RemarkEn = "Currency to shopping currency";
jmodelfee.InAmount = 0;
jmodelfee.OutAmount = fee;
jmodelfee.BalanceAmount = balance;
jmodelfee.JournalDate = DateTime.Now;
jmodelfee.JournalType = (int)Library.AccountType.云盾;
jmodelfee.Journal01 = toUserID;
journalBLL.Add(jmodelfee);
}
//加入流水账表(现金币增加)
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = toUserID;
journalInfo.Remark = "获得" + userInfo.UserCode + "转来云盾";
journalInfo.RemarkEn = "Currency to shopping currency";
journalInfo.InAmount = changeInfo.Change005;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(toUserID, "Emoney ");
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = (int)Library.AccountType.云盾;
journalInfo.Journal01 = userInfo.UserID;
journalBLL.Add(journalInfo);
}
else
{
message = GetLanguage("objectExist");//转帐对象不存在
}
#endregion
}
if (changeInfo.ChangeType == 2)//云图转给其他会员
{
#region 云图转给其他会员
decimal dBonusAccount = userBLL.GetMoney(userid, "BonusAccount ");
if (dBonusAccount >= changeInfo.Amount)
{
UpdateAccount("BonusAccount ", userInfo.UserID, changeInfo.Amount, 0); //
UpdateAccount("BonusAccount ", toUserID, changeInfo.Change005, 1); //
balance = userBLL.GetMoney(userid, "BonusAccount ");
fee = changeInfo.Amount - changeInfo.Change005;
//加入流水账表（佣金币减少）
lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal();
jmodel.UserID = userInfo.UserID;
jmodel.Remark = "云图转给" + toUserCode;
jmodel.RemarkEn = "Currency to shopping currency";
jmodel.InAmount = 0;
jmodel.OutAmount = changeInfo.Change005;
jmodel.BalanceAmount = balance + fee;
jmodel.JournalDate = DateTime.Now;
jmodel.JournalType = (int)Library.AccountType.云图;
jmodel.Journal01 = toUserID;
journalBLL.Add(jmodel);
//转账手续费
if (fee > 0)
{
lgk.Model.tb_journal jmodelfee = new lgk.Model.tb_journal();
jmodelfee.UserID = userInfo.UserID;
jmodelfee.Remark = "云图转给" + toUserCode + ",手续费";
jmodelfee.RemarkEn = "Currency to shopping currency";
jmodelfee.InAmount = 0;
jmodelfee.OutAmount = fee;
jmodelfee.BalanceAmount = balance;
jmodelfee.JournalDate = DateTime.Now;
jmodelfee.JournalType = (int)Library.AccountType.云图;
jmodelfee.Journal01 = toUserID;
journalBLL.Add(jmodelfee);
}
//加入流水账表(现金币增加)
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = toUserID;
journalInfo.Remark = "获得" + userInfo.UserCode + "转来云图";
journalInfo.RemarkEn = "Currency to shopping currency";
journalInfo.InAmount = changeInfo.Change005;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(toUserID, "BonusAccount ");
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = (int)Library.AccountType.云图;
journalInfo.Journal01 = userInfo.UserID;
journalBLL.Add(journalInfo);
}
else
{
message = GetLanguage("objectExist");//转帐对象不存在
}
#endregion
}
if (changeInfo.ChangeType == 3)//云图转给注册币
{
#region 云图转给注册币
decimal dBonusAccount = userBLL.GetMoney(userid, "BonusAccount");
if (dBonusAccount >= changeInfo.Change005)
{
UpdateAccount("BonusAccount ", userInfo.UserID, changeInfo.Change005, 0); //
UpdateAccount("Emoney ", toUserID, changeInfo.Amount, 1); //
//加入流水账表（佣金币减少）
lgk.Model.tb_journal jmodel = new lgk.Model.tb_journal();
jmodel.UserID = userInfo.UserID;
jmodel.Remark = "云图转换云图(AEC),消耗云图";
jmodel.RemarkEn = "Currency to shopping currency";
jmodel.InAmount = 0;
jmodel.OutAmount = changeInfo.Change005;
jmodel.BalanceAmount = userBLL.GetMoney(userid, "BonusAccount");
jmodel.JournalDate = DateTime.Now;
jmodel.JournalType = (int)Library.AccountType.云图;
jmodel.Journal01 = toUserID;
journalBLL.Add(jmodel);
//加入流水账表(现金币增加)
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = toUserID;
journalInfo.Remark = "云图转换云图(AEC)，获得云图(AEC)";
journalInfo.RemarkEn = "Currency to shopping currency";
journalInfo.InAmount = changeInfo.Amount;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(toUserID, "Emoney");
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = (int)Library.AccountType.云图;
journalInfo.Journal01 = userInfo.UserID;
journalBLL.Add(journalInfo);
}
else
{
message = GetLanguage("objectExist");//转帐对象不存在
}
#endregion
}
}
catch
{
message = GetLanguage("addError"); //添加流水账错误
}
message = GetLanguage("TransferSuccess"); //转账成功
}
else
{
message = GetLanguage("addError");//操作失败
}
return(true);
}
else
{
return(false);
}
}
protected void btnApply_Click(object sender, EventArgs e)
{
var usermodel = userBLL.GetModel(LoginUser.UserID);
if (usermodel.User001 == 1)
{
MessageBox.ShowBox(this.Page, "您已开通分号", Library.Enums.ModalTypes.info);//您已开通分号
return;
}
if (usermodel.IsOpend == 0)
{
MessageBox.ShowBox(this.Page, GetLanguage("AccountNoActiveInfo"), Library.Enums.ModalTypes.error);//您的帐号未激活
return;
}
if (usermodel.IsLock == 1)
{
MessageBox.ShowBox(this.Page, GetLanguage("AccountLock"), GetLanguage("AccountLockInfo"), Library.Enums.ModalTypes.error);//您的帐号已冻结，不能进行操作
return;
}
decimal amount = GetInvestAmount(LoginUser.UserID);
if (amount < p_amount)
{
MessageBox.ShowBox(this.Page, "投资额度不足", Library.Enums.ModalTypes.warning);//投资额度不足
return;
}
int recnum = usermodel.User003;
if (recnum < p_recnum)
{
MessageBox.ShowBox(this.Page, "直推人数不足", Library.Enums.ModalTypes.warning);//直推人数不足
return;
}
decimal trans = usermodel.ShopAccount;
if (trans < p_trans)
{
MessageBox.ShowBox(this.Page, "释放币不足", Library.Enums.ModalTypes.warning);//释放币不足
return;
}
usermodel.User001 = 1;
userBLL.Update(usermodel);
UpdateAccount("ShopAccount", usermodel.UserID, trans, 0);//
//加入流水账表(现金币增加)
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal()
{
UserID = usermodel.UserID,
Remark = "开通分号使用释放币",
RemarkEn = "Open Account ",
InAmount = 0,
OutAmount = p_trans,
BalanceAmount = userBLL.GetMoney(usermodel.UserID, "ShopAccount"),
JournalDate = DateTime.Now,
JournalType = 2,
Journal01 = usermodel.UserID
};
journalBLL.Add(journalInfo);
#region 日志
string ip = Page.Request.UserHostAddress;
lgk.Model.SysLog log = new lgk.Model.SysLog();//日志
lgk.BLL.SysLog syslogBLL = new lgk.BLL.SysLog();
log.LogMsg = "";
log.LogType = 22; //
log.LogLeve = 0; //
log.LogDate = DateTime.Now;
log.LogCode = "开通分号"; //
log.IsDeleted = 0;
log.Log1 = usermodel.UserID.ToString(); //用户UserID
log.Log2 = ip; //
log.Log3 = "";
log.Log4 = "";
syslogBLL.Add(log);
#endregion
MessageBox.ShowBox(this.Page, "开通分号成功", Library.Enums.ModalTypes.success);//开通分号成功
}
/// <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, "取消失败");
}
}
}
}
}
public bool TakeMoney(long UserID, string Currency, string ExtMoney, string BankID, string paypassword, out string message)
{
if (TakeMoneyValidate(UserID, Currency, ExtMoney, BankID, out message))
{
#region 提现申请
var user = userBLL.GetModel(UserID);
if (user == null)
{
message = "用户ID不存在";
return(false);
}
if (!ValidPassword(user.SecondPassword, paypassword))
{
message = "支付密码错误";
return(false);
}
if (user.IsLock == 1)
{
message = "账户已冻结，提现失败";
return(false);
}
int JournalType = 0;
int _id = 0;
int.TryParse(BankID, out _id);
var userbank = userBankBLL.GetModel(Convert.ToInt32(_id));
if (user == null)
{
message = "银行账户ID不存在";
return(false);
}
lgk.Model.tb_takeMoney takeMoneyInfo = new lgk.Model.tb_takeMoney();
decimal dMoney = decimal.Parse(ExtMoney);
takeMoneyInfo.TakeTime = DateTime.Now;
takeMoneyInfo.TakeMoney = dMoney;
takeMoneyInfo.Flag = 0;
takeMoneyInfo.UserID = UserID;
if (Currency.Trim() == "1")
{
takeMoneyInfo.TakePoundage = dMoney * getParamAmount("ATM3") / 100;
takeMoneyInfo.RealityMoney = dMoney;// - takeMoneyInfo.TakePoundage;
takeMoneyInfo.BonusBalance = user.Emoney - takeMoneyInfo.TakeMoney;
JournalType = 1;
}
if (Currency.Trim() == "2")
{
takeMoneyInfo.TakePoundage = dMoney * getParamAmount("ATM3") / 100;
takeMoneyInfo.RealityMoney = dMoney;// - takeMoneyInfo.TakePoundage;
takeMoneyInfo.BonusBalance = user.BonusAccount - takeMoneyInfo.TakeMoney;
JournalType = 1;
}
takeMoneyInfo.Take001 = Currency == "2" ? 2 : 1; //提现类型
takeMoneyInfo.Take002 = _id;
#endregion
#region 加入流水账表
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = takeMoneyInfo.UserID;
journalInfo.Remark = Library.AccountTypeHelper.GetName(JournalType) + "提现";
journalInfo.RemarkEn = "Cash withdrawal";
journalInfo.InAmount = 0;
journalInfo.OutAmount = takeMoneyInfo.TakeMoney;
journalInfo.BalanceAmount = takeMoneyInfo.BonusBalance;
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = JournalType;
journalInfo.Journal01 = takeMoneyInfo.UserID;
journalBLL.Add(journalInfo);
lgk.Model.tb_journal journalInfoFee = new lgk.Model.tb_journal();
journalInfoFee.UserID = takeMoneyInfo.UserID;
journalInfoFee.Remark = Library.AccountTypeHelper.GetName(JournalType) + "提现手续费";
journalInfoFee.RemarkEn = "Cash withdrawal";
journalInfoFee.InAmount = 0;
journalInfoFee.OutAmount = takeMoneyInfo.TakePoundage;
journalInfoFee.BalanceAmount = takeMoneyInfo.BonusBalance - takeMoneyInfo.TakePoundage;
journalInfoFee.JournalDate = DateTime.Now;
journalInfoFee.JournalType = JournalType;
journalInfoFee.Journal01 = takeMoneyInfo.UserID;
journalBLL.Add(journalInfoFee);
#endregion
if (takeBLL.Add(takeMoneyInfo) > 0)
{
if (Currency.Trim() == "1")
{
UpdateAccount("Emoney", UserID, takeMoneyInfo.TakeMoney + takeMoneyInfo.TakePoundage, 0);
}
if (Currency.Trim() == "2")
{
UpdateAccount("BonusAccount", UserID, takeMoneyInfo.TakeMoney + takeMoneyInfo.TakePoundage, 0);
}
message = GetLanguage("successful");//申请提现成功
return(true);
}
else
{
message = GetLanguage("OperationFailed");//操作失败
return(false);
}
}
else
{
return(false);
}
}
public void ProcessRequest(HttpContext context)
{
string result = "error";
string message = "";
string dates = "";
string strID = context.Request["ID"];
string strUserID = context.Request["UserID"];
decimal Money = 0;
long ID = 0;
long UserID = 0;
if (string.IsNullOrEmpty(strID) || strID.Trim() == string.Empty || string.IsNullOrEmpty(strUserID) || strUserID.Trim() == string.Empty)
{
message = "账号不存在";
SendResponse(context, result, message, dates);
return;
}
try
{
ID = long.Parse(strID);
UserID = long.Parse(strUserID);
}
catch (Exception)
{
ID = 0;
UserID = 0;
message = "账号不存在";
SendResponse(context, result, message, dates);
}
AllCore core = new AllCore();
lgk.Model.tb_user userModel = core.userBLL.GetModel(UserID);
SqlConnection conn = new SqlConnection(sconn);
conn.Open();
string sql = string.Format("select ID,RandMoney from tb_Rand where ID=" + ID + " and Flag=0 and UserID= '" + UserID + "' ;");
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
Money = decimal.Parse(dt.Rows[0]["RandMoney"].ToString());
conn.Open();
string sql_1 = "update tb_Rand set Flag=2,ClickTime=getdate() where ID='" + ID + "' and UserID= '" + UserID + "';update tb_user set BonusAccount+='" + Money + "' where UserID= '" + UserID + "'; ";
SqlCommand cmd = new SqlCommand(sql_1, conn);
int reInt = cmd.ExecuteNonQuery();
conn.Close();
if (reInt > 0)
{
AllCore AC = new AllCore();
var model = AC.userBLL.GetModel(UserID);
dates = "\"Account\":{\"Emoney\":\"" + model.Emoney.ToString() + "\",\"BonusAccount\":\"" + model.BonusAccount.ToString() + "\",\"ShengYuSuanLi\":\"" + Convert.ToInt32(model.User012) + "\"}";
result = "success";
message = "领取成功！";
//明细记录
var Mjournal = new lgk.Model.tb_journal();
lgk.BLL.tb_journal Bjournal = new lgk.BLL.tb_journal();
Mjournal.UserID = UserID;
Mjournal.InAmount = Money;
Mjournal.OutAmount = 0;
Mjournal.Remark = "领取奖励分 ";
Mjournal.RemarkEn = "Collect " + Money + " clouds";
Mjournal.JournalType = 2;
Mjournal.BalanceAmount = model.BonusAccount;
Mjournal.JournalDate = DateTime.Now;
Bjournal.Add(Mjournal);
//奖项记录
lgk.Model.tb_bonus Mbonus = new lgk.Model.tb_bonus();
lgk.BLL.tb_bonus Bbonus = new lgk.BLL.tb_bonus();
Mbonus.AddTime = DateTime.Now;
Mbonus.TypeID = 1;
Mbonus.IsSettled = 1;
Mbonus.FromUserID = UserID;
Mbonus.Amount = Money;
Mbonus.UserID = UserID;
Mbonus.Source = "领取奖励分 ";
Mbonus.sf = Money;
Mbonus.SourceEn = "Collect " + Money + " clouds";
Mbonus.SttleTime = DateTime.Now;
Bbonus.Add(Mbonus);
//如果冻结奖励分账户大于0，激活矿机时转入明细
if (userModel.User016 > 0)
{
core.UpdateAccount("User016", userModel.UserID, userModel.User016, 0); //
core.UpdateAccount("BonusAccount", userModel.UserID, userModel.User016, 1); //
lgk.Model.tb_journal jourInfo = new lgk.Model.tb_journal();
jourInfo.UserID = userModel.UserID;
jourInfo.Remark = "奖励分账户进账，冻结奖励分转入奖励分账户";
jourInfo.RemarkEn = "Cash withdrawal";
jourInfo.InAmount = userModel.User016;
jourInfo.OutAmount = 0;
jourInfo.BalanceAmount = core.userBLL.GetMoney(UserID, "BonusAccount");
jourInfo.JournalDate = DateTime.Now;
jourInfo.JournalType = (int)Library.AccountType.奖励分;
jourInfo.Journal01 = userModel.UserID;
core.journalBLL.Add(jourInfo);
}
SendResponse(context, result, message, dates);
//差一条记录
}
}
message = "已经领取过";
SendResponse(context, result, message, dates);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
decimal jine1 = 0;
if (!decimal.TryParse(TextBox1.Text, out jine1))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('请输入正确的金额');", true);
return;
}
if (jine1 == 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('输入的金额不能为0');", true);
return;
}
string sql = "select OrderID,a.userid ,BaodanOrder,OrderCode,PVTotal,Order1 from tb_Order a left join tb_user b on a.UserID=b.UserID where BaodanOrder >0 and Order1<>PVTotal and IsSend>2 and IsOpend = 2";
var dt = userBLL.getData_Chaxun(sql, "").Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
decimal shouxufei = 0;
long ID = long.Parse(dt.Rows[i]["OrderID"].ToString());
long userid = long.Parse(dt.Rows[i]["userid"].ToString());
string BaodanOrder = dt.Rows[i]["BaodanOrder"].ToString();
string OrderCode = dt.Rows[i]["OrderCode"].ToString();
decimal PVTotal = decimal.Parse(dt.Rows[i]["PVTotal"].ToString());
decimal Order1 = decimal.Parse(dt.Rows[i]["Order1"].ToString());
if (PVTotal - Order1 <= jine1)//封顶设置
{
jine1 = PVTotal - Order1;
}
shouxufei = jine1 * getParamAmount("PingTai") / 100;
decimal jine = jine1 - shouxufei;
decimal jiangjin = getParamAmount("JJ");
decimal zhongzi = getParamAmount("ZZ");
decimal JJ = jine * jiangjin / 100;
decimal ZZ = jine * zhongzi / 100;
UpdateAccount("Emoney", userid, JJ, 1); //奖金
UpdateAccount("AllBonusAccount", userid, ZZ, 1); //种子
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = userid;
journalInfo.Remark = "订单号：" + OrderCode + ",有" + BaodanOrder + "个分润单位，加权分红获得" + (jine + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + jiangjin + "%进入奖金积分";
journalInfo.RemarkEn = OrderCode;
journalInfo.InAmount = JJ;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(userid, "Emoney");;
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = 1;
journalInfo.Journal01 = 0;
journalBLL.Add(journalInfo);
journalInfo.UserID = userid;
journalInfo.Remark = "订单号：" + OrderCode + ",有" + BaodanOrder + "个分润单位，加权分红获得" + (jine + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + zhongzi + "%进入种子积分";
journalInfo.RemarkEn = OrderCode;
journalInfo.InAmount = ZZ;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(userid, "AllBonusAccount");;
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = 4;
journalInfo.Journal01 = 0;
journalBLL.Add(journalInfo);
string Source = "订单号：" + OrderCode + ",有" + BaodanOrder + "个分润单位，加权分红获得" + (jine + shouxufei);
SqlConnection conn = new SqlConnection(sconn);
conn.Open();
string sql_Add = "insert into tb_bonus(UserID,TypeID,Amount,Revenue,sf,AddTime,IsSettled,Source,SourceEn,SttleTime,FromUserID,Bonus005,Bonus006)";
sql_Add += "values (" + userid + ",4," + (jine + shouxufei) + "," + shouxufei + "," + jine + ",getdate(),1,'" + Source + "','',getdate()," + userid + "," + jiangjin + "," + zhongzi + ");update tb_order set Order1+=" + (jine + shouxufei) + " where OrderID = " + ID + "";
SqlCommand cmd = new SqlCommand(sql_Add, conn);
int reInt = cmd.ExecuteNonQuery();
conn.Close();
}
if (dt.Rows.Count == 0)
{
Response.Write("<script>alert('暂无会员分红');location.href='Fenhong.aspx';</script>");
return;
}
Response.Write("<script>alert('分红成功');location.href='Fenhong.aspx';</script>");
return;
}
protected void rpOrderList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
long iID = Convert.ToInt64(e.CommandArgument);
lgk.Model.tb_Order orderModel = orderBLL.GetModel(iID);
if (e.CommandName.Equals("cancel"))
{
if (orderModel != null)
{
if (orderModel.IsDel == 0)
{
orderModel.IsDel = 1;
if (orderBLL.Update(orderModel))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('订单取消成功!');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('订单取消失败!');", true);
return;
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单已取消!');", true);
return;
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单记录不存在!');", true);
return;
}
}
else if (e.CommandName.Equals("sure"))
{
if (orderModel != null)
{
if (orderModel.IsSend == 3)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单已收货!');", true);
return;
}
else if (orderModel.IsSend == 1)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单未发货!');", true);
return;
}
else
{
orderModel.IsSend = 3;
if (orderBLL.Update(orderModel))
{
//发奖
#region 报单中心（20套）改为4万元
if (orderModel.OrderTotal >= getParamInt("Fuwu2"))//报单中心（20套）
{
int a = agentBLL.GetIDByIDUser(orderModel.UserID);
if (a == 0)//插入用户
{
var userModel = userBLL.GetModel(orderModel.UserID);
lgk.Model.tb_agent model = new lgk.Model.tb_agent();
model.UserID = userModel.UserID;
model.AgentCode = userModel.UserCode;
model.Flag = 1;
model.AgentType = 1;
model.Agent003 = userModel.TrueName;
model.AppliTime = DateTime.Now;
model.JoinMoney = 0;
model.Agent004 = "";
model.Agent001 = 0;
model.Agent002 = 0;
model.PicLink = "";
agentBLL.Add(model);
var model1 = userBLL.GetModel(userModel.UserID);
model1.AgentsID = agentBLL.GetIDByIDUser(userModel.UserID);
model1.IsAgent = 1;
userBLL.Update(model1);
lgk.Model.tb_journal journalInfo = new lgk.Model.tb_journal();
journalInfo.UserID = userModel.UserID;
journalInfo.Remark = "一次性购买 " + getParamInt("Fuwu2") + "元的产品，成为服务网点";
journalInfo.RemarkEn = "Cash withdrawal";
journalInfo.InAmount = 0;
journalInfo.OutAmount = 0;
journalInfo.BalanceAmount = userBLL.GetMoney(userModel.UserID, "StockMoney");
journalInfo.JournalDate = DateTime.Now;
journalInfo.JournalType = 2;
journalInfo.Journal01 = userModel.UserID;
journalBLL.Add(journalInfo);
}
}
long userid = orderModel.UserID;
decimal totalMoney = orderModel.OrderTotal;
#endregion
if (getParamInt("Fuwu") == 1)
{
//报单中心奖
long BD_UserID = userBLL.GetUserID(userBLL.GetModel(orderModel.UserID).User006);
decimal BD = getParamAmount("Fuwu1") / 100 * totalMoney;
int isLock = userBLL.GetModel(BD_UserID).IsLock;
int Ag = userBLL.GetModel(BD_UserID).IsAgent;
if (isLock == 0 && Ag == 1)
{
decimal shouxufei = BD * getParamAmount("PingTai") / 100;
BD -= shouxufei;
decimal jiangjin = getParamAmount("JJ");
decimal zhongzi = getParamAmount("ZZ");
decimal xiaofei = getParamAmount("XF");
decimal JJ = BD * jiangjin / 100;
decimal ZZ = BD * zhongzi / 100;
decimal XF = BD * xiaofei / 100;
UpdateAccount("Emoney", BD_UserID, JJ, 1); //奖金
UpdateAccount("AllBonusAccount", BD_UserID, ZZ, 1); //种子
if (XF > 0)
{
UpdateAccount("AllBonusAccount", BD_UserID, XF, 1);//种子
lgk.Model.tb_journal journal1 = new lgk.Model.tb_journal();
journal1.UserID = BD_UserID;
journal1.Remark = "服务网点获得" + (BD + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + xiaofei + "%进入消费积分";
journal1.RemarkEn = "";
journal1.InAmount = XF;
journal1.OutAmount = 0;
journal1.BalanceAmount = userBLL.GetMoney(BD_UserID, "BonusAccount");;
journal1.JournalDate = DateTime.Now;
journal1.JournalType = 3;
journal1.Journal01 = 0;
journalBLL.Add(journal1);
}
lgk.Model.tb_journal journal = new lgk.Model.tb_journal();
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + jiangjin + "%进入奖金积分";
journal.RemarkEn = "";
journal.InAmount = JJ;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "Emoney");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 1;
journal.Journal01 = 0;
journalBLL.Add(journal);
journal.UserID = BD_UserID;
journal.Remark = "服务网点获得" + (BD + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + zhongzi + "%进入电子积分";
journal.RemarkEn = "";
journal.InAmount = ZZ;
journal.OutAmount = 0;
journal.BalanceAmount = userBLL.GetMoney(BD_UserID, "StockMoney");;
journal.JournalDate = DateTime.Now;
journal.JournalType = 2;
journal.Journal01 = 0;
journalBLL.Add(journal);
SqlConnection conn = new SqlConnection(sconn);
conn.Open();
string sql_Add = "insert into tb_bonus(UserID,TypeID,Amount,Revenue,sf,AddTime,IsSettled,Source,SourceEn,SttleTime,FromUserID,Bonus005,Bonus006)";
sql_Add += "values (" + BD_UserID + ",6," + (BD + shouxufei) + "," + shouxufei + "," + BD + ",getdate(),1,'" + journal.Remark + "','',getdate()," + userid + "," + jiangjin + "," + zhongzi + ");";
SqlCommand cmd = new SqlCommand(sql_Add, conn);
int reInt = cmd.ExecuteNonQuery();
conn.Close();
}
}
////还有运营中心 Yunying1
//if (getParamInt("Yunying") == 1)
//{
// long YY_UserID = long.Parse(orderModel.Order5);
// int isLock = userBLL.GetModel(YY_UserID).IsLock;
// int Ag= agent1BLL.GetIDByIDUser(agent1BLL.GetIDByIDUser(YY_UserID));
// if (isLock==0&&Ag==1)
// {
// decimal YY = getParamAmount("Yunying1") / 100 * totalMoney;
// decimal shouxufei = YY * getParamAmount("PingTai") / 100;
// YY -= shouxufei;
// decimal jiangjin = getParamAmount("JJ");
// decimal zhongzi = getParamAmount("ZZ");
// decimal JJ = YY * jiangjin / 100;
// decimal ZZ = YY * zhongzi / 100;
// UpdateAccount("Emoney", YY_UserID, JJ, 1);//奖金
// UpdateAccount("AllBonusAccount", YY_UserID, ZZ, 1);//种子
// lgk.Model.tb_journal journal = new lgk.Model.tb_journal();
// journal.UserID = YY_UserID;
// journal.Remark = "运营中心奖获得" + (YY + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + jiangjin + "%进入奖金积分";
// journal.RemarkEn = "";
// journal.InAmount = JJ;
// journal.OutAmount = 0;
// journal.BalanceAmount = userBLL.GetMoney(YY_UserID, "Emoney"); ;
// journal.JournalDate = DateTime.Now;
// journal.JournalType = 1;
// journal.Journal01 = 0;
// journalBLL.Add(journal);
// journal.UserID = YY_UserID;
// journal.Remark = "运营中心奖获得" + (YY + shouxufei) + "，其中扣除平台手续费" + shouxufei + "，剩余" + zhongzi + "%进入种子积分";
// journal.RemarkEn = "";
// journal.InAmount = ZZ;
// journal.OutAmount = 0;
// journal.BalanceAmount = userBLL.GetMoney(YY_UserID, "AllBonusAccount"); ;
// journal.JournalDate = DateTime.Now;
// journal.JournalType = 4;
// journal.Journal01 = 0;
// journalBLL.Add(journal);
// SqlConnection conn = new SqlConnection(sconn);
// conn.Open();
// string sql_Add1 = "insert into tb_bonus(UserID,TypeID,Amount,Revenue,sf,AddTime,IsSettled,Source,SourceEn,SttleTime,FromUserID,Bonus005,Bonus006)";
// sql_Add1 += "values (" + YY_UserID + ",5," + (YY + shouxufei) + "," + shouxufei + "," + YY + ",getdate(),1,'" + journal.Remark + "','',getdate()," + userid + "," + jiangjin + "," + zhongzi + ");";
// SqlCommand cmd = new SqlCommand(sql_Add1, conn);
// int reInt1 = cmd.ExecuteNonQuery();
// conn.Close();
// }
//}
//用户账户更新
//MySQL(string.Format(" exec proc_Fenxiangjiang "+ orderModel.UserID+ ","+ orderModel.OrderTotal+ "" ));
//MySQL(string.Format(" exec proc_Yejijiang " + orderModel.UserID + "," + orderModel.OrderTotal + ""));
//MySQL(string.Format(" exec proc_YejiUp " + orderModel.UserID + "," + orderModel.OrderTotal + ""));
Response.Write("<script>alert('收货成功');location.href='OrderList.aspx';</script>");
return;
//ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('收货成功!');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('收货失败!');", true);
return;
}
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('此订单记录不存在!');", true);
return;
}
}
}
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);
}
}
