private DataLog createLog(int count, string impFileName) { DataLog dataLog = new DataLog(); dataLog.FID = Guid.NewGuid().ToString().Replace("-", ""); dataLog.ImpDateTime = DateTime.Now; dataLog.FullFloderName = string.Format("{0}{1}", dataLog.FID, System.IO.Path.GetExtension(sourceFile)); dataLog.CreationDate = DateTime.Now; dataLog.LastUpdateDate = DateTime.Now; dataLog.ImpRowsCount = count; dataLog.TestProjectID = this.taskInfo.id;// ProjectList.FID; dataLog.ImpFileName = impFileName; dataLog.ObjectTable = this.dataScriptRule.DesTable; // 被怀疑是sqlite导入 if (this.dataScript.TableNameExt != null && this.dataScript.TableNameExt.Trim().Length > 0) { dataLog.ObjectTable = this.dataScript.TableNameExt; } dataLog.LastUpdatedBy = this.userID; dataLog.CreatedBy = this.userID; dataLog.LastUpdateIp = "127.0.0.1"; dataLog.TypeName = this.dataScript.FID; dataLog.Version = this.times; DataLogDAL.Insert(dataLog); return(dataLog); }
/// <summary> /// 当试验次数重复时候,是更新逻辑这里为true,那么注意一下表名,用临时表名 /// </summary> /// <returns></returns> private bool checkTestTimes() { // 判断本次试验,有没有解析器执行过 if (DataLogDAL.getList(this.taskInfo.id).Count(it => Convert.ToInt32(it.Version) == this.times) > 0) { return(true); } return(false); }
/// <summary> /// 当试验次数重复时候,是更新逻辑这里为true,那么注意一下表名,用临时表名 /// </summary> /// <returns></returns> private bool checkTestTimes() { int count = TableDAL.removeDataRow(this.dataScriptRule.DesTable, this.taskInfo.id, this.times); return(false); // 判断本次试验,有没有解析器执行过 if (DataLogDAL.getList(this.taskInfo.id).Count(it => Convert.ToInt32(it.Version) == this.times) > 0) { return(false); } return(false); }
/// <summary> /// 当试验次数重复时候,是更新逻辑这里为true,那么注意一下表名,用临时表名 /// </summary> /// <returns></returns> private bool checkTestTimes() { int count = TableDAL.removeDataRow(this.dataScriptRule.DesTable, this.taskInfo.id, this.times); SendMessageEvent(string.Format("{0},{1},{2},{3}", count, this.dataScriptRule.DesTable, this.taskInfo.id, this.times)); return(false); // 判断本次试验,有没有解析器执行过 if (DataLogDAL.getList(this.taskInfo.id).Count(it => Convert.ToInt32(it.Version) == this.times) > 0) { return(false); } return(false); }
void popWindow_runEvent(object sender, EventArgs e) { TaskInfo info = currentInfo; if (string.IsNullOrEmpty(info.interfaceState)) { MessageBox.Show("任务尚未接收,无法上报!"); return; } if (info.interfaceState == "3") { MessageBox.Show("任务已上报,无法重复上报!"); return; } List <string> scriptCodes = DataLogDAL.getScriptCodes(info.id); string result = WebHelper.verificationReportState(info.id); if (result.IndexOf("Y") > -1) { WebHelper.modifyActualDate(info.id, popWindow.begin.Text, popWindow.end.Text, popWindow.actualWorkHours.Text); //if (WebHelper.updateTdmTaskState(info.id, "3")) if (WebHelper.taskReportByClient(info.id)) { element.Text = "已上报"; info.interfaceState = "3"; //dataSource = WebHelper.listTdmTasks(MainWindow.UserName); //dataGrid.DataContext = dataSource; //taskGrid.TaskInfoList = dataSource; //query_Click(null, null); } else { MessageBox.Show("接收任务失败!"); } } else { MessageBox.Show(result); } }
void DataScriptInfo_Loaded(object sender, RoutedEventArgs e) { // 获取这个项目唯一使用目标表 string singleTable = DataLogDAL.getSingleTableName(TaskCenter.TaskID); if (tables.Count == 0) { tables.Add(new TableInfo() { TableDesc = "新建表", TableName = "new" }); 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 }); } Des_Table.ItemsSource = tables; Des_Table.DisplayMemberPath = "TableDesc"; TableInfo singleTinfo = tables.FirstOrDefault(it => it.TableName == singleTable); if (singleTinfo != null) { Des_Table.SelectedItem = singleTinfo; Des_Table.IsEnabled = false; } else { Des_Table.SelectedIndex = 0; } ApplyTestProject.SelectedIndex = 0; } }
/// <summary> /// 当试验次数重复时候,是更新逻辑这里为true,那么注意一下表名,用临时表名 /// </summary> /// <returns></returns> private bool checkTestTimes() { // 判断本次试验,有没有解析器执行过 if (DataLogDAL.getList(this.taskInfo.id).Count(it => Convert.ToInt32(it.Version) == this.times) > 0) { Structure st = structList.FirstOrDefault(it => it.Comments == System.Configuration.ConfigurationManager.AppSettings["pk"]); if (st != null) { this.dataScriptRule.DesBusinessPk = st.ColumnName; tableName += "_" + DateTime.Now.Millisecond.ToString(); if (tableName.Length > 30) { tableName = tableName.Remove(0, tableName.Length - 29); } TableDAL.createtempTable(this.dataScriptRule.DesTable, tableName); TableDAL.AddIndex(tableName, string.Format("{0},TASKTIMES,PROJECTID", st.ColumnName)); } return(true); } return(false); }
void showDetail() { dgResources.Visibility = System.Windows.Visibility.Hidden; dgDelivers.Visibility = System.Windows.Visibility.Hidden; dgScripts.Visibility = System.Windows.Visibility.Hidden; dgUsers.Visibility = System.Windows.Visibility.Hidden; dgTimes.Visibility = System.Windows.Visibility.Hidden; gdTimes.Visibility = System.Windows.Visibility.Hidden; addTimes.Visibility = System.Windows.Visibility.Hidden; dgTechFiles.Visibility = System.Windows.Visibility.Hidden; dgArithmetics.Visibility = System.Windows.Visibility.Hidden; switch (taskTab.SelectedIndex) { case 0: dgTimes.Columns[4].Visibility = System.Windows.Visibility.Collapsed; dgTimes.Columns[5].Visibility = System.Windows.Visibility.Collapsed; dgTimes.Columns[6].Visibility = System.Windows.Visibility.Collapsed; dgTimes.Columns[7].Visibility = System.Windows.Visibility.Collapsed; dgTimes.Visibility = System.Windows.Visibility.Visible; if (currentInfo != null) { // 已经导入过得日志名称 //var scriptNames = DataLogDAL.getScriptCodes(currentInfo.id); var logs = DataLogDAL.getDistinctList(currentInfo.id); if (currentInfo.resolvers.Count(it => it.scriptType == "0") > 0) { dgTimes.Columns[4].Visibility = System.Windows.Visibility.Visible; } if (currentInfo.resolvers.Count(it => it.scriptType == "1") > 0) { dgTimes.Columns[5].Visibility = System.Windows.Visibility.Visible; } if (currentInfo.resolvers.Count(it => it.scriptType == "2") > 0) { dgTimes.Columns[6].Visibility = System.Windows.Visibility.Visible; } if (currentInfo.resolvers.Count(it => it.scriptType == "3") > 0) { dgTimes.Columns[7].Visibility = System.Windows.Visibility.Visible; } var dataSource = WebHelper.listTdmTaskTimesInfo(currentInfo.id); foreach (var item in dataSource) { item.scriptRunds = logs; item.resolvers.AddRange(currentInfo.resolvers); } dgTimes.DataContext = dataSource; int max = 0; try { max = dataSource.Max(it => it.TestTimeInt); } catch { } txtTimes.Text = (max + 1).ToString(); if (currentInfo != null) { if (currentInfo.taskType == "工步") { addTimes.Visibility = System.Windows.Visibility.Visible; } else { addTimes.Visibility = System.Windows.Visibility.Hidden; } } if (dataSource.Count > logs.Count) { // 说明有的试验任务,还没执行过 // 有人说时有时无,先去掉这个判断逻辑 //addTimes.Visibility = System.Windows.Visibility.Hidden; } } break; case 1: dgResources.Visibility = System.Windows.Visibility.Visible; break; case 2: dgDelivers.Visibility = System.Windows.Visibility.Visible; break; case 3: dgUsers.Visibility = System.Windows.Visibility.Visible; break; case 4: dgScripts.Visibility = System.Windows.Visibility.Visible; break; case 5: dgTechFiles.Visibility = System.Windows.Visibility.Visible; break; case 6: dgArithmetics.Visibility = System.Windows.Visibility.Visible; break; } }