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)");
			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)");
			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 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)");
                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)");
                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)
                    
                };
                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;
                
                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();
                }
            }
			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,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 int GetMaxCount()
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select Max(BINGRENZYID) FROM SF_BINGRENQK ");

            object obj = DbHelperSQL.GetSingle(strSql.ToString());
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
        #endregion  ExtensionMethod
    }
}