示例#1
0
        /// <summary>
        /// 同一个表中复制一条记录到另外一条记录(主键除外)
        /// </summary>
        /// <param name="subbasinID">子流域编号</param>
        /// <param name="hruID">hru编号</param>
        /// <param name="MGT_OP">操作编号</param>
        /// <param name="mgt">MGT参数类</param>
        private void CopyToSelf(int subbasinID, int hruID, int MGT_OP, MgtParameter mgt)
        {
            AccessHelper MGTHelper = new AccessHelper();

            /*
             * 改代码舍弃!!!存在严重BUG
             * 拷贝指定子流域下的指定HRU的一个副本,然后对该副本进行更新数据(利用原来的数据表格式)
             * 由于YEAR,MONTH,DAY,都是ACCESS的关键字,所以要加中括号(“[]”)
             */
//            string sql = @"INSERT INTO mgt2(SUBBASIN,HRU,LANDUSE,SOIL, SLOPE_CD, CROP, [YEAR], [MONTH], [DAY], HUSC, MGT_OP, HEATUNITS, PLANT_ID, CURYR_MAT, LAI_INIT,BIO_INIT,
//				                               HI_TARG, BIO_TARG,CNOP, IRR_AMT, FERT_ID,FRT_KG,FRT_SURFACE,PEST_ID,PST_KG,TILLAGE_ID,HARVEFF,HI_OVR,GRZ_DAYS,MANURE_ID,BIO_EAT,
//				                               BIO_TRMP,MANURE_KG,WSTRS_ID,AUTO_WSTRS,AFERT_ID,AUTO_NSTRS,AUTO_NAPP,AUTO_NYR,AUTO_EFF,AFRT_SURFACE,SWEEPEFF,FR_CURB,IMP_TRIG,
//				                               FERT_DAYS,CFRT_ID,IFRT_FREQ,CFRT_KG, PST_DEP,IHV_GBM,IRR_SALT,IRR_EFM,IRR_SQ,IRR_EFF,IRR_MX,IRR_ASQ, CPST_ID,PEST_DAYS,IPEST_FREQ,
//				                               CPST_KG,BURN_FRLB,OP_NUM,IRR_SC,IRR_NO,IRR_SCA,IRR_NOA)
//                                 SELECT TOP 1  SUBBASIN,HRU,LANDUSE,SOIL, SLOPE_CD, CROP, YEAR, MONTH, DAY, HUSC, MGT_OP, HEATUNITS, PLANT_ID, CURYR_MAT, LAI_INIT,	 BIO_INIT,
//				                               HI_TARG, BIO_TARG,CNOP, IRR_AMT, FERT_ID,FRT_KG,FRT_SURFACE,PEST_ID,PST_KG,TILLAGE_ID,HARVEFF,HI_OVR,GRZ_DAYS,MANURE_ID,BIO_EAT,
//				                               BIO_TRMP,MANURE_KG,WSTRS_ID,AUTO_WSTRS,AFERT_ID,AUTO_NSTRS,AUTO_NAPP,AUTO_NYR,AUTO_EFF,AFRT_SURFACE,SWEEPEFF,FR_CURB,IMP_TRIG,
//				                               FERT_DAYS,CFRT_ID,IFRT_FREQ,CFRT_KG, PST_DEP,IHV_GBM,IRR_SALT,IRR_EFM,IRR_SQ,IRR_EFF,IRR_MX,IRR_ASQ, CPST_ID,PEST_DAYS,IPEST_FREQ,
//				                               CPST_KG,BURN_FRLB,OP_NUM,IRR_SC,IRR_NO,IRR_SCA,IRR_NOA
//	                             FROM mgt2 WHERE SUBBASIN = " + subbasinID + "  AND HRU = " + hruID + " AND MGT_OP = " + MGT_OP;

            DataTable hru_info = getLandUse_Soil_SlopeBySUBAndHRU(subbasinID, hruID);  //获得hru的三项信息
            string    land_use = hru_info.Rows[0][0].ToString();
            string    soil     = hru_info.Rows[0][1].ToString();
            string    slope    = hru_info.Rows[0][2].ToString();
            string    sql      = @"INSERT INTO mgt2(SUBBASIN,HRU,LANDUSE,SOIL, SLOPE_CD, CROP, [YEAR], [MONTH], [DAY], HUSC, 
                 MGT_OP,HEATUNITS, PLANT_ID, CURYR_MAT, LAI_INIT,BIO_INIT,HI_TARG, BIO_TARG,CNOP, IRR_AMT,
                 FERT_ID,FRT_KG,FRT_SURFACE,PEST_ID,PST_KG,TILLAGE_ID,HARVEFF,HI_OVR,GRZ_DAYS,MANURE_ID,
                 BIO_EAT,BIO_TRMP,MANURE_KG,WSTRS_ID,AUTO_WSTRS,AFERT_ID,AUTO_NSTRS,AUTO_NAPP,AUTO_NYR,AUTO_EFF,
                 AFRT_SURFACE,SWEEPEFF,FR_CURB,IMP_TRIG,FERT_DAYS,CFRT_ID,IFRT_FREQ,CFRT_KG, PST_DEP,IHV_GBM,
                 IRR_SALT,IRR_EFM,IRR_SQ,IRR_EFF,IRR_MX,IRR_ASQ, CPST_ID,PEST_DAYS,IPEST_FREQ,CPST_KG,
                 BURN_FRLB,OP_NUM,IRR_SC,IRR_NO,IRR_SCA,IRR_NOA) 
          values(" + subbasinID + "," + hruID + ",'" + land_use + "','" + soil + "','" + slope + "','',1,1,1,0," +
                                 "1,0,0,0,0,0,0,0,0,0," +
                                 "0,0,0,0,0,0,0,0,0,0," +
                                 "0,0,0,0,0,0,0,0,0,0," +
                                 "0,0,0,0,0,0,0,0,0,0," +
                                 "0,0,0,0,0,0,0,0,0,0," +
                                 "0,0,0,0,0,0)";
            int n = MGTHelper.ExcuteSql(sql);

            //获取新加数据的OID编号
            sql = "select oid from mgt2 where subbasin = " + subbasinID + " and hru = " + hruID + " order by oid desc";
            DataTable dt  = MGTHelper.GetDataTableFromDB(sql);
            int       OID = Convert.ToInt32(dt.Rows[0][0]);

            //根据MGT_OP和OID更新数据
            if (MGT_OP == 1)    //种植
            {
                sql = @"update mgt2 set CROP = '" + mgt.crop + "',[YEAR] = 1" + ",[MONTH] = " + mgt.plant_month + ",[DAY] = " + mgt.plant_day + ",HUSC = 0" + ",MGT_OP = " + mgt.plant_mgt_op + ",HEATUNITS = " + mgt.heat_units + ",PLANT_ID = " + mgt.plant_id +
                      ",CURYR_MAT = " + mgt.curyr_mat + ",LAI_INIT = " + mgt.lai_init + ",HI_TARG = " + mgt.hi_targ + ",BIO_TARG = " + mgt.bio_targ + ",CNOP = " + mgt.plant_cnop + " WHERE OID =" + OID + " and subbasin = " + subbasinID + " and hru =" + hruID;
                n = MGTHelper.ExcuteSql(sql);
            }
            else if (MGT_OP == 2)   //灌溉
            {
                sql = @"update mgt2 set CROP = null,[YEAR] = 1" + ",[MONTH] = " + mgt.irr_month + ",[DAY] = " + mgt.irr_day + ",HUSC = " + mgt.irr_husc + ",MGT_OP = " + mgt.irr_mgt_op + ",IRR_AMT = " + mgt.irr_amt + ",IRR_SALT = " + mgt.irr_salt + ",IRR_EFM = " + mgt.irr_efm + ",IRR_SQ = " +
                      mgt.irr_sq + ",IRR_SC = " + mgt.irr_sc + ",IRR_NO = " + mgt.irr_no + " WHERE OID =" + OID + " and subbasin = " + subbasinID + " and hru =" + hruID;
                n = MGTHelper.ExcuteSql(sql);
            }
            else if (MGT_OP == 3)   //施肥
            {
                sql = @"update mgt2 set CROP = null,[YEAR] = 1" + ",[MONTH] = " + mgt.frt_month + ",[DAY] = " + mgt.frt_day + ",HUSC = " + mgt.frt_husc + ",MGT_OP =" + mgt.frt_mgt_op + ",FERT_ID = " + mgt.fert_id + ",FRT_KG = " + mgt.frt_kg + ",FRT_SURFACE = " + mgt.frt_surface
                      + " where OID = " + OID + " and subbasin = " + subbasinID + "  and hru = " + hruID;
                n = MGTHelper.ExcuteSql(sql);
            }
            else if (MGT_OP == 5)     //收割
            {
                sql = @"update mgt2 set CROP = null,[YEAR] = 1" + ",[MONTH] = " + mgt.harv_month + ",[DAY] = " + mgt.harv_day + ",HUSC = " + mgt.harv_husc + ",MGT_OP = " + mgt.harv_mgt_op + ",CNOP = " + mgt.harv_cnop
                      + "  where OID = " + OID + " and subbasin = " + subbasinID + "  and hru = " + hruID;
                n = MGTHelper.ExcuteSql(sql);
            }
        }
