private void InitSourceDBInfo(string inDBType) { try { switch (inDBType) { case "SQLSERVER": this.cmbDBType.SelectedIndex = 0; this.txtServer.Text = Config.Intance().EleSource.GetAttribute("ServerName"); this.txtDataBase.Text = Config.Intance().EleSource.GetAttribute("DataBase"); this.txtUser.Text = Config.Intance().EleSource.GetAttribute("User"); this.txtPassword.Text = SecretUtil.DeSecret(Config.Intance().EleSource.GetAttribute("Password")); return; case "ACCESS": this.cmbDBType.SelectedIndex = 1; this.txtDataBase.Text = "template.mdb"; this.txtPassword.Text = SecretUtil.DeSecret(Config.Intance().EleSource.GetAttribute("Password")); return; case "FOXPRO": this.cmbDBType.SelectedIndex = 2; this.txtDataBase.Text = Application.StartupPath; return; case "ORACLE": this.cmbDBType.SelectedIndex = 3; this.txtServer.Text = Config.Intance().EleSource.GetAttribute("ServerName"); this.txtUser.Text = Config.Intance().EleSource.GetAttribute("User"); this.txtPassword.Text = SecretUtil.DeSecret(Config.Intance().EleSource.GetAttribute("Password")); break; case "TXT": this.cmbDBType.SelectedIndex = 5; this.txtDataBase.Text = Application.StartupPath; break; case "EXCEL": this.cmbDBType.SelectedIndex = 4; this.txtDataBase.Text = Config.Intance().CurrentExcelTemplet; break; } } catch (Exception exception1) { ErrorLog.SaveLog("给源数据配置赋值", exception1); } }
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("不是有效的数据文件!"); } }
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 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); } } } }