public ActionResult GetPageStatisticList_DataGrid()
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
//1 分页查询当前登录用户的的发送短信内容集合
var list_SMSContent= userBLL.GetSMSContentListByUID(pageIndex, pageSize,ref rowCount, base.LoginUser.ID,false, false);
List<ViewModel_StatisticsLast10> list_statisticsFinal = new List<ViewModel_StatisticsLast10>();
//2.1 将短信内容实体对象集合转成要在datagrid中显示的统计对象集合
//2.2 需要统计该短信发送的人员个数以及未收到的人员个数
GetStatisticList(list_SMSContent, ref list_statisticsFinal);
//3 转成datagrid识别的json格式数据
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_statisticsFinal,
footer = null
};
//4 序列化
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
/// <summary>
/// 根据传入的Role Id
/// </summary>
/// <param name="rid"></param>
/// <returns></returns>
public ActionResult SetRoleAction(string rid)
{
//int rid = int.Parse(Request.Form["rid"]);
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
if (rid != null)
{
//查询被选中的Action
//1 根据RoleID查询该Role所对应的Action权限
//1.1查出未删除的role中指定ID的Role
var role = roleInfoBLL.GetListBy(r => r.DelFlag == false && r.ID == int.Parse(rid)).FirstOrDefault();
//1.2查出该role中对应的action(ICollection)
var actions = role.ActionInfo.ToList();
//2 需要对actions进行分页
actions = actions.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
//3 将action返回给视图页面，需要添加一个check标签
List<ActionInfo> list = new List<ActionInfo>();
foreach (var item in actions)
{
item.Checked = true;
list.Add(item);
}
list = list.Select(a => a.ToMiddleModel()).ToList();
//4
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list,
footer = null
};
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
return null;
}
// GET: Admin/Action
/// <summary>
/// 获取权限集合
/// </summary>
/// <returns></returns>
public ActionResult GetRoleInfo(ViewModel_RoleInfo_QueryInfo queryModel)
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
//查询的角色
//使用ref声明时需要在传入之前为其赋值
var list_record = roleInfoBLL.GetRoleRecordListByQuery(pageIndex, pageSize, ref rowCount, queryModel, true, true);
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_record,
footer = null
};
//将权限转换为对应的
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
/// <summary>
///
/// </summary>
/// <param name="type">1 全部消息 2 最近（5条）未读消息（不分种类） 3 最近（5条）消息</param>
/// <returns></returns>
private ActionResult BaseGetNewsList(int type)
{
int pageSize = 0;
int pageIndex = 0;
if (Request.Form["rows"]==null|| Request.Form["page"] == null)
{
}
else
{
pageSize = int.Parse(Request.Form["rows"]);
pageIndex = int.Parse(Request.Form["page"]);
}
int count = 0;
//根据登录用户查询其接收到的全部消息
var list = GetAllKindsOfNewsFactory(type, ref count, pageIndex, pageSize);
//var list = newsBLL.GetAllNewsPageListByUser(this.LoginUser.ID, ref count, true, pageIndex, pageSize);
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = count,
rows = list,
footer = null
};
//序列化
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
/// <summary>
/// 分页查询全部短信模板
/// </summary>
/// <returns></returns>
public ActionResult GetAllMsgContent()
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
var userId = base.LoginUser.ID;
//1 查询全部的短信内容模板，并根据sort进行排序
var list_allMsgContent = smsMsgContentBLL.GetPageList(pageIndex, pageSize, ref rowCount, m => m.isDel == false&&m.UID==userId, m => m.Sort, true).ToList().Select(m => m.ToMiddleModel()).ToList();
//2 转成easyui DataGrid
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_allMsgContent,
footer = null
};
//3 序列化
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
/// <summary>
/// 根据smsContent ID 查询对应的记录
/// 注意此处使用分页查询
/// </summary>
/// <param name="cid"></param>
/// <returns></returns>
public ActionResult GetRecordByCID(int cid)
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
//1 根据SMSContent的id查询该短信内容所发送的短信记录列表
//返回的有CID，PName，PhoneNum，StatusCode状态码
var smsContent= smsContentBLL.GetListBy(c => c.ID == cid).FirstOrDefault();
//2 找到其的发送记录
var list_record = smsContent.S_SMSRecord_Current.ToList().Select(r => r.ToMiddleModel());
//2.0 排序，将VIP,未成功的记录放在列表前面
list_record=list_record.OrderByDescending(p=>p.StatusCode).ThenByDescending(p => p.isVIP);
//2.1 获取当总行数
rowCount = list_record.Count();
//2.2 分页返回记录
var list_record_pagelist= list_record.Skip((pageIndex-1)*pageSize).Take(pageSize).ToList();
//3 转成datagrid识别的json格式数据
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_record_pagelist,
footer = null
};
//4 序列化
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
public ActionResult LoadSearchRecordData(ViewModel_RecordQueryInfo model)
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
var list_record= smsContentBLL.GetSMSRecordListByQuery(pageIndex, pageSize, ref rowCount, model, model.CID, true, true);
//3 转成datagrid识别的json格式数据
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_record,
footer = null
};
//4 序列化
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
/// <summary>
/// 查询用户
/// </summary>
/// <returns></returns>
public ActionResult GetUserInfo()
{
//int userId = int.Parse(Request["uid"]);
//1 获取回收站字典
var dic = SMSUserDictionary.GetResponseCode();
//2 将回收站字典转换为easyUI的Combogrid
var list = ToEasyUICombogrid_Common.ToEasyUIDataGrid(dic,false);
//3 将combogrid集合序列化并返回
PMS.Model.EasyUIModel.EasyUIDataGrid model = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = 0,
rows = list,
footer = null
};
var temp = Common.SerializerHelper.SerializerToString(model);
temp = temp.Replace("Checked", "checked");
return Content(temp);
}
/// <summary>
/// 根据请求中的 部门id 以及 群组id 查询对应的联系人
/// </summary>
/// <returns></returns>
public ActionResult GetPersonByGroupDepartment()
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
string dids_str= Request.QueryString["dids"];
string gids_str = Request.QueryString["gids"];
//int[] dids= Array.ConvertAll<string, int>(strArray, s => int.Parse(s));
int rowCount = 0;
var list_person= GetPersonListByGroupDepartment(dids_str, gids_str, out rowCount, pageSize, pageIndex);
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_person,
footer = null
};
//4 序列化后返回
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
public ActionResult GetMissionByUID()
{
int uid = int.Parse(Request["userId"]);
//1 根据传入的userId查询该User所拥有的短信任务
var list_mission= userBLL.GetMissionListByUID(uid, true,false);
//2
PMS.Model.EasyUIModel.EasyUIDataGrid model = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = 0,
rows = list_mission,
footer = null
};
//将权限转换为对应的
return Content(Common.SerializerHelper.SerializerToString(model));
}
/// <summary>
/// 根据 短信任务id 查询对应的群组列表
/// </summary>
/// <param name="mid"></param>
/// <returns></returns>
public ActionResult GetGroupByMID(int mid/*, int userid*/)
{
int userId = int.Parse(Request["uid"]);
//1获取传入的任务id
//1.1根据任务id查找对应的任务对象并查找对应的群组集合
List<PMS.Model.P_Group> list_owned_group = new List<PMS.Model.P_Group>();
//根据短信任务查找短信任务所拥有的群组（在R_Group_Mission表中），并只拿取isPass为true的所对应的群组
smsMissionBLL.GetListBy(m => m.SMID == mid).FirstOrDefault().R_Group_Mission.Where(r => r.isPass == true).ToList().ForEach(r => list_owned_group.Add(r.P_Group));
list_owned_group = list_owned_group.Select(g => g.ToMiddleModel()).ToList();
var list_owned_Ids = list_owned_group.Select(g => g.GID).ToList();
//8月31日
//之前的备份
var list = ToEasyUICombogrid_Group.ToEasyUIDataGrid(list_owned_group, true);
//var list = ToEasyUICombogrid_Group.ToEasyUIDataGrid(list_owned_group, false);
//2 从所有的群组中删除该任务所拥有的群组集合
//2.1 获取当前用户所拥有的常用群组(通过User查询对应的Group）
var list_excludeOwned_group = userBLL.GetRestGroupListByIds(list_owned_Ids, userId, true);
//var list_excludeOwned_group = groupBLL.GetListBy(g => g.isDel == false).ToList().Where(g => !list_owned_group.Contains(g)).Select(g=>g.ToMiddleModel()).ToList();
list.AddRange(ToEasyUICombogrid_Group.ToEasyUIDataGrid(list_excludeOwned_group, false));
//将该任务拥有的群组设置为选中状态
PMS.Model.EasyUIModel.EasyUIDataGrid model = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = 0,
rows = list,
footer = null
};
var temp = Common.SerializerHelper.SerializerToString(model);
temp = temp.Replace("Checked", "checked");
return Content(temp);
}
/// <summary>
/// 查询所有 短信任务对象集合
/// </summary>
/// <returns></returns>
public ActionResult GetAllMissionByPID()
{
//int userId=3;
//userInfoBLL.GetListBy(p=>p.ID==userId).FirstOrDefault().R_UserInfo_SMSMission.
//获取全部的短信种类集合
var list_allmission= smsMissionBLL.GetAllList().ToList().Select(m=>m.ToMiddleModel()).ToList();
PMS.Model.EasyUIModel.EasyUIDataGrid model = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = 0,
rows = list_allmission,
footer = null
};
//将权限转换为对应的
return Content(Common.SerializerHelper.SerializerToString(model));
}
/// <summary>
/// 传入type的id，根据回收站类型返回该类型的isDel为true全部集合
/// </summary>
/// <returns></returns>
public ActionResult GetAllDelInfoByType(int type)
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
//使用工厂模式实现：
//1 根据传入的type id获取对应的bll层对象
// var typeId = int.Parse(Request["type"]);
var typeId = type;
var myBLL= SimpleRecFactory.CreateBLL(typeId);
this.delBLL = myBLL;
//2 需要向BaseDel父类中添加一个公用的获取全部已删除的集合的方法
//var list= myBLL.GetIsDelList();
var list = myBLL.GetIsDelbyPageList(pageIndex,pageSize,ref rowCount);
//3 将combogrid集合序列化并返回
PMS.Model.EasyUIModel.EasyUIDataGrid model = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list,
footer = null
};
var temp = Common.SerializerHelper.SerializerToString(model);
//temp = temp.Replace("Checked", "checked");
return Content(temp);
}
///<summary>
///根据条件获取用户列表
/// </summary>
/// <returns></returns>
public ActionResult GetUserInfo(ViewModel_UserInfo_QueryInfo queryModel)
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
//查询用户
var list_record = userInfoBLL.GetUserRecordListByQuery(pageIndex, pageSize, ref rowCount, queryModel, true, true);
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_record,
footer = null
};
//将用户列表转换为Json格式
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
///<summary>
///通过短信任务得到联系人,并转换为Datagrid
///
///</summary>
///<returns></returns>
public ActionResult GetPersons2Datagrid(ViewModel_Person_QueryInfo queryModel)
{
//1.获取所选的短信任务实体
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
//int smid = int.Parse(Request["smid"]);
//var SMSMission = smsmissionBLL.GetListBy(a => a.SMID == smid).FirstOrDefault();
#region 7月8日注释掉的部分
// //2.根据路线2得到isPass为true群组集合
// bool isPass = true;
// var list_group = GetGroups(isPass, SMSMission);
// List<P_PersonInfo> list_personFromGroup = new List<P_PersonInfo>();
// list_group.ForEach(g => list_personFromGroup.AddRange(g.P_PersonInfo.ToList()));
// //3 根据路线一查询 SMSMission对应的部门，并得到部门中包含的联系人
// //取出isPass为true的所有集合
// var list_department = GetDepartmemts(isPass, SMSMission);
// List<P_PersonInfo> list_personFromDep = new List<P_PersonInfo>();
// list_department.ForEach(g => list_personFromDep.AddRange(g.P_PersonInfo.ToList()));
// //4 将路线一与路线二取出的Person集合合并
// list_personFromGroup.AddRange(list_personFromDep);
// //5 此时的集合中可能存在重复，去重
// list_personFromGroup = list_personFromGroup.Distinct(new PMS.Model.EqualCompare.P_PersonEqualCompare()).ToList();
// //6 取出组群中isPass为false的集合
// isPass = false;
// var list_group_isNotPass = GetGroups(isPass, SMSMission);
// List<P_PersonInfo> list_personFromGroup_isNotPass = new List<P_PersonInfo>();
// list_group_isNotPass.ForEach(g => list_personFromGroup_isNotPass.AddRange(g.P_PersonInfo.ToList()));
// //7 将现有集合中去掉isPass为false的ActionInfo
// list_personFromGroup = list_personFromGroup.Where(a => !list_personFromGroup_isNotPass.Contains(a)).ToList();
// //8 取出组织机构中isPass为false的集合
// var list_department_isNotPass = GetDepartmemts(isPass, SMSMission);
// List<P_PersonInfo> list_personFromDep_isNotPass = new List<P_PersonInfo>();
// list_department_isNotPass.ForEach(g => list_personFromDep_isNotPass.AddRange(g.P_PersonInfo.ToList()));
// //9 将现有集合中去掉isPass为false,isDel为true的
// list_personFromGroup = list_personFromGroup.Where(a => !list_personFromDep_isNotPass.Contains(a)).ToList();
// list_personFromGroup = list_personFromGroup.Where(a => a.isDel == false).ToList();
//rowCount = list_personFromGroup.Count();
#endregion
//7月8日修改
//使用Send/GetPersonByMission这个方法替换上面注释掉的方法
#region 8月16日 临时注释掉
////1 根据mid获取指定任务对象
//var mission = smsmissionBLL.GetListBy(s => s.SMID == smid).FirstOrDefault();
////2 根据短信任务查找对应的群组
//var group = mission.R_Group_Mission.ToList();
////2.1 创建该任务所拥有的群组对象集合
//List<P_Group> list_group = new List<P_Group>();
////2.2 添加至群组对象集合中
//group.ForEach(g => list_group.Add(g.P_Group));
////2.3 根据群组对象集合获取该群组集合中所共有的联系人
//List<P_PersonInfo> list_person = new List<P_PersonInfo>();
//list_group.ForEach(g => list_person.AddRange(g.P_PersonInfo));
////3 根据短信任务查找对应的部门
//var department = mission.R_Department_Mission.ToList();
////3.1 创建该任务所拥有的部门对象集合
//List<P_DepartmentInfo> list_department = new List<P_DepartmentInfo>();
////3.2 添加至部门对象集合中
//department.ForEach(d => list_department.Add(d.P_DepartmentInfo));
////3.3 根据部门对象集合获取该群组集合中所共有的联系人
//list_department.ForEach(d => list_person.AddRange(d.P_PersonInfo));
////4 将联系人集合去重
//list_person = list_person.Distinct(new P_PersonEqualCompare()).ToList().Select(p => p.ToMiddleModel()).Select(p => p.ToMiddleModel()).ToList();
#endregion
List<P_PersonInfo> list_person = new List<P_PersonInfo>();
if (queryModel.SMID != null)
{
list_person= smsmissionBLL.GetPersonByMission(queryModel.SMID, true);
}
//筛选
if (queryModel.PersonName != null)
{
list_person = list_person.Where(p => p.PName.Contains(queryModel.PersonName)).ToList();
}
if (queryModel.PhoneNum != null)
{
list_person = list_person.Where(p => p.PhoneNum.Contains(queryModel.PhoneNum)).ToList();
}
rowCount = list_person.Count();
//10 分页
list_person = list_person.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().Select(m => m.ToMiddleModel()).ToList();
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_person,
footer = null
};
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
/// <summary>
/// 查询当前用户的短信发送情况
/// </summary>
/// <returns></returns>
public ActionResult GetStatisticLast10_DataGrid()
{
//1 获取当前登录的用户
var userInfo = base.LoginUser;
var userTemp= userBLL.GetListBy(u => u.ID == userInfo.ID).FirstOrDefault();
//2 获取该用户所发送的短信内容——只获取当日的发送的短信（或发送最近的前十条短信）
var list_last10 = userTemp.S_SMSContent.OrderByDescending(c => c.SendDateTime).Take(10).ToList();
List<ViewModel_StatisticsLast10> list_statisticslast10 = new List<ViewModel_StatisticsLast10>();
//2.1 将短信内容实体对象集合转成要在datagrid中显示的统计对象集合
//2.2 需要统计该短信发送的人员个数以及未收到的人员个数
GetStatisticList(list_last10, ref list_statisticslast10);
//3 转成datagrid识别的json格式数据
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = 0,
rows = list_statisticslast10,
footer = null
};
//4 序列化
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
protected string GetGroupByUser(int userId,bool isChecked)
{
//1 获取该用户所拥有的权限集合
var list_owned_group = userBLL.GetGroupListByUID(userId, true,false);
//List<int> list_group = new List<int>();
var list_owned_Ids = list_owned_group.Select(g => g.GID).ToList();
//2 获取该用户剩余可以拥有的权限集合
var list_RestOwned_group = groupBLL.GetRestGroupListByIds(list_owned_Ids, true);
//var list_RestOwned_group = userBLL.GetGroupListByUID(userId, true);
var list = ToEasyUICombogrid_Group.ToEasyUIDataGrid(list_owned_group, isChecked);
list.AddRange(ToEasyUICombogrid_Group.ToEasyUIDataGrid(list_RestOwned_group, false));
PMS.Model.EasyUIModel.EasyUIDataGrid model = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = 0,
rows = list,
footer = null
};
var temp = Common.SerializerHelper.SerializerToString(model);
temp = temp.Replace("Checked", "checked");
return temp;
}
/// <summary>
/// 根据任务及时间查询发送短信内容
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ActionResult LoadSearchData(PMS.Model.ViewModel.ViewModel_QueryInfo model)
{
#region 不用此种方式转换时间
//不用以下的方法
//2016 /10 /31
//0123 456 789
//2016 /5 /31
//0123 45 678
// int index_year = query.Dt_target.IndexOf('/'); //4
// int year = int.Parse(query.Dt_target.Substring(0, index_year));//2016
//int index_month = query.Dt_target.IndexOf('/', index_year+1);//7
// int month = int.Parse(query.Dt_target.Substring(index_year+1, index_month-index_year-1));//5
// int day = int.Parse(query.Dt_target.Substring(index_month , query.Dt_target.Length-index_month-1));
#endregion
//使用这种方式转换时间
DateTime dt = new DateTime();
DateTime.TryParse(model.Dt_target, out dt);
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
//1 进行过滤
var list_SMSContent = userBLL.GetSMSContentListByQuery_ExpNamePhone(pageIndex, pageSize, ref rowCount,model, base.LoginUser.ID, false, false);
//1 分页查询当前登录用户的的发送短信内容集合
//var list_SMSContent = userBLL.GetSMSContentListByUID(pageIndex, pageSize, ref rowCount, base.LoginUser.ID, true, false);
List<ViewModel_StatisticsLast10> list_statisticsFinal = new List<ViewModel_StatisticsLast10>();
//2.1 将短信内容实体对象集合转成要在datagrid中显示的统计对象集合
//2.2 需要统计该短信发送的人员个数以及未收到的人员个数
GetStatisticList(list_SMSContent, ref list_statisticsFinal);
//3 转成datagrid识别的json格式数据
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_statisticsFinal,
footer = null
};
//4 序列化
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
protected string GetMissionByUser(int userId,bool isChecked)
{
//1 获取该用户所拥有的短信任务（常用短信任务）
var list_owned_mission = userBLL.GetMissionListByUID(userId, true,false);
var missionIdsbyUser = list_owned_mission.Select(m => m.SMID).ToList();
//2 获取剩余的未拥有的全部短信任务
var list_Ext_mission = smsMissionBLL.GetMissionExt(missionIdsbyUser,false);
var list = ToEasyUICombogrid_Mission.ToEasyUIDataGrid(list_owned_mission, isChecked);
//2 从所有的群组中删除该任务所拥有的群组集合
var list_excludeOwned_group = ToEasyUICombogrid_Mission.ToEasyUIDataGrid(list_Ext_mission, false);
list.AddRange(list_excludeOwned_group);
//将该任务拥有的群组设置为选中状态
PMS.Model.EasyUIModel.EasyUIDataGrid model = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = 0,
rows = list,
footer = null
};
var temp = Common.SerializerHelper.SerializerToString(model);
return temp = temp.Replace("Checked", "checked");
}
public ActionResult GetPersonByCondition(PMS.Model.ViewModel.ViewModel_Person_QueryInfo queryModel)
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
//查询所有的权限
//使用ref声明时需要在传入之前为其赋值
//判断传入的判断条件
IQueryable<P_PersonInfo> list_person = null;
if (queryModel.DID != 0)
{
list_person= personInfoBLL.GetListBy(p => p.isDel == false && p.P_DepartmentInfo.Where(d => d.DID == queryModel.DID).Count() > 0, p => p.PID);
}
if (queryModel.GID != 0)
{
list_person = personInfoBLL.GetListBy(p => p.isDel == false && p.P_Group.Where(g => g.GID== queryModel.GID).Count() > 0, p => p.PID);
}
if (queryModel.PersonName != null)
{
list_person = list_person.Where(p => p.PName.Contains(queryModel.PersonName));
}
if (queryModel.PhoneNum != null)
{
list_person = list_person.Where(p => p.PhoneNum.Contains(queryModel.PhoneNum));
}
//获取筛选后的联系人集合的总数
rowCount = list_person.Count();
list_person = list_person.OrderByDescending(a => a.isVIP);
list_person = list_person.Skip((pageIndex - 1) * pageSize).Take(pageSize);
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_person.ToList().Select(p=>p.ToMiddleModel()).ToList() ,
footer = null
};
//将权限转换为对应的
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
public ActionResult GetPersonByGroup()
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int gid = int.Parse(Request["gid"]);
int rowCount = 0;
//查询所有的权限
//使用ref声明时需要在传入之前为其赋值
var list_person = personInfoBLL.GetPageList(pageIndex, pageSize, ref rowCount, p => p.isDel == false&&p.P_Group.Where(g=>g.GID==gid).Count()>0, p => p.PName, true).ToList().Select(p=>p.ToMiddleModel()).ToList();
//var content = from p in list_person
// select new
// {
// PID = p.PID,
// PName = p.PName,
// Remark = p.Remark,
// PhoneNum = p.PhoneNum,
// };
//在分页查询时如何排序，需要讨论
list_person = list_person.OrderByDescending(a => a.isVIP).ToList();
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_person,
footer = null
};
//将权限转换为对应的
return Json(dgModel,JsonRequestBehavior.AllowGet);
//return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
protected string GetMissionByUser(int userId,int tid, bool isChecked)
{
//1 获取当前短信模板中SMID对应的短信群组类型
var list_owned_mission=smsMsgContentBLL.GetListBy(c => c.UID == userId && c.TID == tid).Select(c => c.S_SMSMission).ToList();
var missionIdsbyUser = list_owned_mission.Select(m => m.SMID).ToList();
//2 获取剩余的未拥有的全部短信任务
var list_Ext_mission = smsMissionBLL.GetMissionExt(missionIdsbyUser,false);
var list = ToEasyUICombogrid_Mission.ToEasyUIDataGrid(list_owned_mission, isChecked);
//2 从所有的群组中删除该任务所拥有的群组集合
var list_excludeOwned_group = ToEasyUICombogrid_Mission.ToEasyUIDataGrid(list_Ext_mission, false);
list.AddRange(list_excludeOwned_group);
//将该任务拥有的群组设置为选中状态
PMS.Model.EasyUIModel.EasyUIDataGrid model = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = 0,
rows = list,
footer = null
};
var temp = Common.SerializerHelper.SerializerToString(model);
return temp = temp.Replace("Checked", "checked");
}
public ActionResult GetPersonInfo()
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int rowCount = 0;
//查询所有的权限
//使用ref声明时需要在传入之前为其赋值
var list_person = personInfoBLL.GetPageList(pageIndex, pageSize, ref rowCount, p => p.isDel == false, p => p.PName, true).ToList().Select(p=>p.ToMiddleModel()).ToList();
//排序，VIP联系人放在前面
list_person = list_person.OrderByDescending(a => a.isVIP).ToList();
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_person,
footer = null
};
//将权限转换为对应的
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
///<summary>
///得到选中任务所包含的群组
///</summary>
///<returns></returns>
public ActionResult GetGroupBySMSMission()
{
int pageSize = int.Parse(Request.Form["rows"]);
int pageIndex = int.Parse(Request.Form["page"]);
int smid = int.Parse(Request["smid"]);
int rowCount = 0;
var list_department = departmentBLL.GetPageList(pageIndex, pageSize, ref rowCount, p => p.isDel == false && p.R_Department_Mission.Where(g => g.MissionID == smid).Count() > 0, p => p.DepartmentName, true).ToList();
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = rowCount,
rows = list_department,
footer = null
};
//将权限转换为对应的
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
public ActionResult GetNewsByTypeList(int type)
{
//获取登录用户可以查看的全部新消息
var list= newsBLL.GetTargetTypeNewsPageListByUser(this.LoginUser.ID,1,true,type,5);
PMS.Model.EasyUIModel.EasyUIDataGrid dgModel = new PMS.Model.EasyUIModel.EasyUIDataGrid()
{
total = 0,
rows = list,
footer = null
};
//4 序列化
return Content(Common.SerializerHelper.SerializerToString(dgModel));
}