示例#2
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dataGridViewMgt_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                AccessHelper helper = new AccessHelper();
                DataTable    dt;
                int          Month  = Convert.ToInt32(dataGridViewMgt.CurrentRow.Cells["month"].Value.ToString());
                int          Day    = Convert.ToInt32(dataGridViewMgt.CurrentRow.Cells["day"].Value.ToString());
                int          MGT_OP = GetMGT_OPByName(dataGridViewMgt.CurrentRow.Cells["operation"].Value.ToString());
                if (MGT_OP == 1)    //种植
                {
                    tabControlMgt.SelectedIndex = 0;
                    string sql = @"select MONTH,DAY,MGT_OP,HEATUNITS,PLANT_ID,CURYR_MAT,LAI_INIT,BIO_INIT,HI_TARG,BIO_TARG,CNOP from mgt2 
                           WHERE SUBBASIN = " + subbasinId + " AND HRU = 1 " + "AND MONTH = " + Month + "  AND DAY = " + Day + " AND MGT_OP = " + MGT_OP;
                    dt = helper.GetDataTableFromDB(sql);
                    if (dt != null)
                    {
                        PLANT_MONTH.Text = dt.Rows[0][0].ToString();
                        PLANT_DAY.Text   = dt.Rows[0][1].ToString();
                        PLANT_ID.Text    = dt.Rows[0][4].ToString() + "," + getPlantNameByID(Convert.ToInt32(dt.Rows[0][4].ToString()));
                        CURYR_MAT.Text   = dt.Rows[0][5].ToString();

                        PLANT_HEAT_UNITS.Text = dt.Rows[0][3].ToString();
                        BIO_INIT.Text         = dt.Rows[0][7].ToString();
                        HI_TARG.Text          = dt.Rows[0][8].ToString();
                        LAI_INIT.Text         = dt.Rows[0][6].ToString();

                        BIO_TARG.Text   = dt.Rows[0][9].ToString();
                        PLANT_CNOP.Text = dt.Rows[0][10].ToString();
                    }
                }
                else if (MGT_OP == 2)
                {
                    tabControlMgt.SelectedIndex = 1;
                    string sql = @"select MONTH,DAY,MGT_OP,IRR_AMT,IRR_SALT,IRR_EFM,IRR_SQ,IRR_SC,IRR_NO from mgt2 
                             WHERE SUBBASIN = " + subbasinId + " AND HRU = 1 " + "AND MONTH = " + Month + "  AND DAY = " + Day + " AND MGT_OP = " + MGT_OP;
                    dt = helper.GetDataTableFromDB(sql);
                    if (dt != null)
                    {
                        IRR_MONTH.Text = dt.Rows[0][0].ToString();
                        IRR_DAY.Text   = dt.Rows[0][1].ToString();
                        IRR_AMT.Text   = dt.Rows[0][3].ToString();
                        IRR_SALT.Text  = dt.Rows[0][4].ToString();
                        IRR_EFM.Text   = dt.Rows[0][5].ToString();
                        IRR_SQ.Text    = dt.Rows[0][6].ToString();
                        IRR_SC.Text    = dt.Rows[0][7].ToString();
                        IRR_NO.Text    = dt.Rows[0][8].ToString();
                    }
                }
                else if (MGT_OP == 3)
                {
                    tabControlMgt.SelectedIndex = 2;
                    string sql = @"select MONTH,DAY,MGT_OP,FERT_ID,FRT_KG,FRT_SURFACE from mgt2
                             WHERE SUBBASIN = " + subbasinId + " AND HRU = 1 " + "AND MONTH = " + Month + "  AND DAY = " + Day + " AND MGT_OP = " + MGT_OP;
                    dt = helper.GetDataTableFromDB(sql);
                    if (dt != null)
                    {
                        FRT_MONTH.Text   = dt.Rows[0][0].ToString();
                        FRT_DAY.Text     = dt.Rows[0][1].ToString();
                        FERT_ID.Text     = dt.Rows[0][3].ToString() + "," + getFertNameByID(Convert.ToInt32(dt.Rows[0][3].ToString()));
                        FRT_KG.Text      = dt.Rows[0][4].ToString();
                        FRT_SURFACE.Text = dt.Rows[0][5].ToString();
                    }
                }
                else if (MGT_OP == 5)
                {
                    tabControlMgt.SelectedIndex = 3;
                    string sql = @"select MONTH,DAY,MGT_OP,CNOP from mgt2 
                             WHERE SUBBASIN = " + subbasinId + " AND HRU = 1 " + "AND MONTH = " + Month + "  AND DAY = " + Day + " AND MGT_OP = " + MGT_OP;
                    dt = helper.GetDataTableFromDB(sql);
                    if (dt != null)
                    {
                        HARV_MONTH.Text = dt.Rows[0][0].ToString();
                        HARV_DAY.Text   = dt.Rows[0][1].ToString();
                        HARV_CNOP.Text  = dt.Rows[0][3].ToString();
                    }
                }
                else
                {
                    MessageBox.Show("错误");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
示例#3
0
        /// <summary>
        /// 保存编辑
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSaveEdit_Click(object sender, EventArgs e)
        {
            helper = new AccessHelper();
            string    sql     = "select MGT_OP,MONTH,DAY from mgt2 where SUBBASIN =" + subbasinId + " AND HRU = 1;";
            DataTable dt_c    = helper.GetDataTableFromDB(sql);
            DataTable dt_show = new DataTable();
            DataRow   dr      = dt_show.NewRow();
            string    str     = "";

            foreach (DataRow dr_c in dt_c.Rows)
            {
                switch (Convert.ToInt32(dr_c[0].ToString()))
                {
                case 1:
                    //获取mgt2表中的信息
                    //以每个子流域的第一个HRU为代表
                    sql     = "select  MONTH,DAY,HUSC,MGT_OP,PLANT_ID,CURYR_MAT,HEATUNITS,LAI_INIT,HI_TARG,BIO_INIT,BIO_TARG,CNOP from mgt2 where SUBBASIN =" + subbasinId + " and hru = 1 and MGT_OP=1 and MONTH=" + dr_c[1] + " and DAY=" + dr_c[2] + ";";
                    dt_show = helper.GetDataTableFromDB(sql);
                    str    += " ";
                    str    += dt_show.Rows[0].ItemArray[0].ToString().PadLeft(2, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[1].ToString().PadLeft(2, ' '); str += " ";
                    str    += string.Format("{0:0000.000}", Convert.ToDouble(dt_show.Rows[0].ItemArray[2])).PadLeft(8, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[3].ToString().PadLeft(2, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[4].ToString().PadLeft(4, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[5].ToString().PadLeft(2, ' '); str += " ";
                    str    += string.Format("{0:000000.00000}", Convert.ToDouble(dt_show.Rows[0].ItemArray[6])).PadLeft(12, ' '); str += " ";
                    str    += string.Format("{0:000.00}", Convert.ToDouble(dt_show.Rows[0].ItemArray[7])).PadLeft(6, ' '); str += " ";
                    str    += string.Format("{0:00000.00000}", Convert.ToDouble(dt_show.Rows[0].ItemArray[8])).PadLeft(11, ' '); str += " ";
                    str    += string.Format("{0:0.00}", Convert.ToDouble(dt_show.Rows[0].ItemArray[9])).PadLeft(4, ' '); str += " ";
                    str    += string.Format("{0:00000.00}", Convert.ToDouble(dt_show.Rows[0].ItemArray[10])).PadLeft(6, ' '); str += " ";
                    str    += string.Format("{0:00.00}", Convert.ToDouble(dt_show.Rows[0].ItemArray[11])).PadLeft(5, ' '); str += " ";
                    str    += "\r\n"; break;

                case 2:
                    sql     = "select MONTH,DAY,HUSC,MGT_OP,IRR_SC,IRR_NO,IRR_AMT,IRR_SALT,IRR_EFM,IRR_SQ from mgt2 where SUBBASIN =" + subbasinId + " and hru = 1 and MGT_OP=2  and MONTH=" + dr_c[1] + " and DAY=" + dr_c[2] + ";";
                    dt_show = helper.GetDataTableFromDB(sql);
                    str    += " ";
                    str    += dt_show.Rows[0].ItemArray[0].ToString().PadLeft(2, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[1].ToString().PadLeft(2, ' '); str += " ";
                    str    += string.Format("{0:0000.000}", Convert.ToDouble(dt_show.Rows[0].ItemArray[2])).PadLeft(8, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[3].ToString().PadLeft(2, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[4].ToString().PadLeft(3, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[5].ToString().PadLeft(2, ' '); str += " ";
                    str    += string.Format("{0:000000.00000}", Convert.ToDouble(dt_show.Rows[0].ItemArray[6])).PadLeft(12, ' '); str += " ";
                    str    += string.Format("{0:000.00}", Convert.ToDouble(dt_show.Rows[0].ItemArray[7])).PadLeft(6, ' '); str += " ";
                    str    += string.Format("{0:00000.00000}", Convert.ToDouble(dt_show.Rows[0].ItemArray[8])).PadLeft(11, ' '); str += " ";
                    str    += string.Format("{0:000.00}", Convert.ToDouble(dt_show.Rows[0].ItemArray[9])).PadLeft(4, ' '); str += " ";
                    str    += "\r\n"; break;

                case 3:
                    sql     = "select MONTH,DAY,HUSC,MGT_OP,FERT_ID,FRT_KG,FRT_SURFACE  from mgt2 where SUBBASIN =" + subbasinId + " and hru = 1 and MGT_OP=3 and MONTH=" + dr_c[1] + " and DAY=" + dr_c[2] + ";";
                    dt_show = helper.GetDataTableFromDB(sql);
                    str    += " ";
                    str    += dt_show.Rows[0].ItemArray[0].ToString().PadLeft(2, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[1].ToString().PadLeft(2, ' '); str += " ";
                    str    += string.Format("{0:0000.000}", Convert.ToDouble(dt_show.Rows[0].ItemArray[2])).PadLeft(8, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[3].ToString().PadLeft(2, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[4].ToString().PadLeft(4, ' '); str += " ";
                    str    += string.Format("{0:000000.00000}", Convert.ToDouble(dt_show.Rows[0].ItemArray[5])).PadLeft(12, ' '); str += " ";
                    str    += string.Format("{0:000.00}", Convert.ToDouble(dt_show.Rows[0].ItemArray[6])).PadLeft(6, ' '); str += " ";
                    str    += "\r\n"; break;

                case 5:
                    sql     = "select MONTH,DAY,HUSC,MGT_OP,CNOP,HI_OVR,FRAC_HARVK from mgt2 where SUBBASIN =" + subbasinId + " and hru = 1 and MGT_OP=5 and MONTH=" + dr_c[1] + " and DAY=" + dr_c[2] + ";";
                    dt_show = helper.GetDataTableFromDB(sql);
                    str    += " ";
                    str    += dt_show.Rows[0].ItemArray[0].ToString().PadLeft(2, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[1].ToString().PadLeft(2, ' '); str += " ";
                    str    += string.Format("{0:0000.000}", Convert.ToDouble(dt_show.Rows[0].ItemArray[2])).PadLeft(8, ' '); str += " ";
                    str    += dt_show.Rows[0].ItemArray[3].ToString().PadLeft(2, ' '); str += " ";
                    str    += string.Format("{0:000000.00000}", Convert.ToDouble(dt_show.Rows[0].ItemArray[4])).PadLeft(12, ' '); str += " ";
                    str    += string.Format("{0:000.00}", Convert.ToDouble(dt_show.Rows[0].ItemArray[5])).PadLeft(6, ' '); str += " ";
                    str    += string.Format("{0:00.00}", Convert.ToDouble(dt_show.Rows[0].ItemArray[6])).PadLeft(5, ' '); str += " ";
                    str    += "\r\n"; break;
                }
            }
            string        way    = Application.StartupPath + @"\TxtInOut";
            DirectoryInfo folder = new DirectoryInfo(way);

            foreach (FileInfo file in folder.GetFiles(subbasinId.ToString().PadLeft(5, '0') + "*.mgt"))      //遍历所有指定的mgt文件
            {
                int rows = find(Application.StartupPath + @"\TxtInOut\" + file.Name, "Operation Schedule:"); //查找指定字符串"Operation Schedule:"所在行数
                if (rows == 0)
                {
                    MessageBox.Show(file.Name + "文件格式错误!");
                }
                var lines = File.ReadAllLines(Application.StartupPath + @"\TxtInOut\" + file.Name); //读取文件的所有行
                var query = lines.Take(rows).ToArray();                                             //读取"Operation Schedule:"之前(包含)的字符串
                File.WriteAllLines(Application.StartupPath + @"\TxtInOut\" + file.Name, query);     //重写
                using (StreamWriter sw = new StreamWriter(Application.StartupPath + @"\TxtInOut\" + file.Name, true))
                {
                    sw.WriteLine(str);
                }
            }
            MessageBox.Show("保存编辑完成!");
        }