/// <summary>
/// 添加解决方案
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_SolutionTableData(Solution_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@P_id", obj.P_id),
new SqlParameter("@S_Content", obj.S_Content),
new SqlParameter("@S_Datetime", obj.S_Datetime),
new SqlParameter("@S_tatle", obj.S_tatle)
}));
}
/// <summary>
/// 获取全部的解决方案
/// </summary>
/// <returns></returns>
public List <Solution_Table> GetSolutionTableAll()
{
List <Solution_Table> list = new List <Solution_Table>();
SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"),
CommandType.StoredProcedure);
while (dr.Read())
{
Solution_Table obj = new Solution_Table()
{
P_id = Convert.ToInt32(dr["P_id"]),
S_Content = dr["S_Content"].ToString(),
S_Datetime = Convert.ToDateTime(dr["S_Datetime"]),
S_id = Convert.ToInt32(dr["S_id"]),
S_tatle = dr["S_tatle"].ToString()
};
list.Add(obj);
}
dr.Close();
return(list);
}
/// <summary>
/// 根据ID查询解决方案信息
/// </summary>
/// <param name="con"></param>
/// <returns></returns>
public Solution_Table GetSolutionTableByConn(string con)
{
Solution_Table obj = null;
SqlDataReader dr = DBHerlper.ExecuteReader(
"Select * from Solution_Table where S_id=@S_id",
CommandType.Text, new SqlParameter[] {
new SqlParameter("@S_id", con)
});
if (dr.Read())
{
obj = new Solution_Table()
{
P_id = Convert.ToInt32(dr["P_id"]),
S_Content = dr["S_Content"].ToString(),
S_Datetime = Convert.ToDateTime(dr["S_Datetime"]),
S_id = Convert.ToInt32(dr["S_id"]),
S_tatle = dr["S_tatle"].ToString()
};
}
dr.Close();
return(obj);
}
/// <summary>
/// 更改解决方案信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_SolutionTableData(Solution_Table obj)
{
return(relevanceClass.Update_SolutionTableData(obj));
}
/// <summary>
/// 添加解决方案信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_SolutionTableData(Solution_Table obj)
{
return(relevanceClass.Insert_SolutionTableData(obj));
}