/// <summary> /// 判断订单中未匹配的产品和企业 /// </summary> /// <param name="sOrderID"></param> /// <param name="sOrgID"></param> //private void JudgeCropDataList(string sOrderID, string sOrgID) //{ // DataTable dtCrop = new DataTable(); // DataTable dtProd = new DataTable(); // dtCrop = SalerOrderBLL.GetInstance().GetNotMapCorp(sOrderID, sOrgID); // if (dtCrop.Rows.Count > 0) // { // FormCropMapExp formexpmap = new FormCropMapExp(dtCrop); // formexpmap.ShowDialog(); // } // dtProd = SalerOrderBLL.GetInstance().GetNotMapProd(sOrderID, sOrgID); // if (dtProd.Rows.Count > 0) // { // FormProMapExp formpromap = new FormProMapExp(dtProd); // formpromap.ShowDialog(); // } //} /// <summary> /// 获取对应的列名 /// </summary> /// <param name="colName"></param> /// <returns></returns> private string getMapColName(string colName) { string result; /****************************************************************** * * 修改时间:2007-3-21 * 修改人:ningbo * 修改原因: * 新增代码:EmedFunc.GetLocalPersonCfgPath()+"GpoOrderSend.xml" * ******************************************************************/ XmlNodeList nodeList = FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/GpoOrderExport.xml", "Config/ContrastList").ChildNodes; foreach (XmlNode xn in nodeList) { XmlElement xe = (XmlElement)xn; if (colName.Equals(xe.GetAttribute("SourceField").ToUpper())) { if (!string.IsNullOrEmpty(xe.GetAttribute("DestField"))) { return(xe.GetAttribute("DestField")); } } } return(""); }
public FormMain() { //InitializeComponent(); this.components = null; this._cfgList = new CfgList(); this._listIndex = new ArrayList(); this._isExistSlnCfg = false; this.InitializeComponent(); localPersonCfgPath = EmedFunc.GetLocalPersonCfgPath(); }
/// <summary> /// 选择数据文件 梁晓奕添加2007-4-13 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnImportDbFile_Click(object sender, EventArgs e) { switch (this.cmbDBType.SelectedIndex) { case 1: openFileDialog1.Filter = "MDB文档(*.mdb)|*.mdb"; break; case 2: openFileDialog1.Filter = "DBF文档(*.dbf)|*.dbf"; break; case 4: openFileDialog1.Filter = "Excel文档(*.xls)|*.xls"; break; default: return; } openFileDialog1.FilterIndex = 1; openFileDialog1.Title = "打开文件"; openFileDialog1.InitialDirectory = Application.StartupPath; openFileDialog1.RestoreDirectory = true; openFileDialog1.FileName = ""; //modify by gaoyuan 20070417 取消时不做任何操作 if (openFileDialog1.ShowDialog() == DialogResult.Cancel) { return; } string fileName = openFileDialog1.FileName; //add by yanbing 2007-6-11 for export to access //this.txtDataBase.Text = fileName; //end by yanbing 2007-6-11 string soureFileName = EmedFunc.GetLocalPersonCfgPath() + @"\" + this.txtDataBase.Text; string backFileName = EmedFunc.GetLocalPersonCfgPath() + @"\Bak" + this.txtDataBase.Text; if (!File.Exists(backFileName)) { File.Copy(soureFileName, backFileName); } if (File.Exists(soureFileName)) { File.Delete(soureFileName); } if (File.Exists(fileName)) { File.Copy(fileName, soureFileName); } }
private string GetConnStr(string inDBType) { //MessageBox.Show(EmedFunc.GetLocalPersonCfgPath() + @"\" + this.txtDataBase.Text); string text1 = ""; string text2 = inDBType.ToUpper(); if (text2 == null) { return(text1); } text2 = string.IsInterned(text2); if (text2 == "SQLSERVER") { return("Provider=SQLOLEDB;Server=" + this.txtServer.Text + ";UID=" + this.txtUser.Text + ";PWD=" + this.txtPassword.Text + ";Database=" + this.txtDataBase.Text); } if (text2 == "ACCESS") { //modify by gaoyuan 20070411 由于发布时将数据库文件以数据文件的类型发布,故修改文件路径 //return ("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password="******";Data Source=" + this.txtDataBase.Text); return("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password="******";Data Source=" + EmedFunc.GetLocalPersonCfgPath() + @"\" + this.txtDataBase.Text); } if (text2 == "FOXPRO") { //modify by gaoyuan 20070411 由于发布时将数据库文件以数据文件的类型发布,故修改文件路径 //return ("Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=" + this.txtDataBase.Text + ";SourceType=DBF;"); return("Provider=MSDASQL.1;Driver=Microsoft Visual Foxpro Driver;SourceDB=" + EmedFunc.GetLocalPersonCfgPath() + @"\" + this.txtDataBase.Text + ";SourceType=DBF;"); } if (text2 == "ORACLE") { return("Provider=MSDAORA.1;Data Source=" + this.txtServer.Text + ";User ID=" + this.txtUser.Text + ";Password="******"EXCEL") { return(text1); } if (Config.Intance().CurrentCfgType == "1") { //modify by gaoyuan 20070411 由于发布时将数据库文件以数据文件的类型发布,故修改文件路径 return("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + EmedFunc.GetLocalPersonCfgPath() + @"\" + this.txtDataBase.Text + ";Persist Security Info=False;Extended Properties=\"Excel 8.0;IMEX=1\""); } //modify by gaoyuan 20070411 由于发布时将数据库文件以数据文件的类型发布,故修改文件路径 return("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + EmedFunc.GetLocalPersonCfgPath() + @"\" + this.txtDataBase.Text + ";Extended Properties=Excel 8.0"); }
/// <summary> /// Handles the Load event of the SyncForm control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param> private void SyncForm_Load(object sender, EventArgs e) { //StartSycn(); InitializeListView(); this.lblTime.Visible = false; this.msgLabel.Visible = false; //this.SyncProgressBar.Visible = false; string filePath; //判断主库文件是否存在,不存在,只能全同步 2007-6-28 if (EmedFunc.GetLocalPersonCfgPath().EndsWith("\\")) { filePath = EmedFunc.GetLocalPersonCfgPath() + "db\\TradeAssistant.mdf"; } else { filePath = EmedFunc.GetLocalPersonCfgPath() + "\\db\\TradeAssistant.mdf"; } if (!File.Exists(filePath)) { this.radioGroupSyncType.SelectedIndex = 0; //this.radioGroupSyncType.EditValue = 1; this.chkUpload.Enabled = false; } else { this.radioGroupSyncType.SelectedIndex = 1; this.chkUpload.Enabled = true; } overFlag = false; if (!string.IsNullOrEmpty(ClientConfiguration.Skin)) { this.LookAndFeel.SetSkinStyle(ClientConfiguration.Skin); } else { this.LookAndFeel.SetSkinStyle("Money Twins"); } }
/// <summary> /// 废弃 /// </summary> /// <param name="dt"></param> /// <returns></returns> public DataTable SetOrderReceiveDTColoum(DataTable dt) { Config.Intance().InitCfgData(EmedFunc.GetLocalPersonCfgPath() + @"\HisOrderReceive.xml"); Config config = Config.Intance(); DataTable outTable = new DataTable(); outTable = dt.Copy(); bool Ifhas = false; ArrayList al = new ArrayList(); foreach (DataColumn dc in outTable.Columns) { XmlElement element1 = config.EleContrast; XmlElement element2 = (XmlElement)config.EleDestination.SelectSingleNode("DestTable"); for (int num1 = 0; num1 < element1.ChildNodes.Count; num1++) { string text1 = element1.ChildNodes[num1].Attributes["SourceField"].Value.Trim().ToLower(); string text2 = element1.ChildNodes[num1].Attributes["DestField"].Value.Trim().ToLower(); if (text1.ToLower() == dc.Caption.ToLower()) { dc.ColumnName = text2; Ifhas = true; } } if (Ifhas == false) { al.Add(dc); } Ifhas = false; } for (int i = 0; i < al.Count; i++) { outTable.Columns.Remove((DataColumn)al[i]); } //修改DataTable列的顺序 //DataTable dtout = changeOrder(outTable, config); return(outTable); }
/// <summary> /// Handles the Load event of the SyncForm control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param> private void SyncForm_Load(object sender, EventArgs e) { //StartSycn(); InitializeListView(); listView1.CheckBoxes = false; this.lblTime.Visible = false; this.msgLabel.Visible = false; this.SyncProgressBar.Visible = false; string filePath; //判断主库文件是否存在,不存在,只能全同步 2007-6-28 if (EmedFunc.GetLocalPersonCfgPath().EndsWith("\\")) { filePath = EmedFunc.GetLocalPersonCfgPath() + "db\\TradeAssistant.mdf"; } else { filePath = EmedFunc.GetLocalPersonCfgPath() + "\\db\\TradeAssistant.mdf"; } if (!File.Exists(filePath)) { this.rbAdd.Enabled = false; this.chkUpload.Enabled = false; this.csvFlag.Checked = false; this.rbAll.Checked = true; } //add by yanbing csv方式下载配置读取 2007-6-28 string XmlPath = ClientConfiguration.LocalPersonConfigPath + @"\UserConfig.xml"; if (File.Exists(XmlPath)) { XmlDocument document1 = new XmlDocument(); document1.Load(XmlPath); XmlElement element1 = (XmlElement)document1.SelectSingleNode("UserConfig/ConnectLogic"); this.csvFlag.Checked = element1.GetAttribute("IfUseCSVMethod").ToLower() == "true"; } //end add }
/// <summary> /// 导出Excel /// </summary> /// <param name="inDestFilePath">目标文件路径</param> /// <param name="inDataTable">导出数据集</param> /// <returns></returns> public bool ExportReceive(string inDestFilePath, DataTable inDataTable) { bool flag = true; Config.Intance().InitCfgData(EmedFunc.GetLocalPersonCfgPath() + @"\HisOrderReceive.xml"); this._Config = Config.Intance(); XmlElement element1 = (XmlElement)this._Config.EleDestination.SelectSingleNode("DestTable"); //获前当前程序路径 string AppPath = EmedFunc.GetLocalPersonCfgPath();// AppDomain.CurrentDomain.BaseDirectory; //获取当前导出数据类型对象 string DbType = this._Config.EleDestination.GetAttribute("DBType").ToString().Trim(); switch (DbType) { case "EXCEL": if (!inDestFilePath.ToString().Contains("xls")) { XtraMessageBox.Show("请选择有效的EXCEL文件(*.xls)!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return(false); } if (!this.CopyStandardTempFile(AppPath + @"\SendReceiveBak.xls", inDestFilePath, DbType)) { XtraMessageBox.Show("导出到货SendReceiveBak.xls模板复制失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return(false); } flag = OrdReceiveExcelDao.ExportReceive(inDataTable, inDestFilePath); break; default: break; } return(flag); }
/// <summary> /// 初始化HIS接口项目列表 /// </summary> private void InitCfgList() { this.lvConfig.DataSource = null; //this.lvConfig.Items.Clear(); ArrayList list1 = new ArrayList(); this._isExistSlnCfg = this._cfgList.ReadConfig(); if (this._isExistSlnCfg) { for (int num1 = 0; num1 < this._cfgList.Cfgs.Length; num1++) { if (this._cfgList.Cfgs[num1] != null) { string text1 = Application.StartupPath + @"\" + this._cfgList.Cfgs[num1].DllName; //MessageBox.Show(localPersonCfgPath + @"\" + this._cfgList.Cfgs[num1].CfgName); string text2 = localPersonCfgPath + @"\" + this._cfgList.Cfgs[num1].CfgName; string text3 = Application.StartupPath + @"\" + this._cfgList.Cfgs[num1].CfgTemplet; if (File.Exists(text2)) { ListViewItem item1 = new ListViewItem(this._cfgList.Cfgs[num1].Name); item1.Tag = localPersonCfgPath + @"\" + this._cfgList.Cfgs[num1].CfgName; item1.SubItems.Add(this._cfgList.Cfgs[num1].CfgName); item1.SubItems.Add(this._cfgList.Cfgs[num1].TypeCn); list1.Add(item1); this._listIndex.Add(num1.ToString()); if (!File.Exists(text2) && File.Exists(text3)) { File.Copy(text3, text2); } } } } } else { string text4 = Application.StartupPath + @"\HisPortalReceiveLib.dll"; if (File.Exists(text4)) { ListViewItem item2 = new ListViewItem("导出到货项目"); item2.Tag = EmedFunc.GetLocalPersonCfgPath() + @"\HisOrderReceive.xml"; item2.SubItems.Add("HisOrderReceive.xml"); item2.SubItems.Add("导出"); list1.Add(item2); if (!File.Exists(EmedFunc.GetLocalPersonCfgPath() + @"\HisOrderReceive.xml") && File.Exists(Application.StartupPath + @"\ReceivePortal.data")) { File.Copy(Application.StartupPath + @"\ReceivePortal.data", EmedFunc.GetLocalPersonCfgPath() + @"\HisOrderReceive.xml"); } } string text5 = Application.StartupPath + @"\HisPortalEnterLib.dll"; if (File.Exists(text5)) { ListViewItem item3 = new ListViewItem("导出入库项目"); item3.Tag = Application.StartupPath + @"\EnterPortal.cfg"; item3.SubItems.Add("EnterPortal.cfg"); item3.SubItems.Add("导出"); list1.Add(item3); if (!File.Exists(Application.StartupPath + @"\EnterPortal.cfg") && File.Exists(Application.StartupPath + @"\EnterPortal.data")) { File.Copy(Application.StartupPath + @"\EnterPortal.data", Application.StartupPath + @"\EnterPortal.cfg"); } } string text6 = Application.StartupPath + @"\HisPortalPurchaseLib.dll"; if (File.Exists(text6)) { ListViewItem item4 = new ListViewItem("导入采购计划项目"); item4.Tag = EmedFunc.GetLocalPersonCfgPath() + @"\HisPurchase.xml"; item4.SubItems.Add("HisPurchase.xml"); item4.SubItems.Add("导入"); list1.Add(item4); if (!File.Exists(EmedFunc.GetLocalPersonCfgPath() + @"\HisPurchase.xml") && File.Exists(Application.StartupPath + @"\PurchasePortal.data")) { File.Copy(Application.StartupPath + @"\PurchasePortal.data", EmedFunc.GetLocalPersonCfgPath() + @"\HisPurchase.xml"); } } string text7 = Application.StartupPath + @"\HisPortalStockLib.dll"; if (File.Exists(text7)) { ListViewItem item5 = new ListViewItem("导入库存项目"); item5.Tag = Application.StartupPath + @"\StockPortal.cfg"; item5.SubItems.Add("StockPortal.cfg"); item5.SubItems.Add("导入"); list1.Add(item5); if (!File.Exists(Application.StartupPath + @"\StockPortal.cfg") && File.Exists(Application.StartupPath + @"\StockPortal.data")) { File.Copy(Application.StartupPath + @"\StockPortal.data", Application.StartupPath + @"\StockPortal.cfg"); } } } string text8 = Application.StartupPath + @"\ErpPortalStockLib.dll"; if (File.Exists(text8)) { ListViewItem item6 = new ListViewItem("导入物流系统库存数据"); item6.Tag = Application.StartupPath + @"\ErpStockPortal.cfg"; item6.SubItems.Add("ErpStockPortal.cfg"); item6.SubItems.Add("导入"); list1.Add(item6); } string text9 = Application.StartupPath + @"\ErpPortalStoreOutLib.dll"; if (File.Exists(text9)) { ListViewItem item7 = new ListViewItem("导入物流系统出库数据"); item7.Tag = Application.StartupPath + @"\ErpStoreOutPortal.cfg"; item7.SubItems.Add("ErpStoreOutPortal.cfg"); item7.SubItems.Add("导入"); list1.Add(item7); } string text10 = Application.StartupPath + @"\ErpPortalMedicalLib.dll"; if (File.Exists(text10)) { ListViewItem item8 = new ListViewItem("导入物流系统药品字典数据"); item8.Tag = Application.StartupPath + @"\ErpMedicalPortal.cfg"; item8.SubItems.Add("ErpMedicalPortal.cfg"); item8.SubItems.Add("导入"); list1.Add(item8); } ListViewItem[] itemArray1 = new ListViewItem[list1.Count]; list1.CopyTo(itemArray1); //this.lvConfig.Items.AddRange(itemArray1); //新加实验代码 DataTable dt = new DataTable(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns.Add(); dt.Columns[0].ColumnName = "name"; dt.Columns[1].ColumnName = "item"; dt.Columns[2].ColumnName = "detail"; dt.Columns[3].ColumnName = "Tag"; ListViewItem Parameter; DataRow item; for (int i = 0; i < itemArray1.Length; i++) { Parameter = itemArray1[i]; item = dt.NewRow(); item[0] = Parameter.SubItems[0].Text.ToString(); item[1] = Parameter.SubItems[1].Text.ToString(); item[2] = Parameter.SubItems[2].Text.ToString(); item[3] = Parameter.Tag.ToString(); dt.Rows.Add(item); } lvConfig.DataSource = dt.DefaultView; //结束 }
private void btnAllExport_Click(object sender, EventArgs e) { bool flag = true; if (this.gridView3.RowCount == 0) { XtraMessageBox.Show("无可操作记录!", Constant.MsgTitle, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } string strCurrentDB = FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/HisOrderReceive.xml", "Config/DestDB"), "DBType"); if (strCurrentDB.Equals("EXCEL")) { //选择导出文件 string ExpFilePath = this.SelectExportFile(); if (ExpFilePath.Length == 0) { return; } try { //dttmp = (DataTable)(this.bindingSource1.List[0]); DataRow[] drArray = dtReceive.DefaultView.Table.Select(dtReceive.DefaultView.RowFilter, dtReceive.DefaultView.Sort, dtReceive.DefaultView.RowStateFilter); dttmp = dtReceive.DefaultView.Table.Clone(); foreach (DataRow dr in drArray) { dttmp.Rows.Add(dr.ItemArray); } //原代码全导出无法查询导出 //flag = OutOrderReceiveDao.GetInstance().ExportReceive(ExpFilePath, dtReceive); //修改后 flag = OutOrderReceiveDao.GetInstance().ExportReceive(ExpFilePath, dttmp); if (flag) { XtraMessageBox.Show("导出到货信息文件成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { XtraMessageBox.Show("导出到货信息文件失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } catch (Exception ex) { XtraMessageBox.Show("导出到货信息文件出错!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } string receiveIdstr = string.Empty; string receiveHisIdstr = string.Empty; foreach (DataRow dr in dtReceive.Rows) { if (dr["TYPE"].ToString().Equals("1")) { receiveIdstr += "'" + dr["ID"].ToString() + "',"; } else { receiveHisIdstr += "'" + dr["ID"].ToString() + "',"; } } //OutOrderReceiveDao.GetInstance().UpdateOrderReceive(receiveIdstr, receiveHisIdstr); }
private bool CheckTemplet() { //modify by gaoyuan 20070411 由于发布时将数据库文件以数据文件的类型发布,故修改文件路径 //if (((Config.Intance().CurrentDBType == "FOXPRO") && (Config.Intance().CurrentFoxproTemplet != "")) && !File.Exists(Config.Intance().CurrentFoxproTemplet)) if (((Config.Intance().CurrentDBType == "FOXPRO") && (Config.Intance().CurrentFoxproTemplet != "")) && !File.Exists(EmedFunc.GetLocalPersonCfgPath() + @"\" + Config.Intance().CurrentFoxproTemplet)) { XtraMessageBox.Show(Config.Intance().CurrentFoxproTemplet + "不存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } //modify by gaoyuan 20070411 由于发布时将数据库文件以数据文件的类型发布,故修改文件路径 //if (((Config.Intance().CurrentDBType == "FOXPRO") && (Config.Intance().CurrentFoxproDetailTemplet != "")) && !File.Exists(Config.Intance().CurrentFoxproDetailTemplet)) if (((Config.Intance().CurrentDBType == "FOXPRO") && (Config.Intance().CurrentFoxproDetailTemplet != "")) && !File.Exists(EmedFunc.GetLocalPersonCfgPath() + @"\" + Config.Intance().CurrentFoxproDetailTemplet)) { XtraMessageBox.Show(Config.Intance().CurrentFoxproDetailTemplet + "不存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } //modify by gaoyuan 20070411 由于发布时将数据库文件以数据文件的类型发布,故修改文件路径 //if (((Config.Intance().CurrentDBType == "TXT") && (Config.Intance().CurrentTxtTemplet != "")) && !File.Exists(Config.Intance().CurrentTxtTemplet)) if (((Config.Intance().CurrentDBType == "TXT") && (Config.Intance().CurrentTxtTemplet != "")) && !File.Exists(EmedFunc.GetLocalPersonCfgPath() + @"\" + Config.Intance().CurrentTxtTemplet)) { XtraMessageBox.Show(Config.Intance().CurrentTxtTemplet + "不存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return(false); } //modify by gaoyuan 20070411 由于发布时将数据库文件以数据文件的类型发布,故修改文件路径 //if (((Config.Intance().CurrentDBType == "EXCEL") && (Config.Intance().CurrentExcelTemplet != "")) && !File.Exists(Config.Intance().CurrentExcelTemplet)) if (((Config.Intance().CurrentDBType == "EXCEL") && (Config.Intance().CurrentExcelTemplet != "")) && !File.Exists(EmedFunc.GetLocalPersonCfgPath() + @"\" + Config.Intance().CurrentExcelTemplet)) { XtraMessageBox.Show(Config.Intance().CurrentExcelTemplet + "不存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);; return(false); } return(true); }
/// <summary> /// 获取导入的发货列表 /// </summary> /// <returns></returns> private DataTable GetImportTable() { string sql = FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"\GpoOrderSend.xml", "Config/Sqls/Sql").InnerText; return(GpoSendDao.GetInstance().GetErpSend(sql)); }
public bool ReadConfig() { XmlDocument document1 = null; int num; bool flag1; string clientType = "0"; string text1 = EmedFunc.GetLocalPersonCfgPath() + @"\" + this.CfgFileName; string userConfig = EmedFunc.GetLocalPersonCfgPath() + @"\UserConfig.xml"; try { document1 = new XmlDocument(); if (!File.Exists(text1)) { return(false); } //判断是否福建项目 2007-6-27 if (File.Exists(userConfig)) { XmlDocument userDoc = new XmlDocument(); userDoc.Load(userConfig); XmlElement elementUser = (XmlElement)userDoc.SelectSingleNode("UserConfig/ClientType"); if (elementUser != null) { clientType = elementUser.GetAttribute("type").Trim().ToUpper(); } } document1.Load(text1); XmlElement element1 = (XmlElement)document1.SelectSingleNode("Config/CfgList"); this.Cfgs = new CfgList[element1.ChildNodes.Count]; num = 0; for (int num1 = 0; num1 < element1.ChildNodes.Count; num1++) { //判断是否福建项目 2007-6-27 if ("1".Equals(clientType) && (element1.ChildNodes[num1].Attributes["Name"].Value.Equals("采购申请导出") || element1.ChildNodes[num1].Attributes["Name"].Value.Equals("采购申请发货导入") || element1.ChildNodes[num1].Attributes["Name"].Value.Equals("导入医院表信息"))) { continue; } this.Cfgs[num] = new CfgList(); this.Cfgs[num].Name = element1.ChildNodes[num1].Attributes["Name"].Value; this.Cfgs[num].Type = element1.ChildNodes[num1].Attributes["Type"].Value; this.Cfgs[num].DllName = element1.ChildNodes[num1].Attributes["DllName"].Value; this.Cfgs[num].CfgName = element1.ChildNodes[num1].Attributes["CfgName"].Value; this.Cfgs[num].CfgTemplet = element1.ChildNodes[num1].Attributes["CfgTemplet"].Value; if (this.Cfgs[num].Type == "0") { this.Cfgs[num].TypeCn = "导出"; } else { this.Cfgs[num].TypeCn = "导入"; } if (element1.ChildNodes[num1].Attributes["IsMulti"] == null) { this.Cfgs[num].IsMulti = false; } else { this.Cfgs[num].IsMulti = element1.ChildNodes[num1].Attributes["CfgTemplet"].Value == "1"; } this.Cfgs[num].FoxTemplet = element1.ChildNodes[num1].SelectSingleNode("FoxTemplet").InnerText; //this.Cfgs[num1].MDBTemplet = element1.ChildNodes[num1].SelectSingleNode("MDBTemplet").InnerText; //this.Cfgs[num1].DBName = element1.ChildNodes[num1].SelectSingleNode("DBName").InnerText; this.Cfgs[num].FoxDetailTemplet = element1.ChildNodes[num1].SelectSingleNode("FoxDetailTemplet").InnerText; this.Cfgs[num].TxtTemplet = element1.ChildNodes[num1].SelectSingleNode("TxtTemplet").InnerText; this.Cfgs[num].ExcelTemplet = element1.ChildNodes[num1].SelectSingleNode("ExcelTemplet").InnerText; ++num; } flag1 = true; } catch (Exception exception1) { ErrorLog.SaveLog("读取配置文件出错", exception1); flag1 = false; } finally { document1 = null; } return(flag1); }
/// <summary> /// 浏览按钮的操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnBrowse_Click(object sender, EventArgs e) { /****************************************************************** * * 修改时间:2007-3-21 * 修改人:ningbo * 修改原因: * 新增代码:EmedFunc.GetLocalPersonCfgPath() + "GpoOrderSend.xml" * ******************************************************************/ string strCurrentDB = FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"\GpoOrderSend.xml", "Config/SourceDB"), "DBType"); if (string.IsNullOrEmpty(strCurrentDB)) { MessageBox.Show("没有进行字段匹配,无法导入!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //选择待导入的文件 string str = ""; if (strCurrentDB.CompareTo("EXCEL") == 0) { openFileDialog1.Filter = "Excel文档(*.xls)|*.xls"; } //openFileDialog1.Filter = "DBF文档(*.dbf)|*.dbf|Excel文档(*.xls)|*.xls"; openFileDialog1.FilterIndex = 1; openFileDialog1.Title = "打开文件"; openFileDialog1.InitialDirectory = Application.StartupPath; openFileDialog1.RestoreDirectory = true; openFileDialog1.FileName = ""; openFileDialog1.ShowDialog(); try { str = openFileDialog1.FileName; if (!string.IsNullOrEmpty(str)) { this.txtImportFilePath.Text = str; ClientConfiguration.HisPath = str; if (strCurrentDB.CompareTo("EXCEL") == 0) { ClientConfiguration.ConnectionString = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + str + ";Extended Properties=Excel 8.0"; } //ClientConfiguration.ConnectionString = ClientConfiguration.ConnectionString.Replace(ClientConfiguration.HisPath, str); ClientConfiguration.Save(); //ClientConfiguration.Reload(); /****************************************************************** * * 修改时间:2007-3-21 * 修改人:ningbo * 修改原因: * 新增代码:EmedFunc.GetLocalPersonCfgPath() + "GpoOrderSend.xml" * ******************************************************************/ //string sql = FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"\GpoOrderSend.xml", "Config/Sqls/Sql").InnerText; //DataTable dt = GpoSendDao.GetInstance().GetErpSend(sql); DataTable dt = GetImportTable(); this.bindingSource1.DataSource = null; this.bindingSource1.DataSource = dt; //"导出采购订单"判断业务流程("进销存"企业对接功能),shangfu 2007-8-24 //如果为1就是进销存对接接口 string clientPlat = UserConfigXml.GetConfigInfo("ClientPlat", "type"); if (clientPlat.Equals("1")) { //dtImp = dt.Clone(); RetOrderItem(out count); } else { setErpSendMapData(out count); } int matchRowsCount = 0; foreach (DataGridViewRow dgvr in dgvErpSend.Rows) { if (dgvr.Cells["type"].Value == "0") { matchRowsCount++; } } if (matchRowsCount > 0) { btnImport.Enabled = true; } else { //btnImport.Enabled = false; } if (count > 0) { lbmess.Text = "有" + count.ToString() + "个产品编码(显示为红色)对应多条数据,请选择一条!"; if (dgvErpSend.RowCount > 0) { lbmess.Visible = true; } else { lbmess.Visible = false; } } } } catch (Exception) { this.bindingSource1.DataSource = null; MessageBox.Show("不是有效的数据文件!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// Syncs this instance. /// </summary> private bool Sync() { bool returnvalue = true; string filePath; //FileControl.CompactAccessDB(ClientConfiguration.TmpDBFile); //删除的记录数 int rows = 0; //上传数据操作--------------------------------------------------------- listView1.Invoke(new treeinvoke(UpdateStart)); if (this.chkUpload.Checked && chkUpload.Enabled) { List <string> InvalidList = null; if (EmedFunc.GetLocalPersonCfgPath().EndsWith("\\")) { filePath = EmedFunc.GetLocalPersonCfgPath() + "db\\TradeAssistant.mdf"; } else { filePath = EmedFunc.GetLocalPersonCfgPath() + "\\db\\TradeAssistant.mdf"; } if (File.Exists(filePath)) { //罗澜涛 仿安徽交易助手程序方法 2007-04-06 bool flag = new ClientUploadBLL().UploadData(false, out InvalidList, out rows); if (!flag) { MessageBox.Show("本地数据上传失败,请重试", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); rows = 0; return(false); } } } curr_rows = rows; listView1.Invoke(new treeinvoke(UpdatelistView2)); //--------------------------------------------------------------------- DateTime Time_Star, Time_End; //获取买方ID //string buyerId = ClientSession.GetInstance().CurrentUser.UserOrg.Reg_org_id; //获取用户ID //string userId = ClientSession.GetInstance().CurrentUser.UserInfo.Id; //获取当前用户对象 LogedInUser CurrentUser = ClientSession.GetInstance().CurrentUser; //建立同步dao对象,在整个同步过程中只建立一次数据库连接 ClientSyncDataDAO syncDao = ClientSyncDataDAO.GetInstance("ClientTempDB"); //if (!this.rbAdd.Checked && csvFlag.Checked) //syncDao.OpenADShell(); for (int i = 1; i < listView1.Items.Count; i++) { //timer_num = 0; curr_row = i; progressNum = 0; Time_Star = DateTime.Now; listView1.Invoke(new treeinvoke(UpdatelistView1)); curr_rows = 0; try { if (Selected == "1" && i != listView1.Items.Count - 1) { if (this.rbAdd.Checked) { //增量同步 curr_rows = syncDao.AllIncrementOneSync(CurrentUser, Pub_tablename, logFlag); } else { //全同步 if (csvFlag.Checked) { //采用CVS方式 curr_rows = syncDao.AllSyncFromCsv(CurrentUser, Pub_tablename); } else { curr_rows = syncDao.AllSyncOneData(CurrentUser, Pub_tablename); } } } if (i == listView1.Items.Count - 1) { syncDao.OpenADShell(); syncDao.CompressDB(ClientConfiguration.TmpDBFile); syncDao.CloseADShell(); } } catch (Exception ex) { returnvalue = false; } Time_End = DateTime.Now; TimeSpan timeSpan = Time_End.Subtract(Time_Star); int seconds = Convert.ToInt16(timeSpan.TotalSeconds); curr_time = new ClientSyncBLL().SecondToTimeStr(seconds); listView1.Invoke(new treeinvoke(UpdatelistView2)); if (curr_rows != -1) { Total_rows = Total_rows + curr_rows; } Total_time = Total_time + seconds; } //if (!this.rbAdd.Checked && csvFlag.Checked) //syncDao.CloseADShell(); //同步完成,关闭数据库连接 syncDao.CloseConntion(); if (Total_rows != 0) { try { //FileControl.CompactAccessDB(ClientConfiguration.TmpDBFile); CopyDB(ClientConfiguration.TmpDBFile, ClientConfiguration.LocalDBFile); } catch (Exception ex) { if (MessageBox.Show("复制压缩库文件异常,请检查磁盘空间,现在是否退出?", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return(false); } } } return(returnvalue); }
private void btnView_Click(object sender, EventArgs e) { string strCurrentDB = FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"\HisProductMapList.xml", "Config/SourceDB"), "DBType"); if (string.IsNullOrEmpty(strCurrentDB)) { ComUtil.MsgBox("没有进行字段匹配,无法导入!"); return; } //选择待导入的文件 string str = ""; if (strCurrentDB.CompareTo("EXCEL") == 0) { openFileDialog1.Filter = "Excel文档(*.xls)|*.xls"; } if (strCurrentDB.CompareTo("ACCESS") == 0) { openFileDialog1.Filter = "MDB文档(*.mdb)|*.mdb"; } openFileDialog1.FilterIndex = 1; openFileDialog1.Title = "打开文件"; openFileDialog1.InitialDirectory = EmedFunc.GetLocalPersonCfgPath(); openFileDialog1.RestoreDirectory = true; openFileDialog1.FileName = ""; openFileDialog1.ShowDialog(); try { str = openFileDialog1.FileName; if (!string.IsNullOrEmpty(str)) { this.txtImportFilePath.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() + @"\HisProductMapList.xml", "Config/Sqls/Sql").InnerText; } if (strCurrentDB.CompareTo("ACCESS") == 0) { string password = SecretUtil.DeSecret(FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/HisProductMapList.xml", "Config/DestDB"), "Password")); ClientConfiguration.ConnectionString = " Provider = Microsoft.Jet.OLEDB.4.0 ;Jet OLEDB:Database Password="******"; Data Source = " + str + ";"; sql = FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"\HisProductMapList.xml", "Config/ASqls/Sql").InnerText; } ClientConfiguration.Save(); DataTable dt = GpoSendDao.GetInstance().GetErpSend(sql); dt.DefaultView.RowFilter = " PRODUCT_CODE is not null"; this.bindingSource1.DataSource = null; this.bindingSource1.DataSource = dt; } } catch (Exception ex) { this.bindingSource1.DataSource = null; ComUtil.MsgBox("不是有效的数据文件!"); } }
/// <summary> /// 订单导出 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExpOrder_Click(object sender, EventArgs e) { int iCount = 0; string sOrderID = string.Empty; //订单ID string sOrgID = base.CurrentUserOrgId; //卖方机构ID if (this.dgvSalerOrderList.CurrentRow == null) { MessageBox.Show("请选择订单!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (this.dgvSalerOrderList.CurrentRow.Cells["order_id"].Value != null) { sOrderID = this.dgvSalerOrderList.CurrentRow.Cells["order_id"].Value.ToString(); } //JudgeCropDataList(sOrderID, sOrgID); //判断是否有未匹配的数据 //"导出采购订单"判断业务流程("进销存"企业对接功能),shangfu 2007-8-24 //如果为1就是进销存对接接口 string clientPlat = UserConfigXml.GetConfigInfo("ClientPlat", "type"); if (IfHasNotMapData(sOrderID, sOrgID) && !clientPlat.Equals("1")) { MessageBox.Show("存在未匹配数据,导出失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { //DataTable mapdt = ProxyFactory.ErpSendRemote.GetOrderExpData(orderid); DataTable mapdt = GpoSendBLL.GetInstance().GetOrderExpData(sOrderID, base.CurrentUserOrgId, clientPlat); DataTable dt = new DataTable(); //"导出采购订单"判断业务流程("进销存"企业对接功能),shangfu 2007-8-29 if ("1".Equals(clientPlat)) { if (mapdt == null || mapdt.Rows.Count == 0) { return; } dt = mapdt.DefaultView.ToTable().Copy(); if (dt.Rows.Count == 0) { MessageBox.Show("导出失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } else { if (mapdt == null || mapdt.Rows.Count == 0) { return; } mapdt.DefaultView.RowFilter = " productid is not null"; dt = mapdt.DefaultView.ToTable().Copy(); mapdt.DefaultView.RowFilter = " productid is null"; } iCount = mapdt.DefaultView.Count; IList result = new ArrayList(); foreach (DataColumn dc in dt.Columns) { string newColName = getMapColName(dc.ColumnName.ToUpper()); if (!string.IsNullOrEmpty(newColName)) { dc.ColumnName = newColName; } else { result.Add(dc.ColumnName); } } for (int i = 0; i < result.Count; i++) { dt.Columns.Remove(result[i].ToString()); } string str = ""; /****************************************************************** * * 修改时间:2007-3-21 * 修改人:ningbo * 修改原因: * 新增代码:EmedFunc.GetLocalPersonCfgPath()+"GpoOrderExport.xml" * ******************************************************************/ string strCurrentDB = FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/GpoOrderExport.xml", "Config/DestDB"), "DBType"); this.saveFileDialog1.FilterIndex = 1; saveFileDialog1.Title = "保存文件为"; saveFileDialog1.InitialDirectory = Application.StartupPath; saveFileDialog1.RestoreDirectory = true; saveFileDialog1.FileName = "ORD" + dgvSalerOrderList.CurrentRow.Cells["ORDER_CODE"].Value.ToString(); if (strCurrentDB.Equals("EXCEL")) { this.saveFileDialog1.Filter = "Excel文档(*.xls)|*.xls"; if (saveFileDialog1.ShowDialog() != DialogResult.Cancel) { str = saveFileDialog1.FileName; bool flg = FileOperation.ExportExcelFile(dt, str); if (flg) { string mess = ""; if (iCount > 0) { mess = "有" + iCount.ToString() + "条数据未被导出"; } MessageBox.Show("导出完毕!" + mess, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } } //导出订单到SQLServer else if (strCurrentDB.Equals("SQLSERVER")) { bool flag = false; try { //获得SQLServer服务数据 string server = FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/GpoOrderExport.xml", "Config/DestDB"), "ServerName"); string database = FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/GpoOrderExport.xml", "Config/DestDB"), "DataBase"); string user = FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/GpoOrderExport.xml", "Config/DestDB"), "User"); string password = SecretUtil.DeSecret(FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/GpoOrderExport.xml", "Config/DestDB"), "Password")); //获得表明 string tableName = FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/GpoOrderExport.xml", "Config/DestDB/DestTable"), "TableName"); //导出操作 flag = GpoSendDao.ExportErpToMSS(tableName, GetConString(server, database, user, password), dt); } catch { flag = false; } if (flag) { string mess = ""; if (iCount > 0) { mess = "有" + iCount.ToString() + "条数据未被导出"; } MessageBox.Show("导出完毕!" + mess, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { MessageBox.Show("导出失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
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() + @"\HisHosptailMapList.xml", "Config/SourceDB"), "DBType"); if (string.IsNullOrEmpty(strCurrentDB)) { 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() + @"\HisHosptailMapList.xml", "Config/Sqls/Sql").InnerText; } if (strCurrentDB.CompareTo("ACCESS") == 0) { string password = SecretUtil.DeSecret(FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"/HisHosptailMapList.xml", "Config/DestDB"), "Password")); ClientConfiguration.ConnectionString = " Provider = Microsoft.Jet.OLEDB.4.0 ;Jet OLEDB:Database Password="******"; Data Source = " + str + ";"; sql = FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"\HisHosptailMapList.xml", "Config/ASqls/Sql").InnerText; } //ClientConfiguration.ConnectionString = ClientConfiguration.ConnectionString.Replace(ClientConfiguration.HisPath, str); ClientConfiguration.Save(); DataTable dt = HosptailIDCompareDAO.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; ComUtil.MsgBox("不是有效的数据文件!"); } }
/// <summary> /// 浏览按钮的操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnBrowse_Click(object sender, EventArgs e) { dtTemp.Columns.Clear(); string strCurrentDB = FileOperation.GetNodeValue(FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"\HisPurchase.xml", "Config/SourceDB"), "DBType"); if (string.IsNullOrEmpty(strCurrentDB)) { ComUtil.MsgBox("没有进行字段匹配,无法导入!"); return; } //选择待导入的文件 string strFileName = string.Empty; if (strCurrentDB.CompareTo("EXCEL") == 0) { openFileDialog1.Filter = "Excel文档(*.xls)|*.xls"; } //openFileDialog1.Filter = "DBF文档(*.dbf)|*.dbf|Excel文档(*.xls)|*.xls"; openFileDialog1.FilterIndex = 1; openFileDialog1.Title = "打开文件"; openFileDialog1.InitialDirectory = System.Windows.Forms.Application.StartupPath; openFileDialog1.RestoreDirectory = true; openFileDialog1.FileName = ""; openFileDialog1.ShowDialog(); try { strFileName = openFileDialog1.FileName; if (!string.IsNullOrEmpty(strFileName)) { this.txtImportFilePath.Text = strFileName; ClientConfiguration.HisPath = strFileName; if (strCurrentDB.CompareTo("EXCEL") == 0) { ClientConfiguration.ConnectionString = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + strFileName + ";Extended Properties=Excel 8.0"; } ClientConfiguration.Save(); string sql = FileOperation.GetNodeObject(EmedFunc.GetLocalPersonCfgPath() + @"\HisPurchase.xml", "Config/Sqls/Sql").InnerText; dtRequestSend = RequestSendDal.GetInstance().GetRequestSend(sql); dtRequestSend.Columns.Add("type"); //采购单明细id dtRequestSend.Columns.Add("state"); dtRequestSend.Columns.Add("emedProductId"); dtRequestSend.Columns.Add("emedSpecId"); dtRequestSend.Columns.Add("emedModelId"); dtRequestSend.Columns.Add("emedSenderId"); dtRequestSend.Columns.Add("emedSenderName"); dtRequestSend.Columns.Add("emedSenderEasy"); dtRequestSend.Columns.Add("selfpackage"); dtRequestSend.Columns.Add("factoryeasy"); dtRequestSend.Columns["Price"].DataType = Type.GetType("System.Double"); this.bindingSource1.DataSource = null; this.bindingSource1.DataSource = dtRequestSend; //获取耗材和医院匹配数据 SetErpSendMapData(); this.button1.Enabled = true; this.btnImport.Enabled = true; } } catch (Exception m) { this.bindingSource1.DataSource = null; ComUtil.MsgBox("不是有效的数据文件!"); } }