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_Vis_DXNTelphone
	/// </summary>
	public partial class T_Vis_DXNTelphone
    {
        public T_Vis_DXNTelphone()
        { }
        #region  BasicMethod

        /// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(CallCenterApi.Model.T_Vis_DXNTelphone model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_Vis_DXNTelphone(");
            strSql.Append("F_SerialNo,F_InfoDode,F_License,F_brand,F_series,F_CarType,F_ownerName,F_Telphone,F_MobilePhone,F_ownerships,F_usePlace,F_ReportRemark,F_khInfor,F_GroupName,F_khType,F_isInto,F_intointent,F_ReportUser,F_ownerships2,F_ReportTime,F_PerfectRate,F_infoState,F_aging,F_LVDate,F_LVContent,F_LVType,F_VisDate,F_VisContent,F_VisType,F_VisUser,F_VisUserID,F_VisDate1,F_VisContent1,F_VisType1,F_VisUser1,F_VisUserID1,F_VisDate2,F_VisContent2,F_VisType2,F_VisUser2,F_VisUserID2,F_VisDate3,F_VisContent3,F_VisType3,F_VisUser3,F_VisUserID3,F_insertDate,F_insertUser,F_insertUserID,F_liableP,F_hjUser,F_hjUserID,F_hjDate,F_ISCall,F_CallRes,F_CallResID,F_ISCallRes,F_ISVis,F_FileID)");
            strSql.Append(" values (");
            strSql.Append("@F_SerialNo,@F_InfoDode,@F_License,@F_brand,@F_series,@F_CarType,@F_ownerName,@F_Telphone,@F_MobilePhone,@F_ownerships,@F_usePlace,@F_ReportRemark,@F_khInfor,@F_GroupName,@F_khType,@F_isInto,@F_intointent,@F_ReportUser,@F_ownerships2,@F_ReportTime,@F_PerfectRate,@F_infoState,@F_aging,@F_LVDate,@F_LVContent,@F_LVType,@F_VisDate,@F_VisContent,@F_VisType,@F_VisUser,@F_VisUserID,@F_VisDate1,@F_VisContent1,@F_VisType1,@F_VisUser1,@F_VisUserID1,@F_VisDate2,@F_VisContent2,@F_VisType2,@F_VisUser2,@F_VisUserID2,@F_VisDate3,@F_VisContent3,@F_VisType3,@F_VisUser3,@F_VisUserID3,@F_insertDate,@F_insertUser,@F_insertUserID,@F_liableP,@F_hjUser,@F_hjUserID,@F_hjDate,@F_ISCall,@F_CallRes,@F_CallResID,@F_ISCallRes,@F_ISVis,@F_FileID)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@F_SerialNo", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_InfoDode", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_License", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_brand", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_series", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_CarType", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ownerName", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_Telphone", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_MobilePhone", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ownerships", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_usePlace", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ReportRemark", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_khInfor", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_GroupName", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_khType", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_isInto", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_intointent", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ReportUser", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ownerships2", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ReportTime", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_PerfectRate", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_infoState", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_aging", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_LVDate", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_LVContent", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_LVType", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisDate", SqlDbType.DateTime),
                    new SqlParameter("@F_VisContent", SqlDbType.NText),
                    new SqlParameter("@F_VisType", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUser", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUserID", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisDate1", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisContent1", SqlDbType.NText),
                    new SqlParameter("@F_VisType1", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUser1", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUserID1", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisDate2", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisContent2", SqlDbType.NText),
                    new SqlParameter("@F_VisType2", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUser2", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUserID2", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisDate3", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisContent3", SqlDbType.NText),
                    new SqlParameter("@F_VisType3", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUser3", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUserID3", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_insertDate", SqlDbType.DateTime),
                    new SqlParameter("@F_insertUser", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_insertUserID", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_liableP", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_hjUser", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_hjUserID", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_hjDate", SqlDbType.DateTime),
                    new SqlParameter("@F_ISCall", SqlDbType.Int,4),
                    new SqlParameter("@F_CallRes", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_CallResID", SqlDbType.Int,4),
                    new SqlParameter("@F_ISCallRes", SqlDbType.Int,4),
                    new SqlParameter("@F_ISVis", SqlDbType.Int,4),
                    new SqlParameter("@F_FileID", SqlDbType.Int,4)};
            parameters[0].Value = model.F_SerialNo;
            parameters[1].Value = model.F_InfoDode;
            parameters[2].Value = model.F_License;
            parameters[3].Value = model.F_brand;
            parameters[4].Value = model.F_series;
            parameters[5].Value = model.F_CarType;
            parameters[6].Value = model.F_ownerName;
            parameters[7].Value = model.F_Telphone;
            parameters[8].Value = model.F_MobilePhone;
            parameters[9].Value = model.F_ownerships;
            parameters[10].Value = model.F_usePlace;
            parameters[11].Value = model.F_ReportRemark;
            parameters[12].Value = model.F_khInfor;
            parameters[13].Value = model.F_GroupName;
            parameters[14].Value = model.F_khType;
            parameters[15].Value = model.F_isInto;
            parameters[16].Value = model.F_intointent;
            parameters[17].Value = model.F_ReportUser;
            parameters[18].Value = model.F_ownerships2;
            parameters[19].Value = model.F_ReportTime;
            parameters[20].Value = model.F_PerfectRate;
            parameters[21].Value = model.F_infoState;
            parameters[22].Value = model.F_aging;
            parameters[23].Value = model.F_LVDate;
            parameters[24].Value = model.F_LVContent;
            parameters[25].Value = model.F_LVType;
            parameters[26].Value = model.F_VisDate;
            parameters[27].Value = model.F_VisContent;
            parameters[28].Value = model.F_VisType;
            parameters[29].Value = model.F_VisUser;
            parameters[30].Value = model.F_VisUserID;
            parameters[31].Value = model.F_VisDate1;
            parameters[32].Value = model.F_VisContent1;
            parameters[33].Value = model.F_VisType1;
            parameters[34].Value = model.F_VisUser1;
            parameters[35].Value = model.F_VisUserID1;
            parameters[36].Value = model.F_VisDate2;
            parameters[37].Value = model.F_VisContent2;
            parameters[38].Value = model.F_VisType2;
            parameters[39].Value = model.F_VisUser2;
            parameters[40].Value = model.F_VisUserID2;
            parameters[41].Value = model.F_VisDate3;
            parameters[42].Value = model.F_VisContent3;
            parameters[43].Value = model.F_VisType3;
            parameters[44].Value = model.F_VisUser3;
            parameters[45].Value = model.F_VisUserID3;
            parameters[46].Value = model.F_insertDate;
            parameters[47].Value = model.F_insertUser;
            parameters[48].Value = model.F_insertUserID;
            parameters[49].Value = model.F_liableP;
            parameters[50].Value = model.F_hjUser;
            parameters[51].Value = model.F_hjUserID;
            parameters[52].Value = model.F_hjDate;
            parameters[53].Value = model.F_ISCall;
            parameters[54].Value = model.F_CallRes;
            parameters[55].Value = model.F_CallResID;
            parameters[56].Value = model.F_ISCallRes;
            parameters[57].Value = model.F_ISVis;
            parameters[58].Value = model.F_FileID;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(CallCenterApi.Model.T_Vis_DXNTelphone model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update T_Vis_DXNTelphone set ");
            strSql.Append("F_SerialNo=@F_SerialNo,");
            strSql.Append("F_InfoDode=@F_InfoDode,");
            strSql.Append("F_License=@F_License,");
            strSql.Append("F_brand=@F_brand,");
            strSql.Append("F_series=@F_series,");
            strSql.Append("F_CarType=@F_CarType,");
            strSql.Append("F_ownerName=@F_ownerName,");
            strSql.Append("F_Telphone=@F_Telphone,");
            strSql.Append("F_MobilePhone=@F_MobilePhone,");
            strSql.Append("F_ownerships=@F_ownerships,");
            strSql.Append("F_usePlace=@F_usePlace,");
            strSql.Append("F_ReportRemark=@F_ReportRemark,");
            strSql.Append("F_khInfor=@F_khInfor,");
            strSql.Append("F_GroupName=@F_GroupName,");
            strSql.Append("F_khType=@F_khType,");
            strSql.Append("F_isInto=@F_isInto,");
            strSql.Append("F_intointent=@F_intointent,");
            strSql.Append("F_ReportUser=@F_ReportUser,");
            strSql.Append("F_ownerships2=@F_ownerships2,");
            strSql.Append("F_ReportTime=@F_ReportTime,");
            strSql.Append("F_PerfectRate=@F_PerfectRate,");
            strSql.Append("F_infoState=@F_infoState,");
            strSql.Append("F_aging=@F_aging,");
            strSql.Append("F_LVDate=@F_LVDate,");
            strSql.Append("F_LVContent=@F_LVContent,");
            strSql.Append("F_LVType=@F_LVType,");
            strSql.Append("F_VisDate=@F_VisDate,");
            strSql.Append("F_VisContent=@F_VisContent,");
            strSql.Append("F_VisType=@F_VisType,");
            strSql.Append("F_VisUser=@F_VisUser,");
            strSql.Append("F_VisUserID=@F_VisUserID,");
            strSql.Append("F_VisDate1=@F_VisDate1,");
            strSql.Append("F_VisContent1=@F_VisContent1,");
            strSql.Append("F_VisType1=@F_VisType1,");
            strSql.Append("F_VisUser1=@F_VisUser1,");
            strSql.Append("F_VisUserID1=@F_VisUserID1,");
            strSql.Append("F_VisDate2=@F_VisDate2,");
            strSql.Append("F_VisContent2=@F_VisContent2,");
            strSql.Append("F_VisType2=@F_VisType2,");
            strSql.Append("F_VisUser2=@F_VisUser2,");
            strSql.Append("F_VisUserID2=@F_VisUserID2,");
            strSql.Append("F_VisDate3=@F_VisDate3,");
            strSql.Append("F_VisContent3=@F_VisContent3,");
            strSql.Append("F_VisType3=@F_VisType3,");
            strSql.Append("F_VisUser3=@F_VisUser3,");
            strSql.Append("F_VisUserID3=@F_VisUserID3,");
            strSql.Append("F_insertDate=@F_insertDate,");
            strSql.Append("F_insertUser=@F_insertUser,");
            strSql.Append("F_insertUserID=@F_insertUserID,");
            strSql.Append("F_liableP=@F_liableP,");
            strSql.Append("F_hjUser=@F_hjUser,");
            strSql.Append("F_hjUserID=@F_hjUserID,");
            strSql.Append("F_hjDate=@F_hjDate,");
            strSql.Append("F_ISCall=@F_ISCall,");
            strSql.Append("F_CallRes=@F_CallRes,");
            strSql.Append("F_CallResID=@F_CallResID,");
            strSql.Append("F_ISCallRes=@F_ISCallRes,");
            strSql.Append("F_ISVis=@F_ISVis,");
            strSql.Append("F_FileID=@F_FileID");
            strSql.Append(" where F_DVNID=@F_DVNID");
            SqlParameter[] parameters = {
                    new SqlParameter("@F_SerialNo", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_InfoDode", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_License", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_brand", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_series", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_CarType", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ownerName", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_Telphone", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_MobilePhone", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ownerships", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_usePlace", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ReportRemark", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_khInfor", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_GroupName", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_khType", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_isInto", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_intointent", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ReportUser", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ownerships2", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_ReportTime", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_PerfectRate", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_infoState", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_aging", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_LVDate", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_LVContent", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_LVType", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisDate", SqlDbType.DateTime),
                    new SqlParameter("@F_VisContent", SqlDbType.NText),
                    new SqlParameter("@F_VisType", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUser", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUserID", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisDate1", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisContent1", SqlDbType.NText),
                    new SqlParameter("@F_VisType1", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUser1", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUserID1", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisDate2", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisContent2", SqlDbType.NText),
                    new SqlParameter("@F_VisType2", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUser2", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUserID2", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisDate3", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisContent3", SqlDbType.NText),
                    new SqlParameter("@F_VisType3", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUser3", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_VisUserID3", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_insertDate", SqlDbType.DateTime),
                    new SqlParameter("@F_insertUser", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_insertUserID", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_liableP", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_hjUser", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_hjUserID", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_hjDate", SqlDbType.DateTime),
                    new SqlParameter("@F_ISCall", SqlDbType.Int,4),
                    new SqlParameter("@F_CallRes", SqlDbType.NVarChar,250),
                    new SqlParameter("@F_CallResID", SqlDbType.Int,4),
                    new SqlParameter("@F_ISCallRes", SqlDbType.Int,4),
                    new SqlParameter("@F_ISVis", SqlDbType.Int,4),
                    new SqlParameter("@F_FileID", SqlDbType.Int,4),
                    new SqlParameter("@F_DVNID", SqlDbType.Int,4)};
            parameters[0].Value = model.F_SerialNo;
            parameters[1].Value = model.F_InfoDode;
            parameters[2].Value = model.F_License;
            parameters[3].Value = model.F_brand;
            parameters[4].Value = model.F_series;
            parameters[5].Value = model.F_CarType;
            parameters[6].Value = model.F_ownerName;
            parameters[7].Value = model.F_Telphone;
            parameters[8].Value = model.F_MobilePhone;
            parameters[9].Value = model.F_ownerships;
            parameters[10].Value = model.F_usePlace;
            parameters[11].Value = model.F_ReportRemark;
            parameters[12].Value = model.F_khInfor;
            parameters[13].Value = model.F_GroupName;
            parameters[14].Value = model.F_khType;
            parameters[15].Value = model.F_isInto;
            parameters[16].Value = model.F_intointent;
            parameters[17].Value = model.F_ReportUser;
            parameters[18].Value = model.F_ownerships2;
            parameters[19].Value = model.F_ReportTime;
            parameters[20].Value = model.F_PerfectRate;
            parameters[21].Value = model.F_infoState;
            parameters[22].Value = model.F_aging;
            parameters[23].Value = model.F_LVDate;
            parameters[24].Value = model.F_LVContent;
            parameters[25].Value = model.F_LVType;
            parameters[26].Value = model.F_VisDate;
            parameters[27].Value = model.F_VisContent;
            parameters[28].Value = model.F_VisType;
            parameters[29].Value = model.F_VisUser;
            parameters[30].Value = model.F_VisUserID;
            parameters[31].Value = model.F_VisDate1;
            parameters[32].Value = model.F_VisContent1;
            parameters[33].Value = model.F_VisType1;
            parameters[34].Value = model.F_VisUser1;
            parameters[35].Value = model.F_VisUserID1;
            parameters[36].Value = model.F_VisDate2;
            parameters[37].Value = model.F_VisContent2;
            parameters[38].Value = model.F_VisType2;
            parameters[39].Value = model.F_VisUser2;
            parameters[40].Value = model.F_VisUserID2;
            parameters[41].Value = model.F_VisDate3;
            parameters[42].Value = model.F_VisContent3;
            parameters[43].Value = model.F_VisType3;
            parameters[44].Value = model.F_VisUser3;
            parameters[45].Value = model.F_VisUserID3;
            parameters[46].Value = model.F_insertDate;
            parameters[47].Value = model.F_insertUser;
            parameters[48].Value = model.F_insertUserID;
            parameters[49].Value = model.F_liableP;
            parameters[50].Value = model.F_hjUser;
            parameters[51].Value = model.F_hjUserID;
            parameters[52].Value = model.F_hjDate;
            parameters[53].Value = model.F_ISCall;
            parameters[54].Value = model.F_CallRes;
            parameters[55].Value = model.F_CallResID;
            parameters[56].Value = model.F_ISCallRes;
            parameters[57].Value = model.F_ISVis;
            parameters[58].Value = model.F_FileID;
            parameters[59].Value = model.F_DVNID;

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

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

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

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


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

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 F_DVNID,F_SerialNo,F_InfoDode,F_License,F_brand,F_series,F_CarType,F_ownerName,F_Telphone,F_MobilePhone,F_ownerships,F_usePlace,F_ReportRemark,F_khInfor,F_GroupName,F_khType,F_isInto,F_intointent,F_ReportUser,F_ownerships2,F_ReportTime,F_PerfectRate,F_infoState,F_aging,F_LVDate,F_LVContent,F_LVType,F_VisDate,F_VisContent,F_VisType,F_VisUser,F_VisUserID,F_VisDate1,F_VisContent1,F_VisType1,F_VisUser1,F_VisUserID1,F_VisDate2,F_VisContent2,F_VisType2,F_VisUser2,F_VisUserID2,F_VisDate3,F_VisContent3,F_VisType3,F_VisUser3,F_VisUserID3,F_insertDate,F_insertUser,F_insertUserID,F_liableP,F_hjUser,F_hjUserID,F_hjDate,F_ISCall,F_CallRes,F_CallResID,F_ISCallRes,F_ISVis,F_FileID from T_Vis_DXNTelphone ");
            strSql.Append(" where F_DVNID=@F_DVNID");
            SqlParameter[] parameters = {
                    new SqlParameter("@F_DVNID", SqlDbType.Int,4)
            };
            parameters[0].Value = F_DVNID;

            CallCenterApi.Model.T_Vis_DXNTelphone model = new CallCenterApi.Model.T_Vis_DXNTelphone();
            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_Vis_DXNTelphone DataRowToModel(DataRow row)
        {
            CallCenterApi.Model.T_Vis_DXNTelphone model = new CallCenterApi.Model.T_Vis_DXNTelphone();
            if (row != null)
            {
                if (row["F_DVNID"] != null && row["F_DVNID"].ToString() != "")
                {
                    model.F_DVNID = int.Parse(row["F_DVNID"].ToString());
                }
                if (row["F_SerialNo"] != null)
                {
                    model.F_SerialNo = row["F_SerialNo"].ToString();
                }
                if (row["F_InfoDode"] != null)
                {
                    model.F_InfoDode = row["F_InfoDode"].ToString();
                }
                if (row["F_License"] != null)
                {
                    model.F_License = row["F_License"].ToString();
                }
                if (row["F_brand"] != null)
                {
                    model.F_brand = row["F_brand"].ToString();
                }
                if (row["F_series"] != null)
                {
                    model.F_series = row["F_series"].ToString();
                }
                if (row["F_CarType"] != null)
                {
                    model.F_CarType = row["F_CarType"].ToString();
                }
                if (row["F_ownerName"] != null)
                {
                    model.F_ownerName = row["F_ownerName"].ToString();
                }
                if (row["F_Telphone"] != null)
                {
                    model.F_Telphone = row["F_Telphone"].ToString();
                }
                if (row["F_MobilePhone"] != null)
                {
                    model.F_MobilePhone = row["F_MobilePhone"].ToString();
                }
                if (row["F_ownerships"] != null)
                {
                    model.F_ownerships = row["F_ownerships"].ToString();
                }
                if (row["F_usePlace"] != null)
                {
                    model.F_usePlace = row["F_usePlace"].ToString();
                }
                if (row["F_ReportRemark"] != null)
                {
                    model.F_ReportRemark = row["F_ReportRemark"].ToString();
                }
                if (row["F_khInfor"] != null)
                {
                    model.F_khInfor = row["F_khInfor"].ToString();
                }
                if (row["F_GroupName"] != null)
                {
                    model.F_GroupName = row["F_GroupName"].ToString();
                }
                if (row["F_khType"] != null)
                {
                    model.F_khType = row["F_khType"].ToString();
                }
                if (row["F_isInto"] != null)
                {
                    model.F_isInto = row["F_isInto"].ToString();
                }
                if (row["F_intointent"] != null)
                {
                    model.F_intointent = row["F_intointent"].ToString();
                }
                if (row["F_ReportUser"] != null)
                {
                    model.F_ReportUser = row["F_ReportUser"].ToString();
                }
                if (row["F_ownerships2"] != null)
                {
                    model.F_ownerships2 = row["F_ownerships2"].ToString();
                }
                if (row["F_ReportTime"] != null)
                {
                    model.F_ReportTime = row["F_ReportTime"].ToString();
                }
                if (row["F_PerfectRate"] != null)
                {
                    model.F_PerfectRate = row["F_PerfectRate"].ToString();
                }
                if (row["F_infoState"] != null)
                {
                    model.F_infoState = row["F_infoState"].ToString();
                }
                if (row["F_aging"] != null)
                {
                    model.F_aging = row["F_aging"].ToString();
                }
                if (row["F_LVDate"] != null)
                {
                    model.F_LVDate = row["F_LVDate"].ToString();
                }
                if (row["F_LVContent"] != null)
                {
                    model.F_LVContent = row["F_LVContent"].ToString();
                }
                if (row["F_LVType"] != null)
                {
                    model.F_LVType = row["F_LVType"].ToString();
                }
                if (row["F_VisDate"] != null && row["F_VisDate"].ToString() != "")
                {
                    model.F_VisDate = DateTime.Parse(row["F_VisDate"].ToString());
                }
                if (row["F_VisContent"] != null)
                {
                    model.F_VisContent = row["F_VisContent"].ToString();
                }
                if (row["F_VisType"] != null)
                {
                    model.F_VisType = row["F_VisType"].ToString();
                }
                if (row["F_VisUser"] != null)
                {
                    model.F_VisUser = row["F_VisUser"].ToString();
                }
                if (row["F_VisUserID"] != null)
                {
                    model.F_VisUserID = row["F_VisUserID"].ToString();
                }
                if (row["F_VisDate1"] != null)
                {
                    model.F_VisDate1 = row["F_VisDate1"].ToString();
                }
                if (row["F_VisContent1"] != null)
                {
                    model.F_VisContent1 = row["F_VisContent1"].ToString();
                }
                if (row["F_VisType1"] != null)
                {
                    model.F_VisType1 = row["F_VisType1"].ToString();
                }
                if (row["F_VisUser1"] != null)
                {
                    model.F_VisUser1 = row["F_VisUser1"].ToString();
                }
                if (row["F_VisUserID1"] != null)
                {
                    model.F_VisUserID1 = row["F_VisUserID1"].ToString();
                }
                if (row["F_VisDate2"] != null)
                {
                    model.F_VisDate2 = row["F_VisDate2"].ToString();
                }
                if (row["F_VisContent2"] != null)
                {
                    model.F_VisContent2 = row["F_VisContent2"].ToString();
                }
                if (row["F_VisType2"] != null)
                {
                    model.F_VisType2 = row["F_VisType2"].ToString();
                }
                if (row["F_VisUser2"] != null)
                {
                    model.F_VisUser2 = row["F_VisUser2"].ToString();
                }
                if (row["F_VisUserID2"] != null)
                {
                    model.F_VisUserID2 = row["F_VisUserID2"].ToString();
                }
                if (row["F_VisDate3"] != null)
                {
                    model.F_VisDate3 = row["F_VisDate3"].ToString();
                }
                if (row["F_VisContent3"] != null)
                {
                    model.F_VisContent3 = row["F_VisContent3"].ToString();
                }
                if (row["F_VisType3"] != null)
                {
                    model.F_VisType3 = row["F_VisType3"].ToString();
                }
                if (row["F_VisUser3"] != null)
                {
                    model.F_VisUser3 = row["F_VisUser3"].ToString();
                }
                if (row["F_VisUserID3"] != null)
                {
                    model.F_VisUserID3 = row["F_VisUserID3"].ToString();
                }
                if (row["F_insertDate"] != null && row["F_insertDate"].ToString() != "")
                {
                    model.F_insertDate = DateTime.Parse(row["F_insertDate"].ToString());
                }
                if (row["F_insertUser"] != null)
                {
                    model.F_insertUser = row["F_insertUser"].ToString();
                }
                if (row["F_insertUserID"] != null)
                {
                    model.F_insertUserID = row["F_insertUserID"].ToString();
                }
                if (row["F_liableP"] != null)
                {
                    model.F_liableP = row["F_liableP"].ToString();
                }
                if (row["F_hjUser"] != null)
                {
                    model.F_hjUser = row["F_hjUser"].ToString();
                }
                if (row["F_hjUserID"] != null)
                {
                    model.F_hjUserID = row["F_hjUserID"].ToString();
                }
                if (row["F_hjDate"] != null && row["F_hjDate"].ToString() != "")
                {
                    model.F_hjDate = DateTime.Parse(row["F_hjDate"].ToString());
                }
                if (row["F_ISCall"] != null && row["F_ISCall"].ToString() != "")
                {
                    model.F_ISCall = int.Parse(row["F_ISCall"].ToString());
                }
                if (row["F_CallRes"] != null)
                {
                    model.F_CallRes = row["F_CallRes"].ToString();
                }
                if (row["F_CallResID"] != null && row["F_CallResID"].ToString() != "")
                {
                    model.F_CallResID = int.Parse(row["F_CallResID"].ToString());
                }
                if (row["F_ISCallRes"] != null && row["F_ISCallRes"].ToString() != "")
                {
                    model.F_ISCallRes = int.Parse(row["F_ISCallRes"].ToString());
                }
                if (row["F_ISVis"] != null && row["F_ISVis"].ToString() != "")
                {
                    model.F_ISVis = int.Parse(row["F_ISVis"].ToString());
                }
                if (row["F_FileID"] != null && row["F_FileID"].ToString() != "")
                {
                    model.F_FileID = int.Parse(row["F_FileID"].ToString());
                }
            }
            return model;
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select F_DVNID,F_SerialNo,F_InfoDode,F_License,F_brand,F_series,F_CarType,F_ownerName,F_Telphone,F_MobilePhone,F_ownerships,F_usePlace,F_ReportRemark,F_khInfor,F_GroupName,F_khType,F_isInto,F_intointent,F_ReportUser,F_ownerships2,F_ReportTime,F_PerfectRate,F_infoState,F_aging,F_LVDate,F_LVContent,F_LVType,F_VisDate,F_VisContent,F_VisType,F_VisUser,F_VisUserID,F_VisDate1,F_VisContent1,F_VisType1,F_VisUser1,F_VisUserID1,F_VisDate2,F_VisContent2,F_VisType2,F_VisUser2,F_VisUserID2,F_VisDate3,F_VisContent3,F_VisType3,F_VisUser3,F_VisUserID3,F_insertDate,F_insertUser,F_insertUserID,F_liableP,F_hjUser,F_hjUserID,F_hjDate,F_ISCall,F_CallRes,F_CallResID,F_ISCallRes,F_ISVis,F_FileID ");
            strSql.Append(" FROM T_Vis_DXNTelphone ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        /// <summary>
        /// 获得前几行数据
        /// </summary>
        public DataSet GetList(int Top, string strWhere, string filedOrder)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ");
            if (Top > 0)
            {
                strSql.Append(" top " + Top.ToString());
            }
            strSql.Append(" F_DVNID,F_SerialNo,F_InfoDode,F_License,F_brand,F_series,F_CarType,F_ownerName,F_Telphone,F_MobilePhone,F_ownerships,F_usePlace,F_ReportRemark,F_khInfor,F_GroupName,F_khType,F_isInto,F_intointent,F_ReportUser,F_ownerships2,F_ReportTime,F_PerfectRate,F_infoState,F_aging,F_LVDate,F_LVContent,F_LVType,F_VisDate,F_VisContent,F_VisType,F_VisUser,F_VisUserID,F_VisDate1,F_VisContent1,F_VisType1,F_VisUser1,F_VisUserID1,F_VisDate2,F_VisContent2,F_VisType2,F_VisUser2,F_VisUserID2,F_VisDate3,F_VisContent3,F_VisType3,F_VisUser3,F_VisUserID3,F_insertDate,F_insertUser,F_insertUserID,F_liableP,F_hjUser,F_hjUserID,F_hjDate,F_ISCall,F_CallRes,F_CallResID,F_ISCallRes,F_ISVis,F_FileID ");
            strSql.Append(" FROM T_Vis_DXNTelphone ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            strSql.Append(" order by " + filedOrder);
            return DbHelperSQL.Query(strSql.ToString());
        }

        /// <summary>
        /// 获取记录总数
        /// </summary>
        public int GetRecordCount(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) FROM T_Vis_DXNTelphone ");
            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 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_DVNID desc");
            }
            strSql.Append(")AS Row, T.*  from T_Vis_DXNTelphone 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());
        }

        #endregion  BasicMethod
        #region  ExtensionMethod
        /// <summary>
        /// 呼叫状态更新
        /// </summary>
        /// <returns></returns>
        public bool UpdateHJ(int telid, int uid, string uname, int resid, string res)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update T_Vis_DXNTelphone set ");
            strSql.Append("F_ISCall=1,");
            strSql.Append("F_CallResID=@F_CallResID,");
            strSql.Append("F_CallRes=@F_CallRes,");
            strSql.Append("F_hjDate=GetDate(),");
            strSql.Append("F_hjUser=@F_CallUserName,");
            strSql.Append("F_hjUserID=@F_CallUserID");
            strSql.Append(" where F_DVNID=@F_DVNID");
            SqlParameter[] parameters = {
                    new SqlParameter("@F_CallResID", SqlDbType.Int,4),
                    new SqlParameter("@F_CallRes", SqlDbType.VarChar,50),
                    new SqlParameter("@F_CallUserName", SqlDbType.VarChar,50),
                    new SqlParameter("@F_CallUserID", SqlDbType.Int,4),
                    new SqlParameter("@F_DVNID", SqlDbType.Int,4)};
            parameters[0].Value = resid;
            parameters[1].Value = res;
            parameters[2].Value = uname;
            parameters[3].Value = uid;
            parameters[4].Value = telid;

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

        /// <summary>
        /// 回访更新
        /// </summary>
        /// <returns></returns>
        public bool UpdateHF(int telid, bool isres, int resid, string res, int uid, string uname,
             string vistype, string viscontent, int isvis)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update T_Vis_DXNTelphone set ");
            strSql.Append("F_VisContent=@F_VisContent,");
            strSql.Append("F_VisType=@F_VisType,");
            strSql.Append("F_ISCallRes=@F_ISCallRes,");
            strSql.Append("F_CallResID=@F_CallResID,");
            strSql.Append("F_CallRes=@F_CallRes,");
            strSql.Append("F_ISVis=@F_ISVis,");
            strSql.Append("F_VisDate=GetDate(),");
            strSql.Append("F_VisUser=@F_VisUserName,");
            strSql.Append("F_VisUserID=@F_VisUserID");
            strSql.Append(" where F_DVNID=@F_DVNID");
            SqlParameter[] parameters = {
                new SqlParameter("@F_VisContent", SqlDbType.VarChar,50),
                new SqlParameter("@F_VisType", SqlDbType.VarChar,50),
                    new SqlParameter("@F_ISCallRes", SqlDbType.Bit),
                    new SqlParameter("@F_CallResID", SqlDbType.Int,4),
                    new SqlParameter("@F_CallRes", SqlDbType.VarChar,50),
                    new SqlParameter("@F_ISVis", SqlDbType.Int,4),
                    new SqlParameter("@F_VisUserName", SqlDbType.VarChar,50),
                    new SqlParameter("@F_VisUserID", SqlDbType.Int,4),
                    new SqlParameter("@F_DVNID", SqlDbType.Int,4)};

            parameters[0].Value = viscontent;
            parameters[1].Value = vistype;
            parameters[2].Value = isres;
            parameters[3].Value = resid;
            parameters[4].Value = res;
            parameters[5].Value = isvis;
            parameters[6].Value = uname;
            parameters[7].Value = uid;
            parameters[8].Value = telid;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        public DataSet GetListExpt(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ");
            strSql.Append("F_SerialNo,F_InfoDode,F_License,F_brand,F_series,F_CarType,F_ownerName,F_Telphone,F_MobilePhone,F_ownerships,");
            strSql.Append("F_usePlace, F_ReportRemark, F_khInfor, ");
            strSql.Append("F_GroupName, F_khType, F_isInto, F_intointent, F_ReportUser, F_ownerships2, F_ReportTime, ");
            strSql.Append("F_PerfectRate, F_infoState, F_aging, ");
            strSql.Append("F_liableP,F_VisDate,F_VisContent,F_VisType,F_VisUser,F_insertDate,F_hjDate,");
            strSql.Append("case F_ISCall when 1 then '已呼叫' else '未呼叫' end F_CallState,");
            strSql.Append("case F_ISCallRes when 1 then '已接通' else '未接通' end F_CallResState, F_CallRes");
            strSql.Append(" FROM T_Vis_DXNTelphone ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());

        }
        /// <summary>
        /// 根据文件删除
        /// </summary>
        public bool DeleteListByFileID(string FileID)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from T_Vis_DXNTelphone ");
            strSql.Append(" where F_Fileid =" + FileID + " ");
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        #endregion  ExtensionMethod
    }
}