internal List <DMChucNangInfor> Search(DMChucNangInfor dmChucNangInfor) { CreateGetListCommand(Declare.StoreProcedureNamespace.spChucNangSearch); Parameters.AddWithValue("@MaChucNang", dmChucNangInfor.MaChucNang); Parameters.AddWithValue("@TenChucNang", dmChucNangInfor.TenChucNang); return(FillToList <DMChucNangInfor>()); }
internal int Insert(DMChucNangInfor dmChucNangInfor) { CreateCommonCommand(Declare.StoreProcedureNamespace.spChucNangInsert); SetParams(dmChucNangInfor); Parameters["@IdChucNang"].Direction = ParameterDirection.Output; ExecuteNoneQuery(); return(Convert.ToInt32(Parameters["@IdChucNang"].Value.ToString())); }
internal bool Exist(DMChucNangInfor dmChucNangInfor) { CreateCommonCommand(Declare.StoreProcedureNamespace.spChucNangExist); Parameters.AddWithValue("@Count", 0).Direction = ParameterDirection.Output; Parameters.AddWithValue("@IdChucNang", dmChucNangInfor.IdChucNang); Parameters.AddWithValue("@MaChucNang", dmChucNangInfor.MaChucNang); ExecuteNoneQuery(); return(Convert.ToInt32(Parameters["@Count"].Value) == 1); }
private DMChucNangInfor getinfor() { DMChucNangInfor dmChucNangInfor = new DMChucNangInfor(); dmChucNangInfor.MaChucNang = txtMa.Text; dmChucNangInfor.TenChucNang = txtTen.Text; dmChucNangInfor.GhiChu = txtMoTa.Text; dmChucNangInfor.SuDung = Convert.ToInt32(chkSuDung.Checked); dmChucNangInfor.IdChucNang = Convert.ToInt32(getValue("clId")); return(dmChucNangInfor); }
private bool Exist(DMChucNangInfor dmChucNangInfor) { return(dmChucNangInfor.IdChucNang != idChucNang && dmChucNangInfor.MaChucNang != null && dmChucNangInfor.MaChucNang.ToLower() == txtMa.Text.Trim().ToLower()); }
internal void Delete(DMChucNangInfor dmChucNangInfor) { CreateCommonCommand(Declare.StoreProcedureNamespace.spChucNangDelete); Parameters.AddWithValue("@IdChucNang", dmChucNangInfor.IdChucNang); ExecuteNoneQuery(); }
internal void Update(DMChucNangInfor dmChucNangInfor) { CreateCommonCommand(Declare.StoreProcedureNamespace.spChucNangUpdate); SetParams(dmChucNangInfor); ExecuteNoneQuery(); }