//public IEnumerable<VW_SJMX> GetSjmx()
//public List<VW_SJMX> GetSjmx()
public dynamic GetSjmx1()
{
// Pages 从 0 开始
dynamic ret = _vwsjmxDapperRepository.GetAllPaged(x => x.器具名称 == "全站仪", 0, 20, "ID").ToDynamicList <dynamic>(); //OK
//IEnumerable<VW_SJMX> ret = _vwsjmxDapperRepository.Query("select top 20 * from VW_SJMX"); //OK
return(ret);
}
public PagedResultDto <VW_CZRZ> GetPagedCzrzs(GetCzrzInput input)
{
Expression <Func <VW_CZRZ, bool> > predicate = p => p.Id > 0;
if (!input.isAdmin)
{
long jdyid = (long)AbpSession.UserId;
predicate = predicate.And(p => p.UserID == jdyid);
}
if (!input.FilterText.IsNullOrWhiteSpace())
{
predicate = predicate.And(p => (p.Surname == input.FilterText || p.CZNR.Contains(input.FilterText)));
}
var totalCount = _czrzDapperRepository.Count(predicate);
IEnumerable <VW_CZRZ> ret = _czrzDapperRepository.GetAllPaged(
predicate,
input.SkipCount / input.MaxResultCount,
input.MaxResultCount,
input.Sorting, input.Order == "desc"); // input.Order=="asc" true/false
List <VW_CZRZ> tempList2 = ObjectMapper.Map <List <VW_CZRZ> >(ret);
return(new PagedResultDto <VW_CZRZ>(
totalCount,
tempList2
));
}
public dynamic GetTestAbpDapper() // 需要设置 SMIC.EntityFrameworkCore\EntityMapper\PersonMapper.cs
{
// Person -> PhoneNumbers
dynamic ret = _personDapperRepository.GetAllPaged(x => x.Address != "SD.JN", 0, 10, "ID").ToDynamicList <dynamic>(); //OK
return(ret);
}
/// <summary>
/// 首页未完成列表
/// JDZT<222
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public PagedResultDto <VW_SJCL_100> GetPagedTasks(GetVwSjmxsInput input)
{
// 数据库里面必须有 SJMX 实体或者视图
Expression <Func <VW_SJCL_100, bool> > predicate = p => p.Id > 0;
if (!input.FilterText.IsNullOrWhiteSpace())
{
predicate = predicate.And(p => (p.DWMC.Contains(input.FilterText) || p.ccbh.Contains(input.FilterText) || p.xhggmc.Contains(input.FilterText) || p.QJMC.Contains(input.FilterText)));
}
predicate = predicate.And(p => p.JDZT < 222);
var totalCount = _vwsjclDapperRepository.Count(predicate);
IEnumerable <VW_SJCL_100> ret = _vwsjclDapperRepository.GetAllPaged(
predicate,
input.SkipCount / input.MaxResultCount,
input.MaxResultCount,
input.Sorting, input.Order == "desc"); // input.Order=="asc" true/false
List <VW_SJCL_100> tempList2 = ObjectMapper.Map <List <VW_SJCL_100> >(ret);
return(new PagedResultDto <VW_SJCL_100>(
totalCount,
tempList2
));
}
public dynamic GetTestAbpDapper() // 需要设置 SMIC.EntityFrameworkCore\EntityMapper\PersonMapper.cs ---> Map(x => x.PhoneNumbers).Ignore();
{
/*
* var a = 0;
* try
* {
* dynamic ret1 = 1 / a;
* }
* catch (System.Exception ex)
* {
* Logger.Error($"{GetType().FullName}:Logger详情测试!{ex}", ex);
* }
*/
// Person -> PhoneNumbers
dynamic ret = _personDapperRepository.GetAllPaged(x => x.Address != "SD.JN", 0, 10, "ID").ToDynamicList <dynamic>(); //OK
return(ret);
}
public PagedResultDto <WTD> GetPagedWtds(GetWtdInput input)
{
// 数据库里面必须有 WTD 实体或者视图
Expression <Func <WTD, bool> > predicate = p => p.Id > 0;
if (!input.FilterText.IsNullOrWhiteSpace())
{
//predicate = predicate.And(p => (p.sjdid==(input.FilterText) || p.dwmc.Contains(input.FilterText)));
predicate = predicate.And(p => (p.sjdid.Contains(input.FilterText) || p.dwmc.Contains(input.FilterText)));
}
var totalCount = _wtdDapperRepository.Count(predicate);
IEnumerable <WTD> ret = _wtdDapperRepository.GetAllPaged(
predicate,
input.SkipCount / input.MaxResultCount,
input.MaxResultCount,
input.Sorting, input.Order == "desc"); // input.Order=="asc" true/false
List <WTD> tempList2 = ObjectMapper.Map <List <WTD> >(ret);
return(new PagedResultDto <WTD>(
totalCount,
tempList2
));
}
/*
* // 待检定列表 - SJCLAppServices/GetPagedDjmxs
* public IEnumerable<SJMX> ListDjmxs(string q)
* {
* string strSQL = @"select top 20 a.id,a.sjdid,qjmc,djrq,xhggmc,b.xhggbm,ccbh,zzcnr as zzc,jdy,a.bzsm,g.jdrq,g.jwrq,f.dwmc as wtdw,DATEADD(day, 14, djrq) as yqjcrq,a.jdzt as jdzt1,
* g.jdzt as jdzt2,e.sjdid as wtdh
* FROM dbo.YQSF_SJMX AS a LEFT JOIN
* dbo.YQSF_SJD as e on a.sjdid = e.id LEFT JOIN
* dbo.YQSF_KH as f on e.khid = f.khid LEFT JOIN
* dbo.JCXX_XHGG_BM AS b ON a.XHGGBM = b.XHGGBM LEFT JOIN
* dbo.JCXX_ZZC_BM AS c ON b.ZZCBM = c.ZZCBM LEFT JOIN
* dbo.JCXX_QJMC_BM AS d ON b.QJMCBM = d.QJMCBM LEFT JOIN
* dbo.SJCL_CHYQ as g on g.id = a.id
* where d.QJMCBM = 1000 and e.djrq > '2019-04-21'"; // 查询searchAll
*
* strSQL += " and g.jdzt is null and a.jdzt<>'检完'"; // 待检:JDZT is null
*
* if (q != "")
* {
* strSQL += " and (ccbh like '%" + q + "%' or xhggmc like '%" + q + "%'";
* strSQL += ")";
* }
*
* IEnumerable<SJMX> ret = _sjmxDapperRepository.Query(strSQL);
* return ret;
* }
*
* public async Task<PagedResultDto<SJMXListDto>> GetPagedSjmxs(GetVwSjmxsInput input)
* {
* Expression<Func<SJMX, bool>> predicate = p => (p.Id != 1);
*
* var totalCount = _sjmxDapperRepository.Count(predicate);
*
*
* var entityList = await _sjmxDapperRepository.GetAll()
* .OrderByDescending(t => t.Id)
* .PageBy(input)
* .ToListAsync();
* var entityListDtos = ObjectMapper.Map<List<SJMXListDto>>(entityList);
*
* return new PagedResultDto<SJMXListDto>(totalCount, entityListDtos);
* }
*/
public PagedResultDto <SJMX> GetPagedSjmxs(GetVwSjmxsInput input)
{
// 数据库里面必须有 SJMX 实体或者视图
// Expression<Func<SJMX, bool>> predicate = p => p.qjmc == "全站仪";
Expression <Func <SJMX, bool> > predicate = p => p.Id > 0;
if (!input.FilterText.IsNullOrWhiteSpace())
{
predicate = predicate.And(p => (p.xhggmc.Contains(input.FilterText) || p.ccbh.Contains(input.FilterText) || p.wtdh.Contains(input.FilterText) || p.wtdw.Contains(input.FilterText)));
}
var totalCount = _sjmxDapperRepository.Count(predicate);
IEnumerable <SJMX> ret = _sjmxDapperRepository.GetAllPaged(
predicate,
input.SkipCount / input.MaxResultCount,
input.MaxResultCount,
input.Sorting, input.Order == "desc"); // input.Order=="asc" true/false
List <SJMX> tempList2 = ObjectMapper.Map <List <SJMX> >(ret);
return(new PagedResultDto <SJMX>(
totalCount,
tempList2
));
}
public void DoSomeStuff()
{
try
{
using (IUnitOfWorkCompleteHandle uow = _unitOfWorkManager.Begin())
{
Logger.Debug("Uow Began!");
int persionId1 = _personRepository.InsertAndGetId(new Person("Oğuzhan"));
_personRepository.Insert(new Person("Ekmek"));
int animalId1 = _animalRepository.InsertAndGetId(new Animal("Kuş"));
_animalRepository.Insert(new Animal("Kedi"));
_animalDbContextProvider.GetDbContext().Animals.Add(new Animal("Kelebek"));
_unitOfWorkManager.Current.SaveChanges();
Person personCache = _cacheManager.GetCache(DemoCacheName.Demo).Get("person", () => _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan"));
Person person = _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan");
Animal animal = _animalRepository.FirstOrDefault(x => x.Name == "Kuş");
using (StoveSession.Use(266))
{
_productDapperRepository.Insert(new Product("TShirt1"));
int gomlekId = _productDapperRepository.InsertAndGetId(new Product("Gomlek1"));
Product firstProduct = _productDapperRepository.FirstOrDefault(x => x.Name == "TShirt1");
IEnumerable <Product> products = _productDapperRepository.GetAll();
firstProduct.Name = "Something";
_productDapperRepository.Update(firstProduct);
_mailDapperRepository.Insert(new Mail("New Product Added"));
Guid mailId = _mailDapperRepository.InsertAndGetId(new Mail("Second Product Added"));
IEnumerable <Mail> mails = _mailDapperRepository.GetAll();
Mail firstMail = mails.First();
firstMail.Subject = "Sorry wrong email!";
_mailDapperRepository.Update(firstMail);
}
Animal oneAnimal = _animalDapperRepository.Get(animalId1);
Animal oneAnimalAsync = _animalDapperRepository.GetAsync(animalId1).Result;
Person onePerson = _personDapperRepository.Get(persionId1);
Person onePersonAsync = _personDapperRepository.GetAsync(persionId1).Result;
IEnumerable <Animal> birdsSet = _animalDapperRepository.GetSet(x => x.Name == "Kuş", 0, 10, "Id");
using (_unitOfWorkManager.Current.DisableFilter(StoveDataFilters.SoftDelete))
{
IEnumerable <Person> personFromDapperNotFiltered = _personDapperRepository.GetAll(x => x.Name == "Oğuzhan");
}
IEnumerable <Person> personFromDapperFiltered = _personDapperRepository.GetAll(x => x.Name == "Oğuzhan");
IEnumerable <Animal> birdsFromExpression = _animalDapperRepository.GetSet(x => x.Name == "Kuş", 0, 10, "Id");
IEnumerable <Animal> birdsPagedFromExpression = _animalDapperRepository.GetAllPaged(x => x.Name == "Kuş", 0, 10, "Name");
IEnumerable <Person> personFromDapperExpression = _personDapperRepository.GetAll(x => x.Name.Contains("Oğuzhan"));
int birdCount = _animalDapperRepository.Count(x => x.Name == "Kuş");
var personAnimal = _animalDapperRepository.Query <PersonAnimal>("select Name as PersonName,'Zürafa' as AnimalName from Persons with(nolock) where name=@name", new { name = "Oğuzhan" })
.MapTo <List <PersonAnimalDto> >();
birdsFromExpression.ToList();
birdsPagedFromExpression.ToList();
birdsSet.ToList();
IEnumerable <Person> person2FromDapper = _personDapperRepository.Query("select * from Persons with(nolock) where name =@name", new { name = "Oğuzhan" });
_personDapperRepository.Insert(new Person("oğuzhan2"));
int id = _personDapperRepository.InsertAndGetId(new Person("oğuzhan3"));
Person person3 = _personDapperRepository.Get(id);
person3.Name = "oğuzhan4";
_personDapperRepository.Update(person3);
_personDapperRepository.Delete(person3);
Person person2Cache = _cacheManager.GetCache(DemoCacheName.Demo).Get("person", () => _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan"));
//Person oguzhan = _personRepository.Nolocking(persons => persons.FirstOrDefault(x => x.Name == "Oğuzhan"));
Person oguzhan2 = _personRepository.FirstOrDefault(x => x.Name == "Oğuzhan");
uow.Complete();
_messageBus.Publish <IPersonAddedMessage>(new PersonAddedMessage
{
Name = "Oğuzhan",
CorrelationId = NewId.NextGuid()
});
//_hangfireBackgroundJobManager.EnqueueAsync<SimpleBackgroundJob, SimpleBackgroundJobArgs>(new SimpleBackgroundJobArgs
//{
// Message = "Oğuzhan"
//});
//_hangfireScheduleJobManager.ScheduleAsync<SimpleBackgroundJob, SimpleBackgroundJobArgs>(new SimpleBackgroundJobArgs
//{
// Message = "Oğuzhan"
//}, Cron.Minutely());
Logger.Debug("Uow End!");
}
}
catch (Exception ex)
{
Logger.Error(ex);
throw ex;
}
}
/// <summary>
/// 增加 LastLogintime,Dapper 实现
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public PagedResultDto <AbpUser> GetPagedMemberUsers(PagedMemberUserResultRequestDto input)
{
//var sw = new Stopwatch();
//sw.Start();
//Expression<Func<AbpUser,Role, bool>> predicat = (p,b) => (p.TenantId == null && p.RoleNames );
/*
* _repository -> MemberUser -> 查询记录 from AbpUsers where UserType =1
* user -> UserType =0 也会显示，TenantId = 1 不显示，未启用租户,User 没有 LastLoginTime 的
*/
Expression <Func <AbpUser, bool> > predicate = p => (p.TenantId == null && p.IsDeleted == false);
//if (input.From != null) // DateTime? 会有问题
if (input.From != null && input.From > DateTimeOffset.MinValue)
{
predicate = predicate.And(p => p.CreationTime >= DateTime.Parse(input.From.ToString())); // input.From
}
if (input.To != null && input.To > DateTimeOffset.MinValue) // != null
{
predicate = predicate.And(p => p.CreationTime <= DateTime.Parse(input.To.ToString())); // input.To
}
//if (!input.Filter.IsNullOrWhiteSpace())
//if (!input.Keyword.IsNullOrWhiteSpace())
//{
// predicate = predicate.And(p => p.Name.Contains(input.Keyword));
//}
if (!input.Keyword.IsNullOrWhiteSpace())
{
predicate = predicate.And(p => p.UserName.Contains(input.Keyword));
}
if (input.IsActive != null)
{
predicate = predicate.And(p => p.IsActive == (input.IsActive == "true"));
}
var totalCount = _userRepository.Count(predicate);
IEnumerable <AbpUser> ret = _userRepository.GetAllPaged(
predicate,
input.SkipCount / input.MaxResultCount,
input.MaxResultCount,
input.Sorting, input.Order == "asc"); // input.Order=="asc" true/false
List <AbpUser> tempList = ObjectMapper.Map <List <AbpUser> >(ret);
/*
* List<AbpUser> tempList2 = new List<AbpUser>();
* IEnumerator<AbpUser> currentEnumerator = ret.GetEnumerator();
* if (currentEnumerator != null)
* {
* for (int count = 0; currentEnumerator.MoveNext(); count++)
* {
* //currentEnumerator.Current.RoleNames = GetRoles(currentEnumerator.Current.Id); // conn 嵌套错误,在下面处理
* tempList.Add(currentEnumerator.Current);
* }
* }
*/
// Abp.Dapper 不支持一对多，只能 Dapper 进行
foreach (AbpUser o in tempList)
{
o.RoleNames = GetRoles(o.Id);
//o.QJMCRoleNames = GetQJMCRoleNames(o.RoleNames); // 检定器具名称列表
}
//sw.Stop();
//Logger.Error("耗时:" + sw.ElapsedMilliseconds + (sw.ElapsedMilliseconds > 1000 ? "#####" : string.Empty) + "毫秒\n"); // 可以记录操作
return(new PagedResultDto <AbpUser>(
totalCount,
tempList
));
}
