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