public ActionResult GetFormDataByUserID(int?keyValue)
{
dm_user_relationEntity data = dM_UserRelationIBLL.GetEntityByUserID(keyValue);
return(Success(data));
}
public ActionResult SaveForm(int?keyValue, dm_user_relationEntity entity)
{
dM_UserRelationIBLL.SaveEntity(keyValue, entity);
return(Success("保存成功！"));
}
public ActionResult ExecuteImportExcel(string templateId, string fileId, int chunks, string ext)
{
string path = annexesFileIBLL.SaveAnnexes(fileId, fileId + "." + ext, chunks);
if (!string.IsNullOrEmpty(path))
{
DataTable dt = ExcelHelper.ExcelImport(path);
dm_user_relationEntity dm_User_RelationEntity = new dm_user_relationEntity();
if (templateId == "a21c6d88-16bf-489d-a019-96047431f0b4")
{
int snum = 0;
int fnum = 0;
DataTable failDt = new DataTable();
dt.Columns.Add("导入错误", typeof(string));
foreach (DataColumn dc in dt.Columns)
{
failDt.Columns.Add(dc.ColumnName, dc.DataType);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dataRow = dt.Rows[i];
if (dataRow[0].IsEmpty())
{
continue;
}
string Phone = dataRow[0].ToString(); //手机号
string RealName = ConvertEmpty(dataRow[1]); //真实姓名
string NickName = ConvertEmpty(dataRow[2]); //用户昵称
string CardNo = ConvertEmpty(dataRow[3]); //身份证号
string UserLevel = ConvertEmpty(dataRow[4]); //用户等级
string InviteCode = ConvertEmpty(dataRow[5]); //邀请码
string Province = ConvertEmpty(dataRow[6]); //省份
string City = ConvertEmpty(dataRow[7]); //城市
string Down = ConvertEmpty(dataRow[8]); //区域
string DetailAddress = ConvertEmpty(dataRow[9]); //详细地址
string WeChat = ConvertEmpty(dataRow[10]); //微信号
string IntegralNum = ConvertEmpty(dataRow[11]); //积分数量
int? partner_id = 0;
dm_userEntity dm_UserEntity = dm_UserBLL.GetEntityByInviteCode(InviteCode, ref dm_User_RelationEntity);
if (!dm_UserEntity.IsEmpty() && !dm_User_RelationEntity.IsEmpty())
{
if (dm_UserEntity.partnersstatus == 2)
{
partner_id = dm_UserEntity.partners;//如果邀请码对应的用户是合伙人 则合伙人编号直接用该用户的
}
else
{
partner_id = dm_User_RelationEntity.partners_id;//如果上级非合伙人则继承上级合伙人
}
UserInfo userInfo = LoginUserInfo.Get();
if (dm_UserBLL.ImportUserInfo(userInfo.companyId, Phone, RealName, NickName, CardNo, UserLevel, Province, City, Down, DetailAddress, WeChat, dm_UserEntity.id.ToString(), dm_UserEntity.nickname, partner_id.ToString(), IntegralNum))
{
snum++;
}
else
{
fnum++;
failDt.Rows.Add(dataRow.ItemArray);
}
}
else
{
continue;
}
}
#region 用户导入成功之后修复没有邀请码的用户
dm_UserBLL.BatchGeneralInviteCode();
#endregion
var data = new
{
Success = snum,
Fail = fnum
};
// 写入缓存如果有未导入的数据
if (failDt.Rows.Count > 0)
{
string errordt = failDt.ToJson();
cache.Write <string>(cacheKey + fileId, errordt, CacheId.excel);
}
return(Success(data));
}
else
{
string res = excelImportIBLL.ImportTable(templateId, fileId, dt);
var data = new
{
Success = res.Split('|')[0],
Fail = res.Split('|')[1]
};
return(Success(data));
}
}
else
{
return(Fail("导入数据失败!"));
}
}
