} // function GetARecord /// <summary> /// 从数据库员工表中获取所有信息 /// </summary> /// <returns>返回员所有工信息</returns> /// 作者:王宇昊 /// 创建时间:2014-09-20 /// 修改时间: public List <EmployeeModel> GetAllRecord() { List <EmployeeModel> Employeelist = new List <EmployeeModel>(); string strSqlCmd;// 存储数据库命令语句 strSqlCmd = string.Format(@"select * from Employee"); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd, "Employee"); foreach (DataRow row in data.Tables["Employee"].Rows) { EmployeeModel Employee = new EmployeeModel(); Employee.EmId = Convert.ToInt32(row["EmId"].ToString()); Employee.EmName = row["EmName"].ToString(); Employee.EmSex = row["EmSex"].ToString(); Employee.EmDepart = row["EmDepart"].ToString(); Employee.EmPhone = row["EmPhone"].ToString(); Employee.EmEmail = row["EmEmail"].ToString(); Employee.EmCompany = row["EmCompany"].ToString(); Employee.EmDuties = row["EmDuties"].ToString(); Employee.EmPassword = row["EmPassword"].ToString(); Employee.EmPermission = row["EmPermission"].ToString(); Employeelist.Add(Employee); } return(Employeelist); } // function GetAllRecord
} // function UpdateARecord /// <summary> /// 获取外部参会者的信息 /// </summary> /// <param name="conId">会议ID</param> /// <returns>返回外部参会者</returns> /// 作者:王宇昊 /// 创建时间:2014-09-19 /// 修改时间: public List <OutConMemberModel> GetConRecord(int conId) { try { List <OutConMemberModel> OutConMemberList = new List <OutConMemberModel>(); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, "select * from OutConMember where Conid='" + conId + "'", "OutConMember"); foreach (DataRow row in data.Tables["OutConMember"].Rows) { OutConMemberModel ConMember = new OutConMemberModel(); ConMember.ConId = Convert.ToInt32(row["ConId"].ToString()); ConMember.ConName = row["ConName"].ToString(); ConMember.ConSex = row["ConSex"].ToString(); ConMember.ConDuties = row["ConDuties"].ToString(); ConMember.ConPhone = row["ConPhone"].ToString(); ConMember.ConEmail = row["ConEmail"].ToString(); ConMember.ConCompany = row["ConCompany"].ToString(); ConMember.ConRegister = char.Parse(row["ConRegister"].ToString()); OutConMemberList.Add(ConMember); } return(OutConMemberList); } catch { throw new Exception(); } }// function GetConRecord
} // function AddRecord /// <summary> /// 获取所有资源信息 /// </summary> /// <returns>一组资源信息</returns> /// 作者:王宇昊 /// 创建时间:2014-09-20 /// 修改时间: public List<ResourceModel> GetAllRecord() { try { List<ResourceModel> Resourcelist = new List<ResourceModel>(); string strSqlCmd;// 存储数据库命令语句 strSqlCmd = string.Format(@"select * from Resource"); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd, "Resource"); foreach (DataRow row in data.Tables["Resource"].Rows) { ResourceModel Resource = new ResourceModel(); Resource.ResourceId = Convert.ToInt32(row["ResourceId"].ToString()); Resource.ResourceStatus = char.Parse(row["ResourceStatus"].ToString()); Resource.ResourceClass = row["ResourceClass"].ToString(); Resourcelist.Add(Resource); } return Resourcelist; } catch { throw new Exception(); // return false; } // try }
}// function GetInConRecord /// <summary> /// 获取内部参会者的员工信息 /// </summary> /// <param name="conId">会议ID</param> /// <returns>返回内部参会者</returns> /// 作者:王宇昊 /// 创建时间:2014-09-18 /// 修改时间: public List <EmployeeModel> GetConRecord(int conId) { try { List <InConMemberModel> InConMemberList = new List <InConMemberModel>(); List <EmployeeModel> EmployeeList = new List <EmployeeModel>(); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, "select * from InConMember where Conid='" + conId + "'", "InConMember"); foreach (DataRow row in data.Tables["InConMember"].Rows) { data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, "select * from Employee where Emid='" + Convert.ToInt32(row["ConEmid"].ToString()) + "'", "Employee"); EmployeeModel Employee = new EmployeeModel(); foreach (DataRow rowem in data.Tables["Employee"].Rows) { Employee.EmId = Convert.ToInt32(rowem["EmId"].ToString()); Employee.EmName = rowem["EmName"].ToString(); Employee.EmSex = rowem["EmSex"].ToString(); Employee.EmDepart = rowem["EmDepart"].ToString(); Employee.EmPhone = rowem["EmPhone"].ToString(); Employee.EmEmail = rowem["EmEmail"].ToString(); Employee.EmCompany = rowem["EmCompany"].ToString(); Employee.EmDuties = rowem["EmDuties"].ToString(); Employee.EmPassword = rowem["EmPassword"].ToString(); Employee.EmPermission = rowem["EmPermission"].ToString(); EmployeeList.Add(Employee); } // } return(EmployeeList); } catch (Exception ex) { throw new Exception(ex.Message); } }// function GetConRecord
}//function IsConExist /// <summary> /// 判断会议室当前时段是否存在会议 /// </summary> /// <param name="bdrId">会议室ID</param> /// <param name="bdrId">开始时间</param> /// <param name="bdrId">结束时间</param> /// <returns>操作成功返回true,失败返回false</returns> /// 作者:王宇昊 /// 创建时间:2014-09-19 /// 修改时间: public bool IsConExist(int bdrId,DateTime start ,DateTime end) { try { string strSqlCmd; // sql命令存放语句 strSqlCmd = string.Format("select * from Conference where ConPlace='{0}' and ConStartTime < '{2}' and ConEndTime > '{1}'", bdrId, start.ToString("yyyy-MM-dd HH:mm:ss"), end.ToString("yyyy-MM-dd HH:mm:ss")); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd, "Conference"); List<ConferenceModel> ConferenceList = new List<ConferenceModel>(); foreach (DataRow row in data.Tables["Conference"].Rows) { ConferenceModel Conference = new ConferenceModel(); ConferenceList.Add(Conference); } if (ConferenceList.Count > 0) { return true ; } else { return false; } } catch (Exception ex) { throw new Exception(ex.Message); } }//function IsConExist
} // function UpdateRecord /// <summary> /// 向数据库会议资源表中查询与某一会议相关的信息 /// </summary> /// <param name="conId">会议id</param> /// <returns>一组资源信息</returns> /// 作者:王宇昊 /// 创建时间:2014-09-19 /// 修改时间: public List<ConUseResourceModel> GetUseResource(int conId) { try { List<ConUseResourceModel> UseResourceList = new List<ConUseResourceModel> (); string strSqlCmd;// 存储数据库命令语句 strSqlCmd = string.Format(@"select * from ConUseResource where ConId = '" + conId + "'"); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd, "ConUseResource"); foreach (DataRow row in data.Tables["ConUseResource"].Rows) { ConUseResourceModel ConUse = new ConUseResourceModel(); ConUse.ConId = Convert.ToInt32(row["ConId"].ToString()); ConUse.DeviceId =Convert.ToInt32( row["DeViceId"].ToString()); UseResourceList.Add(ConUse); } return UseResourceList; } catch (Exception ex) { throw new Exception(ex.Message); } // try }// function GetUseResource
/// <summary> /// 获取指定时段内可以使用资源信息 /// </summary> /// <returns>一组资源信息</returns> /// 作者:张衡 /// 创建时间:2014-09-20 /// 修改时间: public List<ResourceModel> GetCanUseRecord(DateTime startTime, DateTime endTime) { List<ResourceModel> rscList = new List<ResourceModel>(); string strSqlCmd = string.Format("select * from Resource where ResourceStatus = '{0}'", 0); DataSet rsc = SqlHelperDB.GetDataSet(SqlHelperDB.ConnectionString, strSqlCmd, "Resource"); foreach (DataRow rscRow in rsc.Tables["Resource"].Rows) { ResourceModel Resource = new ResourceModel(); Resource.ResourceId = Convert.ToInt32(rscRow["ResourceId"].ToString()); Resource.ResourceStatus = char.Parse(rscRow["ResourceStatus"].ToString()); Resource.ResourceClass = rscRow["ResourceClass"].ToString(); rscList.Add(Resource); } // end foreach return rscList; //// 查询 会议表 找到不在该时段的会议ID //string strSqlCmd = string.Format("select * from Conference where ConStartTime > '{0}' or ConEndTime < '{1}'", // endTime.ToString("yyyy/MM/dd HH:mm:ss"), startTime.ToString("yyyy/MM/dd HH:mm:ss")); //DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd, "Conference"); //if (data.Tables["Conference"].Rows.Count == 0) // 该时段外没有会议(在一个可用时段外没有会议) //{ // rscList = GetAllRecord(); //} //else //{ // // 用不在该时段的会议id,找到不在该时段使用的资源的id // foreach (DataRow row in data.Tables["Conference"].Rows) // { // strSqlCmd = string.Format("select * from ConUseResource where ConId = '{0}'", row["ConId"].ToString()); // DataSet rscData = SqlHelperDB.GetDataSet(SqlHelperDB.ConnectionString, strSqlCmd, "ConUseResource"); // // 根据找到的id在资源表里查询相应的资源 // foreach (DataRow useRscRow in rscData.Tables["ConUseResource"].Rows) // { // strSqlCmd = string.Format("select * from Resource where ResourceId = '{0}'", int.Parse(useRscRow["DeviceId"].ToString())); // DataSet rsc = SqlHelperDB.GetDataSet(SqlHelperDB.ConnectionString, strSqlCmd, "Resource"); // foreach (DataRow rscRow in rsc.Tables["Resource"].Rows) // { // ResourceModel Resource = new ResourceModel(); // Resource.ResourceId = Convert.ToInt32(rscRow["ResourceId"].ToString()); // Resource.ResourceStatus = char.Parse(rscRow["ResourceStatus"].ToString()); // Resource.ResourceClass = rscRow["ResourceClass"].ToString(); // rscList.Add(Resource); // } // end foreach // } // end foreach // } // end foreach //} // end if //return rscList; } // function GetCanUseRecord
} // function GetAllRecord /// <summary> /// 从数据库员工表中获取所有部门信息 /// </summary> /// <returns>返回员所有工信息</returns> /// 作者:张衡 /// 创建时间:2014-09-20 /// 修改时间: public List <EmployeeModel> GetAllDepart() { List <EmployeeModel> Employeelist = new List <EmployeeModel>(); string strSqlCmd;// 存储数据库命令语句 strSqlCmd = string.Format(@"select distinct emdepart from Employee"); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd, "Employee"); foreach (DataRow row in data.Tables["Employee"].Rows) { EmployeeModel Employee = new EmployeeModel(); Employee.EmDepart = row["EmDepart"].ToString(); Employeelist.Add(Employee); } return(Employeelist); } // function GetAllDepart
}// function GetConRecord /// <summary> /// 按照用户ID查找会议信息 /// </summary> /// <param name="employee">用户实体类对象</param> /// <returns>会议列表</returns> /// 作者:张衡 /// 创建时间:2014-09-18 /// 修改时间: public List <ConferenceModel> GetConferenceByUserId(EmployeeModel employee) { try { List <ConferenceModel> list = new List <ConferenceModel>(); // 存放用于返回的会议信息列表 // 查找与指定用户相关的会议id string strSqlCmd = string.Format("select * from InConMember where ConEmId = '{0}'", employee.EmId); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd, "InConMember"); foreach (DataRow row in data.Tables["InConMember"].Rows) { // 根据会议id获取会议信息 strSqlCmd = string.Format("select * from Conference where ConId = '{0}'", row["ConId"]); DataSet conData = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd, "Conference"); foreach (DataRow conRow in conData.Tables["Conference"].Rows) { ConferenceModel Conference = new ConferenceModel(); Conference.ConId = Convert.ToInt32(conRow["ConId"].ToString()); Conference.ConName = conRow["ConName"].ToString(); Conference.ConPlace = Convert.ToInt32(conRow["ConPlace"].ToString()); Conference.ConStartTime = (DateTime)conRow["ConStartTime"]; Conference.ConEndTime = (DateTime)conRow["ConEndTime"]; Conference.ConHost = conRow["ConHost"].ToString(); Conference.ConType = char.Parse(conRow["ConType"].ToString()); Conference.ConStatus = char.Parse(conRow["ConStatus"].ToString()); Conference.ConSubMen = Convert.ToInt32(conRow["ConSubMen"].ToString()); Conference.ConRecordMen = Convert.ToInt32(conRow["ConRecordMen"].ToString()); Conference.ConStaffMen = int.Parse(conRow["ConStaffMen"].ToString()); Conference.ConRegister = char.Parse(conRow["ConRegister"].ToString()); Conference.ConIsDone = char.Parse(conRow["ConIsDone"].ToString()); Conference.ConOthers = conRow["ConOthers"].ToString(); list.Add(Conference); } // end foreach } // end foreach return(list); } catch (Exception ex) { throw new Exception(ex.Message); } } // function GetConferenceByUserId
} // function DelARecord /// <summary> /// 获取表中所有记录 /// </summary> /// <param name="sqlItem">要获取的记录</param> /// <returns>返回ConferenceList</returns> /// 作者:朱健 /// 创建时间:2014-09-18 /// 修改时间:2014-09-18 /// 修改时间:2014-09-19 public List <ConferenceModel> GetAllRecord(string sqlItems) { try { List <ConferenceModel> ConferenceList = new List <ConferenceModel>(); string strSqlCmd = string.Format(@"select * from Conference where Conid like '%{0}%' or ConName like '%{0}%' or ConPlace like '%{0}%' or ConStartTime like '%{0}%' or ConEndTime like '%{0}%' or ConHost like '%{0}%' or ConType like '%{0}%' or ConStatus like '%{0}%' or ConSubMen like '%{0}%' or ConRecordMen like '%{0}%' or ConStaffMen like '%{0}%' or ConRegister like '%{0}%' or ConIsDone like '%{0}%'", sqlItems); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd, "Conference"); foreach (DataRow row in data.Tables["Conference"].Rows) { ConferenceModel Conference = new ConferenceModel(); Conference.ConId = Convert.ToInt32(row["ConId"].ToString()); Conference.ConName = row["ConName"].ToString(); Conference.ConPlace = Convert.ToInt32(row["ConPlace"].ToString()); Conference.ConStartTime = (DateTime)row["ConStartTime"]; Conference.ConEndTime = (DateTime)row["ConEndTime"]; Conference.ConHost = row["ConHost"].ToString(); Conference.ConType = char.Parse(row["ConType"].ToString()); Conference.ConStatus = char.Parse(row["ConStatus"].ToString()); Conference.ConSubMen = Convert.ToInt32(row["ConSubMen"].ToString()); Conference.ConRecordMen = Convert.ToInt32(row["ConRecordMen"].ToString()); Conference.ConStaffMen = int.Parse(row["ConStaffMen"].ToString()); Conference.ConRegister = char.Parse(row["ConRegister"].ToString()); Conference.ConIsDone = char.Parse(row["ConIsDone"].ToString()); Conference.ConOthers = row["ConOthers"].ToString(); ConferenceList.Add(Conference); } return(ConferenceList); } catch (Exception ex) { throw new Exception(ex.Message); } }//function GetAllRecord()
} //function DelARecord /// <summary> /// 获取表中所有记录 /// </summary> /// <param name="sqlItems">要获取的记录</param> /// <returns>返回TopicList</returns> /// 作者:朱健 /// 创建时间:2014-09-18 /// 修改时间:2014-09-18 /// 修改时间:2014-09-19 public List <TopicModel> GetAllRecord(string sqlItems) { try { List <TopicModel> TopicList = new List <TopicModel>(); string strSqlCmd = string.Format(@"select * from Topic where TopicId like '%{0}%' or TopicApplicantId like '%{0}%' or TopicSubTime like '%{0}%' or TopicVerifyTime like '%{0}%' or TopicHead like '%{0}%' or TopicContent like '%{0}%' or TopicStatus like '%{0}%'", sqlItems); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd, "Topic"); foreach (DataRow row in data.Tables["Topic"].Rows) { TopicModel Topic = new TopicModel(); Topic.TopicId = Convert.ToInt32(row["TopicId"].ToString()); Topic.TopicApplicantId = Convert.ToInt32(row["TopicApplicantId"].ToString()); Topic.TopicSubTime = (DateTime)row["TopicSubTime"]; if ((Object)row["TopicVerifyTime"] != null) { Topic.TopicVerifyTime = (DateTime)row["TopicVerifyTime"]; } Topic.TopicHead = row["TopicHead"].ToString(); Topic.TopicContent = row["TopicContent"].ToString(); Topic.TopicStatus = char.Parse(row["TopicStatus"].ToString()); TopicList.Add(Topic); } return(TopicList); } catch (Exception ex) { throw new Exception(ex.Message); } }//function GetAllRecord()
} // function UpdateARecord /// <summary> /// 获取内部参会者的状态 /// </summary> /// <param name="conId">会议ID</param> /// <returns>返回内部参会者</returns> /// 作者:王宇昊 /// 创建时间:2014-09-22 /// 修改时间: public List <InConMemberModel> GetInConRecord(int conId) { try { List <InConMemberModel> InConMemberList = new List <InConMemberModel>(); InConMemberModel InConMember = new InConMemberModel(); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, "select * from InConMember where Conid='" + conId + "'", "InConMember"); foreach (DataRow row in data.Tables["InConMember"].Rows) { InConMember.ConId = Convert.ToInt32(row["ConId"]); InConMember.ConEmId = Convert.ToInt32(row["EmId"]); InConMember.ConRegister = char.Parse(row["ConRegister"].ToString()); InConMemberList.Add(InConMember); } return(InConMemberList); } catch (Exception ex) { throw new Exception(ex.Message); } }// function GetInConRecord
} //function DelARecord /// <summary> /// 获取表中所有记录 /// </summary> /// <param name="sqlItems">要获取的记录</param> /// <returns>返回BoardroomList</returns> /// 作者:朱健 /// 创建时间:2014-09-18 /// 修改时间:2014-09-18 public List<BoardroomModel> GetAllRecord(string sqlItems) { try { List<BoardroomModel> BoardroomList = new List<BoardroomModel>(); string strSqlCmd = string.Format(@"select * from Boardroom where BdrId like '%{0}%' or BdrName like '%{0}%' or BdrContactNum like '%{0}%' or BdrLinkMan like '%{0}%' or BdrContactPhone like '%{0}%' or BdrIntro like '%{0}%' or BdrStatus like '%{0}%' or BdrRemarks like '%{0}%' ", sqlItems); DataSet data = SqlHelperDB.GetDataSet(DB.SqlHelperDB.ConnectionString, strSqlCmd , "Boardroom"); foreach (DataRow row in data.Tables["Boardroom"].Rows) { BoardroomModel boardroom = new BoardroomModel(); boardroom.BdrId = Convert.ToInt32(row["BdrId"].ToString()); boardroom.BdrName = row["BdrName"].ToString(); boardroom.BdrContactNum = int.Parse(row["BdrContactNum"].ToString()); boardroom.BdrLinkMan = row["BdrLinkMan"].ToString(); boardroom.BdrContactPhone = row["BdrContactPhone"].ToString(); boardroom.BdrIntro = row["BdrIntro"].ToString(); boardroom.BdrStatus = char.Parse(row["BdrStatus"].ToString()); boardroom.BdrRemarks = row["BdrRemarks"].ToString(); BoardroomList.Add(boardroom); } return BoardroomList; } catch { throw new Exception(); } }//function GetAllRecord()