/// <summary>
/// 导出至txt文件
/// </summary>
public void to_txt()
{
FileStream fs1 = new FileStream("D:\\数据导出\\Tem\\" + txb_OrderID.Text.Trim() + ".txt", FileMode.Create, FileAccess.Write);//创建写入文件
StreamWriter sw = new StreamWriter(fs1);
sw.WriteLine("TestDate,TestType,SerialNumber,Result,WaveType,ILA,RLA,ILB,RLB");//开始写入值
foreach (object _temJda in _W_DataList)
{
Maticsoft.Model.User_JDS_Test_Good JsdData = (Maticsoft.Model.User_JDS_Test_Good)_temJda;
string _str = JsdData.TestDate + "," + "Type,";
_str += JsdData.SN + ",";
_str += JsdData.Result + ",";
_str += JsdData.Wave + ",";
_str += JsdData.IL_A + ",";
_str += JsdData.Refl_A + ",";
_str += JsdData.IL_B + ",";
_str += JsdData.Refl_B;
sw.WriteLine(_str);//开始写入值
}
sw.Close();
fs1.Close();
Note("导出数据至 D:\\数据导出\\Tem\\ ");
My_MessageBox.My_MessageBox_Message("导出完成！\r\n文件存放路径 \r\n D:\\数据导出\\Tem\\");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.User_JDS_Test_Good model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update User_JDS_Test_Good set ");
strSql.Append("TestDate=@TestDate,");
strSql.Append("PartNumber=@PartNumber,");
strSql.Append("SN=@SN,");
strSql.Append("Result=@Result,");
strSql.Append("Wave=@Wave,");
strSql.Append("IL_A=@IL_A,");
strSql.Append("Refl_A=@Refl_A,");
strSql.Append("IL_B=@IL_B,");
strSql.Append("Refl_B=@Refl_B");
strSql.Append(" where SN=@SN");
SqlParameter[] parameters =
{
new SqlParameter("@TestDate", SqlDbType.VarChar, 25),
new SqlParameter("@PartNumber", SqlDbType.VarChar, 50),
new SqlParameter("@SN", SqlDbType.VarChar, 35),
new SqlParameter("@Result", SqlDbType.VarChar, 10),
new SqlParameter("@Wave", SqlDbType.VarChar, 10),
new SqlParameter("@IL_A", SqlDbType.VarChar, 10),
new SqlParameter("@Refl_A", SqlDbType.VarChar, 10),
new SqlParameter("@IL_B", SqlDbType.VarChar, 10),
new SqlParameter("@Refl_B", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.TestDate;
parameters[1].Value = model.PartNumber;
parameters[2].Value = model.SN;
parameters[3].Value = model.Result;
parameters[4].Value = model.Wave;
parameters[5].Value = model.IL_A;
parameters[6].Value = model.Refl_A;
parameters[7].Value = model.IL_B;
parameters[8].Value = model.Refl_B;
int rows = dbs.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//
//保存至数据库
//
private void btn_Save_To_Server_Click(object sender, System.Windows.RoutedEventArgs e)
{
int Count = 0;
foreach (object testJsd in _W_DataList)
{
Maticsoft.Model.User_JDS_Test_Good _UserJDSTestData = (Maticsoft.Model.User_JDS_Test_Good)testJsd;
MCP_CS._M_User_JDS_Test_Good.Delete(_UserJDSTestData.SN.ToString());
if (MCP_CS._M_User_JDS_Test_Good.Add(_UserJDSTestData) > 0)
{
Count++;
}
}
ClearList();
My_MessageBox.My_MessageBox_Message("保存完成！共添加" + Count + "条记录！");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.User_JDS_Test_Good DataRowToModel(DataRow row)
{
Maticsoft.Model.User_JDS_Test_Good model = new Maticsoft.Model.User_JDS_Test_Good();
if (row != null)
{
if (row["TestDate"] != null)
{
model.TestDate = row["TestDate"].ToString();
}
if (row["PartNumber"] != null)
{
model.PartNumber = row["PartNumber"].ToString();
}
if (row["SN"] != null)
{
model.SN = row["SN"].ToString();
}
if (row["Result"] != null)
{
model.Result = row["Result"].ToString();
}
if (row["Wave"] != null)
{
model.Wave = row["Wave"].ToString();
}
if (row["IL_A"] != null)
{
model.IL_A = row["IL_A"].ToString();
}
if (row["Refl_A"] != null)
{
model.Refl_A = row["Refl_A"].ToString();
}
if (row["IL_B"] != null)
{
model.IL_B = row["IL_B"].ToString();
}
if (row["Refl_B"] != null)
{
model.Refl_B = row["Refl_B"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.User_JDS_Test_Good model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into User_JDS_Test_Good(");
strSql.Append("TestDate,PartNumber,SN,Result,Wave,IL_A,Refl_A,IL_B,Refl_B)");
strSql.Append(" values (");
strSql.Append("@TestDate,@PartNumber,@SN,@Result,@Wave,@IL_A,@Refl_A,@IL_B,@Refl_B)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TestDate", SqlDbType.VarChar, 25),
new SqlParameter("@PartNumber", SqlDbType.VarChar, 50),
new SqlParameter("@SN", SqlDbType.VarChar, 35),
new SqlParameter("@Result", SqlDbType.VarChar, 10),
new SqlParameter("@Wave", SqlDbType.VarChar, 10),
new SqlParameter("@IL_A", SqlDbType.VarChar, 10),
new SqlParameter("@Refl_A", SqlDbType.VarChar, 10),
new SqlParameter("@IL_B", SqlDbType.VarChar, 10),
new SqlParameter("@Refl_B", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.TestDate;
parameters[1].Value = model.PartNumber;
parameters[2].Value = model.SN;
parameters[3].Value = model.Result;
parameters[4].Value = model.Wave;
parameters[5].Value = model.IL_A;
parameters[6].Value = model.Refl_A;
parameters[7].Value = model.IL_B;
parameters[8].Value = model.Refl_B;
object obj = dbs.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.User_JDS_Test_Good GetModel(decimal ID_Key)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 TestDate,PartNumber,SN,Result,Wave,IL_A,Refl_A,IL_B,Refl_B,ID_Key from User_JDS_Test_Good ");
strSql.Append(" where ID_Key=@ID_Key");
SqlParameter[] parameters =
{
new SqlParameter("@ID_Key", SqlDbType.Decimal)
};
parameters[0].Value = ID_Key;
Maticsoft.Model.User_JDS_Test_Good model = new Maticsoft.Model.User_JDS_Test_Good();
DataSet ds = dbs.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 生成数据
/// </summary>
/// <param name="_OrderInfo">工单信息</param>
/// <param name="_SN_List">SN列表</param>
/// <param name="_ConectionType">接头类型</param>
/// <param name="_IL_Min">IL_Min</param>
/// <param name="_IL_Max">IL_Max</param>
/// <param name="_RL_Min">RL_Min</param>
/// <param name="_RL_Man">RL_Max</param>
/// <returns></returns>
private ArrayList GenerateDataList(Maticsoft.Model.WorkOrder _OrderInfo, ArrayList _SN_List,
string _ConectionType, int _IL_Min, int _IL_Max, int _RL_Min, int _RL_Man)
{
ArrayList _temList = new ArrayList();
try
{
double _temIL_1310nm = 0, _temIL_1550nm = 0;
//计算接续值
foreach (string _SN in _SN_List)
{
bool TemV = true;
while (TemV)
{
_temIL_1310nm = _W_GenerateData.Next(_IL_Min, _IL_Max);
_temIL_1550nm = _W_GenerateData.Next(_IL_Min, _IL_Max);
if ((_temIL_1310nm - _temIL_1550nm) < 10 && (_temIL_1310nm - _temIL_1550nm) > -10)
{
TemV = false;
}
}
//对生成的数值进行处理
if (_temIL_1310nm >= 10)
{
_temIL_1310nm = double.Parse("0." + _temIL_1310nm);
}
else
{
_temIL_1310nm = double.Parse("0.0" + _temIL_1310nm);
}
if (_temIL_1550nm >= 10)
{
_temIL_1550nm = double.Parse("0." + _temIL_1550nm);
}
else
{
_temIL_1550nm = double.Parse("0.0" + _temIL_1550nm);
}
#region 添加数据
//循环添加 1310nm 和 1550nm
for (int i = 1; i <= 2; i++)
{
//定义变量
string temWave = "";
double temIL_A = 0;
double temRL_A = _W_GenerateData.Next(_RL_Min, _RL_Man);
//变量赋值
if (i == 1)
{
temWave = "1310nm"; temIL_A = _temIL_1310nm;
}
else
{
temWave = "1550nm"; temIL_A = _temIL_1550nm;
}
//添加至列表
Maticsoft.Model.User_JDS_Test_Good _jdsTest = new Maticsoft.Model.User_JDS_Test_Good()
{
SN = _SN,
PartNumber = "",
Wave = temWave,
Result = "Passed",
TestDate = DateTime.Now.Date.ToString(),
IL_A = temIL_A.ToString("0.00"),
Refl_A = temRL_A.ToString("0"),
IL_B = "null",
Refl_B = "null"
};
_temList.Add(_jdsTest);
}
#endregion
}
Note("生成数据记录" + _W_DataList.Count + "条");
}
catch (SystemException ex) { My_MessageBox.My_MessageBox_Message(ex.Message); }
return(_temList);
}
