//查询
public List <T_OA_MEETINGROOMAPP> GetMeetintRoomAppInfosListBySearch(string StrMeetingRoom, string StrDepartment, DateTime DtStart, DateTime DtEnd, string StrCheckState, string StrCreateUser)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
IQueryable <T_OA_MEETINGROOMAPP> MeetingRoomAppList = RoomAppBll.GetMeetingRoomAppListBySearch(StrMeetingRoom, DtStart, DtEnd, StrDepartment, StrCheckState, StrCreateUser);
if (MeetingRoomAppList == null)
{
return(null);
}
else
{
return(MeetingRoomAppList.ToList());
}
}
}
///根据开始时间、结束时间获取审核通过的会议室申请信息
public List <T_OA_MEETINGROOMAPP> GetMeetingRoomAppBySelectRooms(DateTime start, DateTime end, string StrCheckState)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
IQueryable <T_OA_MEETINGROOMAPP> MeetingInfosList = RoomAppBll.GetMeetingRoomAppInfos(start, end, StrCheckState);
if (MeetingInfosList == null)
{
return(null);
}
else
{
return(MeetingInfosList.ToList());
}
}
}
// 2010-3-23 添加审核状态
public List <T_OA_MEETINGROOMAPP> GetMeetingRoomAppInfos(string StrCheckState)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
List <T_OA_MEETINGROOMAPP> MeetingInfosList = RoomAppBll.GetMeetingRoomAppInfos(StrCheckState);
if (MeetingInfosList == null)
{
return(null);
}
else
{
return(MeetingInfosList);
}
}
}
public List <V_MeetingRoomApp> GetMeetingRoomAppInfosByFlow(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, string checkState, LoginUserInfo loginUserInfo)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
IQueryable <V_MeetingRoomApp> RoomAppsList = null;
if (checkState != ((int)CheckStates.WaittingApproval).ToString()) //获取待审核信息
{
if (checkState == ((int)CheckStates.ALL).ToString())
{
RoomAppsList = RoomAppBll.GetMeetingRoomAppInfosByFlow(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, "", loginUserInfo.userID);
}
else
{
RoomAppsList = RoomAppBll.GetMeetingRoomAppInfosByFlow(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, checkState, loginUserInfo.userID);
}
}
else
{
ServiceClient workFlowWS = new ServiceClient();
V_MeetingRoomApp a = new V_MeetingRoomApp();
FLOW_FLOWRECORDDETAIL_T flowInfo = new FLOW_FLOWRECORDDETAIL_T(); //审核人 操作
FLOW_FLOWRECORDDETAIL_T[] flowList = workFlowWS.GetFlowInfo("", "", "", "0", "MeetingRoomApp", loginUserInfo.companyID, loginUserInfo.userID);
if (flowList == null)
{
return(null);
}
List <V_FlowAPP> flowAppList = new List <V_FlowAPP>();
for (int i = 0; i < flowList.Length; i++)
{
V_FlowAPP App = new V_FlowAPP();
App.Guid = flowList[i].FLOWRECORDDETAILID;
App.FormID = flowList[i].FLOW_FLOWRECORDMASTER_T.FORMID;
App.EditUserID = flowList[i].EDITUSERID;
App.EditUserName = flowList[i].EDITUSERNAME;
flowAppList.Add(App);
}
checkState = ((int)CheckStates.Approving).ToString();
RoomAppsList = RoomAppBll.GetMeetingRoomAppInfosByFlow(pageIndex, pageSize, sort, filterString, paras, ref pageCount, flowAppList, checkState, loginUserInfo.userID);
}
return(RoomAppsList != null?RoomAppsList.ToList() : null);
}
}
//查询
public List<T_OA_MEETINGROOMAPP> GetMeetintRoomAppInfosListBySearch(string StrMeetingRoom, string StrDepartment, DateTime DtStart, DateTime DtEnd, string StrCheckState, string StrCreateUser)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
IQueryable<T_OA_MEETINGROOMAPP> MeetingRoomAppList = RoomAppBll.GetMeetingRoomAppListBySearch(StrMeetingRoom, DtStart, DtEnd, StrDepartment, StrCheckState, StrCreateUser);
if (MeetingRoomAppList == null)
{
return null;
}
else
{
return MeetingRoomAppList.ToList();
}
}
}
public List<V_MeetingRoomApp> GetMeetingRoomAppInfosByFlow(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, string checkState, LoginUserInfo loginUserInfo)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
IQueryable<V_MeetingRoomApp> RoomAppsList = null;
if (checkState != ((int)CheckStates.WaittingApproval).ToString()) //获取待审核信息
{
if (checkState == ((int)CheckStates.ALL).ToString())
{
RoomAppsList = RoomAppBll.GetMeetingRoomAppInfosByFlow(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, "", loginUserInfo.userID);
}
else
{
RoomAppsList = RoomAppBll.GetMeetingRoomAppInfosByFlow(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, checkState, loginUserInfo.userID);
}
}
else
{
ServiceClient workFlowWS = new ServiceClient();
V_MeetingRoomApp a = new V_MeetingRoomApp();
SMT.SaaS.BLLCommonServices.FlowWFService.FLOW_FLOWRECORDDETAIL_T flowInfo = new SMT.SaaS.BLLCommonServices.FlowWFService.FLOW_FLOWRECORDDETAIL_T(); //审核人 操作
SMT.SaaS.BLLCommonServices.FlowWFService.FLOW_FLOWRECORDDETAIL_T[] flowList = workFlowWS.GetFlowInfo("", "", "", "0", "MeetingRoomApp", loginUserInfo.companyID, loginUserInfo.userID);
if (flowList == null)
{
return null;
}
List<V_FlowAPP> flowAppList = new List<V_FlowAPP>();
for (int i = 0; i < flowList.Length; i++)
{
V_FlowAPP App = new V_FlowAPP();
App.Guid = flowList[i].FLOWRECORDDETAILID;
App.FormID = flowList[i].FLOW_FLOWRECORDMASTER_T.FORMID;
App.EditUserID = flowList[i].EDITUSERID;
App.EditUserName = flowList[i].EDITUSERNAME;
flowAppList.Add(App);
}
checkState = ((int)CheckStates.Approving).ToString();
RoomAppsList = RoomAppBll.GetMeetingRoomAppInfosByFlow(pageIndex, pageSize, sort, filterString, paras, ref pageCount, flowAppList, checkState, loginUserInfo.userID);
}
return RoomAppsList != null ? RoomAppsList.ToList() : null;
}
}
///根据开始时间、结束时间获取审核通过的会议室申请信息
public List<T_OA_MEETINGROOMAPP> GetMeetingRoomAppBySelectRooms(DateTime start, DateTime end, string StrCheckState)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
IQueryable<T_OA_MEETINGROOMAPP> MeetingInfosList = RoomAppBll.GetMeetingRoomAppInfos(start,end,StrCheckState);
if (MeetingInfosList == null)
{
return null;
}
else
{
return MeetingInfosList.ToList();
}
}
}
// 2010-3-23 添加审核状态
public List<T_OA_MEETINGROOMAPP> GetMeetingRoomAppInfos(string StrCheckState)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
List<T_OA_MEETINGROOMAPP> MeetingInfosList = RoomAppBll.GetMeetingRoomAppInfos(StrCheckState);
if (MeetingInfosList == null)
{
return null;
}
else
{
return MeetingInfosList;
}
}
}
public T_OA_MEETINGROOMAPP GetMeetingRoomAppSingleInfoByAppId(string StrRoomAppId)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
return RoomAppBll.GetMeetingRoomAppInfoById(StrRoomAppId);
}
}
public string MeetingRoomAppUpdate(T_OA_MEETINGROOMAPP obj)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
return RoomAppBll.UpdateMeetingRoomAppInfo(obj);
}
}
//批量删
public bool MeetingRoomAppBatchDel(string[] StrRoomAppIDs)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
return RoomAppBll.BatchDeleteMeetingRoomAppInfo(StrRoomAppIDs);
}
}
public bool MeetingRoomAppInfoDel(string StrRoomAppInfoID)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
return RoomAppBll.DeleteMeetingRoomAppInfo(StrRoomAppInfoID);
}
}
private bool IsExistMeetingRoomJustUsing(string StrRoomName, DateTime startdt, DateTime enddt)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
return RoomAppBll.GetMeetingRoomJustUsingByRoomStartEnd(StrRoomName, startdt, enddt);
}
}
private bool IsExistMeetingRoomAppInfoByAdd(string StrRoomName, string StrDepartment, DateTime startdt, DateTime enddt, string StrCreateUserID)
{
using (MeetingRoomAppManagementBll RoomAppBll = new MeetingRoomAppManagementBll())
{
return RoomAppBll.GetMeetingRoomAppInfoByRoomStartEnd(StrRoomName, StrDepartment, startdt, enddt, StrCreateUserID);
}
}
