/// <summary> /// 添加订单状态 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_OrderStateTableData(OrderState_Table obj) { return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"), CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@OState_Name", obj.OState_Name) })); }
/// <summary> /// 获取全部的订单状态 /// </summary> /// <returns></returns> public List <OrderState_Table> GetOrderStateTableAll() { List <OrderState_Table> list = new List <OrderState_Table>(); SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"), CommandType.StoredProcedure); while (dr.Read()) { OrderState_Table obj = new OrderState_Table() { OState_id = Convert.ToInt32(dr["OState_id"]), OState_Name = dr["OState_Name"].ToString() }; list.Add(obj); } dr.Close(); return(list); }
/// <summary> /// 根据ID查询订单状态信息 /// </summary> /// <param name="con"></param> /// <returns></returns> public OrderState_Table GetOrderStateTableByConn(string con) { OrderState_Table obj = null; SqlDataReader dr = DBHerlper.ExecuteReader( "Select * from OrderState_Table where OState_id=@OState_id", CommandType.Text, new SqlParameter[] { new SqlParameter("@OState_id", con) }); if (dr.Read()) { obj = new OrderState_Table() { OState_id = Convert.ToInt32(dr["OState_id"]), OState_Name = dr["OState_Name"].ToString() }; } dr.Close(); return(obj); }
/// <summary> /// 更改订单状态信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Update_OrderStateTableData(OrderState_Table obj) { return(relevanceClass.Update_OrderStateTableData(obj)); }
/// <summary> /// 添加订单状态信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_OrderStateTableData(OrderState_Table obj) { return(relevanceClass.Insert_OrderStateTableData(obj)); }