private void ActionManufacturer(action vAction) { try { if (grdManufacturer.CurrentRow == null && (vAction == action.Update || vAction == action.Delete)) { return; } switch (vAction) { case action.Normal: dtManufacturer = new Select().From(LManufacture.Schema.Name).ExecuteDataSet().Tables[0]; grdManufacturer.DataSource = dtManufacturer; break; case action.Delete: if ( DDeviceList.CreateQuery().WHERE(DDeviceList.Columns.ManufactureId, Utility.Int32Dbnull(grdManufacturer.GetValue("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 " + grdManufacturer.GetValue("sName"), "Thông báo", true)) { new Delete().From(LManufacture.Schema.Name).Where(LManufacture.Columns.Id).IsEqualTo( Utility.Int32Dbnull(grdManufacturer.GetValue("ID"))).Execute(); grdManufacturer.CurrentRow.Delete(); grdManufacturer.UpdateData(); } break; default: var oForm = new frmManufacturerList_AU(); if (vAction == action.Update) { oForm.txtID.Text = Utility.sDbnull(grdManufacturer.GetValue("ID")); } oForm.dtList = dtManufacturer; oForm.grdList = grdManufacturer; oForm.ShowDialog(); break; } } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
private void ActionManufacturer(action vAction) { try { if (grdManufacturer.CurrentRow == null && (vAction == action.Update || vAction == action.Delete)) return; switch (vAction) { case action.Normal: dtManufacturer = new Select().From(LManufacture.Schema.Name).ExecuteDataSet().Tables[0]; grdManufacturer.DataSource = dtManufacturer; break; case action.Delete: if ( DDeviceList.CreateQuery().WHERE(DDeviceList.Columns.ManufactureId, Utility.Int32Dbnull(grdManufacturer.GetValue("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 " + grdManufacturer.GetValue("sName"), "Thông báo", true)) { new Delete().From(LManufacture.Schema.Name).Where(LManufacture.Columns.Id).IsEqualTo( Utility.Int32Dbnull(grdManufacturer.GetValue("ID"))).Execute(); grdManufacturer.CurrentRow.Delete(); grdManufacturer.UpdateData(); } break; default: var oForm = new frmManufacturerList_AU(); if(vAction==action.Update) oForm.txtID.Text = Utility.sDbnull(grdManufacturer.GetValue("ID")); oForm.dtList = dtManufacturer; oForm.grdList = grdManufacturer; oForm.ShowDialog(); break; } } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }