private EnterpriseIDCompareBLL()
{
dao = EnterpriseIDCompareDAO.GetInstance();
}
private EnterpriseIDCompareBLL(string connectionName)
{
dao = EnterpriseIDCompareDAO.GetInstance(connectionName);
}
private void btnView_Click(object sender, EventArgs e)
{
//try
//{
// this.openFileDialog.Filter = "Excel文件(*.xls)|*.xls|dbf文件(*.dbf)|*.dbf|文本文件(*.txt)|*.txt|所有文件 (*.*)|*.*";
// if (this.openFileDialog.ShowDialog() == DialogResult.OK)
// {
// if (this.openFileDialog.FileName == "")
// {
// EmedMessageBox.ShowWarning("请选择采购计划文件路径。");
// }
// else
// {
// this.txtFile.Text = this.openFileDialog.FileName;
// openFileDialog.InitialDirectory = System.Windows.Forms.Application.StartupPath;
// openFileDialog.RestoreDirectory = true;
// Cursor.Current = Cursors.AppStarting;
// string dbfile = this.openFileDialog.FileNames[0];
// this.ExcelToDS(dbfile);
// }
// }
//}
//catch (Exception exception1)
//{
// return;
//}
//finally
//{
// Cursor.Current = Cursors.Default;
// GC.Collect();
//}
string strCurrentDB = FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"\HisEnterPriseMapList.xml", "Config/SourceDB"), "DBType");
if (string.IsNullOrEmpty(strCurrentDB))
{
XtraMessageBox.Show("没有进行字段匹配，无法导入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
//ComUtil.MsgBox("没有进行字段匹配，无法导入！");
return;
}
//选择待导入的文件
string str = "";
if (strCurrentDB.CompareTo("EXCEL") == 0)
{
openFileDialog.Filter = "Excel文档(*.xls)|*.xls";
}
if (strCurrentDB.CompareTo("ACCESS") == 0)
{
openFileDialog.Filter = "MDB文档(*.mdb)|*.mdb";
}
//openFileDialog1.Filter = "DBF文档(*.dbf)|*.dbf|Excel文档(*.xls)|*.xls";
openFileDialog.FilterIndex = 1;
openFileDialog.Title = "打开文件";
openFileDialog.InitialDirectory = System.Windows.Forms.Application.StartupPath;
openFileDialog.RestoreDirectory = true;
openFileDialog.FileName = "";
openFileDialog.ShowDialog();
try
{
str = openFileDialog.FileName;
if (!string.IsNullOrEmpty(str))
{
this.txtFile.Text = str;
ClientConfiguration.HisPath = str;
string sql = string.Empty;
if (strCurrentDB.CompareTo("EXCEL") == 0)
{
ClientConfiguration.ConnectionString = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + str + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'";
sql = FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"\HisEnterPriseMapList.xml", "Config/Sqls/Sql").InnerText;
}
if (strCurrentDB.CompareTo("ACCESS") == 0)
{
string password = SecretUtil.DeSecret(FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/HisEnterPriseMapList.xml", "Config/DestDB"), "Password"));
ClientConfiguration.ConnectionString = " Provider = Microsoft.Jet.OLEDB.4.0 ;Jet OLEDB:Database Password="******"; Data Source = " + str + ";";
sql = FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"\HisEnterPriseMapList.xml", "Config/ASqls/Sql").InnerText;
}
//ClientConfiguration.ConnectionString = ClientConfiguration.ConnectionString.Replace(ClientConfiguration.HisPath, str);
ClientConfiguration.Save();
DataTable dt = EnterpriseIDCompareDAO.GetInstance().GetEnterPrise(sql);
this.bindingSource.DataSource = null;
this.bindingSource.DataSource = dt;
this.lb_DgvCaptionText.Text = "HIS企业编码：共 " + dt.DefaultView.Count + " 条记录";
//setErpSendMapData();
}
}
catch (Exception)
{
this.bindingSource.DataSource = null;
XtraMessageBox.Show("不是有效的数据文件！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
//ComUtil.MsgBox("不是有效的数据文件！");
}
}