//导入操作
//读取excel文件
public void ReadExcel(string path)
{
//流
using (FileStream fsRead = new FileStream(path, FileMode.Open, FileAccess.Read))
{
List <MemberInfo> list = new List <MemberInfo>();
//获取工作表
IWorkbook wookbook = WorkbookFactory.Create(fsRead);
//获取页
ISheet sheet = wookbook.GetSheetAt(0);
//遍历该页的所有行
for (int i = 0; i <= sheet.LastRowNum; i++)
{
MemberInfo member = new MemberInfo();
//获取行
IRow row = sheet.GetRow(i);
//第一行是id =======0
member.MemName = row.GetCell(1).StringCellValue; //名字
member.MemMobilePhone = row.GetCell(2).StringCellValue; //电话
member.DelFlag = Convert.ToInt32(row.GetCell(3).NumericCellValue); //删除标识 注意转换。把表格数据看成string（实际有string和numeric），不是string的member属性全部要转换
list.Add(member);
//把Excel文件的数据插入到数据库中
}//end for
//循环结束---list集合中有很多会员对象了---传到DAL中
memDal.AddMemberInfo(list);
} //end using
}
/// <summary>
///
/// </summary>
/// <param name="memberInfo">会员对象</param>
/// <param name="flag">标识 1 新增 2修改</param>
/// <returns>成功或者失败</returns>
public bool AddOrUpdateMemberInfo(MemberInfo memberInfo, int flag)
{
if (flag == 1)
{
return(dal.AddMemberInfo(memberInfo) > 0);
}
else if (flag == 2)
{
return(dal.UpdateMemberInfo(memberInfo) > 0);
}
return(false);
}
/// <summary>
/// 保存新增或者修改会员的信息
/// </summary>
/// <param name="mem"></param>
/// <param name="temp">1-> Add; 2-> Modify</param>
/// <returns>成功或者失败</returns>
public bool SaveMemberInfo(MemberInfo mem, int temp)
{
int r = -1;
if (temp == 1)//新增
{
r = dal.AddMemberInfo(mem);
}
else if (temp == 2)//修改
{
r = dal.UpdateMemberInfo(mem);
}
return(r > 0);
}
/// <summary>
///注册会员（已追加注册返还金额功能）
/// </summary>
public string AddMemberInfo(MemberInfoModel model)
{
string result = "1";
string value = SysAdminConfigDAL.GetConfigsByID(4);//得到注册返还金额
#region 验证用户真实姓名 和手机
int rows = MemberInfoDAL.GetMemberCountInfoByName(model.TruethName.Trim());
if (rows > 2)
{
return("0用户姓名重复");
}
rows = MemberInfoDAL.GetMemberCountInfoByMobile(model.MobileNum.Trim());
if (rows > 0)
{
return("0手机号已被注册");
}
//rows = MemberInfoDAL.GetMemberCountInfoByAlipayNum(model.AliPayNum.Trim());
//if (rows > 0)
//{
// return "0支付宝ID已被注册";
//}
rows = MemberInfoDAL.GetMemberCountInfoByAliPayName(model.AliPayName.Trim());
if (rows > 0)
{
return("0支付宝账户已被注册");
}
#endregion
using (TransactionScope scope = new TransactionScope())
{
int memberid = dal.AddMemberInfo(model);
if (memberid < 1)
{
return("0注册失败");
}
decimal amont = 0;
if (!string.IsNullOrWhiteSpace(value))
{
if (!decimal.TryParse(value, out amont))
{
return("0注册失败");
}
int row = MemberCapitalDetailDAL.UpdateMemberStaticFreezeMoney(memberid, amont, model.TruethName, model.MobileNum);
if (row < 1)
{
return("0注册失败");
}
}
//返还激活码金额
AmountChangeLogModel logmodel = new AmountChangeLogModel();
logmodel.MemberID = memberid;
logmodel.MemberName = model.TruethName;
logmodel.MemberPhone = model.MobileNum;
logmodel.ProduceMoney = amont;
logmodel.Remark = "会员注册激活码" + amont.ToString() + "元";
logmodel.Type = 5;
int rowcount = OperateLogDAL.AddAmountChangeLog(logmodel);
if (rowcount < 1)
{
return("0注册失败");
}
if (model.MemberPhone != model.MobileNum)
{
//插入推荐人信息表
MemberInfoModel soucemember = MemberInfoDAL.GetMember(model.MemberPhone);
if (soucemember.MStatus == 3)
{
return("0推荐人账户被冻结");
}
ReMemberRelationModel remodel = new ReMemberRelationModel();
remodel.MemberID = soucemember.ID;
remodel.MemberTruthName = soucemember.TruethName;
remodel.MemberPhone = soucemember.MobileNum;
remodel.RecommMID = memberid;
remodel.RecommMPhone = model.MobileNum;
remodel.RecommMTruthName = model.TruethName;
rowcount = ReMemberRelationDAL.AddReMemberRelation(remodel);
if (rowcount < 1)
{
return("0注册失败");
}
}
//初始化会员扩展信息表
MemberExtendInfoModel extendinfo = new MemberExtendInfoModel();
extendinfo.MemberID = memberid;
extendinfo.MemberHelpCount = 0;
extendinfo.LastHelpMoney = 0;
extendinfo.LastHelperTime = DateTime.Now.AddYears(-1);
rowcount = MemberExtendInfoDAL.AddModelExtendinfo(extendinfo);
if (rowcount < 1)
{
return("0注册失败");
}
scope.Complete();
result = "1";
}
return(result);
}