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("您还没有检验会员数据，请先检验数据");
}
}
}