Exemple #1
0
        private void button4_Click(object sender, EventArgs e)
        {
            gkfqd.Common.DbUse.GetconnectionStringsConfig();
            gk014 frmgk014 = new gk014();

            frmgk014.FormBorderStyle = FormBorderStyle.FixedSingle;    //固定窗体大小不变
            frmgk014.StartPosition   = FormStartPosition.CenterScreen; //窗体居中
            frmgk014.ShowDialog();
        }
Exemple #2
0
        private void button3_Click(object sender, EventArgs e)
        {
            if (dataGridView1.CurrentRow == null)
            {
                MessageBox.Show("请点击行头选择数据!");
                return;
            }
            DataGridViewRow dgvr = dataGridView1.CurrentRow;
            //获取项目名称值
            string strXmmc = dgvr.Cells["项目名称"].Value.ToString();

            sqlQuery.Clear();
            sqlQuery.Append("SELECT  XMSZ AS 项目所在省, ");
            sqlQuery.Append("XMSZS        AS 项目所在市, ");
            sqlQuery.Append("XMSZX        AS 项目所在县, ");
            sqlQuery.Append("XMMC         AS 项目名称, ");
            sqlQuery.Append("ZZSSDW       AS 组织实施单位, ");
            sqlQuery.Append("PZWH         AS 批准文号, ");
            sqlQuery.Append("PZJG         AS 批准机关, ");
            sqlQuery.Append("PZSJ         AS 批准时间, ");
            sqlQuery.Append("JHKSRQ       AS 计划开始日期, ");
            sqlQuery.Append("JHJSRQ       AS 计划结束日期, ");
            sqlQuery.Append("XMSJQYDWGS   AS 项目涉及权益单位个数, ");
            sqlQuery.Append("ZQYJDWSL     AS 征求意见单位数量, ");
            sqlQuery.Append("TYSL         AS 同意数量, ");
            sqlQuery.Append("FKGM         AS 复垦规模, ");
            sqlQuery.Append("FKGDGM       AS 复垦耕地规模, ");
            sqlQuery.Append("FKZJ         AS 土地复垦资金预算, ");
            sqlQuery.Append("CQF          AS 拆迁费, ");
            sqlQuery.Append("QT           AS 其他, ");
            sqlQuery.Append("HJ           AS 合计, ");
            sqlQuery.Append("CZZJ         AS 财政资金, ");
            sqlQuery.Append("SHZJ         AS 社会资金, ");
            sqlQuery.Append("XDZJ         AS 信贷资金, ");
            sqlQuery.Append("QTZJ         AS 其他资金, ");
            sqlQuery.Append("QSXZ         AS 权属性质, ");
            sqlQuery.Append("QSDWMC       AS 权属单位名称, ");
            sqlQuery.Append("QSDWDM       AS 权属单位代码, ");
            sqlQuery.Append("ZLDWM        AS 坐落单位名, ");
            sqlQuery.Append("FKJD         AS 复垦进度, ");
            sqlQuery.Append("YSZT         AS 验收状态, ");
            sqlQuery.Append("ZLDWDM       AS 坐落单位代码, ");
            sqlQuery.Append("FKJXGM       AS 复垦建新规模, ");
            sqlQuery.Append("XMQF         AS 项目区分, ");
            sqlQuery.Append("ZBSY         AS 指标使用, ");
            sqlQuery.Append("ZJAP         AS 资金安排,  ");
            sqlQuery.Append("YSSJ         AS 验收时间,  ");
            sqlQuery.Append("QSTZ         AS 权属调整,  ");
            sqlQuery.Append("KHZT         AS 考核状态,  ");
            sqlQuery.Append("XMGK         AS 项目概况  ");
            sqlQuery.Append("FROM         FKXM  ");
            sqlQuery.Append("WHERE         XMMC='" + strXmmc + "'");
            gkfqd.Common.DbUse.GetOleDbconnection().Close();
            gkfqd.Common.DbUse.GetOleDbconnection().Open();
            dataSet6.Clear();
            OleDbDataAdapter MyAdapter = new OleDbDataAdapter(sqlQuery.ToString(), gkfqd.Common.DbUse.GetOleDbconnection());

            MyAdapter.Fill(dataSet6);
            gkfqd.Common.DbUse.GetOleDbconnection().Close();
            //dataSet5.Tables[0].Rows[0]["药物名"].ToString();
            gk014 frmgk014 = new gk014(dataSet6.Tables[0]);

            frmgk014.FormBorderStyle = FormBorderStyle.FixedSingle;    //固定窗体大小不变
            frmgk014.StartPosition   = FormStartPosition.CenterScreen; //窗体居中
            frmgk014.ShowDialog();
        }