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