/// <summary>
/// 添加问题库数据
/// </summary>
/// <returns></returns>
public static int InsertIssue_library(Issue_library obj)
{
int n = DBHelper.ExecuteNonQuery("Insert_Issue_library", CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@IssueI_Name", obj.IssueI_Name)
});
return(n);
}
/// <summary>
/// 获取全部问题库信息
/// </summary>
/// <returns></returns>
public static List <Issue_library> GetAllIssue_library()
{
List <Issue_library> list = new List <Issue_library>();
SqlDataReader dr = DBHelper.ExecuteReader("Select_Issue_library", CommandType.StoredProcedure);
while (dr.Read())
{
Issue_library obj = new Issue_library()
{
IssueI_Name = dr["IssueI_Name"].ToString(),
IssueI_No = Convert.ToInt32(dr["IssueI_No"])
};
list.Add(obj);
}
dr.Close();
DBHelper.CloseCon();
return(list);
}
/// <summary>
/// 根据条件查询问题库信息
/// </summary>
/// <returns></returns>
public static Issue_library GetIssue_libraryByConn(string demandType, string demandContent)
{
string sql = "Select * from Issue_library where " + demandType + " = @" + demandType;
Issue_library obj = new Issue_library();
SqlDataReader dr = DBHelper.ExecuteReader(sql, CommandType.Text, new SqlParameter[] {
new SqlParameter("@" + demandType, demandContent)
});
if (dr.Read())
{
obj = new Issue_library()
{
IssueI_Name = dr["IssueI_Name"].ToString(),
IssueI_No = Convert.ToInt32(dr["IssueI_No"])
};
}
dr.Close();
DBHelper.CloseCon();
return(obj);
}
/// <summary>
/// 删除问题库数据
/// </summary>
/// <returns></returns>
public static int DeleteIssue_library(Issue_library obj)
{
return(Issue_library_Server.DeleteIssue_library(obj));
}
/// <summary>
/// 修改问题库数据
/// </summary>
/// <returns></returns>
public static int UpdateIssue_library(Issue_library obj)
{
return(Issue_library_Server.UpdateIssue_library(obj));
}
/// <summary>
/// 添加问题库数据
/// </summary>
/// <returns></returns>
public static int InsertIssue_library(Issue_library obj)
{
return(Issue_library_Server.InsertIssue_library(obj));
}
