public FileResult ExportExcel(string keywords = "")
{
HSSFWorkbook book = new HSSFWorkbook();
ISheet sheet1 = book.CreateSheet("Sheet1");
MembersService ShipServ = new MembersService();
var DataLists = ShipServ.Reposity.GetAllList();
IRow rowhead = sheet1.CreateRow(0);
string[] colums = ("编号|姓名|关系|性别|民族|出生年月|年龄|楼盘|单元|门牌号|身份证号|现户籍地址|原户籍地址|是否兴塘社区户籍|服务处所|职务|联系电话1|联系电话2|政治面貌|党员所在支部|是否楼道组长|是否户代表|是否居民代表|是否居民组长|是否愿意参加公益|是否愿意从事居民事务|调查时间|特长备注").Split('|');
for (int i = 0; i < colums.Length; i++)
{
rowhead.CreateCell(i).SetCellValue(colums[i]);
}
int RowNum = 0;
foreach (var item in DataLists)
{
IRow row = sheet1.CreateRow(RowNum + 1);
row.CreateCell(0).SetCellValue(RowNum + 1);
row.CreateCell(1).SetCellValue(item.TrueName);
row.CreateCell(2).SetCellValue(item.Relations);
row.CreateCell(3).SetCellValue(item.Sex);
row.CreateCell(4).SetCellValue(item.Nation);
row.CreateCell(5).SetCellValue(item.Birthday);
row.CreateCell(6).SetCellValue(item.Age);
row.CreateCell(7).SetCellValue(item.Apartment);
row.CreateCell(8).SetCellValue(item.UnitNum);
row.CreateCell(9).SetCellValue(item.DoorCard);
row.CreateCell(10).SetCellValue(item.UserID);
row.CreateCell(11).SetCellValue(item.Address);
row.CreateCell(12).SetCellValue(item.Address2);
row.CreateCell(13).SetCellValue(item.HhdRegister);
row.CreateCell(14).SetCellValue(item.ServiceAddr);
row.CreateCell(15).SetCellValue(item.Duties);
row.CreateCell(16).SetCellValue(item.Phone);
row.CreateCell(17).SetCellValue(item.Phone2);
row.CreateCell(18).SetCellValue(item.PoliticalRole);
row.CreateCell(19).SetCellValue(item.PartyBranch);
row.CreateCell(20).SetCellValue(item.CorridorLeader);
row.CreateCell(21).SetCellValue(item.HouseLeader);
row.CreateCell(22).SetCellValue(item.ResidentRepresentative);
row.CreateCell(23).SetCellValue(item.ResidentLeader);
row.CreateCell(24).SetCellValue(item.Pipwa);
row.CreateCell(25).SetCellValue(item.Eira);
row.CreateCell(26).SetCellValue(item.CreationTime.ToString());
row.CreateCell(27).SetCellValue(item.Speciality);
RowNum++;
}
MemoryStream ms = new MemoryStream();
book.Write(ms);
ms.Seek(0, SeekOrigin.Begin);
ShipServ.Dispose();
return(File(ms, "application/vnd.ms-excel", "Members" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls"));
}
public JsonResult GetMemberList()
{
MembersService ObjServ = new MembersService();
var result = ObjServ.Reposity.GetPageList(1, 8, o => o.TenantId == tenant.Id);
result.datas = result.datas.OrderByDescending(o => o.CreationTime).ToList();
ObjServ.Dispose();
return(Json(result));
}
public JsonResult DoRegist(Core.Members input)
{
ResultDto <int> result = new ResultDto <int>();
try
{
MembersService ObjServ = new MembersService();
var item1 = ObjServ.Reposity.GetAllList(o => o.UserName == input.UserName).Count();
var item2 = ObjServ.Reposity.GetAllList(o => o.Mobile == input.Mobile && o.Mobile != null).Count();
var item3 = ObjServ.Reposity.GetAllList(o => o.UserID == input.UserID && o.UserID != "00").Count();
if (item1 > 0)
{
result.code = 500;
result.message = "用户名已经存在";
}
else if (item2 > 0)
{
result.code = 500;
result.message = "手机号已经存在";
}
else if (item3 > 0)
{
result.code = 500;
result.message = "身份证号已经存在";
}
else if (input.Phone2 != Session["VeryCode"].ToString())
{
result.code = 500;
result.message = "手机验证码错误";
}
else
{
Random rand = new Random();
int rank = rand.Next(1, 8);
input.Photo = "/Content/dist/img/user" + rank.ToString() + ".jpg";
input.Password = MD5(input.Password);
input.CreationTime = DateTime.Now;
input.TenantId = tenant.Id;
input.Phone2 = "";
ObjServ.Reposity.Insert(input);
result.code = 100;
result.message = "ok";
}
ObjServ.Dispose();
}
catch (Exception ex)
{
result.code = 500;
result.message = ex.Message;
}
return(Json(result));
}
public JsonResult DoSignIn(long id)
{
ResultDto <int> result = new ResultDto <int>();
try
{
MembersService userServ = new MembersService();
SignUpBespeakService signupServ = new SignUpBespeakService();
var model = signupServ.Reposity.Get(id);
if (model != null)
{
if (!model.SignIn)
{
var user = userServ.Reposity.GetAllList(o => o.Mobile == model.Telphone && o.TenantId == TenantId).FirstOrDefault();
if (user != null)
{
result.code = 100;
result.message = "ok";
user.Points += 10;
userServ.Reposity.Update(user);
model.SignIn = true;
signupServ.Reposity.Update(model);
}
else
{
result.code = 500;
result.message = "签到失败！签到手机号与用户注册手机号不符！";
}
}
else
{
result.code = 500;
result.message = "对不起，已经签到过了！";
}
}
else
{
result.code = 500;
result.message = "签到失败！未找到预约信息！";
}
userServ.Dispose();
signupServ.Dispose();
}
catch (Exception ex)
{
result.code = 500;
result.message = ex.Message;
}
return(Json(result));
}
public JsonResult InsertOrUpdate(Members input)
{
ResultDto <int> result = new ResultDto <int>();
try
{
using (MembersService Member = new MembersService())
{
if (input.Id == 0)
{
input.CreationTime = DateTime.Now;
}
else
{
input.UpdateTime = DateTime.Now;
}
MembersService ObjRead = new MembersService();
var obj = ObjRead.Reposity.GetAllList(o => o.UserID == input.UserID && o.Id != input.Id && o.UserID != "00" && o.UserID != "").FirstOrDefault();
if (obj != null)
{
result.code = 500;
result.message = "身份证号已存在";
}
else
{
input.TenantId = TenantId;
BirthdayAgeSex user = AppBase.GetBirthdayAgeSex(input.UserID);
if (user != null)
{
input.Age = user.Age;
input.Birthday = user.Birthday;
input.Sex = user.Sex;
}
Member.Reposity.InsertOrUpdate(input);
result.code = 100;
result.datas = input.Id;
result.message = "ok";
}
ObjRead.Dispose();
}
}
catch (Exception ex)
{
result.code = 500;
result.message = ex.Message;
}
return(Json(result));
}
public JsonResult GetbackPsw(string UserName, string Mobile, string VeryCode)
{
ResultDto <int> result = new ResultDto <int>();
try
{
MembersService ObjServ = new MembersService();
var model = ObjServ.Reposity.GetAllList(o => o.UserName == UserName).FirstOrDefault();
if (model != null)
{
if (model.Mobile != Mobile)
{
result.code = 500;
result.message = "用户名和手机号码不匹配";
}
else
{
if (VeryCode != Session["VeryCode"].ToString())
{
result.code = 500;
result.message = "验证码输入错误";
}
else
{
var entity = model;
entity.Password = MD5(VeryCode);
ObjServ.Reposity.Update(entity);
result.code = 100;
result.message = "密码已重置为验证码，请妥善保存！";
}
}
}
else
{
result.code = 500;
result.message = "用户不存在";
}
ObjServ.Dispose();
}
catch (Exception ex)
{
result.code = 500;
result.message = ex.Message;
}
return(Json(result));
}
public JsonResult GetMember(int id = 0)
{
Core.Members model = new Core.Members();
MembersService ObjServ = new MembersService();
var result = ObjServ.Reposity.Get(id);
if (result != null)
{
model = result;
}
else
{
model.TenantId = tenant.Id;
}
ObjServ.Dispose();
return(Json(model));
}
public JsonResult Update(Core.Members input)
{
ResultDto <int> result = new ResultDto <int>();
try
{
MembersService ObjServ = new MembersService();
MembersService ObjServRead = new MembersService();
var item1 = ObjServ.Reposity.GetAllList(o => o.UserName == input.UserName && o.Id != MemberId).Count();
var item2 = ObjServ.Reposity.GetAllList(o => o.Mobile == input.Mobile && o.Id != MemberId).Count();
var item3 = ObjServ.Reposity.GetAllList(o => o.UserID == input.UserID && o.Id != MemberId && o.UserID != "00").Count();
if (item1 > 0)
{
result.code = 500;
result.message = "用户名已经存在";
}
else if (item2 > 0)
{
result.code = 500;
result.message = "手机号已经存在";
}
else if (item3 > 0)
{
result.code = 500;
result.message = "身份证号已经存在";
}
else
{
var model = ObjServRead.Reposity.Get(input.Id);
input.Password = model.Password;
input.CreationTime = model.CreationTime;
ObjServ.Reposity.Update(input);
result.code = 100;
result.message = "ok";
}
ObjServ.Dispose();
ObjServRead.Dispose();
}
catch (Exception ex)
{
result.code = 500;
result.message = ex.Message;
}
return(Json(result));
}
public JsonResult Del(int id)
{
ResultDto <string> result = new ResultDto <string>();
try
{
MembersService Member = new MembersService();
Member.Reposity.Delete(id);
result.code = 100;
result.message = "success";
Member.Dispose();
}
catch (Exception ex)
{
result.code = 500;
result.message = ex.Message;
}
return(Json(result));
}
public JsonResult GetModel()
{
Core.Members model = new Core.Members();
MembersService ObjServ = new MembersService();
var result = ObjServ.Reposity.Get(MemberId);
if (result != null)
{
model = result;
}
else
{
model.TenantId = tenant.Id;
}
var entity = Mapper.Map <Dto.MemberDto>(model);
ObjServ.Dispose();
return(Json(model));
}
public JsonResult GetCount()
{
Dto.SiteDto result = new Dto.SiteDto();
ArticlesService ArtServ = new ArticlesService();
MembersService MembServ = new MembersService();
SignUpBespeakService SignServ = new SignUpBespeakService();
ProductsService ProdServ = new ProductsService();
result.ArticleCount = ArtServ.Reposity.GetAllList(o => o.TenantId == TenantId).Count;
result.MemberCount = MembServ.Reposity.GetAllList(o => o.TenantId == TenantId).Count;
result.SignCount = SignServ.Reposity.GetAllList(o => o.TenantId == TenantId).Count;
result.ProductCount = ProdServ.Reposity.GetAllList(o => o.TenantId == TenantId).Count;
ArtServ.Dispose();
MembServ.Dispose();
SignServ.Dispose();
ProdServ.Dispose();
return(Json(result));
}
private ResultDto <List <Dto.MemberOutDto> > GetDatas(int page = 1, int pageSize = 0, string keywords = "", bool IsReger = true, string sort = "", string order = "")
{
ResultDto <List <Dto.MemberOutDto> > result = new ResultDto <List <Dto.MemberOutDto> >();
try
{
ResultDto <List <Members> > items = new ResultDto <List <Members> >();
MembersService Member = new MembersService();
var predicate = PredicateBuilder.True <Members>();
predicate = o => o.TenantId == TenantId && o.IsReger == IsReger;
items = Member.GetListOrderByTime(page, pageSize, predicate, keywords, sort, order);
result = Mapper.Map <ResultDto <List <Dto.MemberOutDto> > >(items);
Member.Dispose();
}
catch (Exception ex)
{
result.code = 500;
result.message = ex.Message;
}
return(result);
}
public JsonResult DoLogin(string UserName, string Password)
{
ResultDto <int> result = new ResultDto <int>();
try
{
MembersService ObjServ = new MembersService();
var model = ObjServ.Reposity.GetAllList(o => o.UserName == UserName || o.UserID == UserName || o.Mobile == UserName || o.Email == UserName).FirstOrDefault();
if (model != null)
{
if (model.Password != MD5(Password))
{
result.code = 500;
result.message = "密码错误";
}
else
{
result.code = 100;
result.message = "ok";
SetCookie("MemberId", model.Id.ToString(), 5);
SetCookie("UserName", model.UserName, 5);
}
}
else
{
result.code = 500;
result.message = "用户不存在";
}
ObjServ.Dispose();
}
catch (Exception ex)
{
result.code = 500;
result.message = ex.Message;
}
return(Json(result));
}
public JsonResult DelPatch(string ids)
{
ResultDto <string> result = new ResultDto <string>();
try
{
MembersService Member = new MembersService();
string[] idarr = ids.Split(',');
foreach (string val in idarr)
{
int id = Convert.ToInt32(val);
Member.Reposity.Delete(id);
}
result.code = 100;
result.message = "success";
Member.Dispose();
}
catch (Exception ex)
{
result.code = 500;
result.message = ex.Message;
}
return(Json(result));
}
private void UploadMember()
{
toolBtnUpload.Enabled = false;
Task.Run(() =>
{
MembersService ObjServ = new MembersService();
MembersService ObjServRead = new MembersService();
errorRow = 0;
compRow = 0;
List <Members> members = new List <Members>();
try
{
members = ObjServRead.Reposity.GetAllList(o => o.TenantId == TenantId);
}
catch (Exception ex)
{
this.BeginInvoke(new Action(() =>
{
textBoxError.Text = "获取数据错误：" + ex.Message + "\r\n";
}));
}
ObjServRead.Dispose();
foreach (DataGridViewRow row in dgvMain.Rows)
{
if (row != null)
{
string userid = row.Cells["身份证号"].Value != null ? row.Cells["身份证号"].Value.ToString() : "";
try
{
var obj = members.Where(o => o.UserID == userid && o.UserID != "0").FirstOrDefault();
if (obj != null)
{
#region update
obj.TrueName = row.Cells["姓名"].Value.ToString();
obj.Relations = row.Cells["关系"].Value.ToString();
obj.Sex = row.Cells["性别"].Value.ToString();
obj.Nation = row.Cells["民族"].Value.ToString();
//obj.Birthday = row.Cells["出生年月"].Value.ToString();
obj.Age = AppBase.CInt(row.Cells["年龄"].Value);
obj.Apartment = row.Cells["楼盘"].Value.ToString();
obj.UnitNum = row.Cells["单元"].Value.ToString();
obj.DoorCard = row.Cells["门牌号"].Value.ToString();
obj.UserID = row.Cells["身份证号"].Value.ToString();
obj.Address = row.Cells["现户籍地址"].Value.ToString();
obj.Address2 = row.Cells["原户籍地址"].Value.ToString();
obj.HhdRegister = row.Cells["是否兴塘社区户籍"].Value.ToString() == "是";
obj.ServiceAddr = row.Cells["服务处所"].Value.ToString();
obj.Duties = row.Cells["职务"].Value.ToString();
obj.Phone = row.Cells["联系电话1"].Value.ToString();
obj.Phone2 = row.Cells["联系电话2"].Value.ToString();
obj.PoliticalRole = row.Cells["政治面貌"].Value.ToString();
obj.PartyBranch = row.Cells["党员所在支部"].Value.ToString();
obj.CorridorLeader = row.Cells["是否楼道组长"].Value.ToString() == "是";
obj.HouseLeader = row.Cells["是否户代表"].Value.ToString() == "是";
obj.ResidentRepresentative = row.Cells["是否居民代表"].Value.ToString() == "是";
obj.ResidentLeader = row.Cells["是否居民组长"].Value.ToString() == "是";
obj.Pipwa = row.Cells["是否愿意参加公益"].Value.ToString() == "是";
obj.Eira = row.Cells["是否愿意从事居民事务"].Value.ToString() == "是";
obj.UpdateTime = DateTime.Now;
obj.Speciality = row.Cells["特长备注"].Value.ToString();
obj.TenantId = TenantId;
obj.Community = Community;
obj.IsReger = false;
ObjServ.Reposity.Update(obj);
#endregion
}
else
{
#region insert
Members entity = new Members();
entity.TrueName = row.Cells["姓名"].Value.ToString();
entity.Relations = row.Cells["关系"].Value.ToString();
entity.Nation = row.Cells["民族"].Value.ToString();
entity.Apartment = row.Cells["楼盘"].Value.ToString();
entity.UnitNum = row.Cells["单元"].Value.ToString();
entity.DoorCard = row.Cells["门牌号"].Value.ToString();
entity.UserID = row.Cells["身份证号"].Value.ToString();
entity.Address = row.Cells["现户籍地址"].Value.ToString();
entity.Address2 = row.Cells["原户籍地址"].Value.ToString();
entity.HhdRegister = row.Cells["是否兴塘社区户籍"].Value.ToString() == "是";
entity.ServiceAddr = row.Cells["服务处所"].Value.ToString();
entity.Duties = row.Cells["职务"].Value.ToString();
entity.Phone = row.Cells["联系电话1"].Value.ToString();
entity.Phone2 = row.Cells["联系电话2"].Value.ToString();
entity.PoliticalRole = row.Cells["政治面貌"].Value.ToString();
entity.PartyBranch = row.Cells["党员所在支部"].Value.ToString();
entity.CorridorLeader = row.Cells["是否楼道组长"].Value.ToString() == "是";
entity.HouseLeader = row.Cells["是否户代表"].Value.ToString() == "是";
entity.ResidentRepresentative = row.Cells["是否居民代表"].Value.ToString() == "是";
entity.ResidentLeader = row.Cells["是否居民组长"].Value.ToString() == "是";
entity.Pipwa = row.Cells["是否愿意参加公益"].Value.ToString() == "是";
entity.Eira = row.Cells["是否愿意从事居民事务"].Value.ToString() == "是";
entity.UpdateTime = DateTime.Now;
entity.Speciality = row.Cells["特长备注"].Value.ToString();
entity.UserName = AppBase.GetRndCode(6);
entity.Password = "******";
entity.Email = "-";
entity.CreationTime = DateTime.Now;
entity.TenantId = TenantId;
entity.Community = Community;
entity.IsReger = false;
BirthdayAgeSex user = AppBase.GetBirthdayAgeSex(entity.UserID);
if (user != null)
{
entity.Age = user.Age;
entity.Birthday = user.Birthday;
entity.Sex = user.Sex;
}
else
{
entity.UserID = "no valid";
}
ObjServ.Reposity.Insert(entity);
#endregion
}
}
catch (Exception ex)
{
errorRow++;
this.BeginInvoke(new Action(() =>
{
textBoxError.Text += "导入[" + userid + "]发生错误：" + ex.Message + " ";
}));
}
compRow++;
this.BeginInvoke(new Action(() =>
{
progressBarM.Value = compRow > progressBarM.Maximum ? progressBarM.Maximum : compRow;
labelCount.Text = "完成：" + progressBarM.Value + "/" + totalRow;
labelError.Text = "错误：" + (errorRow > progressBarM.Maximum ? progressBarM.Maximum : errorRow);
toolBtnUpload.Enabled = progressBarM.Value == totalRow;
if (totalRow == progressBarM.Value)
{
MessageBox.Show("导入完毕！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}));
}
}
ObjServ.Dispose();
});
}
public JsonResult ImportExcel(HttpPostedFileBase file)
{
ResultDto <string> result = new ResultDto <string>();
try
{
if (file == null)
{
result.code = 101;
result.message = "请选择上传的Excel文件";
}
else
{
Stream inputStream = file.InputStream;
HSSFWorkbook hssfworkbook = new HSSFWorkbook(inputStream);
ISheet sheet = hssfworkbook.GetSheetAt(0);
IRow headerRow = sheet.GetRow(0);
int cellCount = headerRow.LastCellNum;
int rowCount = sheet.LastRowNum;
string[] CellArr = ("姓名|关系|性别|民族|年龄|楼盘|单元|门牌号|身份证号|现户籍地址|原户籍地址|是否兴塘社区户籍|服务处所|职务|联系电话1|联系电话2|政治面貌|党员所在支部|是否楼道组长|是否户代表|是否居民代表|是否居民组长|是否愿意参加公益|是否愿意从事居民事务|调查时间|特长备注").Split('|');
bool isValid = true;
foreach (string item in CellArr)
{
ICell cell = headerRow.Cells.Where(o => o.StringCellValue == item).FirstOrDefault();
if (cell == null)
{
result.code = 500;
result.message = "导入出错，缺少必要字段 “" + item + "”！";
isValid = false;
break;
}
}
if (isValid)
{
MembersService ObjServ = new MembersService();
MembersService ObjServRead = new MembersService();
TenantsService ObjTenant = new TenantsService();
string community = "";
var tent = ObjTenant.Reposity.Get(TenantId);
if (tent != null)
{
community = tent.TenantName;
}
string msgs = "";
int nums = 0;
for (int i = (sheet.FirstRowNum + 1); i <= rowCount; i++)
{
IRow row = sheet.GetRow(i);
if (row != null)
{
string userid = CellVal(headerRow, "身份证号", row);
try
{
var obj = ObjServRead.Reposity.GetAllList(o => o.UserID == userid && o.UserID != "0" && o.HhdRegister).FirstOrDefault();
if (obj != null)
{
obj.TrueName = CellVal(headerRow, "姓名", row);
obj.Relations = CellVal(headerRow, "关系", row);
obj.Sex = CellVal(headerRow, "性别", row);
obj.Nation = CellVal(headerRow, "民族", row);
//obj.Birthday = CellVal(headerRow, "出生年月", row);
obj.Age = int.Parse(CellVal(headerRow, "年龄", row));
obj.Apartment = CellVal(headerRow, "楼盘", row);
obj.UnitNum = CellVal(headerRow, "单元", row);
obj.DoorCard = CellVal(headerRow, "门牌号", row);
obj.UserID = CellVal(headerRow, "身份证号", row);
obj.Address = CellVal(headerRow, "现户籍地址", row);
obj.Address2 = CellVal(headerRow, "原户籍地址", row);
obj.HhdRegister = CellVal(headerRow, "是否兴塘社区户籍", row) == "是";
obj.ServiceAddr = CellVal(headerRow, "服务处所", row);
obj.Duties = CellVal(headerRow, "职务", row);
obj.Phone = CellVal(headerRow, "联系电话1", row);
obj.Phone2 = CellVal(headerRow, "联系电话2", row);
obj.PoliticalRole = CellVal(headerRow, "政治面貌", row);
obj.PartyBranch = CellVal(headerRow, "党员所在支部", row);
obj.CorridorLeader = CellVal(headerRow, "是否楼道组长", row) == "是";
obj.HouseLeader = CellVal(headerRow, "是否户代表", row) == "是";
obj.ResidentRepresentative = CellVal(headerRow, "是否居民代表", row) == "是";
obj.ResidentLeader = CellVal(headerRow, "是否居民组长", row) == "是";
obj.Pipwa = CellVal(headerRow, "是否愿意参加公益", row) == "是";
obj.Eira = CellVal(headerRow, "是否愿意从事居民事务", row) == "是";
obj.UpdateTime = DateTime.Now;
obj.Speciality = CellVal(headerRow, "特长备注", row);
obj.TenantId = TenantId;
obj.Community = community;
obj.IsReger = false;
ObjServ.Reposity.Update(obj);
}
else
{
Members entity = new Members();
entity.TrueName = CellVal(headerRow, "姓名", row);
entity.Relations = CellVal(headerRow, "关系", row);
entity.Sex = CellVal(headerRow, "性别", row);
entity.Nation = CellVal(headerRow, "民族", row);
//entity.Birthday = CellVal(headerRow, "出生年月", row);
//entity.Age = int.Parse(CellVal(headerRow, "年龄", row));
entity.Apartment = CellVal(headerRow, "楼盘", row);
entity.UnitNum = CellVal(headerRow, "单元", row);
entity.DoorCard = CellVal(headerRow, "门牌号", row);
entity.UserID = CellVal(headerRow, "身份证号", row);
entity.Address = CellVal(headerRow, "现户籍地址", row);
entity.Address2 = CellVal(headerRow, "原户籍地址", row);
entity.HhdRegister = CellVal(headerRow, "是否兴塘社区户籍", row) == "是";
entity.ServiceAddr = CellVal(headerRow, "服务处所", row);
entity.Duties = CellVal(headerRow, "职务", row);
entity.Phone = CellVal(headerRow, "联系电话1", row);
entity.Phone2 = CellVal(headerRow, "联系电话2", row);
entity.PoliticalRole = CellVal(headerRow, "政治面貌", row);
entity.PartyBranch = CellVal(headerRow, "党员所在支部", row);
entity.CorridorLeader = CellVal(headerRow, "是否楼道组长", row) == "是";
entity.HouseLeader = CellVal(headerRow, "是否户代表", row) == "是";
entity.ResidentRepresentative = CellVal(headerRow, "是否居民代表", row) == "是";
entity.ResidentLeader = CellVal(headerRow, "是否居民组长", row) == "是";
entity.Pipwa = CellVal(headerRow, "是否愿意参加公益", row) == "是";
entity.Eira = CellVal(headerRow, "是否愿意从事居民事务", row) == "是";
entity.UpdateTime = DateTime.Now;
entity.Speciality = CellVal(headerRow, "特长备注", row);
entity.UserName = GetRndCode(6);
entity.Password = "******";
entity.Email = "-";
entity.CreationTime = DateTime.Now;
entity.TenantId = TenantId;
entity.Community = community;
entity.IsReger = false;
BirthdayAgeSex user = AppBase.GetBirthdayAgeSex(entity.UserID);
if (user != null)
{
entity.Age = user.Age;
entity.Birthday = user.Birthday;
entity.Sex = user.Sex;
}
else
{
entity.UserID = "身份证号码不合法";
}
ObjServ.Reposity.Insert(entity);
}
nums++;
}
catch (Exception ex)
{
msgs += userid + "错误：" + ex.Message + "，"; continue;
}
}
}
result.code = 100;
result.message = "上传成功" + nums + "条。发生错误条目：" + msgs;
ObjServ.Dispose();
ObjServRead.Dispose();
ObjTenant.Dispose();
}
}
}
catch (Exception ex)
{
result.code = 101;
result.message = "导入失败，错误原因：" + ex.Message;
}
return(Json(result));
}
