private void fRemoveUser()
{
if (grdNguoiDung.VisibleRowCount < 1)
{
Utils.showMessage("Danh sách người dùng trống", "Thông báo");
return;
}
string soid = grdNguoiDung.GetFocusedRowCellValue("soid").ToString();
string sql = String.Format(SQL_DELETE_ND, soid);
try
{
int result = MTSQLServer.getMTSQLServer().wExec(sql, null, false);
if (result == 1)
{
crud.GridForm_Loaded();
Utils.showMessage(Utils.SAVE_DB_OK, "Thông báo");
}
else
{
Utils.showMessage(Utils.ERR_UPDATE_DB, "Thông báo");
}
}
catch (Exception ex) { }
}
private void fdoSave()
{
String msg = "";
try
{
if (MTGlobal.MT_CURRENT_ACTION == "ADD" || MTGlobal.MT_CURRENT_ACTION == "EDIT")
{
DataTable dt = ((DataView)gvNhomQuyen.DataSource).Table;
if (MTSQLServer.getMTSQLServer().doSaveTable(SQLAdaptor, dt))
{
SysPar.SetGridReadOnly(true, gvNhomQuyen);
MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "SAVE");
setDataSourceNhomQuyen();
msg = Utils.SAVE_DB_OK;
}
else
{
msg = Utils.ERR_UPDATE_DB;
}
}
}
catch (Exception ex)
{
msg = ex.Message.ToString();
}
if (msg != "")
{
Utils.showMessage(msg, "Thông báo");
}
}
private void initInfoToEdit(string id)
{
string sql = string.Format("select * from HT_NGUOIDUNG where soid = '{0}'", id);
SQLAdaptor = MTSQLServer.getMTSQLServer().wAdapter(sql, null, false);
DSetMain = new DataSet();
SQLAdaptor.Fill(DSetMain, "HT_NGUOIDUNG");
DataTable dt = DSetMain.Tables["HT_NGUOIDUNG"];
int rowNumber = dt.Rows.Count;
if (rowNumber == 1)
{
string manv = dt.Rows[0].ItemArray[1].ToString();
string tk = dt.Rows[0].ItemArray[2].ToString();
string mk = dt.Rows[0].ItemArray[3].ToString();
oldPassword = mk;
string isSync = dt.Rows[0][10].ToString();
string kyhieu = dt.Rows[0].ItemArray[11].ToString();
for (int i = 0; i < dsNhanVien.Count; i++)
{
if (dsNhanVien[i].Manv.ToLower() == manv.ToLower())
{
cbxNhanVien.SelectedItem = dsNhanVien[i];
break;
}
}
txtUsername.Text = tk;
txtPassword.Text = mk;
txtRepeatPassword.Text = mk;
txtKyHieu.Text = kyhieu;
if (isSync.ToLower() == "true")
{
chkActive.IsChecked = true;
}
else
{
chkActive.IsChecked = false;
}
DataTable nhomQuyenDtb = this.getNhomQuyenByIdUser(id);
int size = nhomQuyenDtb.Rows.Count;
if (size == 1)
{
string maNhom = nhomQuyenDtb.Rows[0][1].ToString();
for (int i = 0; i < dsNhomQuyen.Count; i++)
{
if (dsNhomQuyen[i].manhom == maNhom)
{
cbxNhomQuyen.SelectedItem = dsNhomQuyen[i];
break;
}
}
}
}
}
private void loadGridChucNang()
{
String mSql = mSql = String.Format("select nqcn.soid as soid, nqcn.macn as macn, cn.chucnang as tencn, " +
"nqcn.them as them, nqcn.xoa as xoa, nqcn.sua as sua, nqcn.duyet as duyet, nqcn.[in] as [in]" +
" from HT_NHOMQUYEN_CHUCNANG nqcn left join DM_CHUCNANG cn on cn.macn = nqcn.macn" +
" where nqcn.manhom='{0}' order by manhom asc", nhomQuyenId);
tblSelected = MTSQLServer.getMTSQLServer().wRead(mSql, null, false);
grdChucNang.DataSource = tblSelected;
}
private void fdoAbort()
{
try
{
MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["HT_NHOMQUYEN_CHUCNANG"]);
SysPar.SetGridReadOnly(true, gvQuyenHan);
MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
}
catch { }
}
private void fdoAbort()
{
try
{
MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["DM_NHOMSP"]);
SysPar.SetGridReadOnly(true, gvNhomSanPham);
MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
}
catch { }
}
private void fdoAbort()
{
try
{
MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["DM_BANGGIA_CHITIET"]);
SysPar.SetGridReadOnly(true, gvBangGiaCT);
MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
}
catch { }
}
private void fdoAbort()
{
try
{
MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["DM_KHACHHANG"]);
SysPar.SetGridReadOnly(true, gvKhachHang);
MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
}
catch { }
}
private void initGridChucNang()
{
string sql = string.Format("select cn.* from DM_CHUCNANG cn where cn.macn not in (select nqcn.macn from HT_NHOMQUYEN_CHUCNANG nqcn where nqcn.manhom = '{0}')", this.nhomQuyenId);
SQLAdaptor = MTSQLServer.getMTSQLServer().wAdapter(sql, null, false);
DSetMain = new DataSet();
SQLAdaptor.Fill(DSetMain, "DM_CHUCNANG");
tblSrc = DSetMain.Tables["DM_CHUCNANG"];
grdChucNang.ItemsSource = tblSrc;
}
private void BindDataCT(String mPhieuID)
{
try
{
String mSql = String.Format("SELECT A.*,B.Tensp,B.Dvt,B.Quycach FROM NX_CHANHXECT A LEFT JOIN DM_SANPHAM B ON A.Masp=B.Masp WHERE Chanhxeid='{0}' order by Chanhxectid asc", mPhieuID);
DataTable oTblNXCT = new MTSQLServer().wRead(mSql, null, false);
grdPhieuCT.ItemsSource = oTblNXCT;
MTGlobal.SetGridReadOnly(grdPhieuCT, tblViewCT, true);
}
catch { }
}
private DataTable getNhomQuyenByIdUser(string idUser)
{
string sql = string.Format("select nq.* from HT_NHOMQUYEN nq left join HT_QUYENHAN qh on nq.soid = qh.soid_nhomquyen where qh.soid_nguoidung = '{0}'", id);
SQLAdaptor = MTSQLServer.getMTSQLServer().wAdapter(sql, null, false);
DSetMain = new DataSet();
SQLAdaptor.Fill(DSetMain, "HT_NHOMQUYEN");
DataTable dt = DSetMain.Tables["HT_NHOMQUYEN"];
return(dt);
}
private void fdoAbort()
{
DisableEditCode();
try
{
MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["DM_SANPHAM"]);
SysPar.SetGridReadOnly(true, gvSanPham);
MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
}
catch { }
}
private void fdoAbort()
{
try
{
currentUserId = "";
MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["HT_NGUOIDUNG"]);
SysPar.SetGridReadOnly(true, gvNguoiDung);
MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
}
catch { }
}
private void BindDataCT(String mPhieuID)
{
try
{
String mSql = String.Format("SELECT * FROM BH_PHIEUBHCT where Phieubhid='{0}' AND ISNULL(Quatang,0)=0 order by Phieubhctid ASC", mPhieuID);
DataTable oTblNXCT = new MTSQLServer().wRead(mSql, null, false);
grdPhieuCT.DataSource = oTblNXCT;
SysPar.SetGridReadOnly(true, gvPhieuCT);
}
catch { }
}
private void BindDataKM(String mPhieuID)
{
try
{
String mSql = String.Format("SELECT * FROM BH_PHIEUBHCT where Phieubhid='{0}' AND ISNULL(Quatang,0)=1 order by Phieubhctid ASC", mPhieuID);
DataTable oTblNXCT = new MTSQLServer().wRead(mSql, null, false);
grdPhieuKM.ItemsSource = oTblNXCT;
MTGlobal.SetGridReadOnly(grdPhieuKM, tblViewKM, true);
}
catch { }
}
private void BindDataCT(String mPhieuID)
{
try
{
String mSql = String.Format("SELECT * FROM TC_PHIEUTCCT where phieutcid='{0}' ORDER BY Phieutcctid asc", mPhieuID);
DataTable oTblNXCT = new MTSQLServer().wRead(mSql, null, false);
grdPhieuThuCT.DataSource = oTblNXCT;
SysPar.SetGridReadOnly(true, gvPhieuThuCT);
}
catch { }
}
private void BindDataCT(String mPhieuID)
{
try
{
String mSql = String.Format("SELECT * FROM NX_PHIEUNXCT where phieunxid='{0}' ORDER BY Phieunxctid asc", mPhieuID);
DataTable oTblNXCT = new MTSQLServer().wRead(mSql, null, false);
grdPhieuNXCT.ItemsSource = oTblNXCT;
MTGlobal.SetGridReadOnly(grdPhieuNXCT, tblViewNXCT, true);
}
catch { }
}
private void loadTaiKhoanToLookupEdit()
{
String mSql = String.Format("select * from DM_TAIKHOAN order by Matk asc");
otblTK = MTSQLServer.getMTSQLServer().wRead(mSql, null, false);
repositoryItemTKNo.DataSource = otblTK;
repositoryItemTKNo.ValueMember = "Matk";
repositoryItemTKNo.DisplayMember = "Matk";
repositoryItemTKNo.NullText = "";
colTKNo.ColumnEdit = repositoryItemTKNo;
colTKCo.ColumnEdit = repositoryItemTKNo;
}
private DataTable getProductByCode(string code)
{
string mSQL = "select * from DM_SANPHAM";
if (code.Length > 0)
{
mSQL += string.Format(" where UPPER(Masp) = '{0}' ", code.ToString().ToUpper());
}
DataTable dt = MTSQLServer.getMTSQLServer().wRead(mSQL, null, false);
return(dt);
}
private void fdoSave()
{
String msg = "";
try
{
if (MTGlobal.MT_CURRENT_ACTION == "ADD" || MTGlobal.MT_CURRENT_ACTION == "EDIT")
{
DataTable dt = ((DataView)gvQuyenHan.DataSource).Table;
DataTable tblNQCN = convertTableSelectedToTableNQCN(dt);
try
{
SqlParameter[] arrPara = new SqlParameter[3];
arrPara[0] = new SqlParameter("@nhomQuyenChucNangTbl", SqlDbType.Structured);
arrPara[0].Value = tblNQCN;
arrPara[1] = new SqlParameter("@nguoidung", SqlDbType.NVarChar, 50);
arrPara[1].Value = MTGlobal.MT_USER_LOGIN;
arrPara[2] = new SqlParameter("@ketqua", SqlDbType.NVarChar, 255);
arrPara[2].Direction = ParameterDirection.Output;
int iRs = MTSQLServer.getMTSQLServer().wExec("spHT_AddNhomQuyenChucNang", arrPara);
if (iRs == -1)
{
Utils.showMessage("Dữ liệu không thể cập nhật. Vui lòng kiểm tra lại.", "Thông báo");
//return;
}
else
{
Utils.showMessage("Dữ liệu cập nhật thành công.", "Thông báo");
this.Close();
}
}
catch (Exception ex)
{
Utils.showMessage("Lỗi kết nối cơ sở dữ liệu", "Thông báo");
return;
}
}
}
catch (Exception ex)
{
msg = ex.Message.ToString();
}
if (msg != "")
{
//System.Windows.MessageBox.Show(msg);
Utils.showMessage(msg, "Thông báo");
}
}
private void setDataSourceNhomQuyen()
{
try
{
String mSql = String.Format("select * from HT_NHOMQUYEN order by manhom");
otblSrcNhomQuyen = MTSQLServer.getMTSQLServer().wRead(mSql, null, false);
if (otblSrcNhomQuyen == null)
{
Utils.showMessage("Không thể đọc dữ liệu cần chọn...", "Thông báo");
return;
}
grdNhomQuyen.DataSource = otblSrcNhomQuyen;
SysPar.SetGridReadOnly(true, gvNhomQuyen);
}
catch (Exception ex) { }
}
private void setDataSourceNhomSanPham()
{
try
{
String mSql = String.Format("select Manhomspid,Manhom,Tennhom from DM_NHOMSP order by Manhom asc");
otblSrcNhomSanPham = MTSQLServer.getMTSQLServer().wRead(mSql, null, false);
if (otblSrcNhomSanPham == null)
{
Utils.showMessage("Không thể đọc dữ liệu cần chọn...", "Thông báo");
return;
}
grdNhomSanPham.DataSource = otblSrcNhomSanPham;
SysPar.SetGridReadOnly(true, gvNhomSanPham);
}
catch (Exception ex) { }
}
private List <FunctionNode> initParents()
{
string sql = string.Format("select cn.* from DM_CHUCNANG cn " +
"where (cn.macn not in (select nqcn.macn " +
"from HT_NHOMQUYEN_CHUCNANG nqcn " +
"where nqcn.manhom = '{0}') " +
"or cn.macn in (select distinct a.macnroot " +
"from DM_CHUCNANG a " +
"where a.macnroot is not null " +
"and a.macn not in (select nqcn.macn " +
"from HT_NHOMQUYEN_CHUCNANG nqcn " +
" where nqcn.manhom = '{0}'))) " +
"and macnroot is null", this.nhomQuyenId);
if (removeFunctionIds != "")
{
sql = string.Format("select cn.* from DM_CHUCNANG cn " +
"where (cn.macn not in (select nqcn.macn " +
"from HT_NHOMQUYEN_CHUCNANG nqcn " +
"where nqcn.manhom = '{0}') " +
"or cn.macn in (select distinct a.macnroot " +
"from DM_CHUCNANG a " +
"where a.macnroot is not null " +
"and a.macn not in (select nqcn.macn " +
"from HT_NHOMQUYEN_CHUCNANG nqcn " +
" where nqcn.manhom = '{0}'))) " +
"or cn.macn in ({1}) and macnroot is null", this.nhomQuyenId, removeFunctionIds);
//sql = string.Format("select cn.* from DM_CHUCNANG cn where cn.macn not in (select nqcn.macn from HT_NHOMQUYEN_CHUCNANG nqcn where nqcn.manhom = '{0}') or cn.macn in ({1}) and macnroot is null", this.nhomQuyenId, removeFunctionIds);
}
SQLAdaptor = MTSQLServer.getMTSQLServer().wAdapter(sql, null, false);
DSetMain = new DataSet();
SQLAdaptor.Fill(DSetMain, "DM_CHUCNANG");
DataTable dt = DSetMain.Tables["DM_CHUCNANG"];
List <FunctionNode> parents = new List <FunctionNode>();
foreach (DataRow rw in dt.Rows)
{
FunctionNode parent = new FunctionNode();
parent.macn = rw["macn"].ToString();
parent.chucnang = rw["chucnang"].ToString();
parents.Add(parent);
}
return(parents);
}
private void setDataSourceBangGia()
{
try
{
String mSql = String.Format("select Banggiaid,Banggia,Tungay,Denngay,Ngayapdung,Apdung from DM_BANGGIA order by Banggiaid asc");
otblSrcBangGia = MTSQLServer.getMTSQLServer().wRead(mSql, null, false);
if (otblSrcBangGia == null)
{
Utils.showMessage("Không thể đọc dữ liệu cần chọn...", "Thông báo");
return;
}
grdBangGia.DataSource = otblSrcBangGia;
SysPar.SetGridReadOnly(true, gvBangGia);
}
catch (Exception ex) { }
}
private DataRow getChucNangByCode(string macn)
{
if (macn == "")
{
return(null);
}
string sql = string.Format("select cn.* from DM_CHUCNANG cn where cn.macn ='{0}'", macn);
SQLAdaptor = MTSQLServer.getMTSQLServer().wAdapter(sql, null, false);
DSetMain = new DataSet();
SQLAdaptor.Fill(DSetMain, "DM_CHUCNANG");
DataTable dt = DSetMain.Tables["DM_CHUCNANG"];
if (dt.Rows.Count < 0)
{
return(null);
}
return(dt.Rows[0]);
}
private void initChildForParent()
{
string sql = string.Format("select cn.* from DM_CHUCNANG cn where cn.macn not in (select nqcn.macn from HT_NHOMQUYEN_CHUCNANG nqcn where nqcn.manhom = '{0}') and macnroot is not null", this.nhomQuyenId);
if (removeFunctionIds != "")
{
sql = string.Format("select cn.* from DM_CHUCNANG cn where cn.macn not in (select nqcn.macn from HT_NHOMQUYEN_CHUCNANG nqcn where nqcn.manhom = '{0}') or cn.macn in ({1}) and macnroot is not null", this.nhomQuyenId, removeFunctionIds);
}
SQLAdaptor = MTSQLServer.getMTSQLServer().wAdapter(sql, null, false);
DSetMain = new DataSet();
SQLAdaptor.Fill(DSetMain, "DM_CHUCNANG");
DataTable dt = DSetMain.Tables["DM_CHUCNANG"];
foreach (FunctionNode parent in trees)
{
getChildsForParent(parent, dt);
}
}
public DM_SanPham()
{
InitializeComponent();
MTButton.cmdAdd = this.cmdAdd;
MTButton.cmdEdit = this.cmdEdit;
MTButton.cmdDel = this.cmdDel;
MTButton.cmdSave = this.cmdSave;
MTButton.cmdAbort = this.cmdAbort;
MTGlobal.SetFormatGridControl(grdProduct, tblView);
MTGlobal.SetFormatGridControl(grdProductGroup, tblViewGrp);
crud = new CRUDHandling(grdProduct, tblView, colMasp, MTROLE, MTButton, TABLE_NAME, ID_NAME, CODE_NAME,
CODE_HEADER, String.Format(SQL_LOAD_ALL_SP, mNhomspid), SQL_DELETE_SP);
//LOAD PRODUCT GROUP
DataTable otblNhomSP = new MTSQLServer().wRead(SQL_PRODUCT_GROUP, null, false);
grdProductGroup.ItemsSource = otblNhomSP;
MTGlobal.SetGridReadOnly(grdProductGroup, tblViewGrp, true);
}
private void btnImport_Click(object sender, EventArgs e)
{
if (tblSelected.Rows.Count == 0)
{
Utils.showMessage("Vui lòng chọn chức năng", "Thông báo", "MSG");
return;
}
this.convertTableSelectedToTableNQCN();
try
{
String sql = String.Format("DELETE HT_NHOMQUYEN_CHUCNANG where manhom = '{0}'", nhomQuyenId);
int result = MTSQLServer.getMTSQLServer().wExec(sql, null, false);
SqlParameter[] arrPara = new SqlParameter[3];
arrPara[0] = new SqlParameter("@nhomQuyenChucNangTbl", SqlDbType.Structured);
arrPara[0].Value = tblNQCN;
arrPara[1] = new SqlParameter("@nguoidung", SqlDbType.NVarChar, 50);
arrPara[1].Value = MTGlobal.MT_USER_LOGIN;
arrPara[2] = new SqlParameter("@ketqua", SqlDbType.NVarChar, 255);
arrPara[2].Direction = ParameterDirection.Output;
int iRs = MTSQLServer.getMTSQLServer().wExec("spHT_AddNhomQuyenChucNang", arrPara);
if (iRs == -1)
{
Utils.showMessage("Dữ liệu không thể cập nhật. Vui lòng kiểm tra lại.", "Thông báo");
//return;
}
else
{
Utils.showMessage("Dữ liệu cập nhật thành công.", "Thông báo");
this.Close();
}
}
catch (Exception ex)
{
Utils.showMessage("Lỗi kết nối cơ sở dữ liệu", "Thông báo");
return;
}
}
private void setDataSourceND()
{
try
{
String mSql = String.Format("select nd.* from HT_NGUOIDUNG nd LEFT JOIN HT_QUYENHAN qh ON qh.soid_nguoidung = nd.soid where qh.soid_nhomquyen = '{0}' order by nd.manv asc", nhomQuyenID);
otblSrcND = MTSQLServer.getMTSQLServer().wRead(mSql, null, false);
SQLAdaptor = MTSQLServer.getMTSQLServer().wAdapter(mSql, null, false);
DSetMain = new DataSet();
SQLAdaptor.Fill(DSetMain, "HT_NGUOIDUNG");
if (otblSrcND == null)
{
Utils.showMessage("Không thể đọc dữ liệu cần chọn...", "Thông báo");
return;
}
grdNguoiDung.DataSource = otblSrcND;
SysPar.SetGridReadOnly(true, gvNguoiDung);
}
catch (Exception ex) { }
}
private void setDataSourceLyDo()
{
try
{
String mSql = String.Format("select Mald,Lydo,Loai,TKNo,TKCo,Ghichu from DM_LYDO order by Mald asc");
otblSrcLyDo = MTSQLServer.getMTSQLServer().wRead(mSql, null, false);
SQLAdaptor = MTSQLServer.getMTSQLServer().wAdapter(mSql, null, false);
DSetMain = new DataSet();
SQLAdaptor.Fill(DSetMain, "DM_LYDO");
if (otblSrcLyDo == null)
{
Utils.showMessage("Không thể đọc dữ liệu cần chọn...", "Thông báo");
return;
}
grdLyDo.DataSource = otblSrcLyDo;
SysPar.SetGridReadOnly(true, gvLyDo);
}
catch (Exception ex) { }
}
