コード例 #1
0
 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("您还没有检验会员数据,请先检验数据");
         }
     }
 }