/// <summary> /// 测试信息输出 /// </summary> /// <param name="msg"></param> private void AddStatus(string msg) { if (rTextStatus.InvokeRequired) { Action <string> d = AddStatus; this.Invoke(d, new object[] { msg }); } else { rTextStatus.AppendText(Convert.FormatMsg(msg) + "\n"); } }
private static List <Project> GetProjectlistFromTable(DataTable dataTable) { List <Project> ret = new List <Project>(); foreach (DataRow tempRow in dataTable.Rows) { Project project = new Project(); project.Pn = (string)tempRow["PN"]; project.Customer = (string)tempRow["Customer"]; project.PnCustomer = (string)tempRow["PNCustomer"]; project.Length = (int)tempRow["Length"]; project.Awg = (int)tempRow["AWG"]; project.Diff = Convert.Str2List((string)tempRow["Diff"]); project.Single = Convert.Str2List((string)tempRow["Single"]); project.Tdr = Convert.Str2List((string)tempRow["Tdr"]); project.DiffPair = Convert.Str2List((string)tempRow["DiffPair"]); project.NextPair = Convert.Str2List((string)tempRow["NextPair"]); project.FextPair = Convert.Str2List((string)tempRow["FextPair"]); project.ReportTempletePath = (string)tempRow["ReportTempletePath"]; project.RomFileMode = (RomFileMode)Enum.Parse(typeof(RomFileMode), (string)tempRow["RomFileMode"]); project.RomFilePath = (string)tempRow["RomFilePath"]; project.RomWrite = (bool)tempRow["RomWrite"]; project.Report = GetDbValue(tempRow["Report"], true); project.SwitchFilePath = (string)tempRow["SwitchFilePath"]; project.FreSpec = (string)tempRow["FreSpec"]; project.FreSpecFilePath = (string)tempRow["FreSpecFilePath"]; project.FrePoints = (int)tempRow["FrePoints"]; project.Tdd11 = Serializer.Json2Object <TdrParam>((string)tempRow["Tdd11"]); project.Tdd22 = Serializer.Json2Object <TdrParam>((string)tempRow["Tdd22"]); project.Ild = (IldSpec)Enum.Parse(typeof(IldSpec), (string)tempRow["ILD"]); project.Skew = (double)tempRow["Skew"]; project.Speed = GetDbValue(tempRow["Speed"], ""); project.ProductTypeL = GetDbValue(tempRow["ProductTypeL"], ""); project.ProductTypeR = GetDbValue(tempRow["ProductTypeR"], ""); project.Power = GetDbValue(tempRow["Power"], ""); project.Description = GetDbValue(tempRow["Description"], ""); project.CalFilePath = GetDbValue(tempRow["CalFilePath"], ""); project.KeyPoint = GetDbValue(tempRow["Keypoint"], ""); project.Srevert = GetDbValue(tempRow["Srevert"], false); project.Trevert = GetDbValue(tempRow["Trevert"], false); ret.Add(project); } return(ret); }
private bool SetTestFilePath(ref Savepath savepath) { if (txtSN.Text.Trim() == "") { AddStatus("SN不能为空"); Ui.MessageBoxMuti("SN为空,请输入SN"); return(false); } else { string pn = Convert.SlashRepalce(txt_PN.Text.Trim()); string sn = Convert.SlashRepalce(txtSN.Text.Trim()); savepath.SnpFilePath = _hardware.SnpFolder + "\\" + pn + "\\" + sn; savepath.TxtFilePath = _hardware.TxtFolder + "\\" + pn + "\\" + sn; savepath.Sn = sn; savepath.XmlPath = _hardware.TxtFolder + "\\" + pn + "\\" + sn + "\\txt\\1\\Result & Sample info.xml"; savepath.ReportTempletePath = _curretnProject.ReportTempletePath; Directory.CreateDirectory(savepath.SnpFilePath); Directory.CreateDirectory(savepath.TxtFilePath); return(true); } }
public static bool Add(Project project, ref string msg) { bool ret = false; if (Find(project.Pn).Count > 0) { msg = "相同料号已经存在"; return(false); } string insertSql = "INSERT INTO HPMS_Project (" + "PN, PNCustomer, Length, AWG, Diff, " + "Single, Tdr, DiffPair, NextPair, FextPair, " + "ReportTempletePath, RomFileMode, RomFilePath, RomWrite, SwitchFilePath, " + "FreSpec, FrePoints, Tdd11, Tdd22, ILD, " + "Skew, Customer,FreSpecFilePath, Speed, ProductTypeL, " + "ProductTypeR, Power, Description,CalFilePath,Keypoint,Srevert,Trevert,Report) VALUES (" + "@pn,@pncustomer,@length,@awg,@diff," + "@single,@tdr,@diffpair,@nextpair,@fextpair," + "@reporttempletepath,@romfilemode,@romfilepath,@romwrite,@switchfilepath," + "@frespec,@frepoints,@tdd11,@tdd22,@ild," + "@skew,@customer,@frespecfilepath,@speed,@producttypel," + "@producttyper,@power,@description,@calfilepath,@keypoint,@srevert,@trevert,@report) "; IDataParameter[] b = new IDataParameter[33]; b[0] = Gloabal.GDatabase.CreatePara("pn", project.Pn); b[1] = Gloabal.GDatabase.CreatePara("pncustomer", project.PnCustomer); b[2] = Gloabal.GDatabase.CreatePara("length", project.Length); b[3] = Gloabal.GDatabase.CreatePara("awg", project.Awg); b[4] = Gloabal.GDatabase.CreatePara("diff", Convert.List2Str(project.Diff)); b[5] = Gloabal.GDatabase.CreatePara("single", Convert.List2Str(project.Single)); b[6] = Gloabal.GDatabase.CreatePara("tdr", Convert.List2Str(project.Tdr)); b[7] = Gloabal.GDatabase.CreatePara("diffpair", Convert.List2Str(project.DiffPair)); b[8] = Gloabal.GDatabase.CreatePara("nextpair", Convert.List2Str(project.NextPair)); b[9] = Gloabal.GDatabase.CreatePara("fextpair", Convert.List2Str(project.FextPair)); b[10] = Gloabal.GDatabase.CreatePara("reporttempletepath", project.ReportTempletePath); b[11] = Gloabal.GDatabase.CreatePara("romfilemode", project.RomFileMode.ToString()); b[12] = Gloabal.GDatabase.CreatePara("romfilepath", project.RomFilePath); b[13] = Gloabal.GDatabase.CreatePara("romwrite", project.RomWrite); b[14] = Gloabal.GDatabase.CreatePara("switchfilepath", project.SwitchFilePath); b[15] = Gloabal.GDatabase.CreatePara("frespec", project.FreSpec); b[16] = Gloabal.GDatabase.CreatePara("frepoints", project.FrePoints); b[17] = Gloabal.GDatabase.CreatePara("tdd11", Serializer.Object2Json(project.Tdd11)); b[18] = Gloabal.GDatabase.CreatePara("tdd22", Serializer.Object2Json(project.Tdd22)); b[19] = Gloabal.GDatabase.CreatePara("ild", project.Ild.ToString()); b[20] = Gloabal.GDatabase.CreatePara("skew", project.Skew); b[21] = Gloabal.GDatabase.CreatePara("customer", project.Customer); b[22] = Gloabal.GDatabase.CreatePara("frespecfilepath", project.FreSpecFilePath); b[23] = Gloabal.GDatabase.CreatePara("speed", project.Speed); b[24] = Gloabal.GDatabase.CreatePara("producttypel", project.ProductTypeL); b[25] = Gloabal.GDatabase.CreatePara("producttyper", project.ProductTypeR); b[26] = Gloabal.GDatabase.CreatePara("power", project.Power); b[27] = Gloabal.GDatabase.CreatePara("description", project.Description); b[28] = Gloabal.GDatabase.CreatePara("calfilepath", project.CalFilePath); b[29] = Gloabal.GDatabase.CreatePara("keypoint", project.KeyPoint); b[30] = Gloabal.GDatabase.CreatePara("srevert", project.Srevert); b[31] = Gloabal.GDatabase.CreatePara("trevert", project.Trevert); b[32] = Gloabal.GDatabase.CreatePara("report", project.Report); int insertCount = Gloabal.GDatabase.ExecuteSql(insertSql, b); if (insertCount == 1) { ret = true; } else { msg = "添加新料号失败"; } return(ret); }
public static bool Update(Project project, ref string msg) { bool ret = false; string updateSql = "UPDATE HPMS_Project SET" + " PNCustomer = @pncustomer, Length = @length, AWG = @awg, Diff = @diff, Single = @single," + "Tdr = @tdr,DiffPair = @diffpair,NextPair = @nextpair,FextPair = @fextpair,ReportTempletePath = @reporttempletepath," + "RomFileMode = @romfilemode,RomFilePath = @romfilepath,RomWrite = @romwrite,SwitchFilePath = @switchfilepath,FreSpec = @frespec," + "FrePoints = @frepoints,Tdd11 =@tdd11,Tdd22 = @tdd22,ILD = @ild,Skew = @skew," + "Customer = @customer,FreSpecFilePath = @frespecfilepath, Speed = @speed,ProductTypeL = @producttypel,ProductTypeR = @producttyper," + "Power = @power, Description = @description,CalFilePath = @calfilepath,Keypoint = @keypoint,Srevert=@srevert,Trevert=@trevert,Report=@report where PN = @pn "; IDataParameter[] b = new IDataParameter[33]; b[0] = Gloabal.GDatabase.CreatePara("pn", project.Pn); b[1] = Gloabal.GDatabase.CreatePara("pncustomer", project.PnCustomer); b[2] = Gloabal.GDatabase.CreatePara("length", project.Length); b[3] = Gloabal.GDatabase.CreatePara("awg", project.Awg); b[4] = Gloabal.GDatabase.CreatePara("diff", Convert.List2Str(project.Diff)); b[5] = Gloabal.GDatabase.CreatePara("single", Convert.List2Str(project.Single)); b[6] = Gloabal.GDatabase.CreatePara("tdr", Convert.List2Str(project.Tdr)); b[7] = Gloabal.GDatabase.CreatePara("diffpair", Convert.List2Str(project.DiffPair)); b[8] = Gloabal.GDatabase.CreatePara("nextpair", Convert.List2Str(project.NextPair)); b[9] = Gloabal.GDatabase.CreatePara("fextpair", Convert.List2Str(project.FextPair)); b[10] = Gloabal.GDatabase.CreatePara("reporttempletepath", project.ReportTempletePath); b[11] = Gloabal.GDatabase.CreatePara("romfilemode", project.RomFileMode.ToString()); b[12] = Gloabal.GDatabase.CreatePara("romfilepath", project.RomFilePath); b[13] = Gloabal.GDatabase.CreatePara("romwrite", project.RomWrite); b[14] = Gloabal.GDatabase.CreatePara("switchfilepath", project.SwitchFilePath); b[15] = Gloabal.GDatabase.CreatePara("frespec", project.FreSpec); b[16] = Gloabal.GDatabase.CreatePara("frepoints", project.FrePoints); b[17] = Gloabal.GDatabase.CreatePara("tdd11", Serializer.Object2Json(project.Tdd11)); b[18] = Gloabal.GDatabase.CreatePara("tdd22", Serializer.Object2Json(project.Tdd22)); b[19] = Gloabal.GDatabase.CreatePara("ild", project.Ild.ToString()); b[20] = Gloabal.GDatabase.CreatePara("skew", project.Skew); b[21] = Gloabal.GDatabase.CreatePara("customer", project.Customer); b[22] = Gloabal.GDatabase.CreatePara("frespecfilepath", project.FreSpecFilePath); b[23] = Gloabal.GDatabase.CreatePara("speed", project.Speed); b[24] = Gloabal.GDatabase.CreatePara("producttypel", project.ProductTypeL); b[25] = Gloabal.GDatabase.CreatePara("producttyper", project.ProductTypeR); b[26] = Gloabal.GDatabase.CreatePara("power", project.Power); b[27] = Gloabal.GDatabase.CreatePara("description", project.Description); b[28] = Gloabal.GDatabase.CreatePara("calfilepath", project.CalFilePath); b[29] = Gloabal.GDatabase.CreatePara("keypoint", project.KeyPoint); b[30] = Gloabal.GDatabase.CreatePara("srevert", project.Srevert); b[31] = Gloabal.GDatabase.CreatePara("trevert", project.Trevert); b[32] = Gloabal.GDatabase.CreatePara("report", project.Report); int updateCount = Gloabal.GDatabase.ExecuteSql(updateSql, b); if (updateCount == 1) { ret = true; } return(ret); }