private void button1_Click(object sender, EventArgs e)
{
try
{
String s = qL_NGUOIDUNGDataGridView.CurrentRow.Cells[0].Value.ToString();
String v = cbo_tennhom.SelectedValue.ToString();
var kt = from pqu in ql.QLND_NHOMNDs
where pqu.TENDN == v && pqu.MANHOM == s select pqu;
if (kt.Count() > 0)
{
MessageBox.Show("trùng ");
return;
}
QLND_NHOMND pq = new QLND_NHOMND();
pq.TENDN = s;
pq.MANHOM = v;
ql.QLND_NHOMNDs.InsertOnSubmit(pq);
ql.SubmitChanges();
this.themNDVaoNhomTableAdapter.Fill(this.fPT_SHOPDataSet.ThemNDVaoNhom, cbo_tennhom.SelectedValue.ToString());
MessageBox.Show("Thành công");
}
catch
{
MessageBox.Show("thất bại");
}
}
private void frm_main_Load(object sender, EventArgs e)
{
try {
skins();
//lb_manv.Text = Tendn;
List <QLPHANQUYEN> manhinh = new List <QLPHANQUYEN>();
QLND_NHOMND nhom = new QLND_NHOMND();
nhom = pq.laymanhom(Tendn);
manhinh = pq.laydsmanhinh(nhom.MANHOM);
for (int i = 0; i < manhinh.Count(); i++)
{
if (manhinh[i].MAMANHINH == "MH001")
{
}
else if (manhinh[i].MAMANHINH == "MH002")
{
btn_nhanvien.Enabled = btn_phanquyen.Enabled = false;
}
else
{
ribbonPageGroup1.Visible = ribbonPageGroup7.Visible = ribbonPageGroup8.Visible
= ribbonPageGroup9.Visible = ribbonPageGroup10.Visible = ribbonPageGroup3.Visible =
ribbonPageGroup4.Visible = ribbonPageGroup5.Visible = false;
}
}
}
catch
{
ribbonPageGroup1.Visible = ribbonPageGroup7.Visible = ribbonPageGroup8.Visible
= ribbonPageGroup9.Visible = ribbonPageGroup10.Visible = ribbonPageGroup3.Visible =
ribbonPageGroup4.Visible = ribbonPageGroup5.Visible = false;
}
}
//Thêm
public bool them_QLND_NHOMND(QLND_NHOMND ND_nhomND)
{
try
{
data.QLND_NHOMNDs.InsertOnSubmit(ND_nhomND);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
//Xóa
public bool xoa_QLND_NHOMND(string pMaNhom, string ptendn)
{
try
{
QLND_NHOMND manhom = data.QLND_NHOMNDs.Where(t => t.MANHOM == pMaNhom && t.TENDN == ptendn).FirstOrDefault();
data.QLND_NHOMNDs.DeleteOnSubmit(manhom);
data.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
//Sửa
public bool sua_QLND_NHOMND(QLND_NHOMND pQLND_NHOMND)
{
try
{
QLND_NHOMND ND_nhomND = data.QLND_NHOMNDs.Where(t => t.MANHOM == pQLND_NHOMND.MANHOM).FirstOrDefault();
if (ND_nhomND != null)
{
ND_nhomND.GHICHU = pQLND_NHOMND.GHICHU;
data.SubmitChanges();
}
return(true);
}
catch
{
return(false);
}
}
private void btn_them_Click(object sender, EventArgs e)
{
try
{
qlndnnd = new QLND_NHOMND();
int position = gridView_qlnguoidung.FocusedRowHandle;
qlndnnd.TENDN = gridView_qlnguoidung.GetRowCellValue(position, "TENDN").ToString();
qlndnnd.MANHOM = cbo_quanlynhomnd.SelectedValue.ToString();
qlndnnd.GHICHU = null;
if (bnd_nnd.ktkc_QLND_NHOMND(qlndnnd.MANHOM, qlndnnd.TENDN) == true)
{
MessageBox.Show("trùng khóa chính");
return;
}
if (bnd_nnd.them_QLND_NHOMND(qlndnnd) == true)
{
//grv_qlnd_nnd.DataSource = bnd_nnd.loadBang_QLND_NHOMND();
MessageBox.Show("Thành công");
}
else
{
MessageBox.Show("Thất bại");
}
}
catch
{
MessageBox.Show("lỗi hệ thống");
}
frm_PhanQuyen_Load(sender, e);
//cbo_quanlynhomnd.DataSource = bnhomnd.loadBang_TB();
//cbo_quanlynhomnd.DisplayMember = "TENNHOMND";
//cbo_quanlynhomnd.ValueMember = "MANHOM";
////
//grv_qlnd.DataSource = bqlnd.loadnd();
//grv_qlnd_nnd.DataSource = bnd_nnd.loadBang_QLND_NHOMND();
}
private void frm_main_Load(object sender, EventArgs e)
{
List <QL_PHANQUYEN> manhinh = new List <QL_PHANQUYEN>();
QLND_NHOMND nhom = new QLND_NHOMND();
nhom = pq.laymanhom(Tendn);
manhinh = pq.laydsmanhinh(nhom.MANHOM);
for (int i = 0; i < manhinh.Count(); i++)
{
if (manhinh[i].MAMANHINH == "MH00001")
{
gr_nhaphang.Visible = false;
gr_phanquyen.Visible = gr_taikhoannv.Visible = gr_nhomnd.Visible = gr_ndnnd.Visible = false;
rb_danhmuc.Visible = false;
}
if (manhinh[i].MAMANHINH == "MH00002")
{
gr_banhang.Visible = false;
gr_phanquyen.Visible = gr_taikhoannv.Visible = gr_nhomnd.Visible = gr_ndnnd.Visible = false;
rb_danhmuc.Visible = false;
}
if (manhinh[i].MAMANHINH == "MH00003")
{
rb_nghiepvu.Visible = false;
rb_danhmuc.Visible = false;
// gr_phanquyen.Visible = gr_taikhoannv.Visible = gr_nhomnd.Visible = gr_ndnnd.Visible = false;
}
if (manhinh[i].MAMANHINH == "MH00004")
{
rb_nghiepvu.Visible = false;
gr_phanquyen.Visible = gr_taikhoannv.Visible = gr_nhomnd.Visible = gr_ndnnd.Visible = false;
}
}
//Tendn = lb_manvdn.Text;
var ktt = (from nv in ql.NHANVIENs where nv.MANV == lb_manvdn.Text select nv.HOTENNV).FirstOrDefault();
// lb_tennv_dn.Text = ktt.ToString();
}
//Sửa
public bool sua_QLND_NHOMND(QLND_NHOMND pQLND_NHOMND)
{
return(ND_nhomND.sua_QLND_NHOMND(pQLND_NHOMND));
}
//Thêm
public bool them_QLND_NHOMND(QLND_NHOMND pQLND_NHOMND)
{
return(ND_nhomND.them_QLND_NHOMND(pQLND_NHOMND));
}