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();
}
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();
}