/// <summary>
/// 获取商家详情
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ResponseMerchant GetMerchantDetail(Guid Id)
{
IQueryable <RepastInfo> queryable = Kily.Set <RepastInfo>().Where(t => t.Id == Id);
var data = queryable.OrderByDescending(t => t.CreateTime).Select(t => new ResponseMerchant()
{
Id = t.Id,
CommunityCode = t.CommunityCode,
Account = t.Account,
PassWord = t.PassWord,
MerchantName = t.MerchantName,
MerchantImage = t.MerchantImage,
CardExpiredDate = t.CardExpiredDate,
SafeOffer = t.SafeOffer,
OfferLv = t.OfferLv,
DiningTypeName = AttrExtension.GetSingleDescription <MerchantEnum, DescriptionAttribute>(t.DiningType),
DingRoleId = t.DingRoleId,
Phone = t.Phone,
Email = t.Email,
TypePath = t.TypePath,
Certification = t.Certification,
ImplUser = t.ImplUser,
AllowUnit = t.AllowUnit,
Honor = t.HonorCertification,
VersionTypeName = AttrExtension.GetSingleDescription <SystemVersionEnum, DescriptionAttribute>(t.VersionType),
AuditInfo = Kily.Set <SystemAudit>()
.Where(x => x.IsDelete == false)
.Where(x => x.TableId == t.Id).Select(x => new ResponseAudit
{
Id = x.Id,
TableId = t.Id,
TabelName = t.GetType().Name,
CreateTime = x.CreateTime,
AuditSuggestion = x.AuditSuggestion,
AuditName = x.AuditName,
CreateUser = x.CreateUser
}).ToList()
}).FirstOrDefault();
return(data);
}
/// <summary>
/// 账号分页
/// </summary>
/// <param name="pageParam"></param>
/// <returns></returns>
public PagedResult <ResponseGovtInfo> GetInfoPage(PageParamList <RequestGovtInfo> pageParam)
{
IQueryable <GovtInfo> queryable = Kily.Set <GovtInfo>().Where(t => t.IsDelete == false);
if (!string.IsNullOrEmpty(pageParam.QueryParam.DepartName))
{
queryable = queryable.Where(t => t.DepartName.Contains(pageParam.QueryParam.DepartName));
}
if (UserInfo().AccountType > AccountEnum.Country)
{
queryable = queryable.Where(t => t.TypePath.Contains(UserInfo().Province) ||
t.TypePath.Contains(UserInfo().City) ||
t.TypePath.Contains(UserInfo().Area));
}
var data = queryable.OrderByDescending(t => t.CreateTime).Select(t => new ResponseGovtInfo()
{
Id = t.Id,
DepartName = t.DepartName,
Account = t.Account,
AccountTypeName = AttrExtension.GetSingleDescription <GovtAccountEnum, DescriptionAttribute>(t.AccountType),
TrueName = t.TrueName,
Phone = t.Phone,
Email = t.Email,
TypePath = t.TypePath
}).ToList();
data.ForEach(t =>
{
t.TableName = Kily.Set <SystemProvince>()
.Where(x => x.Id.ToString() == t.Province)
.Select(x => x.Name).AsNoTracking().FirstOrDefault() + "," +
Kily.Set <SystemCity>()
.Where(x => x.Id.ToString() == t.City)
.Select(x => x.Name).AsNoTracking().FirstOrDefault() + "," +
Kily.Set <SystemArea>()
.Where(x => x.Id.ToString() == t.Area)
.Select(x => x.Name).AsNoTracking().FirstOrDefault();
});
return(data.ToPagedResult(pageParam.pageNumber, pageParam.pageSize));
}
/// <summary>
/// 获取认证详情
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ResponseRepastIdent GetDiningIdentDetail(Guid Id)
{
IQueryable <RepastIdent> queryable = Kily.Set <RepastIdent>().Where(t => t.IsDelete == false);
IQueryable <RepastIdentAttach> queryables = Kily.Set <RepastIdentAttach>().Where(t => t.IsDelete == false);
var data = queryable.GroupJoin(queryables, x => x.Id, p => p.IdentId, (x, t) => new ResponseRepastIdent()
{
IdentNo = x.IdentNo,
MerchantName = x.MerchantName,
IdentStarName = AttrExtension.GetSingleDescription <IdentEnum, DescriptionAttribute>(x.IdentStar),
AuditTypeName = AttrExtension.GetSingleDescription <AuditEnum, DescriptionAttribute>(x.AuditType),
DiningTypeName = AttrExtension.GetSingleDescription <MerchantEnum, DescriptionAttribute>(x.DiningType),
IdentYear = x.IdentYear,
CommunityCode = x.CommunityCode,
Representative = x.Representative,
RepresentativeCard = x.RepresentativeCard,
SendPerson = x.SendPerson,
SendCard = x.SendCard,
LinkPhone = x.LinkPhone,
Remark = x.Remark,
IdentStartTime = x.IdentStartTime,
IdentEndTime = x.IdentEndTime,
ImgCard = t.FirstOrDefault().ImgCard,
ImgApply = t.FirstOrDefault().ImgApply,
ImgResearch = t.FirstOrDefault().ImgResearch,
ImgAgreement = t.FirstOrDefault().ImgAgreement,
ImgMaterialOrder = t.FirstOrDefault().ImgMaterialOrder,
ImgDisinfection = t.FirstOrDefault().ImgDisinfection,
ImgMaterialSave = t.FirstOrDefault().ImgMaterialSave,
ImgAbandoned = t.FirstOrDefault().ImgAbandoned,
ImgSample = t.FirstOrDefault().ImgSample,
ImgWorkingPerson = t.FirstOrDefault().ImgWorkingPerson,
ImgOther = t.FirstOrDefault().ImgOther,
AuditInfo = Kily.Set <SystemAudit>()
.Where(o => o.IsDelete == false)
.Where(o => o.TableId == x.Id).ToList().MapToList <SystemAudit, ResponseAudit>()
}).FirstOrDefault();
return(data);
}
/// <summary>
/// 厨师详情
/// </summary>
/// <returns></returns>
public ResponseCookInfo GetCookInfoDetail()
{
var data = Kily.Set <CookInfo>().Where(t => t.CookId == CookInfo().Id).Select(t => new ResponseCookInfo()
{
Id = t.Id,
CookId = t.CookId,
TrueName = t.TrueName,
Sexlab = t.Sexlab,
Nation = t.Nation,
Birthday = t.Birthday,
IdCardNo = t.IdCardNo,
TypePath = t.TypePath,
Address = t.Address,
CardOffice = t.CardOffice,
ExpiredDay = t.ExpiredDay,
IdCardPhoto = t.IdCardPhoto,
BookInCard = t.BookInCard,
HealthCard = t.HealthCard,
TrainCard = t.TrainCard,
AuditTypeName = AttrExtension.GetSingleDescription <DescriptionAttribute>(t.AuditType)
}).AsNoTracking().FirstOrDefault();
return(data);
}
/// <summary>
/// 餐饮认证
/// </summary>
/// <param name="pageParam"></param>
/// <returns></returns>
public PagedResult <ResponseRepastIdent> IdentFoodPay(PageParamList <RequestRepastIdent> pageParam)
{
IQueryable <RepastIdent> queryable = Kily.Set <RepastIdent>().Where(t => t.IsDelete == false);
queryable = queryable.Where(t => t.AuditType >= AuditEnum.AuditSuccess);
if (!string.IsNullOrEmpty(pageParam.QueryParam.MerchantName))
{
queryable = queryable.Where(t => t.MerchantName.Contains(pageParam.QueryParam.MerchantName));
}
var data = queryable.OrderByDescending(t => t.CreateTime).Select(t => new ResponseRepastIdent()
{
Id = t.Id,
IdentNo = t.IdentNo,
MerchantName = t.MerchantName,
IdentStarName = AttrExtension.GetSingleDescription <IdentEnum, DescriptionAttribute>(t.IdentStar),
LinkPhone = t.LinkPhone,
AuditTypeName = AttrExtension.GetSingleDescription <AuditEnum, DescriptionAttribute>(t.AuditType),
TableName = t.GetType().Name,
IdentStartTime = t.IdentStartTime,
IdentEndTime = t.IdentEndTime
}).ToPagedResult(pageParam.pageNumber, pageParam.pageSize);
return(data);
}
/// <summary>
/// 餐饮商家登录
/// </summary>
/// <param name="LoginValidate"></param>
/// <returns></returns>
public Object MerchantLogin(RequestValidate LoginValidate)
{
#region 餐饮企业登录
IQueryable <RepastInfo> queryable = Kily.Set <RepastInfo>()
.Where(t => t.Account.Equals(LoginValidate.Account) || t.Phone.Equals(LoginValidate.Account))
.Where(t => t.PassWord.Equals(LoginValidate.PassWord))
.Where(t => t.IsDelete == false);
ResponseMerchant Info = queryable.Select(t => new ResponseMerchant()
{
Id = t.Id,
Account = t.Account,
CommunityCode = t.CommunityCode,
MerchantName = t.MerchantName,
Phone = t.Phone,
DiningType = t.DiningType,
VersionType = t.VersionType,
VersionTypeName = AttrExtension.GetSingleDescription <SystemVersionEnum, DescriptionAttribute>(t.VersionType),
DiningTypeName = AttrExtension.GetSingleDescription <MerchantEnum, DescriptionAttribute>(t.DiningType),
MerchantImage = t.MerchantImage,
AuditType = t.AuditType,
AuditTypeName = AttrExtension.GetSingleDescription <AuditEnum, DescriptionAttribute>(t.AuditType),
DingRoleId = t.DingRoleId,
TypePath = t.TypePath,
Address = t.Address,
Certification = t.Certification,
Email = t.Email,
ImplUser = t.ImplUser,
TableName = typeof(ResponseMerchant).Name
}).FirstOrDefault();
#endregion 餐饮企业登录
#region 非企业登录
IQueryable <RepastInfoUser> queryables = Kily.Set <RepastInfoUser>()
.Where(t => t.Account.Equals(LoginValidate.Account) || t.Phone.Equals(LoginValidate.Account))
.Where(t => t.PassWord.Equals(LoginValidate.PassWord))
.Where(t => t.IsDelete == false);
ResponseMerchantUser User = queryables.Select(t => new ResponseMerchantUser()
{
Id = t.InfoId,
InfoId = t.Id,
Account = t.Account,
TrueName = t.TrueName,
DiningType = t.DiningType,
VersionType = t.VersionType,
DingRoleId = t.DingRoleId,
TypePath = t.TypePath,
MerchantName = t.MerchantName,
Phone = t.Phone,
IdCard = t.Phone,
VersionTypeName = AttrExtension.GetSingleDescription <SystemVersionEnum, DescriptionAttribute>(t.VersionType),
DiningTypeName = AttrExtension.GetSingleDescription <MerchantEnum, DescriptionAttribute>(t.DiningType),
TableName = typeof(ResponseMerchantUser).Name
}).FirstOrDefault();
#endregion 非企业登录
if (Info != null)
{
return(Info);
}
else if (User != null)
{
return(User);
}
else
{
return(null);
}
}
