} // 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
{
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
/// <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
{
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
} // 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
/// <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 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
} // 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
/// <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
/// <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
} // 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
} // 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-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
/// <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-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 DelRecord
/// <summary>
/// 向数据库会议资源表中修改一条新信息
/// </summary>
/// <param name="obj">要修改的会议资源信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-17
/// 修改时间：
public bool UpdateARecord(object obj)
{
try
{
ConUseResourceModel ConUseResource = (ConUseResourceModel)obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format("update ConUseResource set deviceid='{1}'where conid = '{0}'",
ConUseResource.ConId, ConUseResource.DeviceId);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return true;
}
catch (Exception ex)
{
throw new Exception(ex.Message );
} // try
} // function UpdateRecord
} // 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 GetAllRecord()
/// <summary>
/// 向数据库会议室表中修改一条信息
/// </summary>
/// <param name="obj">要x修改的会议室信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-16
/// 修改时间：
public bool UpdateARecord(object obj)
{
try
{
BoardroomModel boardroom = (BoardroomModel)obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format(@"update boardroom set bdrname='{1}',bdrcontactnum='{2}',bdrlinkman='{3}',
bdrcontactphone='{4}',bdrintro='{5}',bdrstatus='{6}',bdrremarks='{7}' where bdrid = '{0}'",
boardroom.BdrId, boardroom.BdrName, boardroom.BdrContactNum, boardroom.BdrLinkMan, boardroom.BdrContactPhone,
boardroom.BdrIntro, boardroom.BdrStatus, boardroom.BdrRemarks);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
} // try
} //function UpdateARecord
/// <summary>
/// 向数据库会议室表中插入一条新信息
/// </summary>
/// <param name="obj">一条新的会议室信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-16
/// 修改时间：
public bool AddARecord(object obj)
{
try
{
BoardroomModel boardroom = (BoardroomModel)obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format("insert into Boardroom values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')",
boardroom.BdrName, boardroom.BdrContactNum, boardroom.BdrLinkMan, boardroom.BdrContactPhone,
boardroom.BdrIntro, boardroom.BdrStatus, boardroom.BdrRemarks);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return true;
}
catch(Exception ex)
{
throw new Exception(ex.Message);
//return false;
} // try
} // function AddRecord
/// <summary>
/// 向数据库会议表中插入一条新信息
/// </summary>
/// <param name="obj">一条新的会议信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool AddARecord(object obj)
{
try
{
ConferenceModel Conference = (ConferenceModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format(@"insert into Conference values('{0}','{1}','{2}','{3}','{4}',
'{5}','{6}','{7}','{8}','{9}',
'{10}','{11}','{12}')",
Conference.ConName, Conference.ConPlace, Conference.ConStartTime.ToString("yyyy-MM-dd HH:mm:ss"),
Conference.ConEndTime.ToString("yyyy-MM-dd HH:mm:ss"), Conference.ConHost, Conference.ConType, Conference.ConStatus,
Conference.ConSubMen, Conference.ConRecordMen, Conference.ConStaffMen, Conference.ConRegister,
Conference.ConIsDone, Conference.ConOthers);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception)
{
return(false);
}
} // function AddARecord
}//function GetAllRecord()
/// <summary>
/// 从数据库会议表中修改一条信息
/// </summary>
/// <param name="obj">要修改的会议信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者:朱健
/// 创建时间:2014-09-16
/// 修改时间:2014-09-17
public bool UpdateARecord(object obj)
{
try
{
ConferenceModel Conference = (ConferenceModel)obj;
string strSqlCmd;// 存储数据库命令语句
strSqlCmd = string.Format(@"update Conference set
ConName='{1}',ConPlace='{2}', ConStartTime='{3}',ConEndTime='{4}',ConHost='{5}',
ConType='{6}', ConStatus='{7}', ConSubMen='{8}', ConRecordMen='{9}',ConStaffMen='{10}',
ConRegister='{11}', ConIsDone='{12}', ConOthers='{13}' where ConId ='{0}'",
Conference.ConId, Conference.ConName, Conference.ConPlace, Conference.ConStartTime.ToString("yyyy-MM-dd HH:mm:ss"), Conference.ConEndTime.ToString("yyyy-MM-dd HH:mm:ss"),
Conference.ConHost, Conference.ConType, Conference.ConStatus, Conference.ConSubMen, Conference.ConRecordMen,
Conference.ConStaffMen, Conference.ConRegister, Conference.ConIsDone, Conference.ConOthers);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
} // function UpdateARecord
/// <summary>
/// 向数据库议题表中插入一条新信息
/// </summary>
/// <param name="obj">一条新的议题信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-16
/// 修改时间：
public bool AddARecord(object obj)
{
try
{
TopicModel topic = (TopicModel )obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format("insert into topic values('{0}','{1}','{2}','{3}','{4}','{5}')",
topic.TopicApplicantId,
topic.TopicSubTime.ToString("yyyy-MM-dd HH:mm:ss"),
topic.TopicVerifyTime.ToString("yyyy-MM-dd HH:mm:ss"),
topic.TopicHead, topic.TopicContent, topic.TopicStatus);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
// return false;
} // try
} // function AddRecord
}//function GetAllRecord()
/// <summary>
/// 向数据库会议议题室表中修改一条信息
/// </summary>
/// <param name="obj">要修改的议题信息</param>
/// <returns>操作成功返回true，失败返回false</returns>
/// 作者：吴欣哲
/// 创建时间:2014-09-16
/// 修改时间：
public bool UpdateARecord(object obj)
{
try
{
TopicModel topic = (TopicModel)obj;
string strSqlCmd; // sql命令存放语句
strSqlCmd = string.Format(@"update topic set TopicApplicantId='{1}', TopicSubTime='{2}', TopicVerifyTime='{3}',
TopicHead='{4}', TopicContent='{5}', TopicStatus= '{6}' where TopicId = '{0}'",
topic.TopicId, topic.TopicApplicantId,
topic.TopicSubTime.ToString("yyyy-MM-dd HH:mm:ss"),
topic.TopicVerifyTime.ToString("yyyy-MM-dd HH:mm:ss"),
topic.TopicHead, topic.TopicContent, topic.TopicStatus);
SqlHelperDB.ExecuteSql(SqlHelperDB.ConnectionString, strSqlCmd);
return(true);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
// return false;
} // try
} //function DelARecord
