/// <summary> /// XLS导入 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnImportEqu_Click(object sender, RoutedEventArgs e) { SecurityClass[] securityclasses = CO_IA.Client.Utility.GetSecurityClasses(); if (securityclasses == null || securityclasses.Length == 0) { MessageBox.Show("请先在基础数据设置中增加保障类别"); } else { OpenFileDialog dialog = new OpenFileDialog(); dialog.Filter = "Excel文件(*.xls)|*.xls"; //dialog.Filter = "(*.xlsx)|*.xlsx|(*.xls)|*.xls"; //dialog.DefaultExt = "xlsx"; dialog.CheckFileExists = true; if (dialog.ShowDialog() == true) { DataTable[] tables = ExcelImportHelper.LoadDataFromExcel(dialog.FileName); if (tables != null && tables.Length > 0) { //单位信息 Organization orginfo = null; DataTable orgtable = tables.FirstOrDefault(r => r.TableName == "单位信息"); if (orgtable != null && ExcelImportHelper.ValidateORG(orgtable)) { orginfo = this.LoadORGFromTable(orgtable); } if (orginfo != null) { #region 验证单位名称 OrgQueryCondition condition = new OrgQueryCondition(); condition.Name = orginfo.Name; Organization[] orgs = this.GetORGSource(condition); Organization sameorg = orgs.FirstOrDefault(r => r.Name == orginfo.Name); #endregion if (sameorg != null) { MessageBoxResult result = MessageBox.Show(string.Format("'{0}'已经存在,是否将Excel中的设备导入到'{0}'中?", orginfo.Name), "提示", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { ImportEquipment(tables, sameorg); } else { MessageBox.Show("请修改单位名称"); } } else { ImportEquipment(tables, orginfo); } } } } } }
public static void Import(Action <ActivityOrganization, List <ActivityEquipment> > p_importEquips) { ImportEquipmentDelegate = p_importEquips; OpenFileDialog dialog = new OpenFileDialog(); dialog.Filter = "Excel文件(*.xls)|*.xls"; dialog.DefaultExt = "xls"; dialog.CheckFileExists = true; if (dialog.ShowDialog() == true) { DataTable[] tables = ExcelImportHelper.LoadDataFromExcel(dialog.FileName); if (tables != null && tables.Length > 0) { //单位信息 ActivityOrganization activityorg = null; DataTable orgtable = tables.FirstOrDefault(r => r.TableName == "单位信息"); if (orgtable != null && ExcelImportHelper.ValidateORG(orgtable)) { activityorg = LoadActivityORGFromTable(orgtable, SystemLoginService.CurrentActivity.Guid); } if (activityorg != null) { #region 验证单位名称 OrgQueryCondition condition = new OrgQueryCondition(); condition.ActivityGuid = SystemLoginService.CurrentActivity.Guid; condition.Name = activityorg.Name; ActivityOrganization[] orgs = DataOperator.GetActivityOrgSources(condition); ActivityOrganization sameorg = orgs.FirstOrDefault(r => r.Name == activityorg.Name); #endregion if (sameorg != null) { MessageBoxResult result = MessageBox.Show(string.Format("单位'{0}'已经存在,是否将Excel中的设备导入到现有的单位中?", activityorg.Name), "提示", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { ImportActivityEquipment(tables, sameorg); } else { MessageBox.Show("请修改单位名称"); } } else { ImportActivityEquipment(tables, activityorg); } } } } }