public bool DeleteDecentralizationDataToDatabase(DecentralizationDTO _DecentralizationOject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "DeleteDecentralizationDataToDatabase";
m_cmd.Parameters.Add("MaCV", SqlDbType.NVarChar).Value = _DecentralizationOject.maChucVu;
return(m_DecentralizationExecute.updateData(m_cmd) > 0);
}
public DataTable getDecentralizationWithMaCV(DecentralizationDTO _DecentralizationOject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "GetDecentralizationWithMaCV";
m_cmd.Parameters.Add("MaCV", SqlDbType.NVarChar).Value = _DecentralizationOject.maChucVu;
return(m_DecentralizationExecute.getData(m_cmd));
}
private void InitDecentralizationObect(String _maCV)
{
m_DecentralizationObj = new DecentralizationDTO();
m_DecentralizationObj.maChucVu = _maCV;
m_DecentralizationData = m_DecentralizationExecute.getDecentralizationWithMaCV(m_DecentralizationObj);
//
InitCheckEditDefault();
//
InitCheckEdit(m_DecentralizationData);
}
public frmDecentralization()
{
InitializeComponent();
m_ChargeData = new DataTable();
m_ChargeExecute = new CChargeBUS();
m_DecentralizationData = new DataTable();
m_DecentralizationExecute = new DecentralizationBUS();
m_DecentralizationObj = new DecentralizationDTO();
btnSave.Enabled = false;
}
public bool UpdateDecentralizationToDatabase(DecentralizationDTO _DecentralizationOject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "UpdateDecentralizationDataToDatabase";
m_cmd.Parameters.Add("MaCV", SqlDbType.NVarChar).Value = _DecentralizationOject.maChucVu;
m_cmd.Parameters.Add("ThietLapHeThong", SqlDbType.Bit).Value = _DecentralizationOject.ThietLapHeThong;
m_cmd.Parameters.Add("ThayDoiQuyDinh", SqlDbType.Bit).Value = _DecentralizationOject.ThayDoiQuyDinh;
m_cmd.Parameters.Add("QuanLySach", SqlDbType.Bit).Value = _DecentralizationOject.QuanLySach;
m_cmd.Parameters.Add("QuanLyNhanVien", SqlDbType.Bit).Value = _DecentralizationOject.QuanLyNhanVien;
m_cmd.Parameters.Add("QuanLyKhachHang", SqlDbType.Bit).Value = _DecentralizationOject.QuanLyKhachHang;
m_cmd.Parameters.Add("LapPhieuNhapSach", SqlDbType.Bit).Value = _DecentralizationOject.LapPhieuNhapSach;
m_cmd.Parameters.Add("LapHoaDonBanSach", SqlDbType.Bit).Value = _DecentralizationOject.LapHoaDonBanSach;
m_cmd.Parameters.Add("LapPhieuThuTien", SqlDbType.Bit).Value = _DecentralizationOject.LapPhieuThuTien;
m_cmd.Parameters.Add("TraCuuSach", SqlDbType.Bit).Value = _DecentralizationOject.TraCuuSach;
m_cmd.Parameters.Add("TraCuuNhanVien", SqlDbType.Bit).Value = _DecentralizationOject.TraCuuNhanVien;
m_cmd.Parameters.Add("TraCuuHoaDon", SqlDbType.Bit).Value = _DecentralizationOject.TraCuuHoaDon;
m_cmd.Parameters.Add("TraCuuKhachHang", SqlDbType.Bit).Value = _DecentralizationOject.TraCuuKhachHang;
m_cmd.Parameters.Add("LapBaoCaoThang", SqlDbType.Bit).Value = _DecentralizationOject.LapBaoCaoThang;
return(m_DecentralizationExecute.updateData(m_cmd) > 0);
}
private void LoadDecentralization()
{
DecentralizationDTO _decentralizationObject = new DecentralizationDTO();
DecentralizationBUS _decentralizationExecute = new DecentralizationBUS();
DataTable _decentralizationData = new DataTable();
_decentralizationObject.maChucVu = ucLogin.m_EmployeeObject.maChucVu;
_decentralizationData = _decentralizationExecute.getDecentralizationWithMaCV(_decentralizationObject);
if (_decentralizationData.Rows.Count <= 0)
{
ribpgBackupAndRestore.Enabled = true;
ribpgDecentralization.Enabled = true;
ribpgRegulation.Enabled = true;
ribpgbook.Enabled = true;
ribpgemployee.Enabled = true;
ribpgCustomer.Enabled = true;
ribgImportProduct.Enabled = true;
bbtnExportProduct.Enabled = true;
bbtnReceipts.Enabled = true;
bbtnBookSearch.Enabled = true;
bbtnEmployeeSearch.Enabled = true;
bbtnCustomerSearch.Enabled = true;
bbtnNoteSearch.Enabled = true;
bbtnSurvival.Enabled = true;
bbtnLiabilities.Enabled = true;
}
else
{
if (_decentralizationData.Rows[0][2].ToString().Equals("False"))
{
ribpgBackupAndRestore.Enabled = false;
ribpgDecentralization.Enabled = false;
}
if (_decentralizationData.Rows[0][3].ToString().Equals("False"))
{
ribpgRegulation.Enabled = false;
}
if (_decentralizationData.Rows[0][4].ToString().Equals("False"))
{
ribpgbook.Enabled = false;
}
if (_decentralizationData.Rows[0][5].ToString().Equals("False"))
{
ribpgemployee.Enabled = false;
}
if (_decentralizationData.Rows[0][6].ToString().Equals("False"))
{
ribpgCustomer.Enabled = false;
}
if (_decentralizationData.Rows[0][7].ToString().Equals("False"))
{
ribgImportProduct.Enabled = false;
}
if (_decentralizationData.Rows[0][8].ToString().Equals("False"))
{
bbtnExportProduct.Enabled = false;
}
if (_decentralizationData.Rows[0][9].ToString().Equals("False"))
{
bbtnReceipts.Enabled = false;
}
if (_decentralizationData.Rows[0][10].ToString().Equals("False"))
{
bbtnBookSearch.Enabled = false;
}
if (_decentralizationData.Rows[0][11].ToString().Equals("False"))
{
bbtnEmployeeSearch.Enabled = false;
}
if (_decentralizationData.Rows[0][12].ToString().Equals("False"))
{
bbtnCustomerSearch.Enabled = false;
}
if (_decentralizationData.Rows[0][13].ToString().Equals("False"))
{
bbtnNoteSearch.Enabled = false;
}
if (_decentralizationData.Rows[0][14].ToString().Equals("False"))
{
bbtnSurvival.Enabled = false;
bbtnLiabilities.Enabled = false;
}
}
}
public DataTable getDecentralizationWithMaCV(DecentralizationDTO _DecentralizationOject)
{
return(m_DecentralizationDAL.getDecentralizationWithMaCV(_DecentralizationOject));
}
public bool UpdateDecentralizationToDatabase(DecentralizationDTO _DecentralizationOject)
{
return(m_DecentralizationDAL.UpdateDecentralizationToDatabase(_DecentralizationOject));
}
public bool DeleteDecentralizationDataToDatabase(DecentralizationDTO _DecentralizationOject)
{
return(m_DecentralizationDAL.DeleteDecentralizationDataToDatabase(_DecentralizationOject));
}
public bool AddDecentralizationToDatabase(DecentralizationDTO _DecentralizationOject)
{
return(m_DecentralizationDAL.AddDecentralizationToDatabase(_DecentralizationOject));
}
public DecentralizationDAL(DecentralizationDTO _DecentralizationOject)
{
this.m_DecentralizationObject = _DecentralizationOject;
this.m_DecentralizationExecute = new CDataExecute();
this.m_cmd = new SqlCommand();
}
public DecentralizationDAL()
{
m_DecentralizationObject = null;
m_DecentralizationExecute = new CDataExecute();
m_cmd = new SqlCommand();
}
