st_order.cs

it have big power,i hope to do it . happy everyday!

using System;
using System.Data;
using Microsoft.ApplicationBlocks.Data;

namespace STGROUP.ST_BookBiz
{
	/// <summary>
	/// ST_Order 的摘要说明。
	/// </summary>
	public class ST_Order
	{
		public ST_Order()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 插入订单信息
		/// </summary>
		/// <param name="st_order"></param>
		/// <returns></returns>
		public int InsertOrder(ST_BookBiz.ST_OrderEntity st_order)
		{
			string sqlString = @"insert into ST_Order(ST_UserID,ST_CreateTime,ST_Ship,ST_Payment,ST_Sum,ST_Desciption,ST_Consignee,ST_ConsingeeEmail,ST_ConsingeePhone,ST_ConsingeeAddress,ST_ConsingeePostcode,ST_ConsingeeGender)
								 values('"+st_order.ST_UserID+"','"+st_order.ST_CreateTime+"','"+st_order.ST_Ship+"','"+st_order.ST_Payment+"','"+st_order.ST_Sum+"','"+st_order.ST_Desciption+"','"+st_order.ST_Consignee+"','"+st_order.ST_ConsingeeEmail+"','"+st_order.ST_ConsingeePhone+"','"+st_order.ST_ConsingeeAddress+"','"+st_order.ST_ConsingeePostcode+"','"+st_order.ST_ConsingeeGender+"'); select scope_identity();";

			object obj = SqlHelper.ExecuteScalar(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			if(obj!=null)
				return int.Parse(obj.ToString());
			return 0;
		}
        /// <summary>
        /// 插入订单详情
        /// </summary>
        /// <param name="st_xml"></param>
		public void InsertOrderDetail(string st_xml)
		{
			SqlHelper.ExecuteNonQuery(ST_Utility.ST_ConnString,"ST_InsertOrderDetails",st_xml);
		}
        /// <summary>
        /// 修改订单状态
        /// </summary>
        /// <param name="orderid"></param>
        /// <param name="status"></param>
        public void UpdateOrder(int st_orderid, int status)
        {
            string sqlString = @"update ST_Order set ST_Status=" + status + " where st_orderid=" + st_orderid;

            object obj = SqlHelper.ExecuteScalar(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
        }
		/// <summary>
		/// 取得某个订单的信息
		/// </summary>
		/// <param name="st_orderid"></param>
		/// <returns></returns>
		public ST_BookBiz.ST_OrderEntity GetOrderByID(int st_orderid)
		{
			string sqlString = "select * from ST_Order where st_orderid="+st_orderid;
			DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			ST_BookBiz.ST_OrderEntity st_order = new ST_OrderEntity();
			st_order.ST_OrderID = st_orderid;
			st_order.ST_UserID = int.Parse(ds.Tables[0].Rows[0]["ST_UserID"].ToString());
			st_order.ST_CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["ST_CreateTime"].ToString());
			st_order.ST_Ship = ds.Tables[0].Rows[0]["ST_Ship"].ToString();
			st_order.ST_Payment = ds.Tables[0].Rows[0]["ST_Payment"].ToString();
			st_order.ST_Sum = float.Parse(ds.Tables[0].Rows[0]["ST_Sum"].ToString());
			st_order.ST_Desciption = ds.Tables[0].Rows[0]["ST_Desciption"].ToString();
			st_order.ST_Consignee = ds.Tables[0].Rows[0]["ST_Consignee"].ToString();
			st_order.ST_ConsingeeEmail = ds.Tables[0].Rows[0]["ST_ConsingeeEmail"].ToString();
			st_order.ST_ConsingeePhone = ds.Tables[0].Rows[0]["ST_ConsingeePhone"].ToString();
			st_order.ST_ConsingeeAddress = ds.Tables[0].Rows[0]["ST_ConsingeeAddress"].ToString();
			st_order.ST_ConsingeePostcode = ds.Tables[0].Rows[0]["ST_ConsingeePostcode"].ToString();
			st_order.ST_ConsingeeGender = ds.Tables[0].Rows[0]["ST_ConsingeeGender"].ToString();
			st_order.ST_Status = short.Parse(ds.Tables[0].Rows[0]["ST_Status"].ToString());
			return st_order;
		}
        /// <summary>
        /// 取得所有订单
        /// </summary>
        /// <param name="orderid"></param>
        /// <param name="status"></param>
        public DataSet GetAllOrder()
        {
            string sqlString = @"select *  from ST_Order";

            DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
            return ds;

        }
        /// <summary>
        /// 取得某个消费者所有订单
        /// </summary>
        /// <param name="orderid"></param>
        /// <param name="status"></param>
        public DataSet GetAllOrder(int st_userid)
        {
            string sqlString = @"select *  from ST_Order where st_userid=" + st_userid;

            DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
            return ds;

        }
	}
}