private void Membersrecharge(string memid, string total_fee, string jf, string GiveMoney, string out_trade_no, string time_end) { try { int id = int.Parse(memid); int jifen = int.Parse(jf); decimal givemoney = decimal.Parse(GiveMoney); decimal totalfee = decimal.Parse(total_fee) / 100m; time_end = string.Format("{0}-{1}-{2} {3}:{4}:{5}", new object[] { time_end.Substring(0, 4), time_end.Substring(4, 2), time_end.Substring(6, 2), time_end.Substring(8, 2), time_end.Substring(10, 2), time_end.Substring(12, 2) }); DateTime timeend = DateTime.Parse(time_end); Chain.Model.Mem mem = new Chain.Model.Mem(); Chain.BLL.Mem bllMem = new Chain.BLL.Mem(); mem = bllMem.GetModel(id); mem.MemPoint += jifen; mem.MemMoney += totalfee + givemoney; bllMem.Update(mem); Chain.BLL.MemRecharge bllMemRecharge = new Chain.BLL.MemRecharge(); bllMemRecharge.Add(new Chain.Model.MemRecharge { RechargeMemID = id, RechargeAccount = out_trade_no, RechargeMoney = totalfee, RechargeShopID = 1, RechargeUserID = 1, RechargeCreateTime = timeend, RechargeIsApprove = true, RechargeRemark = "会员微信充值", RechargePoint = jifen, RechargeType = 6, RechargeGive = givemoney, RechargeCardBalance = mem.MemMoney }); Chain.Model.MoneyChangeLog moneyChangeLogModel = new Chain.Model.MoneyChangeLog(); moneyChangeLogModel.MoneyChangeMemID = id; moneyChangeLogModel.MoneyChangeUserID = 1; moneyChangeLogModel.MoneyChangeType = 1; moneyChangeLogModel.MoneyChangeAccount = out_trade_no; moneyChangeLogModel.MoneyChangeMoney = totalfee + givemoney; moneyChangeLogModel.MemMoney = mem.MemMoney; moneyChangeLogModel.MoneyChangeCreateTime = timeend; moneyChangeLogModel.MoneyChangeGiveMoney = 0m; new Chain.BLL.MoneyChangeLog().Add(moneyChangeLogModel); if (jifen > 0) { Chain.Model.PointLog mdPoint = new Chain.Model.PointLog(); mdPoint.PointMemID = id; mdPoint.PointNumber = jifen; mdPoint.PointChangeType = 15; mdPoint.PointRemark = string.Concat(new object[] { "会员充值,充值金额:[", totalfee, "],获得积分:[", jifen, "]" }); mdPoint.PointShopID = 1; mdPoint.PointCreateTime = timeend; mdPoint.PointUserID = 1; mdPoint.PointOrderCode = out_trade_no; new Chain.BLL.PointLog().Add(mdPoint); MEMPointUpdate.MEMPointRate(mem, jifen, out_trade_no, 15, 1, 1); PubFunction.UpdateMemLevel(mem); } } catch { return; } base.Response.Write(this.ToXml("SUCCESS", "")); base.Response.End(); }
protected void btnMemImport_Click(object sender, EventArgs e) { lock (DataExcelIn._syncObj) { this.strSavePath = this.strPath.Value; if (File.Exists(this.strSavePath)) { if (this.bolMainIndex) { string errstr = ""; DataTable dtMem = DataExcelInfo.CheckMemDataExcel(this.strSavePath, ref errstr); if (!string.IsNullOrEmpty(errstr)) { File.Delete(this.strSavePath); base.OutputWarn(errstr); } else if (DataExcelInfo.MemImport(dtMem, this.curParameter.bolPwd, this._UserID)) { base.OutputWarn("恭喜您,导入会员成功!"); Chain.BLL.Mem memBll = new Chain.BLL.Mem(); Chain.Model.Mem memModel = new Chain.Model.Mem(); for (int rowIndex = 0; rowIndex < dtMem.Rows.Count; rowIndex++) { decimal memMoney = Convert.ToDecimal(dtMem.Rows[rowIndex]["MemMoney"]); if (memMoney != 0m) { memModel = memBll.GetModelByMemCard(dtMem.Rows[rowIndex]["MemCard"].ToString()); Chain.Model.MoneyChangeLog moneyChangeLogModel = new Chain.Model.MoneyChangeLog(); moneyChangeLogModel.MoneyChangeMemID = memModel.MemID; moneyChangeLogModel.MoneyChangeUserID = this._UserID; moneyChangeLogModel.MoneyChangeType = 6; moneyChangeLogModel.MoneyChangeAccount = ""; moneyChangeLogModel.MoneyChangeMoney = memModel.MemMoney; moneyChangeLogModel.MemMoney = memModel.MemMoney; moneyChangeLogModel.MoneyChangeCreateTime = DateTime.Now; moneyChangeLogModel.MoneyChangeGiveMoney = memModel.MemMoney; new Chain.BLL.MoneyChangeLog().Add(moneyChangeLogModel); Chain.Model.MemRecharge modelRecharge = new Chain.Model.MemRecharge(); modelRecharge.RechargeMemID = memModel.MemID; modelRecharge.RechargeType = 1; modelRecharge.RechargeMoney = 0m; modelRecharge.RechargeGive = memModel.MemMoney; modelRecharge.RechargeRemark = "会员登记赠送金额,初始金额:" + memModel.MemMoney.ToString(); modelRecharge.RechargeShopID = this._UserShopID; modelRecharge.RechargeCreateTime = DateTime.Now; modelRecharge.RechargeAccount = PubFunction.curParameter.strMemRechargePrefix + DateTime.Now.ToString("yyMMddHHmmssffff"); modelRecharge.RechargeUserID = this._UserID; modelRecharge.RechargeCardBalance = memModel.MemMoney; modelRecharge.RechargeIsApprove = true; Chain.BLL.MemRecharge bllRecharge = new Chain.BLL.MemRecharge(); bllRecharge.Add(modelRecharge); } } this.strSavePath = ""; this.bolMainIndex = false; } else { File.Delete(this.strSavePath); base.OutputWarn("导入会员失败,请再次检验并改正会员数据!"); } } else { File.Delete(this.strSavePath); base.OutputWarn("您导入的会员数据还没有检验成功,请通过检验再导入会员数据。"); } } else { base.OutputWarn("您还没有检验会员数据,请先检验数据"); } } }