| | |
| | | { |
| | | input.Keyword = input.Keyword?.Trim(); |
| | | var query = _fBS_CustomerRep.AsQueryable() |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Keyword), u => u.Account.Contains(input.Keyword) || u.RealName.Contains(input.Keyword) || u.NickName.Contains(input.Keyword) || u.IdCardPath.Contains(input.Keyword) || u.College.Contains(input.Keyword) || u.OfficePhone.Contains(input.Keyword) || u.EmergencyContact.Contains(input.Keyword) || u.EmergencyPhone.Contains(input.Keyword) || u.EmergencyAddress.Contains(input.Keyword) || u.Introduction.Contains(input.Keyword) || u.Remark.Contains(input.Keyword) || u.PosLevel.Contains(input.Keyword) || u.PosTitle.Contains(input.Keyword)) |
| | | //.WhereIF(!string.IsNullOrWhiteSpace(input.Keyword), u => u.Account.Contains(input.Keyword) || u.RealName.Contains(input.Keyword) || u.NickName.Contains(input.Keyword) || u.IdCardPath.Contains(input.Keyword) || u.College.Contains(input.Keyword) || u.OfficePhone.Contains(input.Keyword) || u.EmergencyContact.Contains(input.Keyword) || u.EmergencyPhone.Contains(input.Keyword) || u.EmergencyAddress.Contains(input.Keyword) || u.Introduction.Contains(input.Keyword) || u.Remark.Contains(input.Keyword) || u.PosLevel.Contains(input.Keyword) || u.PosTitle.Contains(input.Keyword)) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Account), u => u.Account.Contains(input.Account.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.RealName), u => u.RealName.Contains(input.RealName.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.NickName), u => u.NickName.Contains(input.NickName.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.IdCardPath), u => u.IdCardPath.Contains(input.IdCardPath.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.College), u => u.College.Contains(input.College.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.OfficePhone), u => u.OfficePhone.Contains(input.OfficePhone.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.EmergencyContact), u => u.EmergencyContact.Contains(input.EmergencyContact.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.EmergencyPhone), u => u.EmergencyPhone.Contains(input.EmergencyPhone.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.EmergencyAddress), u => u.EmergencyAddress.Contains(input.EmergencyAddress.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Introduction), u => u.Introduction.Contains(input.Introduction.Trim())) |
| | | //.WhereIF(!string.IsNullOrWhiteSpace(input.IdCardPath), u => u.IdCardPath.Contains(input.IdCardPath.Trim())) |
| | | //.WhereIF(!string.IsNullOrWhiteSpace(input.College), u => u.College.Contains(input.College.Trim())) |
| | | //.WhereIF(!string.IsNullOrWhiteSpace(input.OfficePhone), u => u.OfficePhone.Contains(input.OfficePhone.Trim())) |
| | | //.WhereIF(!string.IsNullOrWhiteSpace(input.EmergencyContact), u => u.EmergencyContact.Contains(input.EmergencyContact.Trim())) |
| | | //.WhereIF(!string.IsNullOrWhiteSpace(input.EmergencyPhone), u => u.EmergencyPhone.Contains(input.EmergencyPhone.Trim())) |
| | | //.WhereIF(!string.IsNullOrWhiteSpace(input.EmergencyAddress), u => u.EmergencyAddress.Contains(input.EmergencyAddress.Trim())) |
| | | //.WhereIF(!string.IsNullOrWhiteSpace(input.Introduction), u => u.Introduction.Contains(input.Introduction.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Remark), u => u.Remark.Contains(input.Remark.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.PosLevel), u => u.PosLevel.Contains(input.PosLevel.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.PosTitle), u => u.PosTitle.Contains(input.PosTitle.Trim())) |
| | | .WhereIF(input.CardType.HasValue, u => u.CardType == input.CardType) |
| | | .WhereIF(input.CultureLevel.HasValue, u => u.CultureLevel == input.CultureLevel) |
| | | .WhereIF(input.OrderNo != null, u => u.OrderNo == input.OrderNo) |
| | | //.WhereIF(!string.IsNullOrWhiteSpace(input.PosLevel), u => u.PosLevel.Contains(input.PosLevel.Trim())) |
| | | //.WhereIF(!string.IsNullOrWhiteSpace(input.PosTitle), u => u.PosTitle.Contains(input.PosTitle.Trim())) |
| | | //.WhereIF(input.CardType.HasValue, u => u.CardType == input.CardType) |
| | | //.WhereIF(input.CultureLevel.HasValue, u => u.CultureLevel == input.CultureLevel) |
| | | //.WhereIF(input.OrderNo != null, u => u.OrderNo == input.OrderNo) |
| | | .WhereIF(input.Status.HasValue, u => u.Status == input.Status) |
| | | .Select<FBS_CustomerOutput>(); |
| | | return await query.OrderBuilder(input).ToPagedListAsync(input.Page, input.PageSize); |
| | |
| | | var entity = input.Adapt<FBS_Customer>(); |
| | | await _fBS_CustomerRep.AsUpdateable(entity) |
| | | .IgnoreColumns(u => new { |
| | | u.Expertise, |
| | | u.OfficeZone, |
| | | u.Office, |
| | | u.JoinDate, |
| | | //u.Expertise, |
| | | //u.OfficeZone, |
| | | //u.Office, |
| | | //u.JoinDate, |
| | | u.LastLoginIp, |
| | | u.LastLoginAddress, |
| | | u.LastLoginTime, |
| | |
| | | .SplitError(it => it.Item.RealName?.Length > 32, "真实姓名长度不能超过32个字符") |
| | | .SplitError(it => it.Item.NickName?.Length > 32, "昵称长度不能超过32个字符") |
| | | .SplitError(it => it.Item.Avatar?.Length > 512, "头像长度不能超过512个字符") |
| | | .SplitError(it => it.Item.Nation?.Length > 32, "民族长度不能超过32个字符") |
| | | //.SplitError(it => it.Item.Nation?.Length > 32, "民族长度不能超过32个字符") |
| | | .SplitError(it => it.Item.Phone?.Length > 16, "手机号码长度不能超过16个字符") |
| | | .SplitError(it => it.Item.IdCardNum?.Length > 32, "身份证号长度不能超过32个字符") |
| | | .SplitError(it => it.Item.IdCardPath?.Length > 512, "身份证长度不能超过512个字符") |
| | | //.SplitError(it => it.Item.IdCardNum?.Length > 32, "身份证号长度不能超过32个字符") |
| | | //.SplitError(it => it.Item.IdCardPath?.Length > 512, "身份证长度不能超过512个字符") |
| | | .SplitError(it => it.Item.Email?.Length > 64, "邮箱长度不能超过64个字符") |
| | | .SplitError(it => it.Item.Address?.Length > 256, "地址长度不能超过256个字符") |
| | | .SplitError(it => it.Item.PoliticalOutlook?.Length > 16, "政治面貌长度不能超过16个字符") |
| | | .SplitError(it => it.Item.College?.Length > 128, "毕业院校长度不能超过128个字符") |
| | | .SplitError(it => it.Item.OfficePhone?.Length > 16, "办公电话长度不能超过16个字符") |
| | | .SplitError(it => it.Item.EmergencyContact?.Length > 32, "紧急联系人长度不能超过32个字符") |
| | | .SplitError(it => it.Item.EmergencyPhone?.Length > 16, "紧急联系人电话长度不能超过16个字符") |
| | | .SplitError(it => it.Item.EmergencyAddress?.Length > 256, "紧急联系人地址长度不能超过256个字符") |
| | | .SplitError(it => it.Item.Introduction?.Length > 512, "个人简介长度不能超过512个字符") |
| | | //.SplitError(it => it.Item.Address?.Length > 256, "地址长度不能超过256个字符") |
| | | //.SplitError(it => it.Item.PoliticalOutlook?.Length > 16, "政治面貌长度不能超过16个字符") |
| | | //.SplitError(it => it.Item.College?.Length > 128, "毕业院校长度不能超过128个字符") |
| | | //.SplitError(it => it.Item.OfficePhone?.Length > 16, "办公电话长度不能超过16个字符") |
| | | //.SplitError(it => it.Item.EmergencyContact?.Length > 32, "紧急联系人长度不能超过32个字符") |
| | | //.SplitError(it => it.Item.EmergencyPhone?.Length > 16, "紧急联系人电话长度不能超过16个字符") |
| | | //.SplitError(it => it.Item.EmergencyAddress?.Length > 256, "紧急联系人地址长度不能超过256个字符") |
| | | //.SplitError(it => it.Item.Introduction?.Length > 512, "个人简介长度不能超过512个字符") |
| | | .SplitError(it => it.Item.Remark?.Length > 256, "备注长度不能超过256个字符") |
| | | .SplitError(it => it.Item.PosLevel?.Length > 32, "职级长度不能超过32个字符") |
| | | .SplitError(it => it.Item.PosTitle?.Length > 32, "职称长度不能超过32个字符") |
| | | //.SplitError(it => it.Item.PosLevel?.Length > 32, "职级长度不能超过32个字符") |
| | | //.SplitError(it => it.Item.PosTitle?.Length > 32, "职称长度不能超过32个字符") |
| | | .SplitInsert(_ => true) |
| | | .ToStorage(); |
| | | |