/// <summary>
/// 增加一条数据
/// </summary>
public void Add(DigiPower.Onlinecol.Standard.Model.c_single_project_MDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into c_single_project(");
strSql.Append("SingleProjectID,dxgcmc,sgdw,dxth,qd,zd,chd,gg,cz,hz,kgsj,jgsj,gczj,gcjs,ajs,wz,tzj,tzz,dt,zp,dp,ly,lx,gp,cd,cp,swz,qt,bgqx,mj,jgrq,yjdw,swh,cfwz,note,swp,lrr,lrsj,zrsbh,lxr,lxdh,gisid,ywzd,ghxkzh,sgxkzh,zlaqjddw,zlyj,gc_code,YDXKZH,ydghxkzh,HJQK,SJDW_XMFZR,KCDW,KCDW_XMFZR,JLDW_XMFZR,SGDW_XMJL,ZJLGCS,ZYJLGCS,FBDW,FBDW_XMJL,FBDW_1,FBDW_1_XMJL,ZYGZ,XMZYZLJCY,SGBZZ,TBR,JSDW_SHR,JLDW_SHR,SHRQ,TJLB,FPSJ,FPR,SPR,SPR_DH,FP_BZ,sjyl,bg,ms,ll,sjdw,jldw,kzdj,wzz,zcd,gczl,gcys,qdzb,zdzb,fz)");
strSql.Append(" values (");
strSql.Append("@SingleProjectID,@dxgcmc,@sgdw,@dxth,@qd,@zd,@chd,@gg,@cz,@hz,@kgsj,@jgsj,@gczj,@gcjs,@ajs,@wz,@tzj,@tzz,@dt,@zp,@dp,@ly,@lx,@gp,@cd,@cp,@swz,@qt,@bgqx,@mj,@jgrq,@yjdw,@swh,@cfwz,@note,@swp,@lrr,@lrsj,@zrsbh,@lxr,@lxdh,@gisid,@ywzd,@ghxkzh,@sgxkzh,@zlaqjddw,@zlyj,@gc_code,@YDXKZH,@ydghxkzh,@HJQK,@SJDW_XMFZR,@KCDW,@KCDW_XMFZR,@JLDW_XMFZR,@SGDW_XMJL,@ZJLGCS,@ZYJLGCS,@FBDW,@FBDW_XMJL,@FBDW_1,@FBDW_1_XMJL,@ZYGZ,@XMZYZLJCY,@SGBZZ,@TBR,@JSDW_SHR,@JLDW_SHR,@SHRQ,@TJLB,@FPSJ,@FPR,@SPR,@SPR_DH,@FP_BZ,@sjyl,@bg,@ms,@ll,@sjdw,@jldw,@kzdj,@wzz,@zcd,@gczl,@gcys,@qdzb,@zdzb,@fz)");
SqlParameter[] parameters =
{
new SqlParameter("@SingleProjectID", SqlDbType.Int, 8),
new SqlParameter("@dxgcmc", SqlDbType.VarChar, 80),
new SqlParameter("@sgdw", SqlDbType.VarChar, 80),
new SqlParameter("@dxth", SqlDbType.VarChar, 20),
new SqlParameter("@qd", SqlDbType.VarChar, 80),
new SqlParameter("@zd", SqlDbType.VarChar, 80),
new SqlParameter("@chd", SqlDbType.Decimal, 9),
new SqlParameter("@gg", SqlDbType.VarChar, 40),
new SqlParameter("@cz", SqlDbType.VarChar, 40),
new SqlParameter("@hz", SqlDbType.VarChar, 40),
new SqlParameter("@kgsj", SqlDbType.DateTime),
new SqlParameter("@jgsj", SqlDbType.DateTime),
new SqlParameter("@gczj", SqlDbType.Decimal, 9),
new SqlParameter("@gcjs", SqlDbType.Decimal, 9),
new SqlParameter("@ajs", SqlDbType.Int, 8),
new SqlParameter("@wz", SqlDbType.Int, 8),
new SqlParameter("@tzj", SqlDbType.Int, 8),
new SqlParameter("@tzz", SqlDbType.Int, 8),
new SqlParameter("@dt", SqlDbType.Int, 8),
new SqlParameter("@zp", SqlDbType.Int, 8),
new SqlParameter("@dp", SqlDbType.Int, 8),
new SqlParameter("@ly", SqlDbType.Int, 8),
new SqlParameter("@lx", SqlDbType.Int, 8),
new SqlParameter("@gp", SqlDbType.Int, 8),
new SqlParameter("@cd", SqlDbType.Int, 8),
new SqlParameter("@cp", SqlDbType.Int, 8),
new SqlParameter("@swz", SqlDbType.Int, 8),
new SqlParameter("@qt", SqlDbType.VarChar, 200),
new SqlParameter("@bgqx", SqlDbType.VarChar, 10),
new SqlParameter("@mj", SqlDbType.VarChar, 10),
new SqlParameter("@jgrq", SqlDbType.DateTime),
new SqlParameter("@yjdw", SqlDbType.VarChar, 80),
new SqlParameter("@swh", SqlDbType.VarChar, 60),
new SqlParameter("@cfwz", SqlDbType.VarChar, 20),
new SqlParameter("@note", SqlDbType.VarChar, 100),
new SqlParameter("@swp", SqlDbType.Int, 8),
new SqlParameter("@lrr", SqlDbType.VarChar, 10),
new SqlParameter("@lrsj", SqlDbType.DateTime),
new SqlParameter("@zrsbh", SqlDbType.VarChar, 20),
new SqlParameter("@lxr", SqlDbType.VarChar, 20),
new SqlParameter("@lxdh", SqlDbType.VarChar, 30),
new SqlParameter("@gisid", SqlDbType.Int, 8),
new SqlParameter("@ywzd", SqlDbType.Int, 8),
new SqlParameter("@ghxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@sgxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@zlaqjddw", SqlDbType.VarChar, 80),
new SqlParameter("@zlyj", SqlDbType.VarChar, 1),
new SqlParameter("@gc_code", SqlDbType.VarChar, 20),
new SqlParameter("@YDXKZH", SqlDbType.VarChar, 80),
new SqlParameter("@ydghxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@HJQK", SqlDbType.VarChar, 60),
new SqlParameter("@SJDW_XMFZR", SqlDbType.VarChar, 20),
new SqlParameter("@KCDW", SqlDbType.VarChar, 80),
new SqlParameter("@KCDW_XMFZR", SqlDbType.VarChar, 20),
new SqlParameter("@JLDW_XMFZR", SqlDbType.VarChar, 20),
new SqlParameter("@SGDW_XMJL", SqlDbType.VarChar, 20),
new SqlParameter("@ZJLGCS", SqlDbType.VarChar, 20),
new SqlParameter("@ZYJLGCS", SqlDbType.VarChar, 20),
new SqlParameter("@FBDW", SqlDbType.VarChar, 80),
new SqlParameter("@FBDW_XMJL", SqlDbType.VarChar, 20),
new SqlParameter("@FBDW_1", SqlDbType.VarChar, 80),
new SqlParameter("@FBDW_1_XMJL", SqlDbType.VarChar, 20),
new SqlParameter("@ZYGZ", SqlDbType.VarChar, 20),
new SqlParameter("@XMZYZLJCY", SqlDbType.VarChar, 20),
new SqlParameter("@SGBZZ", SqlDbType.VarChar, 20),
new SqlParameter("@TBR", SqlDbType.VarChar, 20),
new SqlParameter("@JSDW_SHR", SqlDbType.VarChar, 20),
new SqlParameter("@JLDW_SHR", SqlDbType.VarChar, 20),
new SqlParameter("@SHRQ", SqlDbType.DateTime),
new SqlParameter("@TJLB", SqlDbType.VarChar, 60),
new SqlParameter("@FPSJ", SqlDbType.DateTime),
new SqlParameter("@FPR", SqlDbType.VarChar, 20),
new SqlParameter("@SPR", SqlDbType.VarChar, 20),
new SqlParameter("@SPR_DH", SqlDbType.VarChar, 20),
new SqlParameter("@FP_BZ", SqlDbType.VarChar, 100),
new SqlParameter("@sjyl", SqlDbType.VarChar, 40),
new SqlParameter("@bg", SqlDbType.VarChar, 40),
new SqlParameter("@ms", SqlDbType.VarChar, 40),
new SqlParameter("@ll", SqlDbType.VarChar, 40),
new SqlParameter("@sjdw", SqlDbType.VarChar, 80),
new SqlParameter("@jldw", SqlDbType.VarChar, 80),
new SqlParameter("@kzdj", SqlDbType.VarChar, 80),
new SqlParameter("@wzz", SqlDbType.Int, 8),
new SqlParameter("@zcd", SqlDbType.VarChar, 50),
new SqlParameter("@gczl", SqlDbType.VarChar, 50),
new SqlParameter("@gcys", SqlDbType.VarChar, 50),
new SqlParameter("@qdzb", SqlDbType.VarChar, 50),
new SqlParameter("@zdzb", SqlDbType.VarChar, 50),
new SqlParameter("@fz", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.SingleProjectID;
parameters[1].Value = model.dxgcmc;
parameters[2].Value = model.sgdw;
parameters[3].Value = model.dxth;
parameters[4].Value = model.qd;
parameters[5].Value = model.zd;
parameters[6].Value = model.chd;
parameters[7].Value = model.gg;
parameters[8].Value = model.cz;
parameters[9].Value = model.hz;
parameters[10].Value = model.kgsj;
parameters[11].Value = model.jgsj;
parameters[12].Value = model.gczj;
parameters[13].Value = model.gcjs;
parameters[14].Value = model.ajs;
parameters[15].Value = model.wz;
parameters[16].Value = model.tzj;
parameters[17].Value = model.tzz;
parameters[18].Value = model.dt;
parameters[19].Value = model.zp;
parameters[20].Value = model.dp;
parameters[21].Value = model.ly;
parameters[22].Value = model.lx;
parameters[23].Value = model.gp;
parameters[24].Value = model.cd;
parameters[25].Value = model.cp;
parameters[26].Value = model.swz;
parameters[27].Value = model.qt;
parameters[28].Value = model.bgqx;
parameters[29].Value = model.mj;
parameters[30].Value = model.jgrq;
parameters[31].Value = model.yjdw;
parameters[32].Value = model.swh;
parameters[33].Value = model.cfwz;
parameters[34].Value = model.note;
parameters[35].Value = model.swp;
parameters[36].Value = model.lrr;
parameters[37].Value = model.lrsj;
parameters[38].Value = model.zrsbh;
parameters[39].Value = model.lxr;
parameters[40].Value = model.lxdh;
parameters[41].Value = model.gisid;
parameters[42].Value = model.ywzd;
parameters[43].Value = model.ghxkzh;
parameters[44].Value = model.sgxkzh;
parameters[45].Value = model.zlaqjddw;
parameters[46].Value = model.zlyj;
parameters[47].Value = model.gc_code;
parameters[48].Value = model.YDXKZH;
parameters[49].Value = model.ydghxkzh;
parameters[50].Value = model.HJQK;
parameters[51].Value = model.SJDW_XMFZR;
parameters[52].Value = model.KCDW;
parameters[53].Value = model.KCDW_XMFZR;
parameters[54].Value = model.JLDW_XMFZR;
parameters[55].Value = model.SGDW_XMJL;
parameters[56].Value = model.ZJLGCS;
parameters[57].Value = model.ZYJLGCS;
parameters[58].Value = model.FBDW;
parameters[59].Value = model.FBDW_XMJL;
parameters[60].Value = model.FBDW_1;
parameters[61].Value = model.FBDW_1_XMJL;
parameters[62].Value = model.ZYGZ;
parameters[63].Value = model.XMZYZLJCY;
parameters[64].Value = model.SGBZZ;
parameters[65].Value = model.TBR;
parameters[66].Value = model.JSDW_SHR;
parameters[67].Value = model.JLDW_SHR;
parameters[68].Value = model.SHRQ;
parameters[69].Value = model.TJLB;
parameters[70].Value = model.FPSJ;
parameters[71].Value = model.FPR;
parameters[72].Value = model.SPR;
parameters[73].Value = model.SPR_DH;
parameters[74].Value = model.FP_BZ;
parameters[75].Value = model.sjyl;
parameters[76].Value = model.bg;
parameters[77].Value = model.ms;
parameters[78].Value = model.ll;
parameters[79].Value = model.sjdw;
parameters[80].Value = model.jldw;
parameters[81].Value = model.kzdj;
parameters[82].Value = model.wzz;
parameters[83].Value = model.zcd;
parameters[84].Value = model.gczl;
parameters[85].Value = model.gcys;
parameters[86].Value = model.qdzb;
parameters[87].Value = model.zdzb;
parameters[88].Value = model.fz;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DigiPower.Onlinecol.Standard.Model.c_single_project_MDL GetModel(int SingleProjectID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SingleProjectID,dxgcmc,sgdw,dxth,qd,zd,chd,gg,cz,hz,kgsj,jgsj,gczj,gcjs,ajs,wz,tzj,tzz,dt,zp,dp,ly,lx,gp,cd,cp,swz,qt,bgqx,mj,jgrq,yjdw,swh,cfwz,note,swp,lrr,lrsj,zrsbh,lxr,lxdh,gisid,ywzd,ghxkzh,sgxkzh,zlaqjddw,zlyj,gc_code,YDXKZH,ydghxkzh,HJQK,SJDW_XMFZR,KCDW,KCDW_XMFZR,JLDW_XMFZR,SGDW_XMJL,ZJLGCS,ZYJLGCS,FBDW,FBDW_XMJL,FBDW_1,FBDW_1_XMJL,ZYGZ,XMZYZLJCY,SGBZZ,TBR,JSDW_SHR,JLDW_SHR,SHRQ,TJLB,FPSJ,FPR,SPR,SPR_DH,FP_BZ,sjyl,bg,ms,ll,sjdw,jldw,kzdj,wzz,zcd,gczl,gcys,qdzb,zdzb,fz from c_single_project ");
strSql.Append(" where SingleProjectID=@SingleProjectID ");
SqlParameter[] parameters =
{
new SqlParameter("@SingleProjectID", SqlDbType.Int, 8)
};
parameters[0].Value = SingleProjectID;
DigiPower.Onlinecol.Standard.Model.c_single_project_MDL model = new DigiPower.Onlinecol.Standard.Model.c_single_project_MDL();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SingleProjectID"].ToString() != "")
{
model.SingleProjectID = int.Parse(ds.Tables[0].Rows[0]["SingleProjectID"].ToString());
}
model.dxgcmc = ds.Tables[0].Rows[0]["dxgcmc"].ToString();
model.sgdw = ds.Tables[0].Rows[0]["sgdw"].ToString();
model.dxth = ds.Tables[0].Rows[0]["dxth"].ToString();
model.qd = ds.Tables[0].Rows[0]["qd"].ToString();
model.zd = ds.Tables[0].Rows[0]["zd"].ToString();
if (ds.Tables[0].Rows[0]["chd"].ToString() != "")
{
model.chd = decimal.Parse(ds.Tables[0].Rows[0]["chd"].ToString());
}
model.gg = ds.Tables[0].Rows[0]["gg"].ToString();
model.cz = ds.Tables[0].Rows[0]["cz"].ToString();
model.hz = ds.Tables[0].Rows[0]["hz"].ToString();
if (ds.Tables[0].Rows[0]["kgsj"].ToString() != "")
{
model.kgsj = DateTime.Parse(ds.Tables[0].Rows[0]["kgsj"].ToString());
}
if (ds.Tables[0].Rows[0]["jgsj"].ToString() != "")
{
model.jgsj = DateTime.Parse(ds.Tables[0].Rows[0]["jgsj"].ToString());
}
if (ds.Tables[0].Rows[0]["gczj"].ToString() != "")
{
model.gczj = decimal.Parse(ds.Tables[0].Rows[0]["gczj"].ToString());
}
if (ds.Tables[0].Rows[0]["gcjs"].ToString() != "")
{
model.gcjs = decimal.Parse(ds.Tables[0].Rows[0]["gcjs"].ToString());
}
if (ds.Tables[0].Rows[0]["ajs"].ToString() != "")
{
model.ajs = int.Parse(ds.Tables[0].Rows[0]["ajs"].ToString());
}
if (ds.Tables[0].Rows[0]["wz"].ToString() != "")
{
model.wz = int.Parse(ds.Tables[0].Rows[0]["wz"].ToString());
}
if (ds.Tables[0].Rows[0]["tzj"].ToString() != "")
{
model.tzj = int.Parse(ds.Tables[0].Rows[0]["tzj"].ToString());
}
if (ds.Tables[0].Rows[0]["tzz"].ToString() != "")
{
model.tzz = int.Parse(ds.Tables[0].Rows[0]["tzz"].ToString());
}
if (ds.Tables[0].Rows[0]["dt"].ToString() != "")
{
model.dt = int.Parse(ds.Tables[0].Rows[0]["dt"].ToString());
}
if (ds.Tables[0].Rows[0]["zp"].ToString() != "")
{
model.zp = int.Parse(ds.Tables[0].Rows[0]["zp"].ToString());
}
if (ds.Tables[0].Rows[0]["dp"].ToString() != "")
{
model.dp = int.Parse(ds.Tables[0].Rows[0]["dp"].ToString());
}
if (ds.Tables[0].Rows[0]["ly"].ToString() != "")
{
model.ly = int.Parse(ds.Tables[0].Rows[0]["ly"].ToString());
}
if (ds.Tables[0].Rows[0]["lx"].ToString() != "")
{
model.lx = int.Parse(ds.Tables[0].Rows[0]["lx"].ToString());
}
if (ds.Tables[0].Rows[0]["gp"].ToString() != "")
{
model.gp = int.Parse(ds.Tables[0].Rows[0]["gp"].ToString());
}
if (ds.Tables[0].Rows[0]["cd"].ToString() != "")
{
model.cd = int.Parse(ds.Tables[0].Rows[0]["cd"].ToString());
}
if (ds.Tables[0].Rows[0]["cp"].ToString() != "")
{
model.cp = int.Parse(ds.Tables[0].Rows[0]["cp"].ToString());
}
if (ds.Tables[0].Rows[0]["swz"].ToString() != "")
{
model.swz = int.Parse(ds.Tables[0].Rows[0]["swz"].ToString());
}
model.qt = ds.Tables[0].Rows[0]["qt"].ToString();
model.bgqx = ds.Tables[0].Rows[0]["bgqx"].ToString();
model.mj = ds.Tables[0].Rows[0]["mj"].ToString();
if (ds.Tables[0].Rows[0]["jgrq"].ToString() != "")
{
model.jgrq = DateTime.Parse(ds.Tables[0].Rows[0]["jgrq"].ToString());
}
model.yjdw = ds.Tables[0].Rows[0]["yjdw"].ToString();
model.swh = ds.Tables[0].Rows[0]["swh"].ToString();
model.cfwz = ds.Tables[0].Rows[0]["cfwz"].ToString();
model.note = ds.Tables[0].Rows[0]["note"].ToString();
if (ds.Tables[0].Rows[0]["swp"].ToString() != "")
{
model.swp = int.Parse(ds.Tables[0].Rows[0]["swp"].ToString());
}
model.lrr = ds.Tables[0].Rows[0]["lrr"].ToString();
if (ds.Tables[0].Rows[0]["lrsj"].ToString() != "")
{
model.lrsj = DateTime.Parse(ds.Tables[0].Rows[0]["lrsj"].ToString());
}
model.zrsbh = ds.Tables[0].Rows[0]["zrsbh"].ToString();
model.lxr = ds.Tables[0].Rows[0]["lxr"].ToString();
model.lxdh = ds.Tables[0].Rows[0]["lxdh"].ToString();
if (ds.Tables[0].Rows[0]["gisid"].ToString() != "")
{
model.gisid = int.Parse(ds.Tables[0].Rows[0]["gisid"].ToString());
}
if (ds.Tables[0].Rows[0]["ywzd"].ToString() != "")
{
model.ywzd = int.Parse(ds.Tables[0].Rows[0]["ywzd"].ToString());
}
model.ghxkzh = ds.Tables[0].Rows[0]["ghxkzh"].ToString();
model.sgxkzh = ds.Tables[0].Rows[0]["sgxkzh"].ToString();
model.zlaqjddw = ds.Tables[0].Rows[0]["zlaqjddw"].ToString();
model.zlyj = ds.Tables[0].Rows[0]["zlyj"].ToString();
model.gc_code = ds.Tables[0].Rows[0]["gc_code"].ToString();
model.YDXKZH = ds.Tables[0].Rows[0]["YDXKZH"].ToString();
model.ydghxkzh = ds.Tables[0].Rows[0]["ydghxkzh"].ToString();
model.HJQK = ds.Tables[0].Rows[0]["HJQK"].ToString();
model.SJDW_XMFZR = ds.Tables[0].Rows[0]["SJDW_XMFZR"].ToString();
model.KCDW = ds.Tables[0].Rows[0]["KCDW"].ToString();
model.KCDW_XMFZR = ds.Tables[0].Rows[0]["KCDW_XMFZR"].ToString();
model.JLDW_XMFZR = ds.Tables[0].Rows[0]["JLDW_XMFZR"].ToString();
model.SGDW_XMJL = ds.Tables[0].Rows[0]["SGDW_XMJL"].ToString();
model.ZJLGCS = ds.Tables[0].Rows[0]["ZJLGCS"].ToString();
model.ZYJLGCS = ds.Tables[0].Rows[0]["ZYJLGCS"].ToString();
model.FBDW = ds.Tables[0].Rows[0]["FBDW"].ToString();
model.FBDW_XMJL = ds.Tables[0].Rows[0]["FBDW_XMJL"].ToString();
model.FBDW_1 = ds.Tables[0].Rows[0]["FBDW_1"].ToString();
model.FBDW_1_XMJL = ds.Tables[0].Rows[0]["FBDW_1_XMJL"].ToString();
model.ZYGZ = ds.Tables[0].Rows[0]["ZYGZ"].ToString();
model.XMZYZLJCY = ds.Tables[0].Rows[0]["XMZYZLJCY"].ToString();
model.SGBZZ = ds.Tables[0].Rows[0]["SGBZZ"].ToString();
model.TBR = ds.Tables[0].Rows[0]["TBR"].ToString();
model.JSDW_SHR = ds.Tables[0].Rows[0]["JSDW_SHR"].ToString();
model.JLDW_SHR = ds.Tables[0].Rows[0]["JLDW_SHR"].ToString();
if (ds.Tables[0].Rows[0]["SHRQ"].ToString() != "")
{
model.SHRQ = DateTime.Parse(ds.Tables[0].Rows[0]["SHRQ"].ToString());
}
model.TJLB = ds.Tables[0].Rows[0]["TJLB"].ToString();
if (ds.Tables[0].Rows[0]["FPSJ"].ToString() != "")
{
model.FPSJ = DateTime.Parse(ds.Tables[0].Rows[0]["FPSJ"].ToString());
}
model.FPR = ds.Tables[0].Rows[0]["FPR"].ToString();
model.SPR = ds.Tables[0].Rows[0]["SPR"].ToString();
model.SPR_DH = ds.Tables[0].Rows[0]["SPR_DH"].ToString();
model.FP_BZ = ds.Tables[0].Rows[0]["FP_BZ"].ToString();
model.sjyl = ds.Tables[0].Rows[0]["sjyl"].ToString();
model.bg = ds.Tables[0].Rows[0]["bg"].ToString();
model.ms = ds.Tables[0].Rows[0]["ms"].ToString();
model.ll = ds.Tables[0].Rows[0]["ll"].ToString();
model.sjdw = ds.Tables[0].Rows[0]["sjdw"].ToString();
model.jldw = ds.Tables[0].Rows[0]["jldw"].ToString();
model.kzdj = ds.Tables[0].Rows[0]["kzdj"].ToString();
if (ds.Tables[0].Rows[0]["wzz"].ToString() != "")
{
model.wzz = int.Parse(ds.Tables[0].Rows[0]["wzz"].ToString());
}
model.zcd = ds.Tables[0].Rows[0]["zcd"].ToString();
model.gczl = ds.Tables[0].Rows[0]["gczl"].ToString();
model.gcys = ds.Tables[0].Rows[0]["gcys"].ToString();
model.qdzb = ds.Tables[0].Rows[0]["qdzb"].ToString();
model.zdzb = ds.Tables[0].Rows[0]["zdzb"].ToString();
model.fz = ds.Tables[0].Rows[0]["fz"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(DigiPower.Onlinecol.Standard.Model.c_single_project_MDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update c_single_project set ");
strSql.Append("dxgcmc=@dxgcmc,");
strSql.Append("sgdw=@sgdw,");
strSql.Append("dxth=@dxth,");
strSql.Append("qd=@qd,");
strSql.Append("zd=@zd,");
strSql.Append("chd=@chd,");
strSql.Append("gg=@gg,");
strSql.Append("cz=@cz,");
strSql.Append("hz=@hz,");
strSql.Append("kgsj=@kgsj,");
strSql.Append("jgsj=@jgsj,");
strSql.Append("gczj=@gczj,");
strSql.Append("gcjs=@gcjs,");
strSql.Append("ajs=@ajs,");
strSql.Append("wz=@wz,");
strSql.Append("tzj=@tzj,");
strSql.Append("tzz=@tzz,");
strSql.Append("dt=@dt,");
strSql.Append("zp=@zp,");
strSql.Append("dp=@dp,");
strSql.Append("ly=@ly,");
strSql.Append("lx=@lx,");
strSql.Append("gp=@gp,");
strSql.Append("cd=@cd,");
strSql.Append("cp=@cp,");
strSql.Append("swz=@swz,");
strSql.Append("qt=@qt,");
strSql.Append("bgqx=@bgqx,");
strSql.Append("mj=@mj,");
strSql.Append("jgrq=@jgrq,");
strSql.Append("yjdw=@yjdw,");
strSql.Append("swh=@swh,");
strSql.Append("cfwz=@cfwz,");
strSql.Append("note=@note,");
strSql.Append("swp=@swp,");
strSql.Append("lrr=@lrr,");
strSql.Append("lrsj=@lrsj,");
strSql.Append("zrsbh=@zrsbh,");
strSql.Append("lxr=@lxr,");
strSql.Append("lxdh=@lxdh,");
strSql.Append("gisid=@gisid,");
strSql.Append("ywzd=@ywzd,");
strSql.Append("ghxkzh=@ghxkzh,");
strSql.Append("sgxkzh=@sgxkzh,");
strSql.Append("zlaqjddw=@zlaqjddw,");
strSql.Append("zlyj=@zlyj,");
strSql.Append("gc_code=@gc_code,");
strSql.Append("YDXKZH=@YDXKZH,");
strSql.Append("ydghxkzh=@ydghxkzh,");
strSql.Append("HJQK=@HJQK,");
strSql.Append("SJDW_XMFZR=@SJDW_XMFZR,");
strSql.Append("KCDW=@KCDW,");
strSql.Append("KCDW_XMFZR=@KCDW_XMFZR,");
strSql.Append("JLDW_XMFZR=@JLDW_XMFZR,");
strSql.Append("SGDW_XMJL=@SGDW_XMJL,");
strSql.Append("ZJLGCS=@ZJLGCS,");
strSql.Append("ZYJLGCS=@ZYJLGCS,");
strSql.Append("FBDW=@FBDW,");
strSql.Append("FBDW_XMJL=@FBDW_XMJL,");
strSql.Append("FBDW_1=@FBDW_1,");
strSql.Append("FBDW_1_XMJL=@FBDW_1_XMJL,");
strSql.Append("ZYGZ=@ZYGZ,");
strSql.Append("XMZYZLJCY=@XMZYZLJCY,");
strSql.Append("SGBZZ=@SGBZZ,");
strSql.Append("TBR=@TBR,");
strSql.Append("JSDW_SHR=@JSDW_SHR,");
strSql.Append("JLDW_SHR=@JLDW_SHR,");
strSql.Append("SHRQ=@SHRQ,");
strSql.Append("TJLB=@TJLB,");
strSql.Append("FPSJ=@FPSJ,");
strSql.Append("FPR=@FPR,");
strSql.Append("SPR=@SPR,");
strSql.Append("SPR_DH=@SPR_DH,");
strSql.Append("FP_BZ=@FP_BZ,");
strSql.Append("sjyl=@sjyl,");
strSql.Append("bg=@bg,");
strSql.Append("ms=@ms,");
strSql.Append("ll=@ll,");
strSql.Append("sjdw=@sjdw,");
strSql.Append("jldw=@jldw,");
strSql.Append("kzdj=@kzdj,");
strSql.Append("wzz=@wzz,");
strSql.Append("zcd=@zcd,");
strSql.Append("gczl=@gczl,");
strSql.Append("gcys=@gcys,");
strSql.Append("qdzb=@qdzb,");
strSql.Append("zdzb=@zdzb,");
strSql.Append("fz=@fz");
strSql.Append(" where SingleProjectID=@SingleProjectID ");
SqlParameter[] parameters =
{
new SqlParameter("@SingleProjectID", SqlDbType.Int, 8),
new SqlParameter("@dxgcmc", SqlDbType.VarChar, 80),
new SqlParameter("@sgdw", SqlDbType.VarChar, 80),
new SqlParameter("@dxth", SqlDbType.VarChar, 20),
new SqlParameter("@qd", SqlDbType.VarChar, 80),
new SqlParameter("@zd", SqlDbType.VarChar, 80),
new SqlParameter("@chd", SqlDbType.Decimal, 9),
new SqlParameter("@gg", SqlDbType.VarChar, 40),
new SqlParameter("@cz", SqlDbType.VarChar, 40),
new SqlParameter("@hz", SqlDbType.VarChar, 40),
new SqlParameter("@kgsj", SqlDbType.DateTime),
new SqlParameter("@jgsj", SqlDbType.DateTime),
new SqlParameter("@gczj", SqlDbType.Decimal, 9),
new SqlParameter("@gcjs", SqlDbType.Decimal, 9),
new SqlParameter("@ajs", SqlDbType.Int, 8),
new SqlParameter("@wz", SqlDbType.Int, 8),
new SqlParameter("@tzj", SqlDbType.Int, 8),
new SqlParameter("@tzz", SqlDbType.Int, 8),
new SqlParameter("@dt", SqlDbType.Int, 8),
new SqlParameter("@zp", SqlDbType.Int, 8),
new SqlParameter("@dp", SqlDbType.Int, 8),
new SqlParameter("@ly", SqlDbType.Int, 8),
new SqlParameter("@lx", SqlDbType.Int, 8),
new SqlParameter("@gp", SqlDbType.Int, 8),
new SqlParameter("@cd", SqlDbType.Int, 8),
new SqlParameter("@cp", SqlDbType.Int, 8),
new SqlParameter("@swz", SqlDbType.Int, 8),
new SqlParameter("@qt", SqlDbType.VarChar, 200),
new SqlParameter("@bgqx", SqlDbType.VarChar, 10),
new SqlParameter("@mj", SqlDbType.VarChar, 10),
new SqlParameter("@jgrq", SqlDbType.DateTime),
new SqlParameter("@yjdw", SqlDbType.VarChar, 80),
new SqlParameter("@swh", SqlDbType.VarChar, 60),
new SqlParameter("@cfwz", SqlDbType.VarChar, 20),
new SqlParameter("@note", SqlDbType.VarChar, 100),
new SqlParameter("@swp", SqlDbType.Int, 8),
new SqlParameter("@lrr", SqlDbType.VarChar, 10),
new SqlParameter("@lrsj", SqlDbType.DateTime),
new SqlParameter("@zrsbh", SqlDbType.VarChar, 20),
new SqlParameter("@lxr", SqlDbType.VarChar, 20),
new SqlParameter("@lxdh", SqlDbType.VarChar, 30),
new SqlParameter("@gisid", SqlDbType.Int, 8),
new SqlParameter("@ywzd", SqlDbType.Int, 8),
new SqlParameter("@ghxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@sgxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@zlaqjddw", SqlDbType.VarChar, 80),
new SqlParameter("@zlyj", SqlDbType.VarChar, 1),
new SqlParameter("@gc_code", SqlDbType.VarChar, 20),
new SqlParameter("@YDXKZH", SqlDbType.VarChar, 80),
new SqlParameter("@ydghxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@HJQK", SqlDbType.VarChar, 60),
new SqlParameter("@SJDW_XMFZR", SqlDbType.VarChar, 20),
new SqlParameter("@KCDW", SqlDbType.VarChar, 80),
new SqlParameter("@KCDW_XMFZR", SqlDbType.VarChar, 20),
new SqlParameter("@JLDW_XMFZR", SqlDbType.VarChar, 20),
new SqlParameter("@SGDW_XMJL", SqlDbType.VarChar, 20),
new SqlParameter("@ZJLGCS", SqlDbType.VarChar, 20),
new SqlParameter("@ZYJLGCS", SqlDbType.VarChar, 20),
new SqlParameter("@FBDW", SqlDbType.VarChar, 80),
new SqlParameter("@FBDW_XMJL", SqlDbType.VarChar, 20),
new SqlParameter("@FBDW_1", SqlDbType.VarChar, 80),
new SqlParameter("@FBDW_1_XMJL", SqlDbType.VarChar, 20),
new SqlParameter("@ZYGZ", SqlDbType.VarChar, 20),
new SqlParameter("@XMZYZLJCY", SqlDbType.VarChar, 20),
new SqlParameter("@SGBZZ", SqlDbType.VarChar, 20),
new SqlParameter("@TBR", SqlDbType.VarChar, 20),
new SqlParameter("@JSDW_SHR", SqlDbType.VarChar, 20),
new SqlParameter("@JLDW_SHR", SqlDbType.VarChar, 20),
new SqlParameter("@SHRQ", SqlDbType.DateTime),
new SqlParameter("@TJLB", SqlDbType.VarChar, 60),
new SqlParameter("@FPSJ", SqlDbType.DateTime),
new SqlParameter("@FPR", SqlDbType.VarChar, 20),
new SqlParameter("@SPR", SqlDbType.VarChar, 20),
new SqlParameter("@SPR_DH", SqlDbType.VarChar, 20),
new SqlParameter("@FP_BZ", SqlDbType.VarChar, 100),
new SqlParameter("@sjyl", SqlDbType.VarChar, 40),
new SqlParameter("@bg", SqlDbType.VarChar, 40),
new SqlParameter("@ms", SqlDbType.VarChar, 40),
new SqlParameter("@ll", SqlDbType.VarChar, 40),
new SqlParameter("@sjdw", SqlDbType.VarChar, 80),
new SqlParameter("@jldw", SqlDbType.VarChar, 80),
new SqlParameter("@kzdj", SqlDbType.VarChar, 80),
new SqlParameter("@wzz", SqlDbType.Int, 8),
new SqlParameter("@zcd", SqlDbType.VarChar, 50),
new SqlParameter("@gczl", SqlDbType.VarChar, 50),
new SqlParameter("@gcys", SqlDbType.VarChar, 50),
new SqlParameter("@qdzb", SqlDbType.VarChar, 50),
new SqlParameter("@zdzb", SqlDbType.VarChar, 50),
new SqlParameter("@fz", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.SingleProjectID;
parameters[1].Value = model.dxgcmc;
parameters[2].Value = model.sgdw;
parameters[3].Value = model.dxth;
parameters[4].Value = model.qd;
parameters[5].Value = model.zd;
parameters[6].Value = model.chd;
parameters[7].Value = model.gg;
parameters[8].Value = model.cz;
parameters[9].Value = model.hz;
parameters[10].Value = model.kgsj;
parameters[11].Value = model.jgsj;
parameters[12].Value = model.gczj;
parameters[13].Value = model.gcjs;
parameters[14].Value = model.ajs;
parameters[15].Value = model.wz;
parameters[16].Value = model.tzj;
parameters[17].Value = model.tzz;
parameters[18].Value = model.dt;
parameters[19].Value = model.zp;
parameters[20].Value = model.dp;
parameters[21].Value = model.ly;
parameters[22].Value = model.lx;
parameters[23].Value = model.gp;
parameters[24].Value = model.cd;
parameters[25].Value = model.cp;
parameters[26].Value = model.swz;
parameters[27].Value = model.qt;
parameters[28].Value = model.bgqx;
parameters[29].Value = model.mj;
parameters[30].Value = model.jgrq;
parameters[31].Value = model.yjdw;
parameters[32].Value = model.swh;
parameters[33].Value = model.cfwz;
parameters[34].Value = model.note;
parameters[35].Value = model.swp;
parameters[36].Value = model.lrr;
parameters[37].Value = model.lrsj;
parameters[38].Value = model.zrsbh;
parameters[39].Value = model.lxr;
parameters[40].Value = model.lxdh;
parameters[41].Value = model.gisid;
parameters[42].Value = model.ywzd;
parameters[43].Value = model.ghxkzh;
parameters[44].Value = model.sgxkzh;
parameters[45].Value = model.zlaqjddw;
parameters[46].Value = model.zlyj;
parameters[47].Value = model.gc_code;
parameters[48].Value = model.YDXKZH;
parameters[49].Value = model.ydghxkzh;
parameters[50].Value = model.HJQK;
parameters[51].Value = model.SJDW_XMFZR;
parameters[52].Value = model.KCDW;
parameters[53].Value = model.KCDW_XMFZR;
parameters[54].Value = model.JLDW_XMFZR;
parameters[55].Value = model.SGDW_XMJL;
parameters[56].Value = model.ZJLGCS;
parameters[57].Value = model.ZYJLGCS;
parameters[58].Value = model.FBDW;
parameters[59].Value = model.FBDW_XMJL;
parameters[60].Value = model.FBDW_1;
parameters[61].Value = model.FBDW_1_XMJL;
parameters[62].Value = model.ZYGZ;
parameters[63].Value = model.XMZYZLJCY;
parameters[64].Value = model.SGBZZ;
parameters[65].Value = model.TBR;
parameters[66].Value = model.JSDW_SHR;
parameters[67].Value = model.JLDW_SHR;
parameters[68].Value = model.SHRQ;
parameters[69].Value = model.TJLB;
parameters[70].Value = model.FPSJ;
parameters[71].Value = model.FPR;
parameters[72].Value = model.SPR;
parameters[73].Value = model.SPR_DH;
parameters[74].Value = model.FP_BZ;
parameters[75].Value = model.sjyl;
parameters[76].Value = model.bg;
parameters[77].Value = model.ms;
parameters[78].Value = model.ll;
parameters[79].Value = model.sjdw;
parameters[80].Value = model.jldw;
parameters[81].Value = model.kzdj;
parameters[82].Value = model.wzz;
parameters[83].Value = model.zcd;
parameters[84].Value = model.gczl;
parameters[85].Value = model.gcys;
parameters[86].Value = model.qdzb;
parameters[87].Value = model.zdzb;
parameters[88].Value = model.fz;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
