DanChengCallCenter_API/codegit/CallCenterApi/CallCenterAp.../his/sf_bingrenqk...


using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using CallCenterApi.DB;
using System.Collections.Generic;
using System.Collections;

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



        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(CallCenterApi.Model.SF_BINGRENQK model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into SF_BINGRENQK(");
            strSql.Append("BAH,BINGRENZYID,BRXH,ZYCS,RYRQ,CYRQ,BRXM,XB,CSRQ,NL,NLR,GJ,HY,SFZH,HKDZ,HKDZYB,XZZ,XZZDH,XZZYB,GZDW,DWDH,DWYB,GXRXM,GX,GXRZZ,GXRDH,RYQK,RYKS,RYBS,ZKKB,CYKS,CYBS,ZYTS,RYQZRQ,KZRBH,KZRXM,ZRYSBH,ZRYSXM,ZZYSBH,ZZYSXM,ZYYSBH,ZYYSXM,ZRHSBH,ZRHSXM,LYFS,FFFS,ZFY,ZFJE,JDRQ,BLFL,HZBLXX,CYHZQK)");
            strSql.Append(" values (");
            strSql.Append("@BAH,@BINGRENZYID,@BRXH,@ZYCS,@RYRQ,@CYRQ,@BRXM,@XB,@CSRQ,@NL,@NLR,@GJ,@HY,@SFZH,@HKDZ,@HKDZYB,@XZZ,@XZZDH,@XZZYB,@GZDW,@DWDH,@DWYB,@GXRXM,@GX,@GXRZZ,@GXRDH,@RYQK,@RYKS,@RYBS,@ZKKB,@CYKS,@CYBS,@ZYTS,@RYQZRQ,@KZRBH,@KZRXM,@ZRYSBH,@ZRYSXM,@ZZYSBH,@ZZYSXM,@ZYYSBH,@ZYYSXM,@ZRHSBH,@ZRHSXM,@LYFS,@FFFS,@ZFY,@ZFJE,@JDRQ,@BLFL,@HZBLXX,@CYHZQK)");
            SqlParameter[] parameters = {
                    new SqlParameter("@BAH", SqlDbType.NVarChar,100),
                    new SqlParameter("@BINGRENZYID", SqlDbType.NVarChar,100),
                    new SqlParameter("@BRXH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYCS", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@CYRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@BRXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@XB", SqlDbType.NVarChar,100),
                    new SqlParameter("@CSRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@NL", SqlDbType.NVarChar,100),
                    new SqlParameter("@NLR", SqlDbType.NVarChar,100),
                    new SqlParameter("@GJ", SqlDbType.NVarChar,100),
                    new SqlParameter("@HY", SqlDbType.NVarChar,100),
                    new SqlParameter("@SFZH", SqlDbType.NVarChar,100),
                    new SqlParameter("@HKDZ", SqlDbType.NVarChar,100),
                    new SqlParameter("@HKDZYB", SqlDbType.NVarChar,100),
                    new SqlParameter("@XZZ", SqlDbType.NVarChar,100),
                    new SqlParameter("@XZZDH", SqlDbType.NVarChar,100),
                    new SqlParameter("@XZZYB", SqlDbType.NVarChar,100),
                    new SqlParameter("@GZDW", SqlDbType.NVarChar,100),
                    new SqlParameter("@DWDH", SqlDbType.NVarChar,100),
                    new SqlParameter("@DWYB", SqlDbType.NVarChar,100),
                    new SqlParameter("@GXRXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@GX", SqlDbType.NVarChar,100),
                    new SqlParameter("@GXRZZ", SqlDbType.NVarChar,100),
                    new SqlParameter("@GXRDH", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYQK", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYKS", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYBS", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZKKB", SqlDbType.NVarChar,100),
                    new SqlParameter("@CYKS", SqlDbType.NVarChar,100),
                    new SqlParameter("@CYBS", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYTS", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYQZRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@KZRBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@KZRXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRYSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRYSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZZYSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZZYSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYYSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYYSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRHSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRHSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@LYFS", SqlDbType.NVarChar,100),
                    new SqlParameter("@FFFS", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZFY", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZFJE", SqlDbType.NVarChar,100),
                    new SqlParameter("@JDRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@BLFL", SqlDbType.NVarChar,100),
                     new SqlParameter("@HZBLXX", SqlDbType.NVarChar,100),
                      new SqlParameter("@CYHZQK", SqlDbType.NVarChar,100)
                    

            };
            parameters[0].Value = model.BAH;
            parameters[1].Value = model.BINGRENZYID;
            parameters[2].Value = model.BRXH;
            parameters[3].Value = model.ZYCS;
            parameters[4].Value = model.RYRQ;
            parameters[5].Value = model.CYRQ;
            parameters[6].Value = model.BRXM;
            parameters[7].Value = model.XB;
            parameters[8].Value = model.CSRQ;
            parameters[9].Value = model.NL;
            parameters[10].Value = model.NLR;
            parameters[11].Value = model.GJ;
            parameters[12].Value = model.HY;
            parameters[13].Value = model.SFZH;
            parameters[14].Value = model.HKDZ;
            parameters[15].Value = model.HKDZYB;
            parameters[16].Value = model.XZZ;
            parameters[17].Value = model.XZZDH;
            parameters[18].Value = model.XZZYB;
            parameters[19].Value = model.GZDW;
            parameters[20].Value = model.DWDH;
            parameters[21].Value = model.DWYB;
            parameters[22].Value = model.GXRXM;
            parameters[23].Value = model.GX;
            parameters[24].Value = model.GXRZZ;
            parameters[25].Value = model.GXRDH;
            parameters[26].Value = model.RYQK;
            parameters[27].Value = model.RYKS;
            parameters[28].Value = model.RYBS;
            parameters[29].Value = model.ZKKB;
            parameters[30].Value = model.CYKS;
            parameters[31].Value = model.CYBS;
            parameters[32].Value = model.ZYTS;
            parameters[33].Value = model.RYQZRQ;
            parameters[34].Value = model.KZRBH;
            parameters[35].Value = model.KZRXM;
            parameters[36].Value = model.ZRYSBH;
            parameters[37].Value = model.ZRYSXM;
            parameters[38].Value = model.ZZYSBH;
            parameters[39].Value = model.ZZYSXM;
            parameters[40].Value = model.ZYYSBH;
            parameters[41].Value = model.ZYYSXM;
            parameters[42].Value = model.ZRHSBH;
            parameters[43].Value = model.ZRHSXM;
            parameters[44].Value = model.LYFS;
            parameters[45].Value = model.FFFS;
            parameters[46].Value = model.ZFY;
            parameters[47].Value = model.ZFJE;
            parameters[48].Value = model.JDRQ;
            parameters[49].Value = model.BLFL;
            parameters[50].Value = model.HZBLXX;
            parameters[51].Value = model.CYHZQK;
            



            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
		/// 增加一条数据
		/// </summary>
		public int AddAll(List<CallCenterApi.Model.SF_BINGRENQK> modellist)
        {
            List<CommandInfo> ha = new List<CommandInfo>();
            foreach (CallCenterApi.Model.SF_BINGRENQK model in modellist)
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("insert into SF_BINGRENQK(");
                strSql.Append("BAH,BINGRENZYID,BRXH,ZYCS,RYRQ,CYRQ,BRXM,XB,CSRQ,NL,NLR,GJ,HY,SFZH,HKDZ,HKDZYB,XZZ,XZZDH,XZZYB,GZDW,DWDH,DWYB,GXRXM,GX,GXRZZ,GXRDH,RYQK,RYKS,RYBS,ZKKB,CYKS,CYBS,ZYTS,RYQZRQ,KZRBH,KZRXM,ZRYSBH,ZRYSXM,ZZYSBH,ZZYSXM,ZYYSBH,ZYYSXM,ZRHSBH,ZRHSXM,LYFS,FFFS,ZFY,ZFJE,LRRQ,JDRQ,BLFL,HZBLXX,CYHZQK)");
                strSql.Append(" values (");
                strSql.Append("@BAH,@BINGRENZYID,@BRXH,@ZYCS,@RYRQ,@CYRQ,@BRXM,@XB,@CSRQ,@NL,@NLR,@GJ,@HY,@SFZH,@HKDZ,@HKDZYB,@XZZ,@XZZDH,@XZZYB,@GZDW,@DWDH,@DWYB,@GXRXM,@GX,@GXRZZ,@GXRDH,@RYQK,@RYKS,@RYBS,@ZKKB,@CYKS,@CYBS,@ZYTS,@RYQZRQ,@KZRBH,@KZRXM,@ZRYSBH,@ZRYSXM,@ZZYSBH,@ZZYSXM,@ZYYSBH,@ZYYSXM,@ZRHSBH,@ZRHSXM,@LYFS,@FFFS,@ZFY,@ZFJE,@LRRQ,@JDRQ,@BLFL,@HZBLXX,@CYHZQK)");
                SqlParameter[] parameters = {
                    new SqlParameter("@BAH", SqlDbType.NVarChar,100),
                    new SqlParameter("@BINGRENZYID", SqlDbType.NVarChar,100),
                    new SqlParameter("@BRXH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYCS", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@CYRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@BRXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@XB", SqlDbType.NVarChar,100),
                    new SqlParameter("@CSRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@NL", SqlDbType.NVarChar,100),
                    new SqlParameter("@NLR", SqlDbType.NVarChar,100),
                    new SqlParameter("@GJ", SqlDbType.NVarChar,100),
                    new SqlParameter("@HY", SqlDbType.NVarChar,100),
                    new SqlParameter("@SFZH", SqlDbType.NVarChar,100),
                    new SqlParameter("@HKDZ", SqlDbType.NVarChar,100),
                    new SqlParameter("@HKDZYB", SqlDbType.NVarChar,100),
                    new SqlParameter("@XZZ", SqlDbType.NVarChar,100),
                    new SqlParameter("@XZZDH", SqlDbType.NVarChar,100),
                    new SqlParameter("@XZZYB", SqlDbType.NVarChar,100),
                    new SqlParameter("@GZDW", SqlDbType.NVarChar,100),
                    new SqlParameter("@DWDH", SqlDbType.NVarChar,100),
                    new SqlParameter("@DWYB", SqlDbType.NVarChar,100),
                    new SqlParameter("@GXRXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@GX", SqlDbType.NVarChar,100),
                    new SqlParameter("@GXRZZ", SqlDbType.NVarChar,100),
                    new SqlParameter("@GXRDH", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYQK", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYKS", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYBS", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZKKB", SqlDbType.NVarChar,100),
                    new SqlParameter("@CYKS", SqlDbType.NVarChar,100),
                    new SqlParameter("@CYBS", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYTS", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYQZRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@KZRBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@KZRXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRYSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRYSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZZYSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZZYSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYYSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYYSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRHSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRHSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@LYFS", SqlDbType.NVarChar,100),
                    new SqlParameter("@FFFS", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZFY", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZFJE", SqlDbType.NVarChar,100),
                    new SqlParameter("@LRRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@JDRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@BLFL", SqlDbType.NVarChar,100),
                     new SqlParameter("@HZBLXX", SqlDbType.NVarChar,100),
                     new SqlParameter("@CYHZQK", SqlDbType.NVarChar,100)

                     

                };
                parameters[0].Value = model.BAH;
                parameters[1].Value = model.BINGRENZYID;
                parameters[2].Value = model.BRXH;
                parameters[3].Value = model.ZYCS;
                parameters[4].Value = model.RYRQ;
                parameters[5].Value = model.CYRQ;
                parameters[6].Value = model.BRXM;
                parameters[7].Value = model.XB;
                parameters[8].Value = model.CSRQ;
                parameters[9].Value = model.NL;
                parameters[10].Value = model.NLR;
                parameters[11].Value = model.GJ;
                parameters[12].Value = model.HY;
                parameters[13].Value = model.SFZH;
                parameters[14].Value = model.HKDZ;
                parameters[15].Value = model.HKDZYB;
                parameters[16].Value = model.XZZ;
                parameters[17].Value = model.XZZDH;
                parameters[18].Value = model.XZZYB;
                parameters[19].Value = model.GZDW;
                parameters[20].Value = model.DWDH;
                parameters[21].Value = model.DWYB;
                parameters[22].Value = model.GXRXM;
                parameters[23].Value = model.GX;
                parameters[24].Value = model.GXRZZ;
                parameters[25].Value = model.GXRDH;
                parameters[26].Value = model.RYQK;
                parameters[27].Value = model.RYKS;
                parameters[28].Value = model.RYBS;
                parameters[29].Value = model.ZKKB;
                parameters[30].Value = model.CYKS;
                parameters[31].Value = model.CYBS;
                parameters[32].Value = model.ZYTS;
                parameters[33].Value = model.RYQZRQ;
                parameters[34].Value = model.KZRBH;
                parameters[35].Value = model.KZRXM;
                parameters[36].Value = model.ZRYSBH;
                parameters[37].Value = model.ZRYSXM;
                parameters[38].Value = model.ZZYSBH;
                parameters[39].Value = model.ZZYSXM;
                parameters[40].Value = model.ZYYSBH;
                parameters[41].Value = model.ZYYSXM;
                parameters[42].Value = model.ZRHSBH;
                parameters[43].Value = model.ZRHSXM;
                parameters[44].Value = model.LYFS;
                parameters[45].Value = model.FFFS;
                parameters[46].Value = model.ZFY;
                parameters[47].Value = model.ZFJE;
                parameters[48].Value = model.LRRQ;
                parameters[49].Value = model.JDRQ;
                parameters[50].Value = model.BLFL;
                parameters[51].Value = model.HZBLXX;
                parameters[52].Value = model.CYHZQK;

                 CommandInfo md = new CommandInfo(strSql.ToString(), parameters);
                ha.Add(md);
            }
            int rows = DbHelperSQL.ExecuteSqlTran(ha);

            return rows;

        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(CallCenterApi.Model.SF_BINGRENQK model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update SF_BINGRENQK set ");
            strSql.Append("BAH=@BAH,");
            strSql.Append("BINGRENZYID=@BINGRENZYID,");
            strSql.Append("BRXH=@BRXH,");
            strSql.Append("ZYCS=@ZYCS,");
            strSql.Append("RYRQ=@RYRQ,");
            strSql.Append("CYRQ=@CYRQ,");
            strSql.Append("BRXM=@BRXM,");
            strSql.Append("XB=@XB,");
            strSql.Append("CSRQ=@CSRQ,");
            strSql.Append("NL=@NL,");
            strSql.Append("NLR=@NLR,");
            strSql.Append("GJ=@GJ,");
            strSql.Append("HY=@HY,");
            strSql.Append("SFZH=@SFZH,");
            strSql.Append("HKDZ=@HKDZ,");
            strSql.Append("HKDZYB=@HKDZYB,");
            strSql.Append("XZZ=@XZZ,");
            strSql.Append("XZZDH=@XZZDH,");
            strSql.Append("XZZYB=@XZZYB,");
            strSql.Append("GZDW=@GZDW,");
            strSql.Append("DWDH=@DWDH,");
            strSql.Append("DWYB=@DWYB,");
            strSql.Append("GXRXM=@GXRXM,");
            strSql.Append("GX=@GX,");
            strSql.Append("GXRZZ=@GXRZZ,");
            strSql.Append("GXRDH=@GXRDH,");
            strSql.Append("RYQK=@RYQK,");
            strSql.Append("RYKS=@RYKS,");
            strSql.Append("RYBS=@RYBS,");
            strSql.Append("ZKKB=@ZKKB,");
            strSql.Append("CYKS=@CYKS,");
            strSql.Append("CYBS=@CYBS,");
            strSql.Append("ZYTS=@ZYTS,");
            strSql.Append("RYQZRQ=@RYQZRQ,");
            strSql.Append("KZRBH=@KZRBH,");
            strSql.Append("KZRXM=@KZRXM,");
            strSql.Append("ZRYSBH=@ZRYSBH,");
            strSql.Append("ZRYSXM=@ZRYSXM,");
            strSql.Append("ZZYSBH=@ZZYSBH,");
            strSql.Append("ZZYSXM=@ZZYSXM,");
            strSql.Append("ZYYSBH=@ZYYSBH,");
            strSql.Append("ZYYSXM=@ZYYSXM,");
            strSql.Append("ZRHSBH=@ZRHSBH,");
            strSql.Append("ZRHSXM=@ZRHSXM,");
            strSql.Append("LYFS=@LYFS,");
            strSql.Append("FFFS=@FFFS,");
            strSql.Append("ZFY=@ZFY,");
            strSql.Append("ZFJE=@ZFJE,");
            strSql.Append("JDRQ=@JDRQ,");
            strSql.Append("BLFL=@BLFL");
            strSql.Append(" where BINGRENZYID=@BINGRENZYID");
            SqlParameter[] parameters = {
                    new SqlParameter("@BAH", SqlDbType.NVarChar,100),
                    new SqlParameter("@BINGRENZYID", SqlDbType.NVarChar,100),
                    new SqlParameter("@BRXH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYCS", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@CYRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@BRXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@XB", SqlDbType.NVarChar,100),
                    new SqlParameter("@CSRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@NL", SqlDbType.NVarChar,100),
                    new SqlParameter("@NLR", SqlDbType.NVarChar,100),
                    new SqlParameter("@GJ", SqlDbType.NVarChar,100),
                    new SqlParameter("@HY", SqlDbType.NVarChar,100),
                    new SqlParameter("@SFZH", SqlDbType.NVarChar,100),
                    new SqlParameter("@HKDZ", SqlDbType.NVarChar,100),
                    new SqlParameter("@HKDZYB", SqlDbType.NVarChar,100),
                    new SqlParameter("@XZZ", SqlDbType.NVarChar,100),
                    new SqlParameter("@XZZDH", SqlDbType.NVarChar,100),
                    new SqlParameter("@XZZYB", SqlDbType.NVarChar,100),
                    new SqlParameter("@GZDW", SqlDbType.NVarChar,100),
                    new SqlParameter("@DWDH", SqlDbType.NVarChar,100),
                    new SqlParameter("@DWYB", SqlDbType.NVarChar,100),
                    new SqlParameter("@GXRXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@GX", SqlDbType.NVarChar,100),
                    new SqlParameter("@GXRZZ", SqlDbType.NVarChar,100),
                    new SqlParameter("@GXRDH", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYQK", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYKS", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYBS", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZKKB", SqlDbType.NVarChar,100),
                    new SqlParameter("@CYKS", SqlDbType.NVarChar,100),
                    new SqlParameter("@CYBS", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYTS", SqlDbType.NVarChar,100),
                    new SqlParameter("@RYQZRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@KZRBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@KZRXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRYSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRYSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZZYSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZZYSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYYSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZYYSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRHSBH", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZRHSXM", SqlDbType.NVarChar,100),
                    new SqlParameter("@LYFS", SqlDbType.NVarChar,100),
                    new SqlParameter("@FFFS", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZFY", SqlDbType.NVarChar,100),
                    new SqlParameter("@ZFJE", SqlDbType.NVarChar,100),
                    new SqlParameter("@JDRQ", SqlDbType.NVarChar,100),
                    new SqlParameter("@BLFL", SqlDbType.NVarChar, 100)};
            parameters[0].Value = model.BAH;
            parameters[1].Value = model.BINGRENZYID;
            parameters[2].Value = model.BRXH;
            parameters[3].Value = model.ZYCS;
            parameters[4].Value = model.RYRQ;
            parameters[5].Value = model.CYRQ;
            parameters[6].Value = model.BRXM;
            parameters[7].Value = model.XB;
            parameters[8].Value = model.CSRQ;
            parameters[9].Value = model.NL;
            parameters[10].Value = model.NLR;
            parameters[11].Value = model.GJ;
            parameters[12].Value = model.HY;
            parameters[13].Value = model.SFZH;
            parameters[14].Value = model.HKDZ;
            parameters[15].Value = model.HKDZYB;
            parameters[16].Value = model.XZZ;
            parameters[17].Value = model.XZZDH;
            parameters[18].Value = model.XZZYB;
            parameters[19].Value = model.GZDW;
            parameters[20].Value = model.DWDH;
            parameters[21].Value = model.DWYB;
            parameters[22].Value = model.GXRXM;
            parameters[23].Value = model.GX;
            parameters[24].Value = model.GXRZZ;
            parameters[25].Value = model.GXRDH;
            parameters[26].Value = model.RYQK;
            parameters[27].Value = model.RYKS;
            parameters[28].Value = model.RYBS;
            parameters[29].Value = model.ZKKB;
            parameters[30].Value = model.CYKS;
            parameters[31].Value = model.CYBS;
            parameters[32].Value = model.ZYTS;
            parameters[33].Value = model.RYQZRQ;
            parameters[34].Value = model.KZRBH;
            parameters[35].Value = model.KZRXM;
            parameters[36].Value = model.ZRYSBH;
            parameters[37].Value = model.ZRYSXM;
            parameters[38].Value = model.ZZYSBH;
            parameters[39].Value = model.ZZYSXM;
            parameters[40].Value = model.ZYYSBH;
            parameters[41].Value = model.ZYYSXM;
            parameters[42].Value = model.ZRHSBH;
            parameters[43].Value = model.ZRHSXM;
            parameters[44].Value = model.LYFS;
            parameters[45].Value = model.FFFS;
            parameters[46].Value = model.ZFY;
            parameters[47].Value = model.ZFJE;
            parameters[48].Value = model.JDRQ;
            parameters[49].Value = model.BLFL;
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete()
        {
            //该表无主键信息，请自定义主键/条件字段
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from SF_BINGRENQK ");
            strSql.Append(" where ");
            SqlParameter[] parameters = {
            };

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


        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public CallCenterApi.Model.SF_BINGRENQK GetModel(string id)
        {
            //该表无主键信息，请自定义主键/条件字段
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 * from SF_BINGRENQK ");
            strSql.Append(" where ");
            strSql.Append(" BINGRENZYID=@id ");
            SqlParameter[] parameters = { new SqlParameter("@id", id)
            };

            CallCenterApi.Model.SF_BINGRENQK model = new CallCenterApi.Model.SF_BINGRENQK();
            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.SF_BINGRENQK DataRowToModel(DataRow row)
        {
            CallCenterApi.Model.SF_BINGRENQK model = new CallCenterApi.Model.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();
                }
                if (row["CYHZQK"] != null)
                {
                    model.CYHZQK = row["CYHZQK"].ToString();
                }
            }
            return model;
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select BAH,BINGRENZYID,BRXH,ZYCS,RYRQ,CYRQ,BRXM,XB,CSRQ,NL,NLR,GJ,HY,SFZH,HKDZ,HKDZYB,XZZ,XZZDH,XZZYB,GZDW,DWDH,DWYB,GXRXM,GX,GXRZZ,GXRDH,RYQK,RYKS,RYBS,ZKKB,CYKS,CYBS,ZYTS,RYQZRQ,KZRBH,KZRXM,ZRYSBH,ZRYSXM,ZZYSBH,ZZYSXM,ZYYSBH,ZYYSXM,ZRHSBH,ZRHSXM,LYFS,FFFS,ZFY,ZFJE,JDRQ,BLFL,LRRQ,HZBLXX ");
            strSql.Append(" FROM SF_BINGRENQK ");
            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(" BAH,BINGRENZYID,BRXH,ZYCS,RYRQ,CYRQ,BRXM,XB,CSRQ,NL,NLR,GJ,HY,SFZH,HKDZ,HKDZYB,XZZ,XZZDH,XZZYB,GZDW,DWDH,DWYB,GXRXM,GX,GXRZZ,GXRDH,RYQK,RYKS,RYBS,ZKKB,CYKS,CYBS,ZYTS,RYQZRQ,KZRBH,KZRXM,ZRYSBH,ZRYSXM,ZZYSBH,ZZYSXM,ZYYSBH,ZYYSXM,ZRHSBH,ZRHSXM,LYFS,FFFS,ZFY,ZFJE,JDRQ,BLFL,HZBLXX,LRRQ ");
            strSql.Append(" FROM SF_BINGRENQK ");
            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 SF_BINGRENQK ");
            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. desc");
            }
            strSql.Append(")AS Row, T.*  from SF_BINGRENQK 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 DataTable GetALLListByPage(string strWhere, string orderby, int startIndex, int endIndex, out int count)
        {
            #region 去重一下 一个病人只显示一个手术信息，因为对应的随访的登记问卷 用的是bingrenzyid
            //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 SF_BINGRENQK T1 ");
            //strSqlCount.Append(" left join sf_shoushuxx T2 on T2.BINGRENZYID=T1.BINGRENZYID");
            //strSqlCount.Append(" left join sf_zhenduan T3 on T3.BINGRENZYID=T1.BRXH ");
            //strSqlCount.Append(" left join SF_Result T4 on T4.F_Id=T1.BINGRENZYID ");
            //if (!string.IsNullOrEmpty(strWhere.Trim()))
            //{
            //    strSqlCount.Append(" WHERE " + strWhere);
            //}
            //strSqlCount.Append(" ) TT");
            //count = Convert.ToInt32(DbHelperSQL.GetSingle(strSqlCount.ToString()));

            //strSql.Append("SELECT * FROM ( ");
            //strSql.Append(" SELECT ROW_NUMBER() OVER (");
            //if (!string.IsNullOrEmpty(orderby.Trim()))
            //{
            //    strSql.Append("order by T4." + orderby);
            //}
            //else
            //{
            //    strSql.Append("order by T1.BINGRENZYID desc");
            //}
            //strSql.Append(" )AS r, T1.*,T2.SSMC,T4.*  from SF_BINGRENQK T1 ");
            //strSql.Append(" left join sf_shoushuxx T2 on T2.BINGRENZYID=T1.BINGRENZYID");
            //strSql.Append(" left join sf_zhenduan T3 on T3.BINGRENZYID=T1.BINGRENZYID ");
            //strSql.Append(" left join SF_Result T4 on T4.F_Id=T1.BINGRENZYID ");
            //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 = DbHelperSQL.Query(strSql.ToString());
            //if (ds != null && ds.Tables[0] != null)
            //{
            //    if (ds.Tables[0].Rows.Count > 0)
            //        return ds.Tables[0];
            //}
            //return null;
            #endregion



            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 SF_BINGRENQK T1 ");
            strSqlCount.Append(" left join sf_zhenduan T3 on T3.BINGRENZYID=T1.BRXH ");
            strSqlCount.Append(" left join SF_Result T4 on T4.F_Id=T1.BINGRENZYID ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                strSqlCount.Append(" WHERE " + strWhere);
            }
            strSqlCount.Append(" ) TT");
            count = Convert.ToInt32(DbHelperSQL.GetSingle(strSqlCount.ToString()));

            strSql.Append("SELECT * FROM ( ");
            strSql.Append(" SELECT ROW_NUMBER() OVER (");
            if (!string.IsNullOrEmpty(orderby.Trim()))
            {
                strSql.Append("order by T4." + orderby);
            }
            else
            {
                strSql.Append("order by T1.BINGRENZYID desc");
            }
            strSql.Append(" )AS r, T1.*,  (SELECT TOP 1 T2.ssmc FROM sf_shoushuxx T2 WHERE T2.BINGRENZYID=T1.BINGRENZYID) ssmc,T4.*  from SF_BINGRENQK T1 ");
            // strSql.Append(" left join sf_zhenduan T3 on T3.BINGRENZYID=T1.BINGRENZYID ");
            strSql.Append(" left join SF_Result T4 on T4.F_Id=T1.BINGRENZYID ");

            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 = DbHelperSQL.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 DataTable GetALLListById(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 T1." + orderby);
            }
            else
            {
                strSql.Append("order by T1.BINGRENZYID desc");
            }
            strSql.Append(" )AS r, T1.*,T2.SSMC,T2.SSRQ,T4.*  from SF_BINGRENQK T1 ");
            strSql.Append(" left join sf_shoushuxx T2 on T2.BINGRENZYID=T1.BINGRENZYID");
            strSql.Append(" left join sf_zhenduan T3 on T3.BINGRENZYID=T1.BINGRENZYID ");
            strSql.Append(" left join SF_Result T4 on T4.F_Id=T1.BINGRENZYID ");
            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 = DbHelperSQL.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)
		{
			SqlParameter[] parameters = {
					new SqlParameter("@tblName", SqlDbType.VarChar, 255),
					new SqlParameter("@fldName", SqlDbType.VarChar, 255),
					new SqlParameter("@PageSize", SqlDbType.Int),
					new SqlParameter("@PageIndex", SqlDbType.Int),
					new SqlParameter("@IsReCount", SqlDbType.Bit),
					new SqlParameter("@OrderType", SqlDbType.Bit),
					new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
					};
			parameters[0].Value = "SF_BINGRENQK";
			parameters[1].Value = "";
			parameters[2].Value = PageSize;
			parameters[3].Value = PageIndex;
			parameters[4].Value = 0;
			parameters[5].Value = 0;
			parameters[6].Value = strWhere;	
			return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
		}*/

        #endregion  BasicMethod
        #region  ExtensionMethod
        public string GetMaxCount()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select Max(BINGRENZYID) FROM SF_BINGRENQK where BINGRENZYID< '10000000' ");

            object obj = DbHelperSQL.GetSingle(strSql.ToString());
            if (obj == null)
            {
                return "0";
            }
            else
            {
                return obj.ToString();
            }
        }

        public string GetMaxDate()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select Max(CYRQ) FROM SF_BINGRENQK where BINGRENZYID< '10000000'");

            object obj = DbHelperSQL.GetSingle(strSql.ToString());
            if (obj == null)
            {
                return "0";
            }
            else
            {
                return obj.ToString();
            }

        }

        #endregion  ExtensionMethod
    }
}