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
{
///
/// 数据访问类:SF_BINGRENQK
///
public partial class SF_BINGRENQK
{
public SF_BINGRENQK()
{}
#region BasicMethod
///
/// 增加一条数据
///
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;
}
}
///
/// 增加一条数据
///
public int AddAll(List modellist)
{
List ha = new List();
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;
}
///
/// 更新一条数据
///
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;
}
}
///
/// 删除一条数据
///
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;
}
}
///
/// 得到一个对象实体
///
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;
}
}
///
/// 得到一个对象实体
///
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;
}
///
/// 获得数据列表
///
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());
}
///
/// 获得前几行数据
///
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());
}
///
/// 获取记录总数
///
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);
}
}
///
/// 分页获取数据列表
///
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());
}
///
/// 分页获取数据列表
///
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;
}
///
/// 分页获取数据列表
///
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;
}
/*
///
/// 分页获取数据列表
///
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
}
}