public List <RoomModelQuery> GetMeetRoomUseStatus(string roomCode, string begin, string end, LoadType lt)
{
List <RoomModelQuery> list = new List <RoomModelQuery>();
List <RoomModelQuery> list2 = new List <RoomModelQuery>();
list = new ConferenceManageDAL(new SqlConnection(FunctionRule.GetConnectionString())).GetRoomUseStatus(roomCode, begin, end);
if ((list != null) && (list.Count != 0))
{
foreach (RoomModelQuery query in list)
{
query.RoomCode = int.Parse(roomCode);
query.RoomName = GetMeetRoomName(roomCode);
query.TimeAge = this.ChangeTimeArea(query.TimeAge);
query.ChaterMember = this.GetUserName(query.ChaterMember);
if (lt.Equals(LoadType.Search))
{
query.Message = string.Format("<a href=\"#\" onclick=\"OpenLargeWindow('../RmsOA/XZ_Conference.aspx?Code={0}&Type=Read','')\">{1}</a>", query.MeetCode, query.ChaterMember);
}
else
{
query.Message = query.ChaterMember;
}
list2.Add(query);
}
}
return(list2);
}
public List <ConferenceManageModel> GetUserAdayMeet(DateTime dt, string userCode)
{
List <ConferenceManageModel> list = new List <ConferenceManageModel>();
ConferenceManageDAL edal = new ConferenceManageDAL(new SqlConnection(FunctionRule.GetConnectionString()));
Dictionary <string, DateTime> dayBeginAndEnd = this.GetDayBeginAndEnd(dt);
return(edal.GetUserMeet(userCode, dayBeginAndEnd["DateBegin"], dayBeginAndEnd["DateEnd"]));
}
public int Update(ConferenceManageModel ObjModel, SqlTransaction Transaction)
{
ConferenceManageDAL edal = new ConferenceManageDAL(Transaction);
return(edal.Update(ObjModel));
}
public int Insert(ConferenceManageModel ObjModel, SqlTransaction Transaction)
{
ConferenceManageDAL edal = new ConferenceManageDAL(Transaction);
return(edal.Insert(ObjModel));
}
public List <ConferenceManageModel> GetModels(ConferenceManageQueryModel ObjQueryModel, SqlTransaction Transaction)
{
ConferenceManageDAL edal = new ConferenceManageDAL(Transaction);
return(edal.Select(ObjQueryModel));
}
public List <ConferenceManageModel> GetModels(SqlTransaction Transaction)
{
ConferenceManageDAL edal = new ConferenceManageDAL(Transaction);
return(edal.Select());
}
public ConferenceManageModel GetModel(int Code, SqlTransaction Transaction)
{
ConferenceManageDAL edal = new ConferenceManageDAL(Transaction);
return(edal.GetModel(Code));
}
public ConferenceManageModel GetModel(int Code, SqlConnection Connection)
{
ConferenceManageDAL edal = new ConferenceManageDAL(Connection);
return(edal.GetModel(Code));
}
public int Delete(int Code, SqlTransaction Transaction)
{
ConferenceManageDAL edal = new ConferenceManageDAL(Transaction);
return(edal.Delete(Code));
}
public static string BuildQueryString(string topic, string startTime, string endTime, string dept, string place, string chaterMember)
{
return(ConferenceManageDAL.BuildQueryString(topic, startTime, endTime, dept, place, chaterMember));
}
