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