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