private void cmdSave_Click(object sender, EventArgs e) { try { txtID.Text = txtID.Text.ToUpper(); if (ValidData()) { switch (vAction) { case action.Insert: var obj = new LStandardTest(); obj.TestDataId = Utility.sDbnull(txtID.Text, "NONE"); obj.DataName = Utility.sDbnull(txtName.Text, "NONE"); obj.DataSequence = Utility.Int32Dbnull(txtSequence.Value, 0); obj.TestTypeId = Utility.Int32Dbnull(cboTestType.SelectedValue, -1); obj.MeasureUnit = Utility.sDbnull(txtMeasureUnit.Text); obj.NormalLevel = Utility.sDbnull(txtNormalLevel.Text); obj.NormalLevelW = Utility.sDbnull(txtNormalLevelW.Text); obj.DataPoint = (short)Utility.Int32Dbnull(txtDataPoint.Value, 0); obj.DataView = ckbDataView.Checked; obj.DataPrint = ckbDataPrint.Checked; obj.Description = Utility.sDbnull(txtDesc.Text); obj.IsNew = true; obj.Save(); drData = dtTestDataList.NewRow(); ApplyData2Datarow(); dtTestDataList.Rows.InsertAt(drData, 0); dtTestDataList.AcceptChanges(); txtID.Enabled = false; vAction = action.Update; break; case action.Update: new Update(LStandardTest.Schema.Name).Set(LStandardTest.Columns.TestDataId).EqualTo(txtID.Text). Set(LStandardTest.Columns.DataName).EqualTo(txtName.Text). Set(LStandardTest.Columns.DataSequence).EqualTo(txtSequence.Text). Set(LStandardTest.Columns.TestTypeId).EqualTo(Utility.Int32Dbnull(cboTestType.SelectedValue, -1)). Set(LStandardTest.Columns.MeasureUnit).EqualTo(txtMeasureUnit.Text). Set(LStandardTest.Columns.NormalLevel).EqualTo(txtNormalLevel.Text). Set(LStandardTest.Columns.NormalLevelW).EqualTo(txtNormalLevelW.Text). Set(LStandardTest.Columns.DataPoint).EqualTo(txtDataPoint.Text). Set(LStandardTest.Columns.DataView).EqualTo(ckbDataView.Checked). Set(LStandardTest.Columns.DataPrint).EqualTo(ckbDataPrint.Checked). Set(LStandardTest.Columns.Description).EqualTo(txtDesc.Text). Where(LStandardTest.Columns.TestDataId).IsEqualTo(txtID.Text).Execute(); ApplyData2Datarow(); drData.AcceptChanges(); break; } } } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
private void frmQuickReorderTestSequence_FormClosing(object sender, FormClosingEventArgs e) { for (int i = 0; i < dtDataControl.Rows.Count; i++) { var item = new LStandardTest(dtDataControl.Rows[i]["TestData_ID"]); item.DataSequence = i + 1; item.IsNew = false; item.Save(); } }
private void cmdSave_Click(object sender, EventArgs e) { try { txtID.Text = txtID.Text.ToUpper(); if (ValidData()) switch (vAction) { case action.Insert: var obj = new LStandardTest(); obj.TestDataId = Utility.sDbnull(txtID.Text, "NONE"); obj.DataName = Utility.sDbnull(txtName.Text, "NONE"); obj.DataSequence = Utility.Int32Dbnull(txtSequence.Value, 0); obj.TestTypeId = Utility.Int32Dbnull(cboTestType.SelectedValue, -1); obj.MeasureUnit = Utility.sDbnull(txtMeasureUnit.Text); obj.NormalLevel = Utility.sDbnull(txtNormalLevel.Text); obj.NormalLevelW = Utility.sDbnull(txtNormalLevelW.Text); obj.DataPoint = (short)Utility.Int32Dbnull(txtDataPoint.Value,0); obj.DataView = ckbDataView.Checked; obj.DataPrint = ckbDataPrint.Checked; obj.Description = Utility.sDbnull(txtDesc.Text); obj.IsNew = true; obj.Save(); drData = dtTestDataList.NewRow(); ApplyData2Datarow(); dtTestDataList.Rows.InsertAt(drData, 0); dtTestDataList.AcceptChanges(); txtID.Enabled = false; vAction=action.Update; break; case action.Update: new Update(LStandardTest.Schema.Name).Set(LStandardTest.Columns.TestDataId).EqualTo(txtID.Text). Set(LStandardTest.Columns.DataName).EqualTo(txtName.Text). Set(LStandardTest.Columns.DataSequence).EqualTo(txtSequence.Text). Set(LStandardTest.Columns.TestTypeId).EqualTo(Utility.Int32Dbnull(cboTestType.SelectedValue, -1)). Set(LStandardTest.Columns.MeasureUnit).EqualTo(txtMeasureUnit.Text). Set(LStandardTest.Columns.NormalLevel).EqualTo(txtNormalLevel.Text). Set(LStandardTest.Columns.NormalLevelW).EqualTo(txtNormalLevelW.Text). Set(LStandardTest.Columns.DataPoint).EqualTo(txtDataPoint.Text). Set(LStandardTest.Columns.DataView).EqualTo(ckbDataView.Checked). Set(LStandardTest.Columns.DataPrint).EqualTo(ckbDataPrint.Checked). Set(LStandardTest.Columns.Description).EqualTo(txtDesc.Text). Where(LStandardTest.Columns.TestDataId).IsEqualTo(txtID.Text).Execute(); ApplyData2Datarow(); drData.AcceptChanges(); break; } } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
public void Insert(string TestDataId,int TestTypeId,int? DataSequence,string DataName,string MeasureUnit,short DataPoint,string NormalLevel,string NormalLevelW,bool? DataView,bool? DataPrint,string Description,string ReportDesc) { LStandardTest item = new LStandardTest(); item.TestDataId = TestDataId; item.TestTypeId = TestTypeId; item.DataSequence = DataSequence; item.DataName = DataName; item.MeasureUnit = MeasureUnit; item.DataPoint = DataPoint; item.NormalLevel = NormalLevel; item.NormalLevelW = NormalLevelW; item.DataView = DataView; item.DataPrint = DataPrint; item.Description = Description; item.ReportDesc = ReportDesc; item.Save(UserName); }