private void button7_Click(object sender, EventArgs e)
{
string _strBandedSQL = string.Empty;
DataGridViewRow _drObject = dataGridView1.CurrentRow;
string _strExportType = uctlBaseConfig.GetConfig("ExportType");
string _strObjectName = _drObject.Cells["TABLE_NAME"].Value.ToString();
string _strSQL = string.Empty;
if (DialogResult.OK == MessageBox.Show("确定生成抓取数据SQL？", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning))
{
_strBandedSQL = ExportDB.GetObjectBandedSQL(_strObjectName);
rtb_sql.Text = _strBandedSQL;
}
}
private void button7_Click(object sender, EventArgs e)
{
string _strBandedSQL = string.Empty;
DataGridViewRow _drObject = dataGridView1.CurrentRow;
string _strExportType = uctlBaseConfig.GetConfig("ExportType");
string _strObjectName = _drObject.Cells["TABLE_NAME"].Value.ToString();
string _strSQL = string.Empty;// string.Format(@"delete pt_chapter_dict where table_name = '{0}'", _strObjectName);
DataTable _dtObject = null;
if (DialogResult.OK == MessageBox.Show("确定同步[章节]数据？", "Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning))
{
//CommonFunction.OleExecuteNonQuery(_strSQL, "EMR");
switch (_strExportType)
{
case "DB":
_strBandedSQL = ExportDB.GetObjectBandedSQL(_strObjectName);
break;
case "XML":
_dtObject = ExportXml.GetObject(_strObjectName);
break;
case "EXCEL":
break;
case "DBF":
break;
default:
break;
}
rtb_sql.Text = _strBandedSQL;
//SycnChapterData(_strObjectName, _dtObject);
InitData();
}
}
