using CallCenterApi.DB;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace CallCenterApi.DAL
{
    /// <summary>
    /// 数据访问类:T_Med_FollowUp
    /// </summary>
    public partial class T_Med_FollowUp
    {
        public T_Med_FollowUp()
        { }

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(CallCenterApi.Model.T_Med_FollowUp model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update T_Med_FollowUp set ");
            strSql.Append("F_Name=@F_Name,");
            strSql.Append("F_Addr=@F_Addr,");
            strSql.Append("F_State=@F_State,");
            strSql.Append("F_Code=@F_Code,");
            strSql.Append("F_Age=@F_Age,");
            strSql.Append("F_InDate=@F_InDate,");
            strSql.Append("F_OutDate=@F_OutDate,");
            strSql.Append("F_DischargeDept=@F_DischargeDept,");
            strSql.Append("F_AdmissionDept=@F_AdmissionDept,");
            strSql.Append("F_TubeDoctor=@F_TubeDoctor,");
            strSql.Append("F_Phone=@F_Phone,");
            strSql.Append("F_OpeName=@F_OpeName,");
            strSql.Append("F_Context=@F_Context,");
            strSql.Append("F_Type=@F_Type,");
            strSql.Append("F_Level=@F_Level,");
            strSql.Append("F_FirstLevel=@F_FirstLevel,");
            strSql.Append("F_SecondLevel=@F_SecondLevel,");
            strSql.Append("F_BedNum=@F_BedNum,");
            strSql.Append("F_CostsNature=@F_CostsNature,");
            strSql.Append("F_FollowUpNum=@F_FollowUpNum,");
            strSql.Append("F_IsDel=@F_IsDel,");
            strSql.Append("F_ZDMC=@F_ZDMC,");
            strSql.Append("F_TotalCosts=@F_TotalCosts,");
            strSql.Append("F_SFDate=@F_SFDate,");
            strSql.Append("F_SFPerson=@F_SFPerson,");
            strSql.Append("F_SFResult=@F_SFResult,");
            strSql.Append("F_Satisfied=@F_Satisfied,");
            strSql.Append("F_Advise=@F_Advise,");
            strSql.Append("F_Praise=@F_Praise,");
            strSql.Append("F_Criticism=@F_Criticism,");
            strSql.Append("F_PagerID=@F_PagerID");
            strSql.Append(" where F_Id=@F_Id");
            SqlParameter[] parameters = {
                    new SqlParameter("@F_Id", SqlDbType.Int,4),
                    new SqlParameter("@F_Name", SqlDbType.NVarChar,50),
                    new SqlParameter("@F_Addr", SqlDbType.NVarChar,500),
                    new SqlParameter("@F_State", SqlDbType.Int,4),
                    new SqlParameter("@F_Code", SqlDbType.NVarChar,50),
                    new SqlParameter("@F_Age", SqlDbType.NVarChar,50),
                    new SqlParameter("@F_InDate", SqlDbType.DateTime),
                    new SqlParameter("@F_OutDate", SqlDbType.DateTime),
                    new SqlParameter("@F_DischargeDept", SqlDbType.NVarChar,50),
                    new SqlParameter("@F_AdmissionDept", SqlDbType.NVarChar,50),
                    new SqlParameter("@F_TubeDoctor", SqlDbType.NVarChar,50),
                    new SqlParameter("@F_Phone", SqlDbType.NVarChar,50),
                    new SqlParameter("@F_OpeName", SqlDbType.NVarChar,50),
                    new SqlParameter("@F_Context", SqlDbType.VarChar,5000),
                    new SqlParameter("@F_Type", SqlDbType.VarChar,50),
                    new SqlParameter("@F_Level", SqlDbType.VarChar,50),
                    new SqlParameter("@F_FirstLevel", SqlDbType.Int,4),
                    new SqlParameter("@F_SecondLevel", SqlDbType.Int,4),
                    new SqlParameter("@F_BedNum", SqlDbType.Int,4),
                    new SqlParameter("@F_CostsNature", SqlDbType.VarChar,50),
                    new SqlParameter("@F_FollowUpNum", SqlDbType.Int,4),
                    new SqlParameter("@F_IsDel", SqlDbType.Int,4),
                    new SqlParameter("@F_TotalCosts", SqlDbType.Decimal ),
                    new SqlParameter("@F_SFDate", SqlDbType.DateTime),
                    new SqlParameter("@F_ZDMC", SqlDbType.VarChar,50),
                    new SqlParameter("@F_SFPerson", SqlDbType.VarChar,50),
                    new SqlParameter("@F_SFResult", SqlDbType.VarChar,50),
                    new SqlParameter("@F_Satisfied", SqlDbType.VarChar,50),
                    new SqlParameter("@F_Advise", SqlDbType.VarChar,500),
                    new SqlParameter("@F_Praise", SqlDbType.VarChar,500),
                    new SqlParameter("@F_Criticism", SqlDbType.VarChar,500),
                    new SqlParameter("@F_PagerID", SqlDbType.Int,8)
            };
            parameters[0].Value = model.F_Id;
            parameters[1].Value = model.F_Name;
            parameters[2].Value = model.F_Addr;
            parameters[3].Value = model.F_State;
            parameters[4].Value = model.F_Code;
            parameters[5].Value = model.F_Age;
            parameters[6].Value = model.F_InDate;
            parameters[7].Value = model.F_OutDate;
            parameters[8].Value = model.F_DischargeDept;
            parameters[9].Value = model.F_AdmissionDept;
            parameters[10].Value = model.F_TubeDoctor;
            parameters[11].Value = model.F_Phone;
            parameters[12].Value = model.F_OpeName;
            parameters[13].Value = model.F_Context;
            parameters[14].Value = model.F_Type;
            parameters[15].Value = model.F_Level;
            parameters[16].Value = model.F_FirstLevel;
            parameters[17].Value = model.F_SecondLevel;
            parameters[18].Value = model.F_BedNum;
            parameters[19].Value = model.F_CostsNature;
            parameters[20].Value = model.F_FollowUpNum;
            parameters[21].Value = model.F_IsDel;
            parameters[22].Value = model.F_TotalCosts;
            parameters[23].Value = model.F_SFDate;
            parameters[24].Value = model.F_ZDMC;
            parameters[25].Value = model.F_SFPerson;
            parameters[26].Value = model.F_SFResult;
            parameters[27].Value = model.F_Satisfied;
            parameters[28].Value = model.F_Advise;
            parameters[29].Value = model.F_Praise;
            parameters[30].Value = model.F_Criticism;
            parameters[31].Value = model.F_PagerID;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

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

        /// <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.F_Id desc");
            }
            strSql.Append(")AS Row, T.*  from T_Med_FollowUp T ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                strSql.Append(" WHERE " + strWhere);
            }
            strSql.Append(" ) TT");
            strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
            return DbHelperSQL.Query(strSql.ToString());
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public CallCenterApi.Model.T_Med_FollowUp GetModel(int ID)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 * from T_Med_FollowUp ");
            strSql.Append(" where F_Id=@ID");
            SqlParameter[] parameters = {
                    new SqlParameter("@ID", SqlDbType.Int,4)
            };
            parameters[0].Value = ID;

            CallCenterApi.Model.T_Msg_List model = new CallCenterApi.Model.T_Msg_List();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public CallCenterApi.Model.T_Med_FollowUp DataRowToModel(DataRow row)
        {
            CallCenterApi.Model.T_Med_FollowUp model = new CallCenterApi.Model.T_Med_FollowUp();
            if (row != null)
            {
                if (row["F_Id"] != null && row["F_Id"].ToString() != "")
                {
                    model.F_Id = int.Parse(row["F_Id"].ToString());
                }
                if (row["F_Name"] != null )
                {
                    model.F_Name = row["F_Name"].ToString();
                }
                if (row["F_Addr"] != null)
                {
                    model.F_Addr = row["F_Addr"].ToString();
                }
                if (row["F_State"] != null && row["F_State"].ToString() != "")
                {
                    model.F_State = int.Parse(row["F_State"].ToString());
                }
                if (row["F_Code"] != null)
                {
                    model.F_Code = row["F_Code"].ToString();
                }
                if (row["F_Age"] != null )
                {
                    model.F_Age = row["F_Age"].ToString();
                }                
                if (row["F_InDate"] != null && row["F_InDate"].ToString() != "")
                {
                    model.F_InDate = DateTime.Parse(row["F_InDate"].ToString());
                }
                if (row["F_OutDate"] != null && row["F_OutDate"].ToString() != "")
                {
                    model.F_OutDate = DateTime.Parse(row["F_OutDate"].ToString());
                }
                if (row["F_DischargeDept"] != null )
                {
                    model.F_DischargeDept = row["F_DischargeDept"].ToString();
                }
                if (row["F_AdmissionDept"] != null)
                {
                    model.F_AdmissionDept = row["F_AdmissionDept"].ToString();
                }
                if (row["F_TubeDoctor"] != null )
                {
                    model.F_TubeDoctor = row["F_TubeDoctor"].ToString();
                }

                if (row["F_Phone"] != null)
                {
                    model.F_Phone = row["F_Phone"].ToString();
                }
                if (row["F_OpeName"] != null)
                {
                    model.F_OpeName = row["F_OpeName"].ToString();
                }
                if (row["F_Context"] != null)
                {
                    model.F_Context = row["F_Context"].ToString();
                }
                if (row["F_Type"] != null)
                {
                    model.F_Type = row["F_Type"].ToString();
                }
                if (row["F_Level"] != null)
                {
                    model.F_Level = row["F_Level"].ToString();
                }
                if (row["F_CostsNature"] != null)
                {
                    model.F_CostsNature = row["F_CostsNature"].ToString();
                }
                if (row["F_FirstLevel"] != null && row["F_FirstLevel"].ToString() != "")
                {
                    model.F_FirstLevel = int.Parse(row["F_FirstLevel"].ToString());
                }
                if (row["F_SecondLevel"] != null && row["F_SecondLevel"].ToString() != "")
                {
                    model.F_SecondLevel = int.Parse(row["F_SecondLevel"].ToString());
                }
                if (row["F_BedNum"] != null && row["F_BedNum"].ToString() != "")
                {
                    model.F_BedNum = int.Parse(row["F_BedNum"].ToString());
                }
                if (row["F_FollowUpNum"] != null && row["F_FollowUpNum"].ToString() != "")
                {
                    model.F_FollowUpNum = int.Parse(row["F_FollowUpNum"].ToString());
                }
                if (row["F_IsDel"] != null && row["F_IsDel"].ToString() != "")
                {
                    model.F_IsDel = int.Parse(row["F_IsDel"].ToString());
                }
                if (row["F_ZDMC"] != null)
                {
                    model.F_ZDMC = row["F_ZDMC"].ToString();
                }
                if (row["F_TotalCosts"] != null && row["F_TotalCosts"].ToString() != "")
                {
                    model.F_TotalCosts = decimal.Parse(row["F_TotalCosts"].ToString());
                }
                if (row["F_SFDate"] != null && row["F_SFDate"].ToString() != "")
                {
                    model.F_SFDate = DateTime.Parse(row["F_SFDate"].ToString());
                }
                if (row["F_SFPerson"] != null)
                {
                    model.F_SFPerson = row["F_SFPerson"].ToString();
                }
                if (row["F_SFResult"] != null)
                {
                    model.F_SFResult = row["F_SFResult"].ToString();
                }
                if (row["F_Satisfied"] != null)
                {
                    model.F_Satisfied = row["F_Satisfied"].ToString();
                }
                if (row["F_Advise"] != null)
                {
                    model.F_Advise = row["F_Advise"].ToString();
                }
                if (row["F_Praise"] != null)
                {
                    model.F_Praise = row["F_Praise"].ToString();
                }
                if (row["F_Criticism"] != null)
                {
                    model.F_Criticism = row["F_Criticism"].ToString();
                }
            }
            return model;
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(int ID)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from T_Med_FollowUp ");
            strSql.Append(" where F_Id=@ID");
            SqlParameter[] parameters = {
                    new SqlParameter("@ID", SqlDbType.Int,4)
            };
            parameters[0].Value = ID;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 批量删除数据
        /// </summary>
        public bool DeleteList(string IDlist)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from T_Med_FollowUp ");
            strSql.Append(" where F_Id in (" + IDlist + ")  ");
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 获取记录总数
        /// </summary>
        public int GetRecordCount(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) FROM T_Med_FollowUp ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            object obj = DbHelperSQL.GetSingle(strSql.ToString());
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 病例信息
        /// </summary>
        public DataSet GetBLList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select distinct a.BINGRENZYID,BRXM,a.XZZDH,XB,NL,RYKS,ZZYSXM  FROM SF_BINGRENQK a left join SF_ZHENDUAN b on a.BAH=b.BINGANHAO");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }
    }
}