/// <summary>
/// 得到一个对象实体
/// </summary>
public DigiPower.Onlinecol.Standard.Model.construction_project_c_MDL GetModel(int ConstructionProjectID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ConstructionProjectID,area_code,dh,gcmc,gcdd,jsdw,lxpzdw,sjdw,jgcldw,jldw,lxpzwh,ghxkzh,ydghxkzh,ydxkzh,sgxkzh,qd,zd,zcd,kgsj,jgsj,gczj,gczj_Bak,gcjs,zajs,wz,tzj,tzz,dt,zp,dp,ly,lx,gp,cd,cp,swp,swz,qt,bgqx,mj,jgrq,yjdw,swh,cfwz,note,lrr,lrsj,gisid,ywzd,xmbh,bjlxr,lxdh,yddw,bzdw,kcdw,sgdw,gcxh,zlyj,TJLB,jsdw_xmfzr,gcqy,wzz from construction_project_c ");
strSql.Append(" where ConstructionProjectID=@ConstructionProjectID ");
SqlParameter[] parameters =
{
new SqlParameter("@ConstructionProjectID", SqlDbType.Int, 8)
};
parameters[0].Value = ConstructionProjectID;
DigiPower.Onlinecol.Standard.Model.construction_project_c_MDL model = new DigiPower.Onlinecol.Standard.Model.construction_project_c_MDL();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ConstructionProjectID"].ToString() != "")
{
model.ConstructionProjectID = int.Parse(ds.Tables[0].Rows[0]["ConstructionProjectID"].ToString());
}
model.area_code = ds.Tables[0].Rows[0]["area_code"].ToString();
model.dh = ds.Tables[0].Rows[0]["dh"].ToString();
model.gcmc = ds.Tables[0].Rows[0]["gcmc"].ToString();
model.gcdd = ds.Tables[0].Rows[0]["gcdd"].ToString();
model.jsdw = ds.Tables[0].Rows[0]["jsdw"].ToString();
model.lxpzdw = ds.Tables[0].Rows[0]["lxpzdw"].ToString();
model.sjdw = ds.Tables[0].Rows[0]["sjdw"].ToString();
model.jgcldw = ds.Tables[0].Rows[0]["jgcldw"].ToString();
model.jldw = ds.Tables[0].Rows[0]["jldw"].ToString();
model.lxpzwh = ds.Tables[0].Rows[0]["lxpzwh"].ToString();
model.ghxkzh = ds.Tables[0].Rows[0]["ghxkzh"].ToString();
model.ydghxkzh = ds.Tables[0].Rows[0]["ydghxkzh"].ToString();
model.ydxkzh = ds.Tables[0].Rows[0]["ydxkzh"].ToString();
model.sgxkzh = ds.Tables[0].Rows[0]["sgxkzh"].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]["zcd"].ToString() != "")
{
model.zcd = decimal.Parse(ds.Tables[0].Rows[0]["zcd"].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]["gczj_Bak"].ToString() != "")
{
model.gczj_Bak = decimal.Parse(ds.Tables[0].Rows[0]["gczj_Bak"].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]["zajs"].ToString() != "")
{
model.zajs = int.Parse(ds.Tables[0].Rows[0]["zajs"].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]["swp"].ToString() != "")
{
model.swp = int.Parse(ds.Tables[0].Rows[0]["swp"].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.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();
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());
}
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.xmbh = ds.Tables[0].Rows[0]["xmbh"].ToString();
model.bjlxr = ds.Tables[0].Rows[0]["bjlxr"].ToString();
model.lxdh = ds.Tables[0].Rows[0]["lxdh"].ToString();
model.yddw = ds.Tables[0].Rows[0]["yddw"].ToString();
model.bzdw = ds.Tables[0].Rows[0]["bzdw"].ToString();
model.kcdw = ds.Tables[0].Rows[0]["kcdw"].ToString();
model.sgdw = ds.Tables[0].Rows[0]["sgdw"].ToString();
model.gcxh = ds.Tables[0].Rows[0]["gcxh"].ToString();
model.zlyj = ds.Tables[0].Rows[0]["zlyj"].ToString();
model.TJLB = ds.Tables[0].Rows[0]["TJLB"].ToString();
model.jsdw_xmfzr = ds.Tables[0].Rows[0]["jsdw_xmfzr"].ToString();
model.gcqy = ds.Tables[0].Rows[0]["gcqy"].ToString();
if (ds.Tables[0].Rows[0]["wzz"].ToString() != "")
{
model.wzz = int.Parse(ds.Tables[0].Rows[0]["wzz"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(DigiPower.Onlinecol.Standard.Model.construction_project_c_MDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into construction_project_c(");
strSql.Append("ConstructionProjectID,area_code,dh,gcmc,gcdd,jsdw,lxpzdw,sjdw,jgcldw,jldw,lxpzwh,ghxkzh,ydghxkzh,ydxkzh,sgxkzh,qd,zd,zcd,kgsj,jgsj,gczj,gczj_Bak,gcjs,zajs,wz,tzj,tzz,dt,zp,dp,ly,lx,gp,cd,cp,swp,swz,qt,bgqx,mj,jgrq,yjdw,swh,cfwz,note,lrr,lrsj,gisid,ywzd,xmbh,bjlxr,lxdh,yddw,bzdw,kcdw,sgdw,gcxh,zlyj,TJLB,jsdw_xmfzr,gcqy,wzz)");
strSql.Append(" values (");
strSql.Append("@ConstructionProjectID,@area_code,@dh,@gcmc,@gcdd,@jsdw,@lxpzdw,@sjdw,@jgcldw,@jldw,@lxpzwh,@ghxkzh,@ydghxkzh,@ydxkzh,@sgxkzh,@qd,@zd,@zcd,@kgsj,@jgsj,@gczj,@gczj_Bak,@gcjs,@zajs,@wz,@tzj,@tzz,@dt,@zp,@dp,@ly,@lx,@gp,@cd,@cp,@swp,@swz,@qt,@bgqx,@mj,@jgrq,@yjdw,@swh,@cfwz,@note,@lrr,@lrsj,@gisid,@ywzd,@xmbh,@bjlxr,@lxdh,@yddw,@bzdw,@kcdw,@sgdw,@gcxh,@zlyj,@TJLB,@jsdw_xmfzr,@gcqy,@wzz)");
SqlParameter[] parameters =
{
new SqlParameter("@ConstructionProjectID", SqlDbType.Int, 8),
new SqlParameter("@area_code", SqlDbType.VarChar, 20),
new SqlParameter("@dh", SqlDbType.VarChar, 30),
new SqlParameter("@gcmc", SqlDbType.VarChar, 80),
new SqlParameter("@gcdd", SqlDbType.VarChar, 80),
new SqlParameter("@jsdw", SqlDbType.VarChar, 80),
new SqlParameter("@lxpzdw", SqlDbType.VarChar, 80),
new SqlParameter("@sjdw", SqlDbType.VarChar, 80),
new SqlParameter("@jgcldw", SqlDbType.VarChar, 80),
new SqlParameter("@jldw", SqlDbType.VarChar, 80),
new SqlParameter("@lxpzwh", SqlDbType.VarChar, 80),
new SqlParameter("@ghxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@ydghxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@ydxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@sgxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@qd", SqlDbType.VarChar, 80),
new SqlParameter("@zd", SqlDbType.VarChar, 80),
new SqlParameter("@zcd", SqlDbType.Decimal, 9),
new SqlParameter("@kgsj", SqlDbType.DateTime),
new SqlParameter("@jgsj", SqlDbType.DateTime),
new SqlParameter("@gczj", SqlDbType.Decimal, 9),
new SqlParameter("@gczj_Bak", SqlDbType.Decimal, 9),
new SqlParameter("@gcjs", SqlDbType.Decimal, 9),
new SqlParameter("@zajs", 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("@swp", SqlDbType.Int, 8),
new SqlParameter("@swz", SqlDbType.Int, 8),
new SqlParameter("@qt", SqlDbType.Int, 8),
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("@lrr", SqlDbType.VarChar, 100),
new SqlParameter("@lrsj", SqlDbType.DateTime),
new SqlParameter("@gisid", SqlDbType.Int, 8),
new SqlParameter("@ywzd", SqlDbType.Int, 8),
new SqlParameter("@xmbh", SqlDbType.VarChar, 30),
new SqlParameter("@bjlxr", SqlDbType.VarChar, 40),
new SqlParameter("@lxdh", SqlDbType.VarChar, 40),
new SqlParameter("@yddw", SqlDbType.VarChar, 80),
new SqlParameter("@bzdw", SqlDbType.VarChar, 80),
new SqlParameter("@kcdw", SqlDbType.VarChar, 80),
new SqlParameter("@sgdw", SqlDbType.VarChar, 100),
new SqlParameter("@gcxh", SqlDbType.VarChar, 20),
new SqlParameter("@zlyj", SqlDbType.VarChar, 1),
new SqlParameter("@TJLB", SqlDbType.VarChar, 60),
new SqlParameter("@jsdw_xmfzr", SqlDbType.VarChar, 60),
new SqlParameter("@gcqy", SqlDbType.VarChar, 60),
new SqlParameter("@wzz", SqlDbType.Int, 8)
};
parameters[0].Value = model.ConstructionProjectID;
parameters[1].Value = model.area_code;
parameters[2].Value = model.dh;
parameters[3].Value = model.gcmc;
parameters[4].Value = model.gcdd;
parameters[5].Value = model.jsdw;
parameters[6].Value = model.lxpzdw;
parameters[7].Value = model.sjdw;
parameters[8].Value = model.jgcldw;
parameters[9].Value = model.jldw;
parameters[10].Value = model.lxpzwh;
parameters[11].Value = model.ghxkzh;
parameters[12].Value = model.ydghxkzh;
parameters[13].Value = model.ydxkzh;
parameters[14].Value = model.sgxkzh;
parameters[15].Value = model.qd;
parameters[16].Value = model.zd;
parameters[17].Value = model.zcd;
parameters[18].Value = model.kgsj;
parameters[19].Value = model.jgsj;
parameters[20].Value = model.gczj;
parameters[21].Value = model.gczj_Bak;
parameters[22].Value = model.gcjs;
parameters[23].Value = model.zajs;
parameters[24].Value = model.wz;
parameters[25].Value = model.tzj;
parameters[26].Value = model.tzz;
parameters[27].Value = model.dt;
parameters[28].Value = model.zp;
parameters[29].Value = model.dp;
parameters[30].Value = model.ly;
parameters[31].Value = model.lx;
parameters[32].Value = model.gp;
parameters[33].Value = model.cd;
parameters[34].Value = model.cp;
parameters[35].Value = model.swp;
parameters[36].Value = model.swz;
parameters[37].Value = model.qt;
parameters[38].Value = model.bgqx;
parameters[39].Value = model.mj;
parameters[40].Value = model.jgrq;
parameters[41].Value = model.yjdw;
parameters[42].Value = model.swh;
parameters[43].Value = model.cfwz;
parameters[44].Value = model.note;
parameters[45].Value = model.lrr;
parameters[46].Value = model.lrsj;
parameters[47].Value = model.gisid;
parameters[48].Value = model.ywzd;
parameters[49].Value = model.xmbh;
parameters[50].Value = model.bjlxr;
parameters[51].Value = model.lxdh;
parameters[52].Value = model.yddw;
parameters[53].Value = model.bzdw;
parameters[54].Value = model.kcdw;
parameters[55].Value = model.sgdw;
parameters[56].Value = model.gcxh;
parameters[57].Value = model.zlyj;
parameters[58].Value = model.TJLB;
parameters[59].Value = model.jsdw_xmfzr;
parameters[60].Value = model.gcqy;
parameters[61].Value = model.wzz;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(DigiPower.Onlinecol.Standard.Model.construction_project_c_MDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update construction_project_c set ");
strSql.Append("area_code=@area_code,");
strSql.Append("dh=@dh,");
strSql.Append("gcmc=@gcmc,");
strSql.Append("gcdd=@gcdd,");
strSql.Append("jsdw=@jsdw,");
strSql.Append("lxpzdw=@lxpzdw,");
strSql.Append("sjdw=@sjdw,");
strSql.Append("jgcldw=@jgcldw,");
strSql.Append("jldw=@jldw,");
strSql.Append("lxpzwh=@lxpzwh,");
strSql.Append("ghxkzh=@ghxkzh,");
strSql.Append("ydghxkzh=@ydghxkzh,");
strSql.Append("ydxkzh=@ydxkzh,");
strSql.Append("sgxkzh=@sgxkzh,");
strSql.Append("qd=@qd,");
strSql.Append("zd=@zd,");
strSql.Append("zcd=@zcd,");
strSql.Append("kgsj=@kgsj,");
strSql.Append("jgsj=@jgsj,");
strSql.Append("gczj=@gczj,");
strSql.Append("gczj_Bak=@gczj_Bak,");
strSql.Append("gcjs=@gcjs,");
strSql.Append("zajs=@zajs,");
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("swp=@swp,");
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("lrr=@lrr,");
strSql.Append("lrsj=@lrsj,");
strSql.Append("gisid=@gisid,");
strSql.Append("ywzd=@ywzd,");
strSql.Append("xmbh=@xmbh,");
strSql.Append("bjlxr=@bjlxr,");
strSql.Append("lxdh=@lxdh,");
strSql.Append("yddw=@yddw,");
strSql.Append("bzdw=@bzdw,");
strSql.Append("kcdw=@kcdw,");
strSql.Append("sgdw=@sgdw,");
strSql.Append("gcxh=@gcxh,");
strSql.Append("zlyj=@zlyj,");
strSql.Append("TJLB=@TJLB,");
strSql.Append("jsdw_xmfzr=@jsdw_xmfzr,");
strSql.Append("gcqy=@gcqy,");
strSql.Append("wzz=@wzz");
strSql.Append(" where ConstructionProjectID=@ConstructionProjectID ");
SqlParameter[] parameters =
{
new SqlParameter("@ConstructionProjectID", SqlDbType.Int, 8),
new SqlParameter("@area_code", SqlDbType.VarChar, 20),
new SqlParameter("@dh", SqlDbType.VarChar, 30),
new SqlParameter("@gcmc", SqlDbType.VarChar, 80),
new SqlParameter("@gcdd", SqlDbType.VarChar, 80),
new SqlParameter("@jsdw", SqlDbType.VarChar, 80),
new SqlParameter("@lxpzdw", SqlDbType.VarChar, 80),
new SqlParameter("@sjdw", SqlDbType.VarChar, 80),
new SqlParameter("@jgcldw", SqlDbType.VarChar, 80),
new SqlParameter("@jldw", SqlDbType.VarChar, 80),
new SqlParameter("@lxpzwh", SqlDbType.VarChar, 80),
new SqlParameter("@ghxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@ydghxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@ydxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@sgxkzh", SqlDbType.VarChar, 80),
new SqlParameter("@qd", SqlDbType.VarChar, 80),
new SqlParameter("@zd", SqlDbType.VarChar, 80),
new SqlParameter("@zcd", SqlDbType.Decimal, 9),
new SqlParameter("@kgsj", SqlDbType.DateTime),
new SqlParameter("@jgsj", SqlDbType.DateTime),
new SqlParameter("@gczj", SqlDbType.Decimal, 9),
new SqlParameter("@gczj_Bak", SqlDbType.Decimal, 9),
new SqlParameter("@gcjs", SqlDbType.Decimal, 9),
new SqlParameter("@zajs", 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("@swp", SqlDbType.Int, 8),
new SqlParameter("@swz", SqlDbType.Int, 8),
new SqlParameter("@qt", SqlDbType.Int, 8),
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("@lrr", SqlDbType.VarChar, 100),
new SqlParameter("@lrsj", SqlDbType.DateTime),
new SqlParameter("@gisid", SqlDbType.Int, 8),
new SqlParameter("@ywzd", SqlDbType.Int, 8),
new SqlParameter("@xmbh", SqlDbType.VarChar, 30),
new SqlParameter("@bjlxr", SqlDbType.VarChar, 40),
new SqlParameter("@lxdh", SqlDbType.VarChar, 40),
new SqlParameter("@yddw", SqlDbType.VarChar, 80),
new SqlParameter("@bzdw", SqlDbType.VarChar, 80),
new SqlParameter("@kcdw", SqlDbType.VarChar, 80),
new SqlParameter("@sgdw", SqlDbType.VarChar, 100),
new SqlParameter("@gcxh", SqlDbType.VarChar, 20),
new SqlParameter("@zlyj", SqlDbType.VarChar, 1),
new SqlParameter("@TJLB", SqlDbType.VarChar, 60),
new SqlParameter("@jsdw_xmfzr", SqlDbType.VarChar, 60),
new SqlParameter("@gcqy", SqlDbType.VarChar, 60),
new SqlParameter("@wzz", SqlDbType.Int, 8)
};
parameters[0].Value = model.ConstructionProjectID;
parameters[1].Value = model.area_code;
parameters[2].Value = model.dh;
parameters[3].Value = model.gcmc;
parameters[4].Value = model.gcdd;
parameters[5].Value = model.jsdw;
parameters[6].Value = model.lxpzdw;
parameters[7].Value = model.sjdw;
parameters[8].Value = model.jgcldw;
parameters[9].Value = model.jldw;
parameters[10].Value = model.lxpzwh;
parameters[11].Value = model.ghxkzh;
parameters[12].Value = model.ydghxkzh;
parameters[13].Value = model.ydxkzh;
parameters[14].Value = model.sgxkzh;
parameters[15].Value = model.qd;
parameters[16].Value = model.zd;
parameters[17].Value = model.zcd;
parameters[18].Value = model.kgsj;
parameters[19].Value = model.jgsj;
parameters[20].Value = model.gczj;
parameters[21].Value = model.gczj_Bak;
parameters[22].Value = model.gcjs;
parameters[23].Value = model.zajs;
parameters[24].Value = model.wz;
parameters[25].Value = model.tzj;
parameters[26].Value = model.tzz;
parameters[27].Value = model.dt;
parameters[28].Value = model.zp;
parameters[29].Value = model.dp;
parameters[30].Value = model.ly;
parameters[31].Value = model.lx;
parameters[32].Value = model.gp;
parameters[33].Value = model.cd;
parameters[34].Value = model.cp;
parameters[35].Value = model.swp;
parameters[36].Value = model.swz;
parameters[37].Value = model.qt;
parameters[38].Value = model.bgqx;
parameters[39].Value = model.mj;
parameters[40].Value = model.jgrq;
parameters[41].Value = model.yjdw;
parameters[42].Value = model.swh;
parameters[43].Value = model.cfwz;
parameters[44].Value = model.note;
parameters[45].Value = model.lrr;
parameters[46].Value = model.lrsj;
parameters[47].Value = model.gisid;
parameters[48].Value = model.ywzd;
parameters[49].Value = model.xmbh;
parameters[50].Value = model.bjlxr;
parameters[51].Value = model.lxdh;
parameters[52].Value = model.yddw;
parameters[53].Value = model.bzdw;
parameters[54].Value = model.kcdw;
parameters[55].Value = model.sgdw;
parameters[56].Value = model.gcxh;
parameters[57].Value = model.zlyj;
parameters[58].Value = model.TJLB;
parameters[59].Value = model.jsdw_xmfzr;
parameters[60].Value = model.gcqy;
parameters[61].Value = model.wzz;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}