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