/v1.0/YxShop/YXShop.SQLServerDAL/Product/Product_IntegratePurchas.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using YXShop.IDAL.Product;

using System.Data.SqlClient;

using System.Data;



namespace YXShop.SQLServerDAL.Product

{

    public class Product_IntegratePurchas:IProduct_IntegratePurchas

    {



        #region "DataBase Operation"

        /// <summary>

        /// ????

        /// </summary>

        /// <remarks></remarks>

        public int Add(YXShop.Model.Product.Product_IntegratePurchas model)

        {

            SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);

            string sequel = "Insert into [yxs_productintegratepurchase](";

            sequel = sequel + "[productid], [productName], [startime], [endtime], [deposit], [count], [donateintegral], [laddercount], [ladderPrice], [description],[putoutid])";

            sequel = sequel + "Values(";

            sequel = sequel + "@productid, @productName,@startime,@endtime,@deposit,@count,@donateintegral,@laddercount,@ladderPrice,@description,@putoutid) Select scope_IDENTITY() ";

            object obj = ChangeHope.DataBase.SQLServerHelper.ExecuteSql(sequel, paras);

            if (obj == null)

            {

                return 0;

            }

            else

            {

                return Convert.ToInt32(obj);

            }

        }



        /// <summary>

        /// ???????????

        /// </summary>

        public void Delete(string ID)

