//添加一条课程信息
public bool Add(Bap_Course Bap_Course)
{
DatabaseAccess database = new DatabaseAccess();
String sql = String.Format(@"insert into Bap_Course(Course_Name,Staff_num,Teacher_Name,Department,Hours,Class_Time,Class_Week,Total_Week,Is_Week,Class_Addr,Classes) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')",
Bap_Course.Course_Name, Bap_Course.Staff_num, Bap_Course.Teacher_Name, Bap_Course.Department, Bap_Course.Hours,
Bap_Course.Class_Time, Bap_Course.Class_Week, Bap_Course.Total_Week, Bap_Course.Is_Week, Bap_Course.Class_Addr, Bap_Course.Classes);
return database.executeUpdate(sql);
}
/// <summary>
/// 插入一条数据到数据库
/// </summary>
/// <param name="path">Xpath的对象</param>
/// <returns></returns>
public Boolean insert(Xpath path)
{
Boolean insert = false;
DatabaseAccess database = new DatabaseAccess();
String sql = "insert into xpath(id,websitename,weblanguage,baseurl,cntitle,entitle,unit,types,author,articletype,source,language,journalname,publishtime,levels,recordtype,forbid) values(NewId(),'"
+ path.Websitename + "','" + path.Weblanguage + "','" + path.Baseurl + "','" + path.Cntitle + "','" + path.Entitle + "','" + path.Unit + "','" + path.Types + "','" + path.Author + "','" + path.Articletype + "','" + path.Source + "','" + path.Language + "','" + path.Journalname + "','" + path.Publishtime + "','" + path.Levels + "','" + path.Recordtype + "',0)";
try {
insert = database.executeUpdate(sql);
} catch (Exception e) {
throw new Exception(e.Message);
} finally {
database.close();
}
return insert;
}
/// <summary>
/// 更新整个数据的内容
/// </summary>
/// <param name="path">xpath的实例</param>
/// <returns></returns>
public Boolean update(Xpath path)
{
Boolean update = false;
DatabaseAccess database = new DatabaseAccess();
string sql = "update xpath set websitename='" + path.Websitename + "',weblanguage='" + path.Weblanguage + "',baseurl='" + path.Baseurl + "',cntitle='" + path.Cntitle + "',entitle='" + path.Entitle + "',unit='" + path.Unit + "',author='" + path.Author + "',types='" + path.Types + "',articletype='" + path.Articletype + "',source='" + path.Source + "',language='" + path.Language + "',journalname='" + path.Journalname + "',publishtime='" + path.Publishtime + "',levels='" + path.Levels + "',recordtype='" + path.Recordtype + "',forbid=" + path.Forbid + " where id='" + path.Id+"'";
try {
update = database.executeUpdate(sql);
} catch (Exception e) {
throw new Exception(e.Message);
}
return update;
}
/// <summary>
/// 更新规则是否启用
/// </summary>
/// <param name="ids">id的批量字符串表示形式</param>
/// <param name="forbid">是否启用1表示启用， 0表示禁止</param>
/// <returns></returns>
public Boolean update(string ids,int forbid)
{
Boolean update = false;
DatabaseAccess database = new DatabaseAccess();
string sql = "update xpath set forbid=" + forbid + " where id in (" + ids + ")";
try {
update = database.executeUpdate(sql);
} catch (Exception e) {
throw new Exception(e.Message);
} finally {
database.close();
}
return update;
}
/// <summary>
/// 插入一条新的论文记录到数据库
/// </summary>
/// <param name="treatise"></param>
/// <returns></returns>
public Boolean insert(Treatise treatise)
{
Boolean insert = false;
DatabaseAccess database = new DatabaseAccess();
String sql = "insert into treatise (id,articleurl,sourceid,cntitle,entitle,unitname,types,author,articletype,source,language,journalname,publishtime,levels,recordtype) values(NewId(),'"+
treatise.Articleurl+"','"+treatise.Sourceid+"','"+ treatise.Cntitle + "','" + treatise.Entitle + "','" + treatise.Unitname + "','" + treatise.Types + "','" + treatise.Author + "','" + treatise.Articletype + "','" + treatise.Source + "','" + treatise.Language + "','" + treatise.Journalname + "','" + treatise.Publishtime + "','" + treatise.Levels + "','" + treatise.Recordtype + "')";
try{
insert = database.executeUpdate(sql);
}
catch (Exception e){
throw new Exception(e.Message);
} finally {
database.close();
}
return insert;
}
//根据ID保存修改后的课程信息
public bool SaveById(Bap_Course Bap_Course)
{
DatabaseAccess database = new DatabaseAccess();
String sql = String.Format(@"update Bap_Course set
Course_Name='{0}',
Staff_num='{1}',
Teacher_Name='{2}',
Department='{3}',
Hours='{4}',
Class_Time='{5}',
Class_Week='{6}',
Total_Week='{7}',
Is_Week='{8}',
Class_Addr='{9}',
Classes='{10}' where id='" + Convert.ToInt32(Bap_Course.Id) + "'",
Bap_Course.Course_Name,
Bap_Course.Staff_num,
Bap_Course.Teacher_Name,
Bap_Course.Department,
Bap_Course.Hours,
Bap_Course.Class_Time,
Bap_Course.Class_Week,
Bap_Course.Total_Week,
Bap_Course.Is_Week,
Bap_Course.Class_Addr,
Bap_Course.Classes);
return database.executeUpdate(sql);
}