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

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

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

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from (");
            strSql.Append("select * from patient_info ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            strSql.Append(" ) t Where rownum=1");

            CallCenterApi.Model.O_SF_BINGRENQK model = new CallCenterApi.Model.O_SF_BINGRENQK();
            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_BINGRENQK DataRowToModel(DataRow row)
        {
            CallCenterApi.Model.O_SF_BINGRENQK model = new CallCenterApi.Model.O_SF_BINGRENQK();
            if (row != null)
            {
                if (row["BAH"] != null)
                {
                    model.BAH = row["BAH"].ToString();
                }
                if (row["BINGRENZYID"] != null)
                {
                    model.BINGRENZYID = row["BINGRENZYID"].ToString();
                }
                if (row["BRXH"] != null)
                {
                    model.BRXH = row["BRXH"].ToString();
                }
                if (row["ZYCS"] != null)
                {
                    model.ZYCS = row["ZYCS"].ToString();
                }
                if (row["RYRQ"] != null)
                {
                    model.RYRQ = row["RYRQ"].ToString();
                }
                if (row["CYRQ"] != null)
                {
                    model.CYRQ = row["CYRQ"].ToString();
                }
                if (row["BRXM"] != null)
                {
                    model.BRXM = row["BRXM"].ToString();
                }
                if (row["XB"] != null)
                {
                    model.XB = row["XB"].ToString();
                }
                if (row["CSRQ"] != null)
                {
                    model.CSRQ = row["CSRQ"].ToString();
                }
                if (row["NL"] != null)
                {
                    model.NL = row["NL"].ToString();
                }
                if (row["NLR"] != null)
                {
                    model.NLR = row["NLR"].ToString();
                }
                if (row["GJ"] != null)
                {
                    model.GJ = row["GJ"].ToString();
                }
                if (row["HY"] != null)
                {
                    model.HY = row["HY"].ToString();
                }
                if (row["SFZH"] != null)
                {
                    model.SFZH = row["SFZH"].ToString();
                }
                if (row["HKDZ"] != null)
                {
                    model.HKDZ = row["HKDZ"].ToString();
                }
                if (row["HKDZYB"] != null)
                {
                    model.HKDZYB = row["HKDZYB"].ToString();
                }
                if (row["XZZ"] != null)
                {
                    model.XZZ = row["XZZ"].ToString();
                }
                if (row["XZZDH"] != null)
                {
                    model.XZZDH = row["XZZDH"].ToString();
                }
                if (row["XZZYB"] != null)
                {
                    model.XZZYB = row["XZZYB"].ToString();
                }
                if (row["GZDW"] != null)
                {
                    model.GZDW = row["GZDW"].ToString();
                }
                if (row["DWDH"] != null)
                {
                    model.DWDH = row["DWDH"].ToString();
                }
                if (row["DWYB"] != null)
                {
                    model.DWYB = row["DWYB"].ToString();
                }
                if (row["GXRXM"] != null)
                {
                    model.GXRXM = row["GXRXM"].ToString();
                }
                if (row["GX"] != null)
                {
                    model.GX = row["GX"].ToString();
                }
                if (row["GXRZZ"] != null)
                {
                    model.GXRZZ = row["GXRZZ"].ToString();
                }
                if (row["GXRDH"] != null)
                {
                    model.GXRDH = row["GXRDH"].ToString();
                }
                if (row["RYQK"] != null)
                {
                    model.RYQK = row["RYQK"].ToString();
                }
                if (row["RYKS"] != null)
                {
                    model.RYKS = row["RYKS"].ToString();
                }
                if (row["RYBS"] != null)
                {
                    model.RYBS = row["RYBS"].ToString();
                }
                if (row["ZKKB"] != null)
                {
                    model.ZKKB = row["ZKKB"].ToString();
                }
                if (row["CYKS"] != null)
                {
                    model.CYKS = row["CYKS"].ToString();
                }
                if (row["CYBS"] != null)
                {
                    model.CYBS = row["CYBS"].ToString();
                }
                if (row["ZYTS"] != null)
                {
                    model.ZYTS = row["ZYTS"].ToString();
                }
                if (row["RYQZRQ"] != null)
                {
                    model.RYQZRQ = row["RYQZRQ"].ToString();
                }
                if (row["KZRBH"] != null)
                {
                    model.KZRBH = row["KZRBH"].ToString();
                }
                if (row["KZRXM"] != null)
                {
                    model.KZRXM = row["KZRXM"].ToString();
                }
                if (row["ZRYSBH"] != null)
                {
                    model.ZRYSBH = row["ZRYSBH"].ToString();
                }
                if (row["ZRYSXM"] != null)
                {
                    model.ZRYSXM = row["ZRYSXM"].ToString();
                }
                if (row["ZZYSBH"] != null)
                {
                    model.ZZYSBH = row["ZZYSBH"].ToString();
                }
                if (row["ZZYSXM"] != null)
                {
                    model.ZZYSXM = row["ZZYSXM"].ToString();
                }
                if (row["ZYYSBH"] != null)
                {
                    model.ZYYSBH = row["ZYYSBH"].ToString();
                }
                if (row["ZYYSXM"] != null)
                {
                    model.ZYYSXM = row["ZYYSXM"].ToString();
                }
                if (row["ZRHSBH"] != null)
                {
                    model.ZRHSBH = row["ZRHSBH"].ToString();
                }
                if (row["ZRHSXM"] != null)
                {
                    model.ZRHSXM = row["ZRHSXM"].ToString();
                }
                if (row["LYFS"] != null)
                {
                    model.LYFS = row["LYFS"].ToString();
                }
                if (row["FFFS"] != null)
                {
                    model.FFFS = row["FFFS"].ToString();
                }
                if (row["ZFY"] != null)
                {
                    model.ZFY = row["ZFY"].ToString();
                }
                if (row["ZFJE"] != null)
                {
                    model.ZFJE = row["ZFJE"].ToString();
                }
                if (row["LRRQ"] != null)
                {
                    model.LRRQ = row["LRRQ"].ToString();
                }
                if (row["JDRQ"] != null)
                {
                    model.JDRQ = row["JDRQ"].ToString();
                }
                if (row["BLFL"] != null)
                {
                    model.BLFL = row["BLFL"].ToString();
                }
                if (row["HZBLXX"] != null)
                {
                    model.HZBLXX = row["HZBLXX"].ToString();
                }
            }
            return model;
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * ");
            strSql.Append(" FROM patient_info ");
            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 patient_info ");
            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.BINGRENZYID ASC");
            }
            strSql.Append(")AS r, T.*  from patient_info 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 DataTable GetALLListByPage(string strWhere, string orderby, int startIndex, int endIndex,out int count)
        {
            StringBuilder strSql = new StringBuilder();
            StringBuilder strSqlCount = new StringBuilder();
            strSqlCount.Append("SELECT count(1) FROM ( ");    
            strSqlCount.Append(" SELECT ROW_NUMBER() OVER (");
            strSqlCount.Append("order by T1.BRXH desc");

            strSqlCount.Append(" )AS r, T1.*  from patient_info T1 ");
            strSqlCount.Append(" left join operation_info T2 on T1.BRXH=T2.BRXH");
            strSqlCount.Append(" left join DIAGNOSIS_V T3 on T3.BRXH=T2.BRXH ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                strSqlCount.Append(" WHERE " + strWhere);
            }
            strSqlCount.Append(" ) TT");
            count=Convert.ToInt32(DBOracleHelper.GetSingle(strSqlCount.ToString()));

            strSql.Append("SELECT * FROM ( ");
            strSql.Append(" SELECT ROW_NUMBER() OVER (");
            if (!string.IsNullOrEmpty(orderby.Trim()))
            {
                strSql.Append("order by T1." + orderby);
            }
            else
            {
                strSql.Append("order by T1.BRXH desc");
            }
            strSql.Append(" )AS r, T1.*,T2.SSMC  from patient_info T1 ");
            strSql.Append(" left join operation_info T2 on T1.BRXH=T2.BRXH");
            strSql.Append(" left join DIAGNOSIS_V T3 on T3.BRXH=T2.BRXH ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                strSql.Append(" WHERE " + strWhere);
            }
            strSql.Append(" ) TT");
            strSql.AppendFormat(" WHERE TT.r between {0} and {1}", startIndex, endIndex);
            DataSet ds= DBOracleHelper.Query(strSql.ToString());
            if (ds != null && ds.Tables[0] != null)
            {
                if(ds.Tables[0].Rows.Count>0)
                   return ds.Tables[0];
            }
            return null;
        }


        /*
		/// <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_BINGRENQK";
			parameters[1].Value = "ZFJE";
			parameters[2].Value = PageSize;
			parameters[3].Value = PageIndex;
			parameters[4].Value = 0;
			parameters[5].Value = 0;
			parameters[6].Value = strWhere;	
			return DBOracleHelper.RunProcedure("UP_GetRecordByPage",parameters,"ds");
		}*/


        #endregion  BasicMethod
        #region  ExtensionMethod

        #endregion  ExtensionMethod
    }
}