/// <summary> /// 增加一条数据 /// </summary> public void Add(DigiPower.Onlinecol.Standard.Model.a_single_project_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into a_single_project("); strSql.Append("SingleProjectID,jzmj,gd,dxcs,dscs,jglx,kgsj,jgsj,gczj,gcjs,ajs,wz,tzj,tzz,dt,zp,dp,ly,lx,gp,cd,cp,swz,qt,mj,jgrq,yjdw,swh,cfwz,note,ds,swp,lrr,lrsj,zrsbh,lxr,lxdh,gisid,ywzd,ghxkzh,sgxkzh,zlaqjddw,zlyj,gc_code,ydxkzh,ydghxkzh,HJQK,ZZMJ,BBYFMJ,SYYFMJ,CFMJ,DXSMJ,RFMJ,QTYFMJ,DSGYTS,TJTS1,TJTS2,TJTS3,TJTS4,zts,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,fhdj,kzdj,sjdw,jldw,wzz,fsts,cws,xmzj,jldwshr,fz,gcys,bgyfmj,gczl,xcjl,xmjl,jsdwshr)"); strSql.Append(" values ("); strSql.Append("@SingleProjectID,@jzmj,@gd,@dxcs,@dscs,@jglx,@kgsj,@jgsj,@gczj,@gcjs,@ajs,@wz,@tzj,@tzz,@dt,@zp,@dp,@ly,@lx,@gp,@cd,@cp,@swz,@qt,@mj,@jgrq,@yjdw,@swh,@cfwz,@note,@ds,@swp,@lrr,@lrsj,@zrsbh,@lxr,@lxdh,@gisid,@ywzd,@ghxkzh,@sgxkzh,@zlaqjddw,@zlyj,@gc_code,@ydxkzh,@ydghxkzh,@HJQK,@ZZMJ,@BBYFMJ,@SYYFMJ,@CFMJ,@DXSMJ,@RFMJ,@QTYFMJ,@DSGYTS,@TJTS1,@TJTS2,@TJTS3,@TJTS4,@zts,@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,@fhdj,@kzdj,@sjdw,@jldw,@wzz,@fsts,@cws,@xmzj,@jldwshr,@fz,@gcys,@bgyfmj,@gczl,@xcjl,@xmjl,@jsdwshr)"); SqlParameter[] parameters = { new SqlParameter("@SingleProjectID", SqlDbType.Int, 8), new SqlParameter("@jzmj", SqlDbType.Decimal, 9), new SqlParameter("@gd", SqlDbType.Decimal, 9), new SqlParameter("@dxcs", SqlDbType.VarChar, 20), new SqlParameter("@dscs", SqlDbType.VarChar, 20), new SqlParameter("@jglx", 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.Int, 8), 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("@ds", SqlDbType.Int, 8), 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("@ZZMJ", SqlDbType.Decimal, 9), new SqlParameter("@BBYFMJ", SqlDbType.Decimal, 9), new SqlParameter("@SYYFMJ", SqlDbType.Decimal, 9), new SqlParameter("@CFMJ", SqlDbType.Decimal, 9), new SqlParameter("@DXSMJ", SqlDbType.Decimal, 9), new SqlParameter("@RFMJ", SqlDbType.Decimal, 9), new SqlParameter("@QTYFMJ", SqlDbType.Decimal, 9), new SqlParameter("@DSGYTS", SqlDbType.Int, 8), new SqlParameter("@TJTS1", SqlDbType.Int, 8), new SqlParameter("@TJTS2", SqlDbType.Int, 8), new SqlParameter("@TJTS3", SqlDbType.Int, 8), new SqlParameter("@TJTS4", SqlDbType.Int, 8), new SqlParameter("@zts", SqlDbType.Int, 8), 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("@fhdj", SqlDbType.VarChar, 80), new SqlParameter("@kzdj", SqlDbType.VarChar, 80), new SqlParameter("@sjdw", SqlDbType.VarChar, 80), new SqlParameter("@jldw", SqlDbType.VarChar, 80), new SqlParameter("@wzz", SqlDbType.Int, 8), new SqlParameter("@fsts", SqlDbType.VarChar, 50), new SqlParameter("@cws", SqlDbType.VarChar, 50), new SqlParameter("@xmzj", SqlDbType.VarChar, 50), new SqlParameter("@jldwshr", SqlDbType.VarChar, 50), new SqlParameter("@fz", SqlDbType.VarChar, 200), new SqlParameter("@gcys", SqlDbType.VarChar, 50), new SqlParameter("@bgyfmj", SqlDbType.VarChar, 50), new SqlParameter("@gczl", SqlDbType.VarChar, 50), new SqlParameter("@xcjl", SqlDbType.VarChar, 50), new SqlParameter("@xmjl", SqlDbType.VarChar, 50), new SqlParameter("@jsdwshr", SqlDbType.VarChar, 50) }; parameters[0].Value = model.SingleProjectID; parameters[1].Value = model.jzmj; parameters[2].Value = model.gd; parameters[3].Value = model.dxcs; parameters[4].Value = model.dscs; parameters[5].Value = model.jglx; parameters[6].Value = model.kgsj; parameters[7].Value = model.jgsj; parameters[8].Value = model.gczj; parameters[9].Value = model.gcjs; parameters[10].Value = model.ajs; parameters[11].Value = model.wz; parameters[12].Value = model.tzj; parameters[13].Value = model.tzz; parameters[14].Value = model.dt; parameters[15].Value = model.zp; parameters[16].Value = model.dp; parameters[17].Value = model.ly; parameters[18].Value = model.lx; parameters[19].Value = model.gp; parameters[20].Value = model.cd; parameters[21].Value = model.cp; parameters[22].Value = model.swz; parameters[23].Value = model.qt; parameters[24].Value = model.mj; parameters[25].Value = model.jgrq; parameters[26].Value = model.yjdw; parameters[27].Value = model.swh; parameters[28].Value = model.cfwz; parameters[29].Value = model.note; parameters[30].Value = model.ds; parameters[31].Value = model.swp; parameters[32].Value = model.lrr; parameters[33].Value = model.lrsj; parameters[34].Value = model.zrsbh; parameters[35].Value = model.lxr; parameters[36].Value = model.lxdh; parameters[37].Value = model.gisid; parameters[38].Value = model.ywzd; parameters[39].Value = model.ghxkzh; parameters[40].Value = model.sgxkzh; parameters[41].Value = model.zlaqjddw; parameters[42].Value = model.zlyj; parameters[43].Value = model.gc_code; parameters[44].Value = model.ydxkzh; parameters[45].Value = model.ydghxkzh; parameters[46].Value = model.HJQK; parameters[47].Value = model.ZZMJ; parameters[48].Value = model.BBYFMJ; parameters[49].Value = model.SYYFMJ; parameters[50].Value = model.CFMJ; parameters[51].Value = model.DXSMJ; parameters[52].Value = model.RFMJ; parameters[53].Value = model.QTYFMJ; parameters[54].Value = model.DSGYTS; parameters[55].Value = model.TJTS1; parameters[56].Value = model.TJTS2; parameters[57].Value = model.TJTS3; parameters[58].Value = model.TJTS4; parameters[59].Value = model.zts; parameters[60].Value = model.SJDW_XMFZR; parameters[61].Value = model.KCDW; parameters[62].Value = model.KCDW_XMFZR; parameters[63].Value = model.JLDW_XMFZR; parameters[64].Value = model.SGDW_XMJL; parameters[65].Value = model.ZJLGCS; parameters[66].Value = model.ZYJLGCS; parameters[67].Value = model.FBDW; parameters[68].Value = model.FBDW_XMJL; parameters[69].Value = model.FBDW_1; parameters[70].Value = model.FBDW_1_XMJL; parameters[71].Value = model.ZYGZ; parameters[72].Value = model.XMZYZLJCY; parameters[73].Value = model.SGBZZ; parameters[74].Value = model.TBR; parameters[75].Value = model.JSDW_SHR; parameters[76].Value = model.JLDW_SHR; parameters[77].Value = model.SHRQ; parameters[78].Value = model.TJLB; parameters[79].Value = model.FPSJ; parameters[80].Value = model.FPR; parameters[81].Value = model.SPR; parameters[82].Value = model.SPR_DH; parameters[83].Value = model.FP_BZ; parameters[84].Value = model.fhdj; parameters[85].Value = model.kzdj; parameters[86].Value = model.sjdw; parameters[87].Value = model.jldw; parameters[88].Value = model.wzz; parameters[89].Value = model.fsts; parameters[90].Value = model.cws; parameters[91].Value = model.xmzj; parameters[92].Value = model.jldwshr; parameters[93].Value = model.fz; parameters[94].Value = model.gcys; parameters[95].Value = model.bgyfmj; parameters[96].Value = model.gczl; parameters[97].Value = model.xcjl; parameters[98].Value = model.xmjl; parameters[99].Value = model.jsdwshr; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public DigiPower.Onlinecol.Standard.Model.a_single_project_MDL GetModel(int SingleProjectID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SingleProjectID,jzmj,gd,dxcs,dscs,jglx,kgsj,jgsj,gczj,gcjs,ajs,wz,tzj,tzz,dt,zp,dp,ly,lx,gp,cd,cp,swz,qt,mj,jgrq,yjdw,swh,cfwz,note,ds,swp,lrr,lrsj,zrsbh,lxr,lxdh,gisid,ywzd,ghxkzh,sgxkzh,zlaqjddw,zlyj,gc_code,ydxkzh,ydghxkzh,HJQK,ZZMJ,BBYFMJ,SYYFMJ,CFMJ,DXSMJ,RFMJ,QTYFMJ,DSGYTS,TJTS1,TJTS2,TJTS3,TJTS4,zts,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,fhdj,kzdj,sjdw,jldw,wzz,fsts,cws,xmzj,jldwshr,fz,gcys,bgyfmj,gczl,xcjl,xmjl,jsdwshr from a_single_project "); strSql.Append(" where SingleProjectID=@SingleProjectID "); SqlParameter[] parameters = { new SqlParameter("@SingleProjectID", SqlDbType.Int, 8) }; parameters[0].Value = SingleProjectID; DigiPower.Onlinecol.Standard.Model.a_single_project_MDL model = new DigiPower.Onlinecol.Standard.Model.a_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()); } if (ds.Tables[0].Rows[0]["jzmj"].ToString() != "") { model.jzmj = decimal.Parse(ds.Tables[0].Rows[0]["jzmj"].ToString()); } if (ds.Tables[0].Rows[0]["gd"].ToString() != "") { model.gd = decimal.Parse(ds.Tables[0].Rows[0]["gd"].ToString()); } model.dxcs = ds.Tables[0].Rows[0]["dxcs"].ToString(); model.dscs = ds.Tables[0].Rows[0]["dscs"].ToString(); model.jglx = ds.Tables[0].Rows[0]["jglx"].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()); } if (ds.Tables[0].Rows[0]["qt"].ToString() != "") { model.qt = int.Parse(ds.Tables[0].Rows[0]["qt"].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]["ds"].ToString() != "") { model.ds = int.Parse(ds.Tables[0].Rows[0]["ds"].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(); if (ds.Tables[0].Rows[0]["ZZMJ"].ToString() != "") { model.ZZMJ = decimal.Parse(ds.Tables[0].Rows[0]["ZZMJ"].ToString()); } if (ds.Tables[0].Rows[0]["BBYFMJ"].ToString() != "") { model.BBYFMJ = decimal.Parse(ds.Tables[0].Rows[0]["BBYFMJ"].ToString()); } if (ds.Tables[0].Rows[0]["SYYFMJ"].ToString() != "") { model.SYYFMJ = decimal.Parse(ds.Tables[0].Rows[0]["SYYFMJ"].ToString()); } if (ds.Tables[0].Rows[0]["CFMJ"].ToString() != "") { model.CFMJ = decimal.Parse(ds.Tables[0].Rows[0]["CFMJ"].ToString()); } if (ds.Tables[0].Rows[0]["DXSMJ"].ToString() != "") { model.DXSMJ = decimal.Parse(ds.Tables[0].Rows[0]["DXSMJ"].ToString()); } if (ds.Tables[0].Rows[0]["RFMJ"].ToString() != "") { model.RFMJ = decimal.Parse(ds.Tables[0].Rows[0]["RFMJ"].ToString()); } if (ds.Tables[0].Rows[0]["QTYFMJ"].ToString() != "") { model.QTYFMJ = decimal.Parse(ds.Tables[0].Rows[0]["QTYFMJ"].ToString()); } if (ds.Tables[0].Rows[0]["DSGYTS"].ToString() != "") { model.DSGYTS = int.Parse(ds.Tables[0].Rows[0]["DSGYTS"].ToString()); } if (ds.Tables[0].Rows[0]["TJTS1"].ToString() != "") { model.TJTS1 = int.Parse(ds.Tables[0].Rows[0]["TJTS1"].ToString()); } if (ds.Tables[0].Rows[0]["TJTS2"].ToString() != "") { model.TJTS2 = int.Parse(ds.Tables[0].Rows[0]["TJTS2"].ToString()); } if (ds.Tables[0].Rows[0]["TJTS3"].ToString() != "") { model.TJTS3 = int.Parse(ds.Tables[0].Rows[0]["TJTS3"].ToString()); } if (ds.Tables[0].Rows[0]["TJTS4"].ToString() != "") { model.TJTS4 = int.Parse(ds.Tables[0].Rows[0]["TJTS4"].ToString()); } if (ds.Tables[0].Rows[0]["zts"].ToString() != "") { model.zts = int.Parse(ds.Tables[0].Rows[0]["zts"].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.fhdj = ds.Tables[0].Rows[0]["fhdj"].ToString(); model.kzdj = ds.Tables[0].Rows[0]["kzdj"].ToString(); model.sjdw = ds.Tables[0].Rows[0]["sjdw"].ToString(); model.jldw = ds.Tables[0].Rows[0]["jldw"].ToString(); if (ds.Tables[0].Rows[0]["wzz"].ToString() != "") { model.wzz = int.Parse(ds.Tables[0].Rows[0]["wzz"].ToString()); } model.fsts = ds.Tables[0].Rows[0]["fsts"].ToString(); model.cws = ds.Tables[0].Rows[0]["cws"].ToString(); model.xmzj = ds.Tables[0].Rows[0]["xmzj"].ToString(); model.jldwshr = ds.Tables[0].Rows[0]["jldwshr"].ToString(); model.fz = ds.Tables[0].Rows[0]["fz"].ToString(); model.gcys = ds.Tables[0].Rows[0]["gcys"].ToString(); model.bgyfmj = ds.Tables[0].Rows[0]["bgyfmj"].ToString(); model.gczl = ds.Tables[0].Rows[0]["gczl"].ToString(); model.xcjl = ds.Tables[0].Rows[0]["xcjl"].ToString(); model.xmjl = ds.Tables[0].Rows[0]["xmjl"].ToString(); model.jsdwshr = ds.Tables[0].Rows[0]["jsdwshr"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(DigiPower.Onlinecol.Standard.Model.a_single_project_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update a_single_project set "); strSql.Append("jzmj=@jzmj,"); strSql.Append("gd=@gd,"); strSql.Append("dxcs=@dxcs,"); strSql.Append("dscs=@dscs,"); strSql.Append("jglx=@jglx,"); 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("mj=@mj,"); strSql.Append("jgrq=@jgrq,"); strSql.Append("yjdw=@yjdw,"); strSql.Append("swh=@swh,"); strSql.Append("cfwz=@cfwz,"); strSql.Append("note=@note,"); strSql.Append("ds=@ds,"); 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("ZZMJ=@ZZMJ,"); strSql.Append("BBYFMJ=@BBYFMJ,"); strSql.Append("SYYFMJ=@SYYFMJ,"); strSql.Append("CFMJ=@CFMJ,"); strSql.Append("DXSMJ=@DXSMJ,"); strSql.Append("RFMJ=@RFMJ,"); strSql.Append("QTYFMJ=@QTYFMJ,"); strSql.Append("DSGYTS=@DSGYTS,"); strSql.Append("TJTS1=@TJTS1,"); strSql.Append("TJTS2=@TJTS2,"); strSql.Append("TJTS3=@TJTS3,"); strSql.Append("TJTS4=@TJTS4,"); strSql.Append("zts=@zts,"); 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("fhdj=@fhdj,"); strSql.Append("kzdj=@kzdj,"); strSql.Append("sjdw=@sjdw,"); strSql.Append("jldw=@jldw,"); strSql.Append("wzz=@wzz,"); strSql.Append("fsts=@fsts,"); strSql.Append("cws=@cws,"); strSql.Append("xmzj=@xmzj,"); strSql.Append("jldwshr=@jldwshr,"); strSql.Append("fz=@fz,"); strSql.Append("gcys=@gcys,"); strSql.Append("bgyfmj=@bgyfmj,"); strSql.Append("gczl=@gczl,"); strSql.Append("xcjl=@xcjl,"); strSql.Append("xmjl=@xmjl,"); strSql.Append("jsdwshr=@jsdwshr"); strSql.Append(" where SingleProjectID=@SingleProjectID "); SqlParameter[] parameters = { new SqlParameter("@SingleProjectID", SqlDbType.Int, 8), new SqlParameter("@jzmj", SqlDbType.Decimal, 9), new SqlParameter("@gd", SqlDbType.Decimal, 9), new SqlParameter("@dxcs", SqlDbType.VarChar, 20), new SqlParameter("@dscs", SqlDbType.VarChar, 20), new SqlParameter("@jglx", 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.Int, 8), 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("@ds", SqlDbType.Int, 8), 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("@ZZMJ", SqlDbType.Decimal, 9), new SqlParameter("@BBYFMJ", SqlDbType.Decimal, 9), new SqlParameter("@SYYFMJ", SqlDbType.Decimal, 9), new SqlParameter("@CFMJ", SqlDbType.Decimal, 9), new SqlParameter("@DXSMJ", SqlDbType.Decimal, 9), new SqlParameter("@RFMJ", SqlDbType.Decimal, 9), new SqlParameter("@QTYFMJ", SqlDbType.Decimal, 9), new SqlParameter("@DSGYTS", SqlDbType.Int, 8), new SqlParameter("@TJTS1", SqlDbType.Int, 8), new SqlParameter("@TJTS2", SqlDbType.Int, 8), new SqlParameter("@TJTS3", SqlDbType.Int, 8), new SqlParameter("@TJTS4", SqlDbType.Int, 8), new SqlParameter("@zts", SqlDbType.Int, 8), 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("@fhdj", SqlDbType.VarChar, 80), new SqlParameter("@kzdj", SqlDbType.VarChar, 80), new SqlParameter("@sjdw", SqlDbType.VarChar, 80), new SqlParameter("@jldw", SqlDbType.VarChar, 80), new SqlParameter("@wzz", SqlDbType.Int, 8), new SqlParameter("@fsts", SqlDbType.VarChar, 50), new SqlParameter("@cws", SqlDbType.VarChar, 50), new SqlParameter("@xmzj", SqlDbType.VarChar, 50), new SqlParameter("@jldwshr", SqlDbType.VarChar, 50), new SqlParameter("@fz", SqlDbType.VarChar, 200), new SqlParameter("@gcys", SqlDbType.VarChar, 50), new SqlParameter("@bgyfmj", SqlDbType.VarChar, 50), new SqlParameter("@gczl", SqlDbType.VarChar, 50), new SqlParameter("@xcjl", SqlDbType.VarChar, 50), new SqlParameter("@xmjl", SqlDbType.VarChar, 50), new SqlParameter("@jsdwshr", SqlDbType.VarChar, 50) }; parameters[0].Value = model.SingleProjectID; parameters[1].Value = model.jzmj; parameters[2].Value = model.gd; parameters[3].Value = model.dxcs; parameters[4].Value = model.dscs; parameters[5].Value = model.jglx; parameters[6].Value = model.kgsj; parameters[7].Value = model.jgsj; parameters[8].Value = model.gczj; parameters[9].Value = model.gcjs; parameters[10].Value = model.ajs; parameters[11].Value = model.wz; parameters[12].Value = model.tzj; parameters[13].Value = model.tzz; parameters[14].Value = model.dt; parameters[15].Value = model.zp; parameters[16].Value = model.dp; parameters[17].Value = model.ly; parameters[18].Value = model.lx; parameters[19].Value = model.gp; parameters[20].Value = model.cd; parameters[21].Value = model.cp; parameters[22].Value = model.swz; parameters[23].Value = model.qt; parameters[24].Value = model.mj; parameters[25].Value = model.jgrq; parameters[26].Value = model.yjdw; parameters[27].Value = model.swh; parameters[28].Value = model.cfwz; parameters[29].Value = model.note; parameters[30].Value = model.ds; parameters[31].Value = model.swp; parameters[32].Value = model.lrr; parameters[33].Value = model.lrsj; parameters[34].Value = model.zrsbh; parameters[35].Value = model.lxr; parameters[36].Value = model.lxdh; parameters[37].Value = model.gisid; parameters[38].Value = model.ywzd; parameters[39].Value = model.ghxkzh; parameters[40].Value = model.sgxkzh; parameters[41].Value = model.zlaqjddw; parameters[42].Value = model.zlyj; parameters[43].Value = model.gc_code; parameters[44].Value = model.ydxkzh; parameters[45].Value = model.ydghxkzh; parameters[46].Value = model.HJQK; parameters[47].Value = model.ZZMJ; parameters[48].Value = model.BBYFMJ; parameters[49].Value = model.SYYFMJ; parameters[50].Value = model.CFMJ; parameters[51].Value = model.DXSMJ; parameters[52].Value = model.RFMJ; parameters[53].Value = model.QTYFMJ; parameters[54].Value = model.DSGYTS; parameters[55].Value = model.TJTS1; parameters[56].Value = model.TJTS2; parameters[57].Value = model.TJTS3; parameters[58].Value = model.TJTS4; parameters[59].Value = model.zts; parameters[60].Value = model.SJDW_XMFZR; parameters[61].Value = model.KCDW; parameters[62].Value = model.KCDW_XMFZR; parameters[63].Value = model.JLDW_XMFZR; parameters[64].Value = model.SGDW_XMJL; parameters[65].Value = model.ZJLGCS; parameters[66].Value = model.ZYJLGCS; parameters[67].Value = model.FBDW; parameters[68].Value = model.FBDW_XMJL; parameters[69].Value = model.FBDW_1; parameters[70].Value = model.FBDW_1_XMJL; parameters[71].Value = model.ZYGZ; parameters[72].Value = model.XMZYZLJCY; parameters[73].Value = model.SGBZZ; parameters[74].Value = model.TBR; parameters[75].Value = model.JSDW_SHR; parameters[76].Value = model.JLDW_SHR; parameters[77].Value = model.SHRQ; parameters[78].Value = model.TJLB; parameters[79].Value = model.FPSJ; parameters[80].Value = model.FPR; parameters[81].Value = model.SPR; parameters[82].Value = model.SPR_DH; parameters[83].Value = model.FP_BZ; parameters[84].Value = model.fhdj; parameters[85].Value = model.kzdj; parameters[86].Value = model.sjdw; parameters[87].Value = model.jldw; parameters[88].Value = model.wzz; parameters[89].Value = model.fsts; parameters[90].Value = model.cws; parameters[91].Value = model.xmzj; parameters[92].Value = model.jldwshr; parameters[93].Value = model.fz; parameters[94].Value = model.gcys; parameters[95].Value = model.bgyfmj; parameters[96].Value = model.gczl; parameters[97].Value = model.xcjl; parameters[98].Value = model.xmjl; parameters[99].Value = model.jsdwshr; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }