private void ActionDevice(action vAction) { try { if (grdDevice.CurrentRow == null && (vAction == action.Update || vAction == action.Delete)) { return; } switch (vAction) { case action.Normal: dtDevice = new Select(DDeviceList.Schema.Name + ".*", TTestTypeList.Columns.TestTypeName, LManufacture.Columns.SName) .From(DDeviceList.Schema.Name). LeftOuterJoin(TTestTypeList.TestTypeIdColumn, DDeviceList.TestTypeIdColumn). LeftOuterJoin(LManufacture.IdColumn, DDeviceList.ManufactureIdColumn). ExecuteDataSet().Tables[0]; grdDevice.DataSource = dtDevice; break; case action.Delete: if ( DDataControl.CreateQuery().WHERE(DDataControl.Columns.DeviceId, Utility.Int32Dbnull(grdDevice.GetValue("Device_ID"))). GetRecordCount() > 0) { Utility.ShowMsg("Danh mục đang được sử dụng. Không được xóa"); return; } if (Utility.AcceptQuestion("Thực hiện xóa " + grdDevice.GetValue("Device_Name"), "Thông báo", true)) { new Delete().From(DDeviceList.Schema.Name).Where(DDeviceList.Columns.DeviceId).IsEqualTo( Utility.Int32Dbnull(grdDevice.GetValue("Device_ID"))).Execute(); grdDevice.CurrentRow.Delete(); grdDevice.UpdateData(); } dtDevice.AcceptChanges(); break; default: var oForm = new frmDeviceList_AU(); oForm.vAction = vAction; oForm.drList = Utility.GetDataRow(dtDevice, DDeviceList.Columns.DeviceId, grdDevice.GetValue("Device_ID")); oForm.dtList = dtDevice; oForm.ShowDialog(); break; } } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
private void ActionDevice(action vAction) { try { if (grdDevice.CurrentRow == null && (vAction == action.Update || vAction == action.Delete)) return; switch (vAction) { case action.Normal: dtDevice = new Select(DDeviceList.Schema.Name + ".*", TTestTypeList.Columns.TestTypeName, LManufacture.Columns.SName) .From(DDeviceList.Schema.Name). LeftOuterJoin(TTestTypeList.TestTypeIdColumn, DDeviceList.TestTypeIdColumn). LeftOuterJoin(LManufacture.IdColumn, DDeviceList.ManufactureIdColumn). ExecuteDataSet().Tables[0]; grdDevice.DataSource = dtDevice; break; case action.Delete: if ( DDataControl.CreateQuery().WHERE(DDataControl.Columns.DeviceId,Utility.Int32Dbnull(grdDevice.GetValue("Device_ID"))). GetRecordCount() > 0) { Utility.ShowMsg("Danh mục đang được sử dụng. Không được xóa"); return; } if (Utility.AcceptQuestion("Thực hiện xóa " + grdDevice.GetValue("Device_Name"), "Thông báo", true)) { new Delete().From(DDeviceList.Schema.Name).Where(DDeviceList.Columns.DeviceId).IsEqualTo( Utility.Int32Dbnull(grdDevice.GetValue("Device_ID"))).Execute(); grdDevice.CurrentRow.Delete(); grdDevice.UpdateData(); } dtDevice.AcceptChanges(); break; default: var oForm = new frmDeviceList_AU(); oForm.vAction = vAction; oForm.drList = Utility.GetDataRow(dtDevice, DDeviceList.Columns.DeviceId, grdDevice.GetValue("Device_ID")); oForm.dtList = dtDevice; oForm.ShowDialog(); break; } } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }