/// <summary> /// 添加试用审核状态 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_TryOutTableData(TryOut_Table obj) { return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"), CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@TO_Name", obj.TO_Name) })); }
/// <summary> /// 获取全部的试用审核状态 /// </summary> /// <returns></returns> public List <TryOut_Table> GetTryOutTableAll() { List <TryOut_Table> list = new List <TryOut_Table>(); SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"), CommandType.StoredProcedure); while (dr.Read()) { TryOut_Table obj = new TryOut_Table() { TO_id = Convert.ToInt32(dr["TO_id"]), TO_Name = dr["TO_Name"].ToString() }; list.Add(obj); } dr.Close(); return(list); }
/// <summary> /// 根据ID查询试用审核状态信息 /// </summary> /// <param name="con"></param> /// <returns></returns> public TryOut_Table GetTryOutTableByConn(string con) { TryOut_Table obj = null; SqlDataReader dr = DBHerlper.ExecuteReader( "Select * from TryOut_Table where TO_id=@TO_id", CommandType.Text, new SqlParameter[] { new SqlParameter("@TO_id", con) }); if (dr.Read()) { obj = new TryOut_Table() { TO_id = Convert.ToInt32(dr["TO_id"]), TO_Name = dr["TO_Name"].ToString() }; } dr.Close(); return(obj); }
/// <summary> /// 更改试用审核状态信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Update_TryOutTableData(TryOut_Table obj) { return(relevanceClass.Update_TryOutTableData(obj)); }
/// <summary> /// 添加试用审核状态信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_TryOutTableData(TryOut_Table obj) { return(relevanceClass.Insert_TryOutTableData(obj)); }