        {

            StringBuilder strSql = new StringBuilder();

            strSql.Append("delete from yxs_productintegratepurchase ");

            strSql.Append(" where id in (" + ID + ") ");

            ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString());

        }

        /// <summary>

        /// ?????????????????, ???????

        /// </summary>

        /// <remarks></remarks>

        public int Amend(YXShop.Model.Product.Product_IntegratePurchas model)

        {

            string sequel = "Update [yxs_productintegratepurchase] set  ";

            sequel = sequel + "[productid] =@productid ,[productName] =@productName ,[startime]=@startime ,[endtime] =@endtime ,[deposit] =@deposit ,[count] =@count ,[donateintegral] =@donateintegral,[laddercount] =@laddercount,[ladderPrice] =@ladderPrice,[description] =@description,[putoutid]=@putoutid";

            sequel = sequel + UpdateWhereSequel;

            object obj = ChangeHope.DataBase.SQLServerHelper.ExecuteSql(sequel, (SqlParameter[])this.ValueParas(model));

            if (obj == null)

            {

                return 0;

            }

            else

            {

                return Convert.ToInt32(obj);

            }

        }



        /// <summary>

        /// ?????????

        /// </summary>

        /// <param name="uID"></param>

        /// <param name="columnName"></param>

        /// <param name="value"></param>

        /// <returns></returns>

        public int Amend(int id, string columnName, Object value)

        {

            string sequel = "Update [yxs_productintegratepurchase] set ";

            sequel = sequel + "[" + columnName + "] =@Value ";

            sequel = sequel + UpdateWhereSequel;

            SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@Value", value), new SqlParameter("@id", id) };

            object obj = ChangeHope.DataBase.SQLServerHelper.GetSingle(sequel, paras);

            if (obj == null)

            {

                return 0;

            }

            else

            {

                return Convert.ToInt32(obj);

            }

        }



        #endregion



        #region "Data Load"

        /// <summary>

        /// ????

        /// </summary>

        /// <param name="row"></param>

        /// <returns></returns>

        public YXShop.Model.Product.Product_IntegratePurchas GetModel(System.Data.DataRow row)

        {

            YXShop.Model.Product.Product_IntegratePurchas model = new YXShop.Model.Product.Product_IntegratePurchas();

            if (row != null)

            {

                model.ID = int.Parse(row["id"].ToString());

                model.ProductID = int.Parse(row["productid"].ToString());

                model.ProductName = row["productName"].ToString();

                model.StartTime = Convert.ToDateTime(row["startime"].ToString());

                model.EndTime = Convert.ToDateTime(row["endtime"].ToString());

                model.Deposit = decimal.Parse(row["deposit"].ToString());

                model.Count = int.Parse(row["count"].ToString());

                model.DonateIntegral = decimal.Parse(row["donateintegral"].ToString());

                model.LadderCount = row["laddercount"].ToString();

                model.LadderPrice = row["ladderPrice"].ToString();

                model.Description = row["description"].ToString();

                return model;

            }

            else

            {

                return null;

            }

        }

        /// <summary>

        /// ID??

        /// </summary>

        /// <remarks></remarks>

        public YXShop.Model.Product.Product_IntegratePurchas GetModelID(int id)

        {

            string sequel = SelectSequel + UpdateWhereSequel;

            SqlParameter[] paras = (SqlParameter[])this.ValueIDPara(id);

            DataSet ds = ChangeHope.DataBase.SQLServerHelper.Query(sequel, paras);

            if (ds.Tables[0].Rows.Count > 0)

            {

                return GetModel(ds.Tables[0].Rows[0]);

            }

            else

            {

                return null;

            }

        }

        /// <summary>

        /// ProductID??

        /// </summary>

        /// <remarks></remarks>

        public YXShop.Model.Product.Product_IntegratePurchas GetModelProductID(int ProductId)

        {

            string sequel = SelectSequel + " Where [productid] = @productid";

            SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@productid", ProductId) };

            DataSet ds = ChangeHope.DataBase.SQLServerHelper.Query(sequel, paras);

            if (ds.Tables[0].Rows.Count > 0)

            {

                return GetModel(ds.Tables[0].Rows[0]);

            }

            else

            {

                return null;

            }

        }

        /// <summary>

        /// ????

        /// </summary>

        /// <remarks></remarks>

        public ChangeHope.DataBase.DataByPage GetList()

        {

            ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();

            dataPage.Sql = "[select] * [from] yxs_productintegratepurchase [where] 1=1 [order by] id asc";

            dataPage.GetRecordSetByPage();

            return dataPage;

        }

        /// <summary>

        /// ????????

        /// </summary>

        /// <remarks></remarks>

        public ChangeHope.DataBase.DataByPage GetList(string orderfield, int pagesize, string Conditions)

        {

            ChangeHope.DataBase.DataByPage dataPage = new ChangeHope.DataBase.DataByPage();

            dataPage.Sql = "[select] * [from] yxs_productintegratepurchase [where] 1=1 " + Conditions + " " + orderfield;

            dataPage.PageSize = pagesize;

            dataPage.GetRecordSetByPage();

            return dataPage;

        }

        #endregion



        #region "Other function"

        string selectSequel = string.Empty;

        protected string SelectSequel

        {

            get

            {

                if (selectSequel == string.Empty)

                    selectSequel = "Select *,1 PersistStatus  From [yxs_productintegratepurchase] ";

                return selectSequel;

            }

            set

            {

                this.selectSequel = value;

            }

        }

        /// <summary>

        /// 

        /// </summary>

        protected string UpdateWhereSequel

        {

            get

            {

                return " Where [id] = @id";

            }

        }

        /// <summary>

        /// ???????????????????????

        /// </summary>

        /// <remarks></remarks>



        public IDbDataParameter[] ValueParas(YXShop.Model.Product.Product_IntegratePurchas model)

        {

            SqlParameter[] paras = new SqlParameter[12];

            paras[0] = new SqlParameter("@id", SqlDbType.Int, 4);

            paras[0].Value = model.ID;

            paras[1] = new SqlParameter("@productid", SqlDbType.Int, 4);

            paras[1].Value = model.ProductID;

            paras[2] = new SqlParameter("@productName", SqlDbType.VarChar, 200);

            paras[2].Value = model.ProductName;



            paras[3] = new SqlParameter("@startime", SqlDbType.DateTime, 8);

            paras[3].Value = model.StartTime;

            paras[4] = new SqlParameter("@endtime", SqlDbType.DateTime, 8);

            paras[4].Value = model.EndTime;



            paras[5] = new SqlParameter("@deposit", SqlDbType.Float, 8);

            paras[5].Value = model.Deposit;

            paras[6] = new SqlParameter("@count", SqlDbType.Int, 4);

            paras[6].Value = model.Count;

            paras[7] = new SqlParameter("@donateintegral", SqlDbType.Float, 8);

            paras[7].Value = model.DonateIntegral;

            paras[8] = new SqlParameter("@laddercount", SqlDbType.NVarChar, 100);

            paras[8].Value = model.LadderCount;

            paras[9] = new SqlParameter("@ladderPrice", SqlDbType.NVarChar, 100);

            paras[9].Value = model.LadderPrice;

            paras[10] = new SqlParameter("@description", SqlDbType.NVarChar, 2000);

            paras[10].Value = model.Description;

            paras[11] = new SqlParameter("@putoutid", SqlDbType.Int, 4);

            paras[11].Value = model.ProductID == null ? 0 : model.ProductID;

            return paras;

        }



        public IDbDataParameter[] ValueIDPara(int id)

        {

            SqlParameter[] paras = new SqlParameter[1];

            paras[0] = new SqlParameter("@id", id);

            paras[0].DbType = DbType.Int32;

            return paras;

        }



        #endregion

    }

}