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