?using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
namespace sp.SQLServerDAL
{
    /// <summary>
    /// 數據訪問類sp_answer。
    /// </summary>
    public class sp_answer
    {
        public sp_answer()
        { }
        #region  成員方法
        /// <summary>
        /// 得到最大ID
        /// </summary>
        public int GetMaxId()
        {
            return DbHelperSQL.GetMaxID("id", "sp_answer");
        }
        /// <summary>
        /// 是否存在該記錄
        /// </summary>
        public bool Exists(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from sp_answer");
            strSql.Append(" where id= @id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4)
				};
            parameters[0].Value = id;
            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }


        /// <summary>
        /// 增加一條數據
        /// </summary>
        public void Add(sp.Model.sp_answer model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into sp_answer(");
            strSql.Append("answer_cn,answer_en,amount,for_question)");
            strSql.Append(" values (");
            strSql.Append("@answer_cn,@answer_en,@amount,@for_question)");
            SqlParameter[] parameters = {
					new SqlParameter("@answer_cn", SqlDbType.VarChar,50),
					new SqlParameter("@answer_en", SqlDbType.VarChar,50),
					new SqlParameter("@amount", SqlDbType.Int,4),
					new SqlParameter("@for_question", SqlDbType.Int,4)};
            parameters[0].Value = model.answer_cn;
            parameters[1].Value = model.answer_en;
            parameters[2].Value = model.amount;
            parameters[3].Value = model.for_question;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
        /// <summary>
        /// 更新一條數據
        /// </summary>
        public void Update(sp.Model.sp_answer model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update sp_answer set ");
            strSql.Append("answer_cn=@answer_cn,");
            strSql.Append("answer_en=@answer_en,");
            strSql.Append("amount=@amount,");
            strSql.Append("for_question=@for_question");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
					new SqlParameter("@answer_cn", SqlDbType.VarChar,50),
					new SqlParameter("@answer_en", SqlDbType.VarChar,50),
					new SqlParameter("@amount", SqlDbType.Int,4),
					new SqlParameter("@for_question", SqlDbType.Int,4)};
            parameters[0].Value = model.answer_cn;
            parameters[1].Value = model.answer_en;
            parameters[2].Value = model.amount;
            parameters[3].Value = model.for_question;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }

        /// <summary>
        /// 刪除一條數據
        /// </summary>
        public void Delete(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete sp_answer ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4)
				};
            parameters[0].Value = id;
            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }


        /// <summary>
        /// 得到一個對象實體
        /// </summary>
        public sp.Model.sp_answer GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from sp_answer ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
					new SqlParameter("@id", SqlDbType.Int,4)};
            parameters[0].Value = id;
            sp.Model.sp_answer model = new sp.Model.sp_answer();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            model.id = id;
            if (ds.Tables[0].Rows.Count > 0)
            {
                model.answer_cn = ds.Tables[0].Rows[0]["answer_cn"].ToString();
                model.answer_en = ds.Tables[0].Rows[0]["answer_en"].ToString();
                if (ds.Tables[0].Rows[0]["amount"].ToString() != "")
                {
                    model.amount = int.Parse(ds.Tables[0].Rows[0]["amount"].ToString());
                }
                if (ds.Tables[0].Rows[0]["for_question"].ToString() != "")
                {
                    model.for_question = int.Parse(ds.Tables[0].Rows[0]["for_question"].ToString());
                }
                return model;
            }
            else
            {
                return null;
            }
        }
        /// <summary>
        /// 獲得數據列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select [id],[answer_cn],[answer_en],[amount],[for_question] ");
            strSql.Append(" FROM sp_answer ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        /// <summary>
        /// 分頁獲取數據列表
        /// </summary>
        public DataSet GetList(int PageSize, int PageIndex, string strWhere)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@tblName", SqlDbType.VarChar, 255),
					new SqlParameter("@fldName", SqlDbType.VarChar, 255),
					new SqlParameter("@PageSize", SqlDbType.Int),
					new SqlParameter("@PageIndex", SqlDbType.Int),
					new SqlParameter("@IsReCount", SqlDbType.Bit),
					new SqlParameter("@OrderType", SqlDbType.Bit),
					new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
					};
            parameters[0].Value = "sp_answer";
            parameters[1].Value = "id";
            parameters[2].Value = PageSize;
            parameters[3].Value = PageIndex;
            parameters[4].Value = 0;
            parameters[5].Value = 0;
            parameters[6].Value = strWhere;
            return DbHelperSQL.RunProcedure("UP_GetRecordByPage", parameters, "ds");
        }

        #endregion  成員方法
    }
}