using System;
using System.Data;
using System.Text;
using System.Data.OracleClient;
using CallCenterApi.DB;

namespace CallCenterApi.DAL
{
    /// <summary>
    /// 数据访问类:SF_ZHENDUAN
    /// </summary>
    public partial class O_SF_ZHENDUAN
    {
        public O_SF_ZHENDUAN()
        { }
        #region  BasicMethod

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public CallCenterApi.Model.O_SF_ZHENDUAN GetModel(string strWhere)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from (");
            strSql.Append("select * from DIAGNOSIS_V ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            strSql.Append(" ) t Where rownum=1");
            CallCenterApi.Model.O_SF_ZHENDUAN model = new CallCenterApi.Model.O_SF_ZHENDUAN();
            DataSet ds = DBOracleHelper.Query(strSql.ToString());
            if (ds.Tables[0].Rows.Count > 0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public CallCenterApi.Model.O_SF_ZHENDUAN DataRowToModel(DataRow row)
        {
            CallCenterApi.Model.O_SF_ZHENDUAN model = new CallCenterApi.Model.O_SF_ZHENDUAN();
            if (row != null)
            {
                if (row["BINGANHAO"] != null)
                {
                    model.BINGANHAO = row["BINGANHAO"].ToString();
                }
                if (row["BINGRENZYID"] != null)
                {
                    model.BINGRENZYID = row["BINGRENZYID"].ToString();
                }
                if (row["BRXH"] != null)
                {
                    model.BRXH = row["BRXH"].ToString();
                }
                if (row["ZZD"] != null)
                {
                    model.ZZD = row["ZZD"].ToString();
                }
                if (row["ZZDMC"] != null)
                {
                    model.ZZDMC = row["ZZDMC"].ToString();
                }
                if (row["ZZDBQ"] != null)
                {
                    model.ZZDBQ = row["ZZDBQ"].ToString();
                }
                if (row["ZZDQK"] != null)
                {
                    model.ZZDQK = row["ZZDQK"].ToString();
                }
                if (row["MZZD"] != null)
                {
                    model.MZZD = row["MZZD"].ToString();
                }
                if (row["MZZDMC"] != null)
                {
                    model.MZZDMC = row["MZZDMC"].ToString();
                }
                if (row["MZZDBQ"] != null)
                {
                    model.MZZDBQ = row["MZZDBQ"].ToString();
                }
                if (row["MZZDQK"] != null)
                {
                    model.MZZDQK = row["MZZDQK"].ToString();
                }
                if (row["CZD1"] != null)
                {
                    model.CZD1 = row["CZD1"].ToString();
                }
                if (row["CZDMC1"] != null)
                {
                    model.CZDMC1 = row["CZDMC1"].ToString();
                }
                if (row["CZDBQ1"] != null)
                {
                    model.CZDBQ1 = row["CZDBQ1"].ToString();
                }
                if (row["CZDQK1"] != null)
                {
                    model.CZDQK1 = row["CZDQK1"].ToString();
                }
                if (row["CZD2"] != null)
                {
                    model.CZD2 = row["CZD2"].ToString();
                }
                if (row["CZDMC2"] != null)
                {
                    model.CZDMC2 = row["CZDMC2"].ToString();
                }
                if (row["CZDBQ2"] != null)
                {
                    model.CZDBQ2 = row["CZDBQ2"].ToString();
                }
                if (row["CZDQK2"] != null)
                {
                    model.CZDQK2 = row["CZDQK2"].ToString();
                }
                if (row["CZD3"] != null)
                {
                    model.CZD3 = row["CZD3"].ToString();
                }
                if (row["CZDMC3"] != null)
                {
                    model.CZDMC3 = row["CZDMC3"].ToString();
                }
                if (row["CZDBQ3"] != null)
                {
                    model.CZDBQ3 = row["CZDBQ3"].ToString();
                }
                if (row["CZDQK3"] != null)
                {
                    model.CZDQK3 = row["CZDQK3"].ToString();
                }
                if (row["CZD4"] != null)
                {
                    model.CZD4 = row["CZD4"].ToString();
                }
                if (row["CZDMC4"] != null)
                {
                    model.CZDMC4 = row["CZDMC4"].ToString();
                }
                if (row["CZDBQ4"] != null)
                {
                    model.CZDBQ4 = row["CZDBQ4"].ToString();
                }
                if (row["CZDQK4"] != null)
                {
                    model.CZDQK4 = row["CZDQK4"].ToString();
                }
                if (row["CZD5"] != null)
                {
                    model.CZD5 = row["CZD5"].ToString();
                }
                if (row["CZDMC5"] != null)
                {
                    model.CZDMC5 = row["CZDMC5"].ToString();
                }
                if (row["CZDBQ5"] != null)
                {
                    model.CZDBQ5 = row["CZDBQ5"].ToString();
                }
                if (row["CZDQK5"] != null)
                {
                    model.CZDQK5 = row["CZDQK5"].ToString();
                }
                if (row["CZD6"] != null)
                {
                    model.CZD6 = row["CZD6"].ToString();
                }
                if (row["CZDMC6"] != null)
                {
                    model.CZDMC6 = row["CZDMC6"].ToString();
                }
                if (row["CZDBQ6"] != null)
                {
                    model.CZDBQ6 = row["CZDBQ6"].ToString();
                }
                if (row["CZDQK6"] != null)
                {
                    model.CZDQK6 = row["CZDQK6"].ToString();
                }
                if (row["CZD7"] != null)
                {
                    model.CZD7 = row["CZD7"].ToString();
                }
                if (row["CZDMC7"] != null)
                {
                    model.CZDMC7 = row["CZDMC7"].ToString();
                }
                if (row["CZDBQ7"] != null)
                {
                    model.CZDBQ7 = row["CZDBQ7"].ToString();
                }
                if (row["CZDQK7"] != null)
                {
                    model.CZDQK7 = row["CZDQK7"].ToString();
                }
                if (row["CZD8"] != null)
                {
                    model.CZD8 = row["CZD8"].ToString();
                }
                if (row["CZDMC8"] != null)
                {
                    model.CZDMC8 = row["CZDMC8"].ToString();
                }
                if (row["CZDBQ8"] != null)
                {
                    model.CZDBQ8 = row["CZDBQ8"].ToString();
                }
                if (row["CZDQK8"] != null)
                {
                    model.CZDQK8 = row["CZDQK8"].ToString();
                }
                if (row["CZD9"] != null)
                {
                    model.CZD9 = row["CZD9"].ToString();
                }
                if (row["CZDMC9"] != null)
                {
                    model.CZDMC9 = row["CZDMC9"].ToString();
                }
                if (row["CZDBQ9"] != null)
                {
                    model.CZDBQ9 = row["CZDBQ9"].ToString();
                }
                if (row["CZDQK9"] != null)
                {
                    model.CZDQK9 = row["CZDQK9"].ToString();
                }
                if (row["CZD10"] != null)
                {
                    model.CZD10 = row["CZD10"].ToString();
                }
                if (row["CZDMC10"] != null)
                {
                    model.CZDMC10 = row["CZDMC10"].ToString();
                }
                if (row["CZDBQ10"] != null)
                {
                    model.CZDBQ10 = row["CZDBQ10"].ToString();
                }
                if (row["CZDQK10"] != null)
                {
                    model.CZDQK10 = row["CZDQK10"].ToString();
                }
                if (row["CZD11"] != null)
                {
                    model.CZD11 = row["CZD11"].ToString();
                }
                if (row["CZDMC11"] != null)
                {
                    model.CZDMC11 = row["CZDMC11"].ToString();
                }
                if (row["CZDBQ11"] != null)
                {
                    model.CZDBQ11 = row["CZDBQ11"].ToString();
                }
                if (row["CZDQK11"] != null)
                {
                    model.CZDQK11 = row["CZDQK11"].ToString();
                }
                if (row["CZD12"] != null)
                {
                    model.CZD12 = row["CZD12"].ToString();
                }
                if (row["CZDMC12"] != null)
                {
                    model.CZDMC12 = row["CZDMC12"].ToString();
                }
                if (row["CZDBQ12"] != null)
                {
                    model.CZDBQ12 = row["CZDBQ12"].ToString();
                }
                if (row["CZDQK12"] != null)
                {
                    model.CZDQK12 = row["CZDQK12"].ToString();
                }
                if (row["CZD13"] != null)
                {
                    model.CZD13 = row["CZD13"].ToString();
                }
                if (row["CZDMC13"] != null)
                {
                    model.CZDMC13 = row["CZDMC13"].ToString();
                }
                if (row["CZDBQ13"] != null)
                {
                    model.CZDBQ13 = row["CZDBQ13"].ToString();
                }
                if (row["CZDQK13"] != null)
                {
                    model.CZDQK13 = row["CZDQK13"].ToString();
                }
                if (row["CZD14"] != null)
                {
                    model.CZD14 = row["CZD14"].ToString();
                }
                if (row["CZDMC14"] != null)
                {
                    model.CZDMC14 = row["CZDMC14"].ToString();
                }
                if (row["CZDBQ14"] != null)
                {
                    model.CZDBQ14 = row["CZDBQ14"].ToString();
                }
                if (row["CZDQK14"] != null)
                {
                    model.CZDQK14 = row["CZDQK14"].ToString();
                }
                if (row["CZD15"] != null)
                {
                    model.CZD15 = row["CZD15"].ToString();
                }
                if (row["CZDMC15"] != null)
                {
                    model.CZDMC15 = row["CZDMC15"].ToString();
                }
                if (row["CZDBQ15"] != null)
                {
                    model.CZDBQ15 = row["CZDBQ15"].ToString();
                }
                if (row["CZDQK15"] != null)
                {
                    model.CZDQK15 = row["CZDQK15"].ToString();
                }
                if (row["CZD16"] != null)
                {
                    model.CZD16 = row["CZD16"].ToString();
                }
                if (row["CZDMC16"] != null)
                {
                    model.CZDMC16 = row["CZDMC16"].ToString();
                }
                if (row["CZDBQ16"] != null)
                {
                    model.CZDBQ16 = row["CZDBQ16"].ToString();
                }
                if (row["CZDQK16"] != null)
                {
                    model.CZDQK16 = row["CZDQK16"].ToString();
                }
                if (row["CZD17"] != null)
                {
                    model.CZD17 = row["CZD17"].ToString();
                }
                if (row["CZDMC17"] != null)
                {
                    model.CZDMC17 = row["CZDMC17"].ToString();
                }
                if (row["CZDBQ17"] != null)
                {
                    model.CZDBQ17 = row["CZDBQ17"].ToString();
                }
                if (row["CZDQK17"] != null)
                {
                    model.CZDQK17 = row["CZDQK17"].ToString();
                }
                if (row["CZD18"] != null)
                {
                    model.CZD18 = row["CZD18"].ToString();
                }
                if (row["CZDMC18"] != null)
                {
                    model.CZDMC18 = row["CZDMC18"].ToString();
                }
                if (row["CZDBQ18"] != null)
                {
                    model.CZDBQ18 = row["CZDBQ18"].ToString();
                }
                if (row["CZDQK18"] != null)
                {
                    model.CZDQK18 = row["CZDQK18"].ToString();
                }
                if (row["CZD19"] != null)
                {
                    model.CZD19 = row["CZD19"].ToString();
                }
                if (row["CZDMC19"] != null)
                {
                    model.CZDMC19 = row["CZDMC19"].ToString();
                }
                if (row["CZDBQ19"] != null)
                {
                    model.CZDBQ19 = row["CZDBQ19"].ToString();
                }
                if (row["CZDQK19"] != null)
                {
                    model.CZDQK19 = row["CZDQK19"].ToString();
                }
                if (row["CZD20"] != null)
                {
                    model.CZD20 = row["CZD20"].ToString();
                }
                if (row["CZDMC20"] != null)
                {
                    model.CZDMC20 = row["CZDMC20"].ToString();
                }
                if (row["CZDBQ20"] != null)
                {
                    model.CZDBQ20 = row["CZDBQ20"].ToString();
                }
                if (row["CZDQK20"] != null)
                {
                    model.CZDQK20 = row["CZDQK20"].ToString();
                }
                if (row["CZD21"] != null)
                {
                    model.CZD21 = row["CZD21"].ToString();
                }
                if (row["CZDMC21"] != null)
                {
                    model.CZDMC21 = row["CZDMC21"].ToString();
                }
                if (row["CZDBQ21"] != null)
                {
                    model.CZDBQ21 = row["CZDBQ21"].ToString();
                }
                if (row["CZDQK21"] != null)
                {
                    model.CZDQK21 = row["CZDQK21"].ToString();
                }
                if (row["CZD22"] != null)
                {
                    model.CZD22 = row["CZD22"].ToString();
                }
                if (row["CZDMC22"] != null)
                {
                    model.CZDMC22 = row["CZDMC22"].ToString();
                }
                if (row["CZDBQ22"] != null)
                {
                    model.CZDBQ22 = row["CZDBQ22"].ToString();
                }
                if (row["CZDQK22"] != null)
                {
                    model.CZDQK22 = row["CZDQK22"].ToString();
                }
                if (row["CZD23"] != null)
                {
                    model.CZD23 = row["CZD23"].ToString();
                }
                if (row["CZDMC23"] != null)
                {
                    model.CZDMC23 = row["CZDMC23"].ToString();
                }
                if (row["CZDBQ23"] != null)
                {
                    model.CZDBQ23 = row["CZDBQ23"].ToString();
                }
                if (row["CZDQK23"] != null)
                {
                    model.CZDQK23 = row["CZDQK23"].ToString();
                }
                if (row["CZD24"] != null)
                {
                    model.CZD24 = row["CZD24"].ToString();
                }
                if (row["CZDMC24"] != null)
                {
                    model.CZDMC24 = row["CZDMC24"].ToString();
                }
                if (row["CZDBQ24"] != null)
                {
                    model.CZDBQ24 = row["CZDBQ24"].ToString();
                }
                if (row["CZDQK24"] != null)
                {
                    model.CZDQK24 = row["CZDQK24"].ToString();
                }
                if (row["CZD25"] != null)
                {
                    model.CZD25 = row["CZD25"].ToString();
                }
                if (row["CZDMC25"] != null)
                {
                    model.CZDMC25 = row["CZDMC25"].ToString();
                }
                if (row["CZDBQ25"] != null)
                {
                    model.CZDBQ25 = row["CZDBQ25"].ToString();
                }
                if (row["CZDQK25"] != null)
                {
                    model.CZDQK25 = row["CZDQK25"].ToString();
                }
            }
            return model;
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM DIAGNOSIS_V ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DBOracleHelper.Query(strSql.ToString());
        }

        /// <summary>
        /// 获取记录总数
        /// </summary>
        public int GetRecordCount(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) FROM DIAGNOSIS_V ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            object obj = DBOracleHelper.GetSingle(strSql.ToString());
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 分页获取数据列表
        /// </summary>
        public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT * FROM ( ");
            strSql.Append(" SELECT ROW_NUMBER() OVER (");
            if (!string.IsNullOrEmpty(orderby.Trim()))
            {
                strSql.Append("order by T." + orderby);
            }
            else
            {
                strSql.Append("order by T.CZDQK25 desc");
            }
            strSql.Append(")AS r, T.*  from DIAGNOSIS_V T ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                strSql.Append(" WHERE " + strWhere);
            }
            strSql.Append(" ) TT");
            strSql.AppendFormat(" WHERE TT.r between {0} and {1}", startIndex, endIndex);
            return DBOracleHelper.Query(strSql.ToString());
        }

        /*
		/// <summary>
		/// 分页获取数据列表
		/// </summary>
		public DataSet GetList(int PageSize,int PageIndex,string strWhere)
		{
			OracleParameter[] parameters = {
					new OracleParameter(":tblName", OracleType.VarChar, 255),
					new OracleParameter(":fldName", OracleType.VarChar, 255),
					new OracleParameter(":PageSize", OracleType.Number),
					new OracleParameter(":PageIndex", OracleType.Number),
					new OracleParameter(":IsReCount", OracleType.Clob),
					new OracleParameter(":OrderType", OracleType.Clob),
					new OracleParameter(":strWhere", OracleType.VarChar,1000),
					};
			parameters[0].Value = "SF_ZHENDUAN";
			parameters[1].Value = "CZDQK25";
			parameters[2].Value = PageSize;
			parameters[3].Value = PageIndex;
			parameters[4].Value = 0;
			parameters[5].Value = 0;
			parameters[6].Value = strWhere;	
			return DbHelperOra.RunProcedure("UP_GetRecordByPage",parameters,"ds");
		}*/

        #endregion  BasicMethod
        #region  ExtensionMethod

        #endregion  ExtensionMethod
    }
}