/// <summary> /// 增加 /// </summary> /// <param name="Tmp_Date">Tmp_Date实体对象</param> /// <returns>int值,返回自增ID</returns> public int addReturnId(Tmp_Date model) { SqlParameter[] param = new SqlParameter[] { new SqlParameter ("@i_value",model.I_value) }; return Convert.ToInt32(Helper.ExecuteScalar ("Tmp_Date_AddReturnId",param)); }
/// <summary> /// 增加 /// </summary> /// <param name="Tmp_Date">Tmp_Date实体对象</param> /// <returns>bool值,判断是否操作成功</returns> public bool add(Tmp_Date model) { SqlParameter[] param = new SqlParameter[] { new SqlParameter ("@i_value",model.I_value) }; return Helper.ExecuteNonQuery("Tmp_Date_Add",param); }
/// <summary> /// 修改 /// </summary> /// <param name="Tmp_Date">Tmp_Date实体对象</param> /// <returns>bool值,判断是否操作成功</returns> public bool change(Tmp_Date model) { SqlParameter[] param = new SqlParameter[] { new SqlParameter ("@i_key",model.I_key), new SqlParameter ("@i_value",model.I_value) }; return Helper.ExecuteNonQuery("Tmp_Date_Change",param); }
/// <summary> /// 查看全部 /// </summary> /// <returns>list集合</returns> public List<Tmp_Date> selectAll() { List<Tmp_Date> list = new List<Tmp_Date>(); Tmp_Date model = null; using (SqlDataReader dr = Helper.ExecuteReader("Tmp_Date_SelectAll", null)) { while (dr.Read()) { model = new Tmp_Date(); model.I_key= Convert.ToInt32(dr["i_key"]); if (DBNull.Value!=dr["i_value"]) model.I_value= Convert.ToInt32(dr["i_value"]); list.Add(model); } } return list; }
/// <summary> /// 通过Id查询 /// </summary> /// <param name="Id">主键Id</param> /// <returns>Tmp_Date实体类对象</returns> public Tmp_Date selectById(int Id) { SqlParameter[] param = new SqlParameter[] { new SqlParameter ("@i_key",Id) }; Tmp_Date model = new Tmp_Date(); using (SqlDataReader dr = Helper.ExecuteReader("Tmp_Date_SelectById", param)) { if (dr.Read()) { model.I_key= Convert.ToInt32(dr["i_key"]); if (DBNull.Value!=dr["i_value"]) model.I_value= Convert.ToInt32(dr["i_value"]); } } return model; }
/// <summary> /// 通过条件查询 /// </summary> /// <param name="WhereString">查询条件</param> /// <returns>Tmp_Date实体类对象</returns> public List<Tmp_Date> selectByWhere(string WhereString) { SqlParameter[] param = new SqlParameter[] { new SqlParameter ("@where",WhereString) }; List<Tmp_Date> list = new List<Tmp_Date>(); Tmp_Date model = null; using (SqlDataReader dr = Helper.ExecuteReader("Tmp_Date_SelectByWhere", param)) { while (dr.Read()) { model = new Tmp_Date(); model.I_key= Convert.ToInt32(dr["i_key"]); if (DBNull.Value!=dr["i_value"]) model.I_value= Convert.ToInt32(dr["i_value"]); list.Add(model); } } return list; }