protected void btnMemCheck_Click(object sender, EventArgs e) { lock (DataExcelIn._syncObj) { string strUploadPath = this.fileUploadMem.FileName; this.strSavePath = base.Server.MapPath("~/Upload/Members/Members" + DateTime.Now.ToString("yyMMddHHmmssffff") + ".xls"); this.strPath.Value = this.strSavePath; if (strUploadPath == "") { base.OutputWarn("请先选择Excel文件。"); } else { string strFileFix = Path.GetExtension(strUploadPath).ToLower(); if (strFileFix != ".xls") { base.OutputWarn("选择文件的文件格式错误,请重新选择Excel文件。"); } else { if (!Directory.Exists(base.Server.MapPath("~/Upload/Members"))) { Directory.CreateDirectory(base.Server.MapPath("~/Upload/Members")); } if (File.Exists(this.strSavePath)) { File.Delete(this.strSavePath); } this.fileUploadMem.PostedFile.SaveAs(this.strSavePath); } if (File.Exists(this.strSavePath)) { string err = ""; DataTable dtMem = DataExcelInfo.CheckMemDataExcel(this.strSavePath, ref err); if (!string.IsNullOrEmpty(err)) { File.Delete(this.strSavePath); base.OutputWarn(err); } else { DataTable dtMemCopy = this.CheckData(dtMem); this.Get_ParameterList(dtMemCopy); if (dtMemCopy.Rows.Count <= 0 && dtMem.Rows.Count > 0) { this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "message", "<Script Language='JavaScript' defer>art.dialog({title: '系统提示',time: 2,content:'您提交的会员数据检验通过,请导入会员数据。',close: function () { }});</script>"); this.bolMainIndex = true; } else { File.Delete(this.strSavePath); } } } else { File.Delete(this.strSavePath); base.OutputWarn("会员数据有错误,请改正。"); } } } }
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("您还没有检验会员数据,请先检验数据"); } } }