/// <summary>保存Jew数据
/// </summary>
/// <param name="data"></param>
/// <param name="IsDelete"></param>
public static void SaveJewData(JewDataClass jewData)
{
string sqlstr = @"insert into JewDataTable(ID,Name,JewClass,Wavelength,Spectrum,AddTime,Creator,Remark,RealSign,UnRealSign)values(@ID,@Name,@JewClass,@Wavelength,@Spectrum,@AddTime,@Creator,@Remark,@RealSign,@UnRealSign)";
SqliteHelper.ExecuteSql(sqlstr, new
{
ID = jewData.jewId,
Name = jewData.jewName,
JewClass = jewData.jewClass,
Wavelength = ProcessArray.DoubleToStringEncryption(jewData.wavelength),
Spectrum = ProcessArray.DoubleToStringEncryption(jewData.spectrum),
AddTime = jewData.addTime,
Creator = jewData.creator,
Remark = jewData.remark,
RealSign = ProcessArray.DoubleToString(jewData.realSign.ToArray()),
UnRealSign = ProcessArray.DoubleToString(jewData.unRealSign.ToArray())
});
}
private void btn_addJewData_Click(object sender, EventArgs e)
{
if (!processSpec.IsConn)
{
return;
}
try
{
List <double> realSign = new List <double>();
List <double> unRealSign = new List <double>();
for (int i = 0; i < dgv_sign.Rows.Count; i++)
{
double real, unReal;
if (double.TryParse(dgv_sign.Rows[i].Cells [0].Value.ToString(), out real))
{
realSign.Add(real);
}
if (double.TryParse(dgv_sign.Rows [i].Cells [1].Value.ToString(), out unReal))
{
unRealSign.Add(unReal);
}
}
JewDataClass jewSample = new JewDataClass();
jewSample.jewId = processSpec.JewID;
jewSample.jewName = txt_name.Text.Trim();
jewSample.jewClass = cbx_class.SelectedItem.ToString();
jewSample.wavelength = ProcessArray.getOneStepArrayDouble(processSpec.ShowWavelength_MinMax[0], processSpec.ShowWavelength_MinMax[1]);
jewSample.spectrum = ProcessArray.FixArrayY(jewSample.wavelength, processSpec.wavelengths, processSpec.showY);
jewSample.creator = cbx_people.SelectedItem.ToString();
jewSample.remark = rtb_remark.Text.Trim();
jewSample.addTime = DateTime.Now.ToString();
jewSample.realSign = realSign;
jewSample.unRealSign = unRealSign;
SqliteHelper.SaveJewData(jewSample);
processSpec.JewID = processSpec.JewID + 1;
MessageBox.Show("保存成功！");
}
catch (Exception ex)
{
MessageBox.Show("保存失败！" + ex.Message);
}
}
