}// 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 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 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
} // 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 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 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
/// <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 ExcelTsql
/// <summary>
/// 将填充的DataSet写入Sql中
/// </summary>
/// <param name="ConID">会议ID</param>
/// 作者：吴若彤
/// 创建时间：2014-9-22
/// 修改时间：2014-9-22
public void ExcelToSqlFill(int ConID)
{
DataSet ds = ExcelTsql();
SqlConnection sqlConn = SqlHelperDB.GetConnection();
for (int i = 0; i < ds.Tables["table"].Rows.Count; i++)
{
string sqlcmdstring = String.Format("Insert into OutConMember values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", ConID, ds.Tables["table"].Rows[i][1], ds.Tables["table"].Rows[i][2], ds.Tables["table"].Rows[i][3], ds.Tables["table"].Rows[i][4], ds.Tables["table"].Rows[i][5], ds.Tables["table"].Rows[i][0], '0');
SqlCommand cmd = new SqlCommand(sqlcmdstring, sqlConn);
DB.SqlHelperDB.ExecuteSql(DB.SqlHelperDB.ConnectionString, sqlcmdstring);
}
sqlConn.Close();
} //function ExcelToSqlFill
/// <summary>
/// 向数据库会议资料存储表中插入一条新信息
/// </summary>
/// <param name="obj">一条新的会议资料存储信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool AddARecord(object obj)
{
try
{
ConferenceDocModel ConferenceDoc = (ConferenceDocModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("insert into ConferenceDoc values('{0}','{1}')", ConferenceDoc.ConID, ConferenceDoc.ConDataRoute);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function AddARecord
} // function AddARecord
/// <summary>
/// 从数据库会议表中删除新信息
/// </summary>
/// <param name="obj">要删除的会议信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool DelARecord(object obj)
{
try
{
ConferenceModel Conference = (ConferenceModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("Delete from Conference where ConId ='{0}'", Conference.ConId);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
} // function DelARecord
} // function AddARecord
/// <summary>
/// 数据库外部与会人员表中删除一条信息
/// </summary>
/// <param name="obj">要删除的外部与会人员信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool DelARecord(object obj)
{
try
{
OutConMemberModel OutConMember = (OutConMemberModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("Delete from OutConMember where ConId ='{0}'", OutConMember.ConId);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function DelARecord
} // function AddARecord
/// <summary>
/// 从数据库会议资料存储表中删除一条信息
/// </summary>
/// <param name="obj">要删除的会议资料存储信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool DelARecord(object obj)
{
try
{
ConferenceDocModel ConferenceDoc = (ConferenceDocModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("Delete from ConferenceDoc where ConId ='{0}'", ConferenceDoc.ConID);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function DelARecord
} // function AddARecord
/// <summary>
/// 从数据库员工表中删除一条信息
/// </summary>
/// <param name="obj">要删除的员工信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool DelARecord(object obj)
{
try
{
EmployeeModel Employee = (EmployeeModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("Delete from Employee where EmId ='{0}'", Employee.EmId);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function DelARecord
/// <summary>
/// 向数据库内部与会人员表中插入一条新信息
/// </summary>
/// <param name="obj">一条新的内部与会人员信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool AddARecord(object obj)
{
try
{
InConMemberModel InConMember = (InConMemberModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("insert into InconMember values('{0}','{1}','{2}')",
InConMember.ConId, InConMember.ConEmId, InConMember.ConRegister);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function AddARecord
} // 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 DelARecord
/// <summary>
/// 从数据库会议资料存储表中修改一条信息
/// </summary>
/// <param name="obj">要修改的会议资料存储信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool UpdateARecord(object obj)
{
try
{
ConferenceDocModel ConferenceDoc = (ConferenceDocModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("update ConferenceDoc set ConDataRoute='{1}' where ConID='{0}'",
ConferenceDoc.ConID, ConferenceDoc.ConDataRoute);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function UpdateARecord
} // function DelARecord
/// <summary>
/// 向数据库内部与会人员表中修改信息
/// </summary>
/// <param name="obj">要修改的内部与会人员信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool UpdateARecord(object obj)
{
try
{
InConMemberModel InConMember = (InConMemberModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("update InConMember set ConRegister='{2}' where ConId ='{0}'and ConEmId='{1}'",
InConMember.ConId, InConMember.ConEmId, InConMember.ConRegister);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function UpdateARecord
/// <summary>
/// 向数据库外部与会人员表中插入一条新信息
/// </summary>
/// <param name="obj">一条新的外部与会人员信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool AddARecord(object obj)
{
try
{
OutConMemberModel OutConMember = (OutConMemberModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("insert into OutConMember values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')",
OutConMember.ConId, OutConMember.ConName, OutConMember.ConSex, OutConMember.ConDuties,
OutConMember.ConPhone, OutConMember.ConEmail, OutConMember.ConCompany, OutConMember.ConRegister);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function AddARecord
/// <summary>
/// 向数据库员工表中插入一条新信息
/// </summary>
/// <param name="obj">一条新的员工信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool AddARecord(object obj)
{
try
{
EmployeeModel Employee = (EmployeeModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format("insert into Employee values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')",
Employee.EmId, Employee.EmName, Employee.EmSex, Employee.EmDepart,
Employee.EmPhone, Employee.EmEmail, Employee.EmCompany, Employee.EmDuties);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function AddARecord
}// 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="obj">要修改员工信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool UpdateARecord(object obj)
{
try
{
EmployeeModel Employee = (EmployeeModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format(@"update Employee set EmName='{1}',EmSex='{2}', EmDepart='{3}',EmPhone='{4}',
EmEmail='{5}', EmCompany='{6}', EmDuties='{7}' where EmId='{0}'",
Employee.EmId, Employee.EmName, Employee.EmSex, Employee.EmDepart,
Employee.EmPhone, Employee.EmEmail, Employee.EmCompany, Employee.EmDuties);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function UpdateARecord
/// <summary>
/// 向数据库会议资源表中插入一条新信息
/// </summary>
/// <param name="obj">一条新的会议资源信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-17
/// 修改时间：
public bool AddARecord(object obj)
{
try
{
ConUseResourceModel ConUseResource = (ConUseResourceModel)obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format("insert into ConUseResource values('{0}','{1}')",
ConUseResource.ConId, ConUseResource.DeviceId);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return true;
}
catch
{
throw new Exception();
} // try
} // function AddRecord
} // function AddRecord
/// <summary>
/// 向数据库会议资源表中删除一条新信息
/// </summary>
/// <param name="obj">要删除的会议资源信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-17
/// 修改时间：
public bool DelARecord(object obj)
{
try
{
ConUseResourceModel ConUseResource = (ConUseResourceModel)obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format("delete from ConUseResource where ConId = '{0}'",
ConUseResource.ConId);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return true;
}
catch
{
throw new Exception();
} // try
} // function DelRecord
} // function AddRecord
/// <summary>
/// 向数据库会议议题室表中删除一条信息
/// </summary>
/// <param name="obj">要删除的议题信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-16
/// 修改时间：
public bool DelARecord(object obj)
{
try
{
TopicModel topic = (TopicModel)obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format("delete from topic where topicid = '{0}'", topic.TopicId);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch
{
throw new Exception();
// return false;
} // try
} //function DelARecord
} // function AddRecord
/// <summary>
/// 向数据库会议室表中删除一条信息
/// </summary>
/// <param name="obj">要删除的会议室信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-16
/// 修改时间：
public bool DelARecord(object obj)
{
try
{
BoardroomModel boardroom = (BoardroomModel)obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format("delete from boardroom where bdrid = '{0}'", boardroom.BdrId);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return true;
}
catch
{
throw new Exception();
//return false;
} // try
} //function DelARecord
} // function DelARecord
/// <summary>
/// 向数据库外部与会人员表中修改信息
/// </summary>
/// <param name="obj">要修改的外部与会人员信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool UpdateARecord(object obj)
{
try
{
OutConMemberModel OutConMember = (OutConMemberModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format(@"update OutConMember set
ConName='{1}',ConSex='{2}', ConDuties='{3}',ConPhone='{4}',
ConEmail='{5}', ConCompany='{6}', ConRegister='{7}' where ConID='{0}'",
OutConMember.ConId, OutConMember.ConName, OutConMember.ConSex, OutConMember.ConDuties,
OutConMember.ConPhone, OutConMember.ConEmail, OutConMember.ConCompany, OutConMember.ConRegister);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function UpdateARecord
} // function AddRecord
/// <summary>
/// 向数据库资源表中修改一条新信息
/// </summary>
/// <param name="obj">要修改的资源信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-17
/// 修改时间：
public bool UpdateARecord(object obj)
{
try
{
ResourceModel resource = (ResourceModel)obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format("update resource set resourcestatus = '{1}',resourceclass='{2}'where resourceid = '{0}'"
,resource .ResourceId ,resource .ResourceStatus ,resource .ResourceClass );
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return true;
}
catch
{
throw new Exception();
// return false;
} // try
} // function AddRecord
} // function AddRecord
/// <summary>
/// 向数据库资源表中删除一条新信息
/// </summary>
/// <param name="obj">要删除的资源信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-17
/// 修改时间：
public bool DelARecord(object obj)
{
try
{
ResourceModel resource = (ResourceModel)obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format("delete from resource where resourceId = '{0}'",
resource.ResourceId);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return true;
}
catch
{
throw new Exception();
// return false;
} // try
} // function AddRecord
/// <summary>
/// 向数据库资源表中插入一条新信息
/// </summary>
/// <param name="obj">一条新的资源信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-17
/// 修改时间：
public bool AddARecord(object obj)
{
try
{
ResourceModel resource = (ResourceModel)obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format("insert into resource values('{0}','{1}')",
resource .ResourceStatus,resource.ResourceClass);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return true;
}
catch (Exception ex)
{
throw new Exception(ex.Message );
// return false;
} // try
} // function AddRecord
} // 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()
