public JsonResult InsertOrUpdate(Tenants input)
{
ResultDto <long> result = new ResultDto <long>();
try
{
using (TenantsService Tenant = new TenantsService())
{
if (input.Id == 0)
{
input.CreationTime = DateTime.Now;
input.SecretKey = Guid.NewGuid();
}
Tenant.Reposity.InsertOrUpdate(input);
result.code = 100;
result.message = "ok";
result.datas = input.Id;
}
}
catch (Exception ex)
{
result.code = 500;
result.message = ex.Message;
}
return(Json(result));
}
public ActionResult Index()
{
AdminWithTenant models = new AdminWithTenant();
if (AdminId > 0)
{
using (AdminsService admin = new AdminsService())
{
var model = admin.Reposity.Get(AdminId);
models.Admin = Mapper.Map <AdminDto>(model);
}
using (TenantsService tenantS = new TenantsService())
{
var model = tenantS.Reposity.Get(TenantId);
if (model != null)
{
models.Tenant = Mapper.Map <TenantDto>(model);
}
else
{
models.Tenant = new TenantDto()
{
TenantName = "暂无站点",
Id = 0
};
}
}
}
return(View(models));
}
public async Task EditShouldSucceed()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(databaseName: "EditTenantsTestDb").Options;
using var dbContext = new ApplicationDbContext(options);
var tenantId = 5;
var tenantName = "Ivan Ivanov";
dbContext.Tenants.Add(new Tenant()
{
Id = tenantId,
Name = tenantName,
});
await dbContext.SaveChangesAsync();
using var tenantRepository = new EfDeletableEntityRepository <Tenant>(dbContext);
using var propertyRepository = new EfDeletableEntityRepository <Property>(dbContext);
var tenantService = new TenantsService(tenantRepository, propertyRepository);
var editedName = "Petar Petrov";
var model = new EditTenantsViewModel()
{
Name = editedName,
};
var tenant = tenantService.EditAsync(tenantId, model);
var editedTenant = dbContext.Tenants.FirstOrDefault(t => t.Id == tenantId);
Assert.NotNull(editedTenant);
Assert.Equal(editedName, editedTenant.Name);
}
public JsonResult GetLists(int page, int pageSize)
{
TenantsService Tenant = new TenantsService();
var result = Tenant.Reposity.GetPageList(page, pageSize);
var lists = Mapper.Map <ResultDto <List <Dto.TenantDto> > >(result);
return(Json(lists));
}
public BaseController()
{
tenant = new Tenants();
try {
TenantsService tenantS = new TenantsService();
tenant = tenantS.Reposity.GetAllList(o => o.SecretKey == new Guid(AppSecretKey)).FirstOrDefault();
tenantS.Dispose();
GetMemberCookie();
} catch { }
}
public JsonResult SwitchTenant(int tenantId)
{
using (TenantsService tenantS = new TenantsService())
{
var tenant = tenantS.Reposity.Get(tenantId);
if (tenant != null)
{
AppBase.SetCookie("TenantId", tenantId.ToString(), 1);
}
return(Json(tenant));
}
}
public JsonResult GetModel(int id)
{
Tenants model = new Tenants();
TenantsService Tenant = new TenantsService();
var result = Tenant.Reposity.FirstOrDefault(id);
if (result != null)
{
model = result;
}
return(Json(model));
}
public JsonResult Del(int id)
{
Studio.Dto.ResultDto <string> result = new Studio.Dto.ResultDto <string>();
try
{
TenantsService Tenant = new TenantsService();
Tenant.Reposity.Delete(id);
result.code = 100;
result.message = "success";
}
catch (Exception ex)
{
result.message = ex.Message;
}
return(Json(result));
}
public async Task GetCountShouldReturnCorrectNumberUsingDbContext()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(databaseName: "TenantsTestDb").Options;
using var dbContext = new ApplicationDbContext(options);
dbContext.Tenants.Add(new Tenant());
dbContext.Tenants.Add(new Tenant());
dbContext.Tenants.Add(new Tenant());
await dbContext.SaveChangesAsync();
using var tenantRepository = new EfDeletableEntityRepository <Tenant>(dbContext);
using var propertyRepository = new EfDeletableEntityRepository <Property>(dbContext);
var service = new TenantsService(tenantRepository, propertyRepository);
Assert.Equal(3, service.GetCount());
}
private void FormLogin_Load(object sender, EventArgs e)
{
try
{
this.Text = ProductName + " v" + ProductVersion;
using (TenantsService objserv = new TenantsService())
{
var list = objserv.Reposity.GetAllList();
comboBoxTenant.DataSource = list.Select(o => new { o.TenantName, o.Id }).ToList();
comboBoxTenant.DisplayMember = "TenantName";
comboBoxTenant.ValueMember = "Id";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public JsonResult GetListsByAdmin()
{
ResultDto <List <Dto.TenantDto> > lists = new ResultDto <List <Dto.TenantDto> >();
AdminsService adminServ = new AdminsService();
var admin = adminServ.Reposity.Get(AdminId);
if (admin != null && admin.ControlTenants != null)
{
List <int> tenantIds = new List <int>();
foreach (var item in admin.ControlTenants.Split(','))
{
tenantIds.Add(int.Parse(item));
}
TenantsService Tenant = new TenantsService();
var result = Tenant.Reposity.GetPageList(1, 0, (o => tenantIds.Contains(o.Id)));
lists = Mapper.Map <ResultDto <List <Dto.TenantDto> > >(result);
if (TenantId == 0 && tenantIds.Count > 0)
{
AppBase.SetCookie("TenantId", tenantIds.First().ToString(), 1);
}
}
return(Json(lists));
}
public async Task CreateShouldSucceed()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(databaseName: "CreateTenantsTestDb").Options;
using var dbContext = new ApplicationDbContext(options);
using var tenantRepository = new EfDeletableEntityRepository <Tenant>(dbContext);
using var propertyRepository = new EfDeletableEntityRepository <Property>(dbContext);
var tenantsService = new TenantsService(tenantRepository, propertyRepository);
var model = new CreateTenantsViewModel()
{
Name = "Peter",
Rate = 1800,
LeasePeriod = 12,
};
await tenantsService.CreateAsync(model);
var createdModel = dbContext.Tenants.FirstOrDefault(p => p.Name == "Peter");
Assert.NotNull(createdModel);
}
public JsonResult GetTenantsType()
{
return(Json(TenantsService.GetTenantsType().ToList <TenantTypeModel>(), JsonRequestBehavior.AllowGet));
}
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));
}
public UsersTenantServiceTests() : base()
{
usersTenantService = GetService <UsersTenantService>();
rolesService = GetService <RolesService>();
tenantsService = GetService <TenantsService>();
}
public JsonResult GetModelWithSelect(int id)
{
AdminWithSelect result = new AdminWithSelect();
AdminsService AdminServ = new AdminsService();
var model = AdminServ.Reposity.FirstOrDefault(id);
if (model == null)
{
model = new Admins();
}
result.Admin = model;
List <int> tenantIds = new List <int>();
if (model.ControlTenants != null)
{
foreach (var item in model.ControlTenants.Split(','))
{
tenantIds.Add(int.Parse(item));
}
}
List <int> powers = new List <int>();
if (model.Powers != null)
{
foreach (var item in model.Powers.Split(','))
{
powers.Add(int.Parse(item));
}
}
TenantsService TenServ = new TenantsService();
var tenants = TenServ.Reposity.GetAllList();
List <TenantSelect> TenantList = new List <TenantSelect>();
foreach (var item in tenants)
{
TenantSelect obj = new TenantSelect();
obj.Id = item.Id;
obj.selected = tenantIds.Contains(item.Id);
obj.TenantName = item.TenantName;
TenantList.Add(obj);
}
result.Tenants = TenantList;
CategoriesService CateServ = new CategoriesService();
var Powers = CateServ.Reposity.GetAllList(o => o.Layout == "Powers");
List <CategorySelect> PowerList = new List <CategorySelect>();
foreach (var item in Powers)
{
CategorySelect obj = new CategorySelect();
obj.Id = item.Id;
obj.selected = powers.Contains(item.Id);
obj.CategoryName = item.CategoryName;
PowerList.Add(obj);
}
result.Powers = PowerList;
AdminServ.Dispose();
TenServ.Dispose();
CateServ.Dispose();
return(Json(result));
}
public JsonResult Edit(TenantModel tenant)
{
TenantsService.UpdateTenant(tenant);
return(Json(new { Status = "OK" }, JsonRequestBehavior.AllowGet));
}
public TenantServiceTests() : base()
{
tenantsService = GetService <TenantsService>();
}
public TenantsController(TenantsService configTenantService) : base(configTenantService)
{
_service = configTenantService;
}
