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;
}
}
