void resolver(string title, string scriptId) { bool retest = System.Configuration.ConfigurationManager.AppSettings["retest"] == "true"; if (title == "已执行" && !retest) { MessageBox.Show("解析器已执行,无法重复执行!"); return; } string taskid = currentInfo.id; DataImport.DataAccess.Entitys.TaskInfo.resolver ar = currentInfo.resolvers.FirstOrDefault(it => it.resolverId == scriptId); if (ar != null) { TaskCenter.TaskID = currentInfo.id; TaskCenter.CurrentInfo = currentInfo; TaskCenter.ScriptCode = ar.resolverCode; TaskCenter.ScriptID = ar.resolverId; MainWindow window = App.Current.MainWindow as MainWindow; UIElement item = new ImportFileSelecte(); ImportStack.clear(); ImportStack.Push(this); window.StartPage(item); } }
private void nextButton_Click(object sender, RoutedEventArgs e) { string erromsg = ""; if (string.IsNullOrEmpty(MidsScriptCode.Text.Trim())) { erromsg += "请输入解析器编码!\r\n"; } else { if (string.IsNullOrEmpty(FID) && (!checkCode())) { erromsg += "解析器编码重复!\r\n"; } } if (string.IsNullOrEmpty(MidsScriptName.Text.Trim())) { erromsg += "请输入解析器名称!\r\n"; } if (string.IsNullOrEmpty(txtTemplageFile.Text.Trim())) { erromsg += "请选择样例文件!\r\n"; } if (Des_Table.SelectedIndex == -1) { erromsg += "请选择目标数据表!\r\n"; } if (!string.IsNullOrEmpty(erromsg)) { MessageBox.Show(erromsg); return; } if (string.IsNullOrEmpty(FID)) { insert(); } else { Update(); } DataScriptMapModify mapModify = new DataScriptMapModify(); mapModify.FID = FID; mapModify.DataScriptRule = dRule; mapModify.DataScript = dScript; MainWindow window = App.Current.MainWindow as MainWindow; ImportStack.Push(this); window.StartPage(mapModify); }
private void btNext_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(txtTemplageFile.Text.Trim())) { MessageBox.Show("请选择导入文件"); return; } if (f**k.IsChecked.Value && false) { List <string> difference = new List <string>(); foreach (DataColumn column in sourceDt.Columns) { if (structures.FirstOrDefault(it => it.Comments == column.ColumnName) == null) { difference.Add(column.ColumnName); } } if (difference.Count > structures.Count(it => string.IsNullOrEmpty(it.Comments))) { MessageBox.Show("剩余空闲字段不足,无法导入全部字段,请重新选择数据文件!"); return; } Comments(); if (update.IsChecked.Value) { float newVersion = float.Parse(dataScript.MidsScriptVesion) + 0.1f; DataScriptDAL.updateLevel(dataScript.FID, newVersion.ToString()); } } dataScript = (DataScript)ScriptName.SelectedItem; ImportMapModify mapModify = new ImportMapModify(); mapModify.FID = dataScript.FID; mapModify.DataScriptRule = dataRule; mapModify.DataScript = dataScript; mapModify.sourceFile = txtTemplageFile.Text; importGrid.getHexColumn(); ImportStack.Push(this); MainWindow window = App.Current.MainWindow as MainWindow; window.StartPage(mapModify); }
private void Direct_MouseLeftButtonUp(object sender, MouseButtonEventArgs e) { Image img = (Image)sender; TaskCenter.TaskID = img.Tag.ToString(); var project = dataSource.SingleOrDefault(it => it.FID == TaskCenter.TaskID); if (project != null) { TaskCenter.ScriptID = project.ScriptID; } MainWindow window = App.Current.MainWindow as MainWindow; UIElement item = new DataImportInteractive.DataScriptInfo(); ImportStack.clear(); ImportStack.Push(this); window.StartPage(item); }
private void scriptrun_Click(object sender, RoutedEventArgs e) { var taskinfos = taskGrid.getTaskInfos(); // dataGrid.SelectedItems; Dictionary <string, string> files = new Dictionary <string, string>(); if (taskinfos.Count == 0) { MessageBox.Show("您未选择任何工序!"); return; } foreach (TaskInfo info in taskinfos) { string scriptPath = string.Format(@"{0}\{1}\Sequence.xml", AppDomain.CurrentDomain.BaseDirectory + @"scripts", info.id); if (downLoadScriptFile(info)) { files.Add(info.taskName, scriptPath); } } if (files.Count == taskinfos.Count) { MainWindow window = App.Current.MainWindow as MainWindow; UIElement item = new SequencesView(files); ImportStack.clear(); ImportStack.Push(this); window.StartPage(item); } else { MessageBox.Show("您选择的工序没有配置脚本文件!"); } }
private void nextButton_Click(object sender, RoutedEventArgs e) { string erromsg = ""; if (string.IsNullOrEmpty(txtTemplageFile.Text.Trim())) { erromsg += "请选择样例文件!\r\n"; } if (Des_Table.SelectedIndex == -1) { erromsg += "请选择目标数据表!\r\n"; } if (Des_Table.SelectedIndex == 0 && string.IsNullOrEmpty(txtTableName.Text)) { erromsg += "请输入数据表名称!\r\n"; } if (Des_Table.SelectedIndex == 0 && string.IsNullOrEmpty(txtTableCode.Text)) { erromsg += "请输入数据表代码!\r\n"; } if (cbSave.IsChecked.Value) { if (string.IsNullOrEmpty(MidsScriptCode.Text.Trim())) { erromsg += "请输入解析器编码!\r\n"; } else { if (!checkCode()) { erromsg += "解析器编码重复!\r\n"; } } if (string.IsNullOrEmpty(MidsScriptName.Text.Trim())) { erromsg += "请输入解析器名称!\r\n"; } } if (!string.IsNullOrEmpty(erromsg)) { MessageBox.Show(erromsg); return; } builderScript(); if (cbSave.IsChecked.Value) { insert(); } DataTable dt = new DataTable(); if (FileType.SelectedValue.ToString() == "xls/xlsx") { dt = ExcelImportHelper.GetDataTable(txtTemplageFile.Text.Trim()); } else { dt = TextImportHelper.GetDataTable(txtTemplageFile.Text.Trim(), DataScriptRule.getColSeperatorChar(GetColSperator())); } TableDAL.CreateTable(txtTableCode.Text.ToUpper(), dt); int count = ObjtableInfoDAL.Count(txtTableCode.Text.ToUpper()); if (count == 0) { ObjtableInfo oinfo = new ObjtableInfo(); oinfo.FID = Guid.NewGuid().ToString().Replace("-", ""); oinfo.CreatedBy = MainWindow.UserID; oinfo.LastUpdatedBy = MainWindow.UserID; oinfo.ObjectTableCode = txtTableCode.Text.ToUpper(); oinfo.ObjectTableName = txtTableName.Text; oinfo.Status = "02"; oinfo.Version = 1; oinfo.LastUpdateIp = "127.0.0.1"; oinfo.LastUpdateDate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); oinfo.CreationDate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); ObjtableInfoDAL.Insert(oinfo); } ImportMapModify mapModify = new ImportMapModify(); mapModify.FID = FID; mapModify.DataScriptRule = dRule; mapModify.DataScript = dScript; mapModify.sourceFile = txtTemplageFile.Text.Trim(); mapModify.isAutoDrawLine = true; ImportStack.Push(this); MainWindow window = App.Current.MainWindow as MainWindow; window.StartPage(mapModify); }
private void nextButton_Click(object sender, RoutedEventArgs e) { string erromsg = ""; if (string.IsNullOrEmpty(MidsScriptCode.Text.Trim())) { erromsg += "请输入解析器编码!\r\n"; } if (string.IsNullOrEmpty(TaskName.Text.Trim())) { erromsg += "请输入试验名称!\r\n"; } if (string.IsNullOrEmpty(MidsScriptName.Text.Trim())) { erromsg += "请输入解析器名称!\r\n"; } if (string.IsNullOrEmpty(txtTemplageFile.Text.Trim())) { erromsg += "请选择样例文件!\r\n"; } else if (FileType.SelectedValue.ToString() != "xls/xlsx" && FileType.SelectedValue.ToString() != "mdb" && FileType.SelectedValue.ToString() != "db") { string[] columns = TextImportHelper.GetColumns(txtTemplageFile.Text, DataScriptRule.getColSeperatorChar(GetColSperator())); if (columns.Length < 2) { erromsg += "数据文件列分隔符不存在,请选择相应列分隔符!\r\n"; } } dScript = new DataScript(); dScript.MidsScriptCode = MidsScriptCode.Text.Trim(); dScript.MidsScriptName = MidsScriptName.Text.Trim(); dScript.MidsScriptVesion = MidsScriptVesion.Text.Trim(); dScript.FileType = FileType.SelectedValue.ToString(); dScript.IndexKey = IndexKey.Text.Trim(); dScript.ValidFlag = ValidFlag.Text.Trim(); dScript.ApplyTestProject = ApplyTestProject.SelectedValue.ToString(); dScript.CreationDate = DateTime.Now; dScript.LastUpdateDate = DateTime.Now; dScript.LastUpdateIp = "127.0.0.1"; dScript.Version = 1; dScript.LastUpdatedBy = MainWindow.UserID; dScript.CreatedBy = MainWindow.UserID; dScript.ScriptType = ScriptType.SelectedIndex; dScript.TableName = txtTableName.Text; dScript.ProjectCode = ProjectCode.SelectedValue.ToString(); dScript.TaskName = TaskName.Text.Trim(); // 这是sqlitedb格式,需要计算tablenameex if (FileType.SelectedValue.ToString() == "db") { int count = SQLiteImportHelper.GetTableNames(txtTemplageFile.Text).Count(); string tablenames = ""; for (int i = 1; i <= count; i++) { tablenames += string.Format("{0}_{1},", txtTableName.Text, i); } dScript.TableNameExt = tablenames.TrimEnd(','); } dRule = new DataScriptRule(); dRule.ColSperator = GetColSperator(); dRule.ColnameLines = int.Parse(ColName_Lines.Text.Trim()); dRule.DesTable = txtTableName.Text; dRule.DesFile = txtTemplageFile.Text; dRule.CreationDate = DateTime.Now; dRule.LastUpdateDate = DateTime.Now; dRule.LastUpdateIp = "127.0.0.1"; dRule.Version = 1; dRule.DesBusinessPk = ""; dRule.CreatedBy = MainWindow.UserID; dRule.LastUpdatedBy = MainWindow.UserID; // 我发现,现在就没有更新逻辑 //if (string.IsNullOrEmpty(FID)) //{ // var oldScript = scripts.FirstOrDefault(it => it.ScriptType == dScript.ScriptType && it.ProjectCode == dScript.ProjectCode && it.TaskName == dScript.TaskName); // if (oldScript != null) // { // FID = oldScript.FID; // dScript.FID = FID; // } //} if (!string.IsNullOrEmpty(erromsg)) { MessageBox.Show(erromsg); return; } var oldScript = scripts.FirstOrDefault(it => it.ScriptType == dScript.ScriptType && it.ProjectCode == dScript.ProjectCode && it.TaskName == dScript.TaskName); if (oldScript != null) { dScript.FID = Guid.NewGuid().ToString().Replace("-", ""); FID = dScript.FID; dRule.FID = dScript.FID; dRule.MdsImpDataScriptID = dScript.FID; insertScript(); // 正常表 updateTableStructure(); if (FileType.SelectedValue.ToString() == "db") { // sqlite 多表 foreach (string tname in dScript.TableNameExt.Split(',')) { updateTableStructure(tname); } } } else { dScript.FID = Guid.NewGuid().ToString().Replace("-", ""); FID = dScript.FID; dRule.FID = dScript.FID; dRule.MdsImpDataScriptID = dScript.FID; insertScript(); // 正常表 insertTableStructure(); if (FileType.SelectedValue.ToString() == "db") { // sqlite 多表,再把多表搞一下。 foreach (string tname in dScript.TableNameExt.Split(',')) { insertTableStructure(tname); } } } DataScriptMapModify mapModify = new DataScriptMapModify(); mapModify.FID = FID; mapModify.DataScriptRule = dRule; mapModify.DataScript = dScript; MainWindow window = App.Current.MainWindow as MainWindow; ImportStack.Push(this); window.StartPage(mapModify); }
private void btnNext_Click(object sender, RoutedEventArgs e) { ImportRun mapModify = new ImportRun(); mapModify.DataScript = this.DataScript; mapModify.DataScriptRule = this.DataScriptRule; mapModify.ColumnMap = columnConnection.ColumnMap; mapModify.ScriptMap = columnConnection.ScriptMap; mapModify.sourceFile = sourceFile; mapModify.DataScriptRule.DesBusinessPk = columnConnection.BusinessPK; if (!mapModify.ColumnMap.ContainsKey("COLUMN0")) { MessageBox.Show("您需要指定时间列的关联关系,才可以导入数据!"); return; } foreach (string key in mapModify.ScriptMap.Keys) { string script = mapModify.ScriptMap[key].Trim(); if (!string.IsNullOrEmpty(script)) { DataScriptMapDAL.SaveScriptFile(key, script); } } // 保存对应关系 if (DataScriptInfo.saveScript || true) { DataScriptMapDAL.delAll(FID); DataScriptRuleDAL.updateBusinessPK(FID, columnConnection.BusinessPK); foreach (var key in columnConnection.ColumnMap.Keys) { DataScriptMap map = new DataScriptMap(); map.FID = Guid.NewGuid().ToString().Replace("-", ""); map.MdsImpDataScriptRuleID = FID; map.TableColName = key; map.FileColName = columnConnection.ColumnMap[key]; map.TransferType = "02"; map.CreatedBy = MainWindow.UserID; map.LastUpdatedBy = MainWindow.UserID; map.LastUpdateIp = "127.0.0.1"; // 如果有算式,保存 if (columnConnection.ScriptMap.ContainsKey(key)) { map.TransferScript = columnConnection.ScriptMap[key]; } DataScriptMapDAL.Insert(map); } //MessageBox.Show("对应关系已经保存!"); } ImportStack.Push(this); MainWindow window = App.Current.MainWindow as MainWindow; window.StartPage(mapModify); }