示例#1
0
        /// <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);
            }
        }
示例#2
0
        /// <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);
        }
示例#3
0
        /// <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);
        }