private void Update() { 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.Remark = Remark.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.ScriptType = ScriptType.SelectedIndex; dRule.ColSperator = GetColSperator(); dRule.ColnameLines = int.Parse(ColName_Lines.Text.Trim()); dRule.DesTable = (Des_Table.SelectedItem as TableInfo).TableName; dRule.DesFile = txtTemplageFile.Text; dRule.CreationDate = DateTime.Now; dRule.LastUpdateDate = DateTime.Now; dRule.LastUpdateIp = "127.0.0.1"; dRule.Version = 1; dRule.Remark = Remark.Text.Trim(); DataScriptDAL.update(dScript); DataScriptRuleDAL.update(dRule); }
private void showData() { dScript = DataScriptDAL.getInfo(FID); dRule = DataScriptRuleDAL.getInfo(FID); ProjectCode.SelectedValue = dScript.ProjectCode; TaskName.Text = dScript.TaskName; txtTableName.Text = dScript.TableName; MidsScriptCode.Text = dScript.MidsScriptCode; MidsScriptName.Text = dScript.MidsScriptName; MidsScriptVesion.Text = dScript.MidsScriptVesion; FileType.SelectedValue = dScript.FileType; IndexKey.Text = dScript.IndexKey; ValidFlag.Text = dScript.ValidFlag; Remark.Text = dScript.Remark; ApplyTestProject.SelectedValue = dScript.ApplyTestProject; ScriptType.SelectedIndex = dScript.ScriptType; SetColSperator(dRule.ColSperator); ColName_Lines.Text = dRule.ColnameLines.ToString(); if (tables.SingleOrDefault(it => it.TableName == dRule.DesTable) == null) { tables.Add(new TableInfo() { TableDesc = dRule.DesTable, TableName = dRule.DesTable }); } ProjectCode.SelectedValue = dScript.ProjectCode; txtTemplageFile.Text = dRule.DesFile; }
private void InvalidText_MouseLeftButtonUp(object sender, MouseButtonEventArgs e) { TextBlock img = (TextBlock)sender; DataScript info = img.Tag as DataScript; DataScriptDAL.updateInvalid(info.FID, info.Invalid == 0 ? 1 : 0); dataSource = DataScriptDAL.getList(); bindData(); }
private string scriptCode2Fid(string code) { string result = ""; var item = DataScriptDAL.getList().LastOrDefault(it => it.MidsScriptCode == code); if (item != null) { result = item.FID; } return(result); }
private void FillDataScriptStatus(DropDownList ddl) { try { ddl.DataSource = DataScriptDAL.GetDataScriptStatus(); ddl.DataBind(); } catch (Exception exc) { ErrorMessage = exc.Message; } }
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 delButton_Click(object sender, RoutedEventArgs e) { string error = ""; foreach (DataScript item in dataGrid.SelectedItems) { if (item.CreatedBy != MainWindow.UserID) { error += string.Format("解析器[{0}],是别人创建的,无法删除\r\n", item.DisplayName); continue; } if (item.Release == "02") { error += string.Format("解析器[{0}],已发布,无法删除\r\n", item.DisplayName); continue; } List <string> allMaps = DataScriptDAL.getMapColName(item.TableName); var currMaps = DataScriptMapDAL.getList(item.FID); var struceures = TableDAL.getTableStructure(item.TableName); foreach (var cm in currMaps) { if (allMaps.Count(it => it == cm.TableColName) > 1) { // 多个并用 continue; } var s = struceures.FirstOrDefault(it => it.ColumnName == cm.TableColName); if (s != null && s.IsKey) { // 主键不能删 continue; } TableDAL.dropColumn(item.TableName, cm.TableColName); } DataScriptDAL.Delete(item.FID); DataScriptRuleDAL.Delete(item.FID); DataScriptMapDAL.delAll(item.FID); } if (!string.IsNullOrEmpty(error)) { MessageBox.Show(error); } dataGrid.DataContext = DataScriptDAL.getList(); }
void DataScriptList_Loaded(object sender, RoutedEventArgs e) { if (!System.ComponentModel.DesignerProperties.GetIsInDesignMode(this)) { dataSource = DataScriptDAL.getList(); dataGrid.DataContext = dataSource; FileType.SelectedIndex = 0; FileType.SelectionChanged += FileType_SelectionChanged; MidsScriptCode.TextChanged += MidsScriptCode_TextChanged; MidsScriptName.TextChanged += MidsScriptName_TextChanged; IndexKey.TextChanged += IndexKey_TextChanged; } }
private void TextBlock_MouseLeftButtonUp(object sender, MouseButtonEventArgs e) { TextBlock block = sender as TextBlock; string fid = block.Tag.ToString(); if (block.Text == "未发布") { DataScriptDAL.Release(fid); block.Text = "已发布"; MessageBox.Show("新建解析器发布后,请及时进行同步数据操作!"); } else { MessageBox.Show("解析器已发布,无法重复发布"); } }
void DataScriptInfo_Loaded(object sender, RoutedEventArgs e) { string[] tablelist = System.Configuration.ConfigurationManager.AppSettings["tables"].Split(new char[] { ',' }); string[] descs = System.Configuration.ConfigurationManager.AppSettings["tabledescs"].Split(new char[] { ',' }); // 所有Script的列表,用于计算版本号 scripts = DataScriptDAL.getList(); var objTableList = ObjtableInfoDAL.getList(); foreach (var objTable in objTableList) { tables.Add(new TableInfo() { TableDesc = string.Format("{0}({1})", objTable.ObjectTableName, objTable.ObjectTableCode), TableName = objTable.ObjectTableCode }); } projectList = WebHelper.listProject(MainWindow.UserName); ProjectCode.ItemsSource = projectList; ProjectCode.DisplayMemberPath = "ProjectName"; ProjectCode.SelectedValuePath = "ProjectCode"; ProjectCode.KeyUp += ProjectCode_KeyUp; if (projectList.Count > 0) { ProjectCode.SelectedIndex = 0; } ScriptType.SelectedIndex = 0; if (string.IsNullOrEmpty(FID)) { // new row MidsScriptCode.Text = ""; getScriptCode(); } else { nextButton.IsEnabled = false; nextButton.Visibility = System.Windows.Visibility.Collapsed; // edit row showData(); } }
protected void btnCreate_Click(object sender, EventArgs e) { try { DataScriptDAL.InsertDataScript( Convert.ToInt32(ddlDimensionNumber.SelectedItem.Value), txtScriptName.Text, txtModuleName.Text, txtDescription.Text, txtParameters.Text, Convert.ToInt32(1111111), Convert.ToInt32(2222222), cbIsBackEnd.Checked ); } catch (Exception exc) { ErrorMessage = exc.Message; } FetchDataScripts(); }
private void insert() { dScript = new DataScript(); dScript.FID = Guid.NewGuid().ToString().Replace("-", ""); FID = dScript.FID; 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; dRule = new DataScriptRule(); dRule.FID = dScript.FID; // Guid.NewGuid().ToString().Replace("-", ""); dRule.MdsImpDataScriptID = dScript.FID; dRule.ColSperator = GetColSperator(); dRule.ColnameLines = int.Parse(ColName_Lines.Text.Trim()); dRule.DesTable = (Des_Table.SelectedItem as TableInfo).TableName; 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; DataScriptDAL.Insert(dScript); DataScriptRuleDAL.Insert(dRule); }
public Class1(string userID, string userName, string projectCode, string taskCode, string scriptCode, int times, string sourceFile) { this.userID = userID; var taskInfoList = WebHelper.listTdmTasks(userName); this.taskInfo = taskInfoList.FirstOrDefault(it => it.taskCode == taskCode); // "b1190f6a66a94b6eb110b3ffc0739887"; string fid = scriptCode2Fid(scriptCode); this.dataScript = DataScriptDAL.getInfo(fid); this.dataScriptRule = DataScriptRuleDAL.getInfo(fid); this.times = times; this.sourceFile = sourceFile; this.columnMap = getColumnMap(); this.calColumnMap(); if (this.dataScriptRule != null) { this.structList = TableDAL.getTableStructure(this.dataScriptRule.DesTable); } }
private void getScriptCode() { if (TaskNameList.SelectedIndex == 0) { MidsScriptName.Text = ""; var list = DataScriptDAL.getList(); var projectCode = ProjectCode.SelectedValue.ToString(); for (int i = 0; i < 100; i++) { string scriptcode = string.Format("{0}{1}{2}", projectCode, DateTime.Now.Year, i.ToString("000")); if (list.FirstOrDefault(it => it.MidsScriptCode == scriptcode) == null) { MidsScriptCode.Text = scriptcode; break; } } getScriptName(); } }
void ImportFileSelecte_Loaded(object sender, RoutedEventArgs e) { if (ScriptName.Items == null || ScriptName.Items.Count == 0) { var dsList = DataScriptDAL.getList(); ScriptName.Items.Clear(); foreach (var item in dsList) { ScriptName.Items.Add(item); } ScriptName.SelectedIndex = 0; if (!String.IsNullOrEmpty(TaskCenter.ScriptID)) { var script = dsList.FirstOrDefault(it => it.FID == TaskCenter.ScriptID); if (script != null) { ScriptName.SelectedIndex = dsList.IndexOf(script); switch (script.FileType) { case "txt": FileType.SelectedIndex = 0; break; case "dat": FileType.SelectedIndex = 2; break; default: FileType.SelectedIndex = 1; break; } } } } }
private void updateScript() { DataScriptDAL.update(dScript); DataScriptRuleDAL.update(dRule); }
public bool init() { var taskInfoList = TaskinfoDAL.getList(userName); if (taskInfoList == null || taskInfoList.Count == 0) { SendMessageEvent(false, string.Format("用户[{0}],无任务数据", userName)); CompleteEvent(this, new CompleteArgs() { Message = "数据导入失败" }); return(false); } this.taskInfo = taskInfoList.FirstOrDefault(it => it.taskCode == taskCode); if (taskInfo == null) { SendMessageEvent(false, string.Format("任务[{0}],不存在", taskCode)); CompleteEvent(this, new CompleteArgs() { Message = "数据导入失败" }); return(false); } var dataSource = WebHelper.listTdmTaskTimesInfo(taskInfo.id); if (dataSource.Count(it => it.TestTime == this.times.ToString()) < 1) { SendMessageEvent(false, string.Format("任务 [ {0} ] ,试验次数 [ {1} ] 不存在,", taskCode, this.times)); CompleteEvent(this, new CompleteArgs() { Message = "数据导入失败" }); return(false); } string fid = scriptCode2Fid(scriptCode); if (string.IsNullOrEmpty(fid)) { SendMessageEvent(false, string.Format("任务[{0}],不存在", taskCode)); CompleteEvent(this, new CompleteArgs() { Message = "数据导入失败" }); return(false); } this.dataScript = DataScriptDAL.getInfo(fid); if (dataScript == null) { SendMessageEvent(false, string.Format("任务[{0}],不存在", taskCode)); CompleteEvent(this, new CompleteArgs() { Message = "数据导入失败" }); return(false); } this.dataScriptRule = DataScriptRuleDAL.getInfo(fid); if (dataScriptRule == null) { SendMessageEvent(false, string.Format("任务规则[{0}],不存在", fid)); CompleteEvent(this, new CompleteArgs() { Message = "数据导入失败" }); return(false); } this.columnMap = getColumnMap(); if (this.dataScriptRule != null) { this.structList = TableDAL.getTableStructure(this.dataScriptRule.DesTable); } return(true); }
private void insert() { DataScriptDAL.Insert(dScript); DataScriptRuleDAL.Insert(dRule); }
private bool checkCode() { return(DataScriptDAL.CheckCode(MidsScriptCode.Text.Trim()) == 0); }
private void FetchDataScripts() { GridView1.DataSource = DataScriptDAL.FetchDataScripts(); GridView1.DataBind(); }