//根据ShopGroup，进行PersonShopGroupPBs的排班插入
public void ShopGroupPB(ShopGroups ShopGroup, UserWorkDate WorkDate, Kf_DepartMent kf_DepartMent)
{
if (ShopGroup.WorkDayOrNight != DayOrNight.全天)
{
PersonShopGroupPBs personShopGroupPBs = new PersonShopGroupPBs();
personShopGroupPBs.WorkDayOrNight = ShopGroup.WorkDayOrNight;
personShopGroupPBs.UserWorkDate = WorkDate;
personShopGroupPBs.UpdateTime = System.DateTime.Now.Date;
personShopGroupPBs._ShopGroups = ShopGroup;
personShopGroupPBs._User = this.getAvailableUser(ShopGroup, personShopGroupPBs.WorkDayOrNight, WorkDate);
this.Save(personShopGroupPBs);
}
else
{
for (int t = 0; t < 2; t++)
{
PersonShopGroupPBs personShopGroupPBs = new PersonShopGroupPBs();
if (t == 0)
{
personShopGroupPBs.WorkDayOrNight = DayOrNight.白班;
}
else
{
personShopGroupPBs.WorkDayOrNight = DayOrNight.晚班;
}
personShopGroupPBs.UserWorkDate = WorkDate;
personShopGroupPBs.UpdateTime = System.DateTime.Now.Date;
personShopGroupPBs._ShopGroups = ShopGroup;
personShopGroupPBs._User = this.getAvailableUser(ShopGroup, personShopGroupPBs.WorkDayOrNight, WorkDate);
this.Save(personShopGroupPBs);
}
}
}
//(4)进行系统排班,清空PBDateTemplet,PersonShopPBs，PersonPBs之前的记录。插入PBDateTemplet,PersonShopPBs，PersonPBs自动插入。
//（5）手工调整PBDateTemplet和值班人员，调整时PersonShopPBs，PersonPBs自动更新。
public void PaiBan(DateTime localStartDate, DateTime localEndDate, Kf_DepartMent kf_DepartMent)
{
WorkDateRepository workDateRepo = new WorkDateRepository();
List <UserWorkDate> listUserWorkDate = workDateRepo.PaiBan(localStartDate, localEndDate);
ShopTempletRepository shopTempletRepo = new ShopTempletRepository();
//把PBDateTemplet中的记录删除掉，再重新
List <PBDateTemplet> listPBDateTemplet = this.GetAll()
.Where(it => it._UserWorkDate.WorkDate.Date <= localEndDate.Date)
.Where(it => it._UserWorkDate.WorkDate.Date >= localStartDate.Date)
.WhereIf(it => it._ShopTemplet._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.ToList();
//删除，重新排
if (listPBDateTemplet != null && listPBDateTemplet.Count != 0)
{
foreach (var pb in listPBDateTemplet)
{
this.Delete(pb);
}
}
List <ShopTemplet> listShopTemplet = shopTempletRepo.GetAll()
.Where(it => it.isExpire == isExpire.未过期)
.Where(it => it.isValid == isValid.效)
.WhereIf(it => it._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.ToList();
for (DateTime Date = localStartDate; Date <= localEndDate; Date = Date.AddDays(1))
{
UserWorkDate workDate = listUserWorkDate.Where(it => it.WorkDate == Date).FirstOrDefault();
//循环
ShopTemplet shopTempletOrdinary = listShopTemplet.Where(it => it.ShopTempletTypeID == _ShopTempletType.平时).ToList().FirstOrDefault();
ShopTemplet shopTempletWeekEnd = listShopTemplet.Where(it => it.ShopTempletTypeID == _ShopTempletType.周末).ToList().FirstOrDefault();
ShopTemplet shopTempletHoliday = listShopTemplet.Where(it => it.ShopTempletTypeID == _ShopTempletType.假期).ToList().FirstOrDefault();
ShopTemplet shopTempletSpecailDate = listShopTemplet.Where(it => it.ShopTempletTypeID == _ShopTempletType.特定日期).ToList().FirstOrDefault();
PBDateTemplet pbDateTemplet = new PBDateTemplet();
if ((Date.DayOfWeek == DayOfWeek.Saturday || Date.DayOfWeek == DayOfWeek.Sunday) && shopTempletWeekEnd != null)
{
pbDateTemplet._ShopTemplet = shopTempletWeekEnd;
}
else if (shopTempletSpecailDate != null && Date.Date == shopTempletSpecailDate.SpecialDate.Date)
{
pbDateTemplet._ShopTemplet = shopTempletSpecailDate;
}
else if (false)//假期还没完善上去。
{
}
else
{
pbDateTemplet._ShopTemplet = shopTempletOrdinary;
}
pbDateTemplet._UserWorkDate = workDate;
pbDateTemplet.UpdateTime = System.DateTime.Now.Date;
this.Save(pbDateTemplet);
}
}
public ActionResult ShopIndexForFenPeiQuery(QueryInfo queryInfo, string name, string alertMessage, string subAction, FormCollection form)
{
User user = this.Users();
Kf_DepartMent departMent = user.DepartMent;
PagedData <Shop> data = shopRepository.GetData(queryInfo, null, name, departMent);
return(View(data));
}
public List <ShopTemplet> GetShopTemplet(Kf_DepartMent kf_DepartMent)
{
return(GetSession().Linq <ShopTemplet>()
.Where(it => it.isExpire == isExpire.未过期)
.Where(it => it.isValid == isValid.效)
.WhereIf(u => u._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.ToList());
}
public List <PersonPBData> GetData(string Year, string Month, Kf_DepartMent kf_DepartMent)
{
return(GetSession()
.Linq <PersonPBData>()
.Where(u => u.Year == Convert.ToInt64(Year))
.Where(u => u.Month == Convert.ToInt64(Month))
.WhereIf(u => u._user.DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.ToList());
}
//查询出某一部门的某一个时间段的排班信息
public List <PersonShopGroupPBs> GetData(Kf_DepartMent kf_DepartMent, DateTime localStartDate, DateTime localEndDate)
{
return(GetSession().Linq <PersonShopGroupPBs>()
.Where(it => it.UserWorkDate.WorkDate >= localStartDate)
.Where(it => it.UserWorkDate.WorkDate <= localEndDate)
.WhereIf(it => it._ShopGroups._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.OrderBy(it => it.UserWorkDate)
.ToList());
}
public PagedData <PayRecords> GetPayRecords(QueryInfo queyInfo, Kf_DepartMent kf_DepartMent, string name, string Year, string Month)
{
return(GetSession().Linq <PayRecords>()
.WhereIf(p => p._Shop._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.WhereIf(p => p._Shop.Name.Contains(name), name.IsNotNullAndEmpty())
.Where(p => p.Year == Convert.ToInt32(Year))
.Where(p => p.Month == Convert.ToInt32(Month))
.OrderByDescending(p => p.PayDate)
.Page(queyInfo));
}
//按理说应该根据模板，如果部门确定了，日期确定了，那么模板也就确定了，所以根据这两个也可以
public List <PersonShopGroupPBs> GetListPersonShopGroupPB(Kf_DepartMent _kf_DepartMent, UserWorkDate workDate)
{
var list = GetSession()
.Linq <PersonShopGroupPBs>()
.Where(u => u.UserWorkDate == workDate)
.Where(u => u._ShopGroups._Kf_DepartMent == _kf_DepartMent)
.OrderBy(u => u.WorkDayOrNight)
.ToList();
return(list);
}
public ActionResult ShopIndex(QueryInfo queryInfo, int[] ids, string name, string alertMessage, string subAction)
{
if (subAction == "delete")
{
foreach (int userid in ids)
{
shopRepository.Delete(userid);
}
ViewBag.message = "删除成功！";
}
ViewBag.message = alertMessage;
User user = this.Users();
Kf_DepartMent departMent = user.DepartMent;
PagedData <Shop> data = shopRepository.GetData(queryInfo, null, name, departMent);
return(View(data));
}
//根据班组排班表中的内容，更新PersonPB里的数据
public void PaiBan(DateTime localStartDate, DateTime localEndDate, Kf_DepartMent kf_DepartMent)
{
List <PersonPB> listPersonPB = this.GetAll()
.Where(it => it.UserWorkDate.WorkDate.Date <= localEndDate.Date)
.Where(it => it.UserWorkDate.WorkDate.Date >= localStartDate.Date)
.WhereIf(it => it._Shop._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.ToList();
foreach (var PB in listPersonPB)
{
this.Delete(PB);
}
ShopGroupDetailRepository shopGroupDetailRepo = new ShopGroupDetailRepository();//
PersonShopGroupPBsRepository personShopGroupPBsRepo = new PersonShopGroupPBsRepository();
List <PersonShopGroupPBs> listPersonShopGroupPBs = personShopGroupPBsRepo.GetAll()
.Where(it => it.UserWorkDate.WorkDate.Date <= localEndDate.Date)
.Where(it => it.UserWorkDate.WorkDate.Date >= localStartDate.Date)
.WhereIf(it => it._ShopGroups._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.ToList();
List <ShopGroupDetails> listShopGroupDetails = shopGroupDetailRepo.GetAll()
.WhereIf(it => it._Shop._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.ToList();
foreach (var personShopGroupPBs in listPersonShopGroupPBs)
{
List <Shop> listShop = listShopGroupDetails
.Where(it => it._ShopGroup == personShopGroupPBs._ShopGroups)
.Select(it => it._Shop)
.ToList();
foreach (var shop in listShop)
{
PersonPB pb = new PersonPB();
pb._Shop = shop;
pb._user = personShopGroupPBs._User;
pb.UserWorkDate = personShopGroupPBs.UserWorkDate;
pb.WorkDayOrNight = personShopGroupPBs._ShopGroups.WorkDayOrNight;
this.Save(pb);
}
}
}
//根据PBDateTemplet，模板排班里面的内容，更新班组排班表PersonShopGroupPBs
public void PaiBan(DateTime localStartDate, DateTime localEndDate, Kf_DepartMent kf_DepartMent)
{
ShopTempletDetailsRepository shopTempletDetailsRepo = new ShopTempletDetailsRepository();
PBDateTempletRepository pbDateTempletRepo = new PBDateTempletRepository();
List <PersonShopGroupPBs> listPersonShopGroupPBs = this.GetAll()
.Where(it => it.UserWorkDate.WorkDate <= localEndDate)
.Where(it => it.UserWorkDate.WorkDate >= localStartDate)
.WhereIf(it => it._ShopGroups._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.ToList();
//删除原来的
foreach (var PersonShopGroupPB in listPersonShopGroupPBs)
{
this.Delete(PersonShopGroupPB);
}
//取出来哪些shopGroup，插入进去
List <ShopTempletDetails> listShopTempletDetails = shopTempletDetailsRepo.GetAll()
.Where(it => it._ShopTemplet._Kf_DepartMent == kf_DepartMent)
.Where(it => it._ShopTemplet.isExpire == isExpire.未过期)
.Where(it => it._ShopTemplet.isValid == isValid.效)
.ToList();
List <PBDateTemplet> listPBDateTemplet = pbDateTempletRepo.GetAll()
.Where(it => it._UserWorkDate.WorkDate <= localEndDate)
.Where(it => it._UserWorkDate.WorkDate >= localStartDate)
.ToList();
foreach (var PBDateTemplet in listPBDateTemplet)
{
List <ShopTempletDetails> localListShopTempletDetails = listShopTempletDetails
.Where(it => it._ShopTemplet == PBDateTemplet._ShopTemplet).ToList();
foreach (var ShopTempletDetails in localListShopTempletDetails)
{
//根据ShopGroup，进行PersonShopGroupPBs的排班插入
this.ShopGroupPB(ShopTempletDetails._ShopGroup, PBDateTemplet._UserWorkDate, kf_DepartMent);
}
}
}
//检查有无模板，如果有，是不是可用。
public string checkShopTempletValid(Kf_DepartMent kf_DepartMentID)
{
string strResult = "";
List <ShopTemplet> listShopTemplet = this.GetAll()
.Where(it => it.isExpire == isExpire.未过期)
.Where(it => it.isValid == isValid.效)
.WhereIf(u => u._Kf_DepartMent == kf_DepartMentID, kf_DepartMentID.ID != 1)
.ToList();
if (listShopTemplet.Count() == 0)
{
strResult = "没有未过期的并且有效的模板，请检查后再排班";
return(strResult);
}
foreach (var shopTemplet in listShopTemplet)
{
strResult = this.checkShopTempletValid(shopTemplet.ID);
if (strResult != "模板有效")
{
return(strResult);
}
}
return(strResult);
}
public PagedData <ShopTemplet> GetShopTemplet(QueryInfo queyInfo, string name, Kf_DepartMent kf_DepartMent)
{
return(GetSession().Linq <ShopTemplet>()
.WhereIf(p => p.ShopTempletName.Contains(name), name.IsNotNullAndEmpty())
.WhereIf(u => u._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.Page(queyInfo));
}
public PagedData <PersonPB> GetPagedData(QueryInfo queryInfo, string ShopName, DateTime startDate, DateTime endDate, Kf_DepartMent kf_DepartMent)
{
return(GetSession()
.Linq <PersonPB>()
.WhereIf(u => u.UserWorkDate.WorkDate >= startDate, startDate != null)
.WhereIf(u => u.UserWorkDate.WorkDate <= endDate, endDate != null)
.WhereIf(u => u._Shop.Name.Contains(ShopName.Trim()), ShopName.IsNotNullAndEmpty())
.WhereIf(u => u._Shop._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.Page(queryInfo));
}
public void updatePersonPBData(string Year, string Month, Kf_DepartMent kf_DepartMent)
{
PersonShopGroupPBsRepository PersonShopGroupPBRepo = new PersonShopGroupPBsRepository();
List <PersonShopGroupPBs> listPersonShopGroupPBs = PersonShopGroupPBRepo.GetListPersonShopGroupPB(Year, Month, kf_DepartMent);
UserRepository UserRepo = new UserRepository();
List <User> ListUser = UserRepo.GetAll()
.Where(p => p.Type.ID.ToString().Trim() == "1")
.ToList();
List <PersonPBData> listPersonPBData = this.GetData(Year, Month, kf_DepartMent);
foreach (var PersonPBData in listPersonPBData)
{
this.Delete(PersonPBData);
}
var distinctWorkDate = from y in listPersonShopGroupPBs
group y by new { y.UserWorkDate };
foreach (var workDate in distinctWorkDate)
{
foreach (var user in ListUser)
{
PersonPBData PersonPBData = new PersonPBData();
PersonPBData.UserWorkDate = workDate.Key.UserWorkDate;
PersonPBData._user = user;
PersonPBData.Year = Year.ToInt();
PersonPBData.Month = Month.ToInt();
PersonPBData.UpdateTime = System.DateTime.Now;
//如果能查到是白班，那么就是白班，如果能查到是晚班，那么就是晚班，如果白班和白班都查到了，那么是全班，如果都没查到，那么是休班.
List <PersonShopGroupPBs> listLocalPersonShopGroupPBs = listPersonShopGroupPBs
.Where(it => it._User == user)
.Where(it => it.UserWorkDate == workDate.Key.UserWorkDate)
.ToList();
if (listLocalPersonShopGroupPBs.Count == 0)
{
PersonPBData.WorkDayOrNight = DayOrNight.休班;
}
else if (listLocalPersonShopGroupPBs.Count == 1)
{
if (listLocalPersonShopGroupPBs.FirstOrDefault()._ShopGroups.WorkDayOrNight == DayOrNight.白班)
{
PersonPBData.WorkDayOrNight = DayOrNight.白班;
}
if (listLocalPersonShopGroupPBs.FirstOrDefault()._ShopGroups.WorkDayOrNight == DayOrNight.晚班)
{
PersonPBData.WorkDayOrNight = DayOrNight.晚班;
}
}
else
{
PersonPBData.WorkDayOrNight = DayOrNight.全天;
}
PersonPBData.DayNumMonth = 0;
PersonPBData.NightNumMonth = 0;
PersonPBData.RestNumMonth = 0;
this.Save(PersonPBData);
}
}
List <PersonPBData> listPersonPBDataNew = this.GetData(Year, Month, kf_DepartMent);
foreach (var User in ListUser)
{
List <PersonPBData> listLocalPersonPBDataNew = listPersonPBDataNew.Where(it => it._user == User).ToList();
int intUserDayNumMonth = 0;
int intUserNightNumMonth = 0;
int intUserRestNumMonth = 0;
foreach (var personPBData in listLocalPersonPBDataNew)
{
if (personPBData.WorkDayOrNight == DayOrNight.休班)
{
intUserRestNumMonth = intUserRestNumMonth + 1;
}
if (personPBData.WorkDayOrNight == DayOrNight.全天)
{
intUserDayNumMonth = intUserDayNumMonth + 1;
intUserNightNumMonth = intUserNightNumMonth + 1;
}
if (personPBData.WorkDayOrNight == DayOrNight.白班)
{
intUserDayNumMonth = intUserDayNumMonth + 1;
}
if (personPBData.WorkDayOrNight == DayOrNight.晚班)
{
intUserNightNumMonth = intUserNightNumMonth + 1;
}
}
foreach (var personPBData in listLocalPersonPBDataNew)
{
//PersonPBData pbData = this.GetByDatabaseID(personPBData.ID);
personPBData.DayNumMonth = intUserDayNumMonth;
personPBData.NightNumMonth = intUserNightNumMonth;
personPBData.RestNumMonth = intUserRestNumMonth;
this.Save(personPBData);
}
}
}
public PagedData <PersonPBData> GetData(QueryInfo queryInfo, string Year, string Month, string UserName, Kf_DepartMent kf_DepartMent)
{
return(GetSession()
.Linq <PersonPBData>()
.Where(u => u.Year == Convert.ToInt64(Year))
.Where(u => u.Month == Convert.ToInt64(Month))
.WhereIf(u => u._user.DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.WhereIf(u => u._user.userName.Contains(UserName.Trim()), UserName.IsNotNullAndEmpty())
.OrderBy(u => u.UserWorkDate)
.Page(queryInfo));
}
//根据客服查询排班的情况，也就是取出PersonShopGroupPBs表中的内容，客服和班组的排班对应表。
public ActionResult PaiBanByUsersIndex(QueryInfo queryInfo, DateTime?startDate, DateTime?endDate, string Name, Kf_DepartMent kf_DepartMent)
{ //取出排班客服表
DateTime localStartDate;
DateTime localEndDate;
if (startDate == null)
{
localStartDate = System.DateTime.Now.Date;
}
else
{
localStartDate = Convert.ToDateTime(startDate);
}
if (endDate == null)
{
localEndDate = localStartDate.AddDays(6);
}
else
{
localEndDate = Convert.ToDateTime(endDate);
}
ViewData["startDate"] = localStartDate;
ViewData["endDate"] = localEndDate;
//根据
//this.personShopGroupPBsRepo.GetAll()
string localName = "";
if (Name != null)
{
localName = Name.ToString();
ViewData["Name"] = localName;
}
PagedData <PersonShopGroupPBs> data = this.personShopGroupPBsRepo.GetData(queryInfo, localName, localStartDate, localEndDate, this.Users().DepartMent);
return(View(data));
}
//根据客服人员取出该客服的班次信息List<PersonShopGroupPBs>
public List <PersonShopGroupPBs> GetListPersonShopGroupPB(string Year, string Month, Kf_DepartMent kf_DepartMent)
{
var list = GetSession()
.Linq <PersonShopGroupPBs>()
.Where(u => u.UserWorkDate.Year == Year.ToInt())
.Where(u => u.UserWorkDate.Month == Month.ToInt())
.WhereIf(u => u._User.DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
//.OrderBy("UserWorkDateID", false)
.ToList();
return(list);
}
public PagedData <PBDateTemplet> GetData(QueryInfo queyInfo, DateTime localStartDate, DateTime localEndDate, Kf_DepartMent kf_DepartMent)
{
return(GetSession().Linq <PBDateTemplet>()
.Where(it => it._UserWorkDate.WorkDate >= localStartDate)
.Where(it => it._UserWorkDate.WorkDate <= localEndDate)
.WhereIf(u => u._ShopTemplet._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.OrderBy("_UserWorkDate", false)
.Page(queyInfo));
}
public PagedData <Shop> GetData(QueryInfo queryInfo, int?typeId, string name, Kf_DepartMent kf_DepartMent)
{
return(GetSession()
.Linq <Shop>()
.WhereIf(u => u.Name.Contains(name.Trim()), name.IsNotNullAndEmpty())
.WhereIf(u => u._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.Page(queryInfo));
}
//如果是手工排班需要不需要检查里面有无排班，如果有排班的数据，那么就不重新全部删除，而是保留一部分原来的排班的数据
public void PaiBanHandChange(PBDateTemplet PbDateTempletOld, ShopTemplet shopTempletNew, Kf_DepartMent kf_DepartMent)
{
ShopTempletDetailsRepository shopTempletDetailsRepo = new ShopTempletDetailsRepository();
PBDateTempletRepository pbDateTempletRepo = new PBDateTempletRepository();
List <ShopTempletDetails> listShopTempletDetailsOld = shopTempletDetailsRepo.GetAll()
.Where(it => it._ShopTemplet == PbDateTempletOld._ShopTemplet)
.WhereIf(it => it._ShopGroup._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.ToList();
List <ShopTempletDetails> listShopTempletDetailsNew = shopTempletDetailsRepo.GetAll()
.Where(it => it._ShopTemplet == shopTempletNew)
.WhereIf(it => it._ShopGroup._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.ToList();
//在老的里面有，新的里面也有的，不动。
List <PersonShopGroupPBs> listPersonShopGroupPBs = this.GetAll()
.Where(it => it.UserWorkDate == PbDateTempletOld._UserWorkDate)
.WhereIf(it => it._ShopGroups._Kf_DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.ToList();
//在老的里面有，新的里面没有的，删除掉。
foreach (var PersonShopGroupPB in listPersonShopGroupPBs)
{
if (listShopTempletDetailsNew.Where(it => it._ShopGroup == PersonShopGroupPB._ShopGroups).Count() == 0)
{
this.Delete(PersonShopGroupPB);
}
}
//在老的里面没有，新的里面有的，插入进去。
//都是哪些人可以做这个班组的客服
PersonShopGroupRepository PersonShopGroupRepo = new PersonShopGroupRepository();
List <PersonShopGroup> listPersonShopGroup = PersonShopGroupRepo.GetAll().ToList();
foreach (var shopGroupDetail in listShopTempletDetailsNew)
{
if (listPersonShopGroupPBs.Where(it => it._ShopGroups == shopGroupDetail._ShopGroup).Count() == 0)
{
//根据排班来插入店铺
this.ShopGroupPB(shopGroupDetail._ShopGroup, PbDateTempletOld._UserWorkDate, kf_DepartMent);
}
}
}
//
public PagedData <PersonShopGroupPBs> GetData(QueryInfo queyInfo, string UserName, DateTime localStartDate, DateTime localEndDate, Kf_DepartMent kf_DepartMent)
{
return(GetSession().Linq <PersonShopGroupPBs>()
.Where(it => it.UserWorkDate.WorkDate >= localStartDate)
.Where(it => it.UserWorkDate.WorkDate <= localEndDate)
.WhereIf(u => u._User.userName.Contains(UserName.Trim()), UserName.IsNotNullAndEmpty())
.WhereIf(u => u._User.DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.OrderBy(u => u.UserWorkDate)
.Page(queyInfo));
}
/// <summary>
//public PagedData<User> GetUser(QueryInfo queryInfo, int? typeId, string name,string username,string iskf)
//{
// return GetSession()
// .Linq<User>()
// //.Where(u => u.Type != "1".ToEnum<UserEnmType>() && u.Type != "2".ToEnum<UserEnmType>())
// // .WhereIf(u => u.Type == typeId.ToString().ToEnum<UserEnmType>(), typeId != null)
// .WhereIf(u => u.Name.Contains(name.Trim()), name.IsNotNullAndEmpty())
// .WhereIf(u => u.userName.Contains(username.Trim()), username.IsNotNullAndEmpty())
// //.WhereIf(u=>u.Type.ID==typeId,iskf.IsNotNullAndEmpty())
// .Page(queryInfo);
//}
public PagedData <User> GetUserData(QueryInfo queryInfo, string name, string typeID, Kf_DepartMent kf_DepartMent)
{
return(GetSession()
.Linq <User>()
.WhereIf(u => u.Type.ID == Convert.ToInt64(typeID), typeID != null)
.WhereIf(u => u.userName.Contains(name.Trim()), name.IsNotNullAndEmpty())
.WhereIf(u => u.DepartMent == kf_DepartMent, kf_DepartMent.ID != 1)
.Page(queryInfo));
}
