} // 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()
