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