Exemplo n.º 1
0
        private void setDataSourceQuyenHan(String nhomQuyenID)
        {
            try
            {
                String mSql = String.Format("select nqcn.soid as soid, nqcn.macn as macn, cn.chucnang as chucnang, " +
                                            "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" +
                                            " order by manhom asc");

                if (nhomQuyenID != null && nhomQuyenID.Length > 0)
                {
                    mSql = String.Format("select nqcn.soid as soid, nqcn.macn as macn, cn.chucnang as chucnang, " +
                                         "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);
                }
                otblSrcQuyenHan = MTSQLServer.getMTSQLServer().wRead(mSql, null, false);
                SQLAdaptor      = MTSQLServer.getMTSQLServer().wAdapter(mSql, null, false);
                DSetMain        = new DataSet();
                SQLAdaptor.Fill(DSetMain, "HT_NHOMQUYEN_CHUCNANG");
                if (otblSrcQuyenHan == null)
                {
                    Utils.showMessage("Không thể đọc dữ liệu cần chọn...", "Thông báo");
                    return;
                }

                grdQuyenHan.DataSource = otblSrcQuyenHan;
                SysPar.SetGridReadOnly(true, gvQuyenHan);
            }
            catch (Exception ex) { }
        }
Exemplo n.º 2
0
        private void fdoAdd()
        {
            try
            {
                int mMM = int.Parse(Convert.ToDateTime(pDenNgay).Month.ToString().PadLeft(2, '0'));
                int mYY = int.Parse(Convert.ToDateTime(pDenNgay).Year.ToString());
                pPhieuID        = MTGlobal.GetNewID();
                txtSophieu.Text = MTGlobal.GetSophieu(MTGlobal.MT_KYHIEU_CUAHANG, pLoaiPhieu, mMM, mYY, MTGlobal.MT_USER_LOGIN).ToString();
                dtpNgaylap.Text = DateTime.Now.ToShortDateString();
                dtpNgayPS.Text  = DateTime.Now.ToShortDateString();

                BindData();
                if (SysPar.SetGridReadOnly(false, gvPhieu))
                {
                    gvPhieu.OptionsView.NewItemRowPosition = NewItemRowPosition.Bottom;
                    gvPhieu.FocusedRowHandle = GridControl.NewItemRowHandle;
                    gvPhieu.FocusedColumn    = gvPhieu.Columns[0];
                    gvPhieu.ShowEditor();
                }

                setReadOnly(false);
                MTGlobal.SetToolStripButtonAction(pACT_ROLE, MTButton, "ADD");
                txtSophieu.Focus();
                isEdit = true;
            }
            catch (Exception ex) { Utils.showMessage(ex.Message.ToString(), "Thông báo lỗi"); }
        }
Exemplo n.º 3
0
        private void frmMain_Load(object sender, EventArgs e)
        {
            SysPar.SetFormatGridControl(grdSanpham, gvSanpham);
            SysPar.SetFormatGridControl(grdSanphamc, gvSanphamc);

            setDataSource();
            try
            {
                spinSoluong.Text = SysPar.MT_BARCODE_COPYNO.ToString();
                if (SysPar.MT_DEFAULT_TYPE == "QR")
                {
                    chkQR.Checked = true;
                }
                else
                {
                    chkQR.Checked = false;
                }
                if (SysPar.MT_DEFAUL_TEM_ROW == 3)
                {
                    cbMautem.SelectedIndex = 0;
                }
                else
                {
                    cbMautem.SelectedIndex = 1;
                }
            }
            catch { }
        }
Exemplo n.º 4
0
        public TC_PhieuThuFrm(String mPhieuTCID, String mLoaiPhieu, String mTuNgay, String mDenNgay,
                              MTGlobal.MT_ROLE mActRole, bool isAddNew = false)
        {
            InitializeComponent();
            this.pPhieuTCID = mPhieuTCID;
            this.pTuNgay    = mTuNgay == "" ? DateTime.Now.ToShortDateString() : mTuNgay;
            this.pDenNgay   = mDenNgay == "" ? DateTime.Now.ToShortDateString() : mDenNgay;
            this.pLoaiPhieu = mLoaiPhieu;
            this.pACT_ROLE  = mActRole;

            lblTitle.Text     = mLoaiPhieu == MTGlobal.PT ? "Phiếu thu - " + MTGlobal.RPT_COMPANY : "Phiếu chi - " + MTGlobal.RPT_COMPANY;
            lblTitleText.Text = mLoaiPhieu == MTGlobal.PT ? "Phiếu thu" : "Phiếu chi";

            Dlg = Utils.shwWait();

            setUserRight();
            loadCustomerToLookupEdit();
            loadLydoToLookupEdit();
            loadNhanVienToLookupEdit();
            loadTaiKhoanToLookupEdit();
            if (isAddNew)
            {
                fdoAdd();
            }
            else
            {
                BindData();
                SysPar.SetGridReadOnly(true, gvPhieuThuCT);
                setReadOnly(true);
            }

            Utils.closeWait(Dlg);
        }
Exemplo n.º 5
0
        private void setDataSourceSanPham(String Manhomspid)
        {
            try
            {
                String mSql = String.Format("select Maspid,Masp,Tensp,Dvt,Quycach,Quydoikgl,Quydoithung,Maqrcode,Mabarcode from DM_SANPHAM order by Masp asc");

                if (Manhomspid != null && Manhomspid.Length > 0)
                {
                    mSql = String.Format("select Maspid,Manhomspid,Masp,Tensp,Dvt,Quycach,Quydoikgl,Quydoithung,Maqrcode,Mabarcode from DM_SANPHAM where Manhomspid ='{0}' order by Masp asc", Manhomspid);
                }
                otblSrcSanPham = MTSQLServer.getMTSQLServer().wRead(mSql, null, false);
                SQLAdaptor     = MTSQLServer.getMTSQLServer().wAdapter(mSql, null, false);
                DSetMain       = new DataSet();
                SQLAdaptor.Fill(DSetMain, "DM_SANPHAM");
                DataTable dt = DSetMain.Tables["DM_SANPHAM"];
                if (otblSrcSanPham == null)
                {
                    Utils.showMessage("Không thể đọc dữ liệu cần chọn...", "Thông báo");
                    return;
                }

                grdSanPham.DataSource = otblSrcSanPham;
                SysPar.SetGridReadOnly(true, gvSanPham);
            }
            catch (Exception ex) { }
        }
Exemplo n.º 6
0
        public NX_PhieuXuat(String mPhieuNXID, String mLoaiPhieu, String mTuNgay, String mDenNgay, MTGlobal.MT_ROLE mActRole, bool isAddNew = false)
        {
            InitializeComponent();
            this.lblTitle.Text = "Phiếu xuất kho - " + MTGlobal.RPT_COMPANY;
            this.pPhieuNXID    = mPhieuNXID;
            this.pTuNgay       = mTuNgay == "" ? DateTime.Now.ToShortDateString() : mTuNgay;
            this.pDenNgay      = mDenNgay == "" ? DateTime.Now.ToShortDateString() : mDenNgay;
            this.pLoaiPhieu    = mLoaiPhieu;
            this.pACT_ROLE     = mActRole;

            Dlg = Utils.shwWait();
            setUserRight();
            loadWarehourseToLookupEdit();
            loadCustomerToLookupEdit();
            loadLydoToLookupEdit();
            if (isAddNew)
            {
                fdoAdd();
            }
            else
            {
                BindData();
                SysPar.SetGridReadOnly(true, gvPhieuXuat);
                setReadOnly(true);
            }

            System.Threading.Thread oThreSP = new System.Threading.Thread(LoadSanPham);
            oThreSP.Start();

            Utils.closeWait(Dlg);
        }
Exemplo n.º 7
0
        private void fdoSave()
        {
            String msg = "";

            try
            {
                if (MTGlobal.MT_CURRENT_ACTION == "ADD" || MTGlobal.MT_CURRENT_ACTION == "EDIT")
                {
                    DataTable dt = ((DataView)gvNhomSanPham.DataSource).Table;
                    if (MTSQLServer.getMTSQLServer().doSaveTable(SQLAdaptor, dt))
                    {
                        SysPar.SetGridReadOnly(true, gvNhomSanPham);
                        MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "SAVE");
                        setDataSourceNhomSanPham();
                        msg = Utils.SAVE_DB_OK;
                    }
                    else
                    {
                        msg = Utils.ERR_UPDATE_DB;
                    }
                }
            }
            catch (Exception ex)
            {
                msg = ex.Message.ToString();
            }
            if (msg != "")
            {
                //System.Windows.MessageBox.Show(msg);
                Utils.showMessage(msg, "Thông báo");
            }
        }
Exemplo n.º 8
0
        private void setDataSource()
        {
            try{
                String mSql = "";
                if (chkQR.Checked)
                {
                    mSql = String.Format("select Maspid,Masp,Tensp,Dvt,Quycach,Macode=Maqrcode,cast ({0} as int) as Soluong, cast(0 as numeric(18,3)) as Dongia from DM_SANPHAM order by Masp asc", spinSoluong.Text.Trim());
                }
                else
                {
                    mSql = String.Format("select Maspid,Masp,Tensp,Dvt,Quycach,Macode=Mabarcode,cast ({0} as int) as Soluong, cast(0 as numeric(18,3)) as Dongia from DM_SANPHAM order by Masp asc", spinSoluong.Text.Trim());
                }
                otblSrc = MTSQLServer.getMTSQLServer().wRead(mSql, null, false);
                if (otblSrc == null)
                {
                    MessageBox.Show("Không thể đọc dữ liệu cần chọn...", "Thông báo");
                    return;
                }
                otblChon = otblSrc.Clone();

                grdSanpham.DataSource  = this.otblSrc;
                grdSanphamc.DataSource = this.otblChon;

                SysPar.SetGridReadOnly(true, gvSanpham);
                SysPar.SetGridReadOnly(false, gvSanphamc);
                //grdDSPhieuChon.Columns["Soluong"].ReadOnly = false;
                //grdDSPhieuChon.Columns["Soluong"].AllowFocus = true;
            }
            catch (Exception ex) { }
        }
Exemplo n.º 9
0
        private void setDataSourceBangGiaCT(String _bangGiaID)
        {
            try
            {
                String mSql = String.Format("select Banggiactid,Banggiaid,Maspid,Mavung,Masp,Tensp,Giagoc,Giasi,Giale,Ghichu from DM_BANGGIA_CHITIET order by Masp asc");

                if (_bangGiaID != null && _bangGiaID.Length > 0)
                {
                    mSql = String.Format("select Banggiactid,Banggiaid,Maspid,Mavung,Masp,Tensp,Giagoc,Giasi,Giale,Ghichu from DM_BANGGIA_CHITIET where Banggiaid='{0}' order by Masp asc", _bangGiaID);
                }

                otblSrcBangGiaCT = MTSQLServer.getMTSQLServer().wRead(mSql, null, false);
                SQLAdaptor       = MTSQLServer.getMTSQLServer().wAdapter(mSql, null, false);
                DSetMain         = new DataSet();
                SQLAdaptor.Fill(DSetMain, "DM_BANGGIA_CHITIET");
                if (otblSrcBangGiaCT == null)
                {
                    Utils.showMessage("Không thể đọc dữ liệu cần chọn...", "Thông báo");
                    return;
                }

                grdBangGiaCT.DataSource = otblSrcBangGiaCT;
                SysPar.SetGridReadOnly(true, gvBangGiaCT);
            }
            catch (Exception ex) { }
        }
Exemplo n.º 10
0
        public CX_PhieuCX(String mPhieuID, String mLoaiPhieu, String mTuNgay, String mDenNgay, MTGlobal.MT_ROLE mActRole, bool isAddNew = false)
        {
            InitializeComponent();

            this.pPhieuID   = mPhieuID;
            this.pTuNgay    = mTuNgay == "" ? DateTime.Now.ToShortDateString() : mTuNgay;
            this.pDenNgay   = mDenNgay == "" ? DateTime.Now.ToShortDateString() : mDenNgay;
            this.pLoaiPhieu = mLoaiPhieu;
            this.pACT_ROLE  = mActRole;

            Dlg = Utils.shwWait();
            setUserRight();
            loadCustomerToLookupEdit();
            loadCarToLookupEdit();
            if (isAddNew)
            {
                fdoAdd();
            }
            else
            {
                BindData();
                SysPar.SetGridReadOnly(true, gvPhieu);
                setReadOnly(true);
            }
            System.Threading.Thread oThreSP = new System.Threading.Thread(LoadSanPham);
            oThreSP.Start();

            Utils.closeWait(Dlg);
        }
Exemplo n.º 11
0
        private void BindData(bool isDetailOnly = false)
        {
            try
            {
                if (isDetailOnly)
                {
                    otblCXCT            = new MTSQLServer().wRead(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", pPhieuID), null, false);
                    grdPhieu.DataSource = otblCXCT;
                    SysPar.SetGridReadOnly(false, gvPhieu);
                }
                else
                {
                    txtTrongluong.Text  = "";
                    txtChiphi.Text      = "";
                    cbThanhtoan.Text    = "";
                    txtMadv.Text        = "";
                    txtTendonvi.Text    = "";
                    txtDienthoai.Text   = "";
                    txtDiachi.Text      = "";
                    txtSoxe.Text        = "";
                    txtLoaixe.Text      = "";
                    txtTaixe.Text       = "";
                    txtDienthoaiXe.Text = "";
                    txtGhichu.Text      = "";
                    if (pPhieuID != "")
                    {
                        String mSql = String.Format("SELECT * FROM NX_CHANHXE WHERE Chanhxeid='{0}'", pPhieuID);
                        otblCX = new MTSQLServer().wRead(mSql, null, false);
                        if (otblCX != null)
                        {
                            foreach (DataRow vR in otblCX.Rows)
                            {
                                txtSophieu.Text      = vR["Sophieu"].ToString();
                                dtpNgaylap.EditValue = vR["Ngayct"].ToString() != "" ? Convert.ToDateTime(vR["Ngayct"].ToString()).ToShortDateString() : "";
                                dtpNgayPS.EditValue  = vR["Ngayps"].ToString() != "" ? Convert.ToDateTime(vR["Ngayps"].ToString()).ToShortDateString() : "";

                                txtTrongluong.Text  = vR["Trongluong"].ToString();
                                txtChiphi.Text      = vR["Chiphi"].ToString();
                                cbThanhtoan.Text    = vR["HTThanhtoan"].ToString();
                                txtMadv.Text        = vR["Makh"].ToString();
                                txtTendonvi.Text    = vR["Tenkh"].ToString();
                                txtDienthoai.Text   = vR["Dienthoai"].ToString();
                                txtDiachi.Text      = vR["Diachi"].ToString();
                                txtSoxe.Text        = vR["Soxe"].ToString();
                                txtLoaixe.Text      = vR["Loaixe"].ToString();
                                txtTaixe.Text       = vR["Taixe"].ToString();
                                txtDienthoaiXe.Text = vR["Dienthoaixe"].ToString();
                                txtGhichu.Text      = vR["Ghichu"].ToString();
                            }
                        }
                    }

                    otblCXCT            = new MTSQLServer().wRead(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", pPhieuID), null, false);
                    grdPhieu.DataSource = otblCXCT;
                    SysPar.SetGridReadOnly(false, gvPhieu);
                }
            }
            catch { }
        }
Exemplo n.º 12
0
 private void fdoEdit()
 {
     if (SysPar.SetGridReadOnly(false, gvTichLuy))
     {
         gvTichLuy.Focus();
         gvTichLuy.FocusedColumn = colMasp;
         gvTichLuy.ShowEditor();
         MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "EDIT");
     }
 }
Exemplo n.º 13
0
 private void fdoEdit()
 {
     if (SysPar.SetGridReadOnly(false, gvNguoiDung))
     {
         gvNguoiDung.Focus();
         gvNguoiDung.FocusedColumn = colmanv;
         gvNguoiDung.ShowEditor();
         MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "EDIT");
     }
 }
Exemplo n.º 14
0
 private void fdoEdit()
 {
     if (SysPar.SetGridReadOnly(false, gvBangGia))
     {
         gvBangGia.Focus();
         gvBangGia.FocusedColumn = colBanggia;
         gvBangGia.ShowEditor();
         MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "EDIT");
     }
 }
Exemplo n.º 15
0
 private void fdoAbort()
 {
     try
     {
         MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["DM_BANGGIA_CHITIET"]);
         SysPar.SetGridReadOnly(true, gvBangGiaCT);
         MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
     }
     catch { }
 }
Exemplo n.º 16
0
 private void fdoAbort()
 {
     try
     {
         MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["DM_KHACHHANG"]);
         SysPar.SetGridReadOnly(true, gvKhachHang);
         MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
     }
     catch { }
 }
Exemplo n.º 17
0
 private void fdoAbort()
 {
     try
     {
         MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["HT_NHOMQUYEN_CHUCNANG"]);
         SysPar.SetGridReadOnly(true, gvQuyenHan);
         MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
     }
     catch { }
 }
Exemplo n.º 18
0
 private void fdoEdit()
 {
     if (SysPar.SetGridReadOnly(false, gvQuyenHan))
     {
         gvQuyenHan.Focus();
         gvQuyenHan.FocusedColumn = colthem;
         gvQuyenHan.ShowEditor();
         MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "EDIT");
     }
 }
Exemplo n.º 19
0
 private void fdoAbort()
 {
     try
     {
         MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["DM_NHOMSP"]);
         SysPar.SetGridReadOnly(true, gvNhomSanPham);
         MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
     }
     catch { }
 }
Exemplo n.º 20
0
 private void fdoEdit()
 {
     if (SysPar.SetGridReadOnly(false, gvNhomSanPham))
     {
         gvNhomSanPham.Focus();
         gvNhomSanPham.FocusedColumn = colManhom;
         gvNhomSanPham.ShowEditor();
         MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "EDIT");
     }
 }
Exemplo n.º 21
0
 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.DataSource = oTblNXCT;
         SysPar.SetGridReadOnly(true, gvPhieuCT);
     }
     catch { }
 }
Exemplo n.º 22
0
 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 { }
 }
Exemplo n.º 23
0
 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.DataSource = oTblNXCT;
         SysPar.SetGridReadOnly(true, gvPhieuNXCT);
     }
     catch { }
 }
Exemplo n.º 24
0
 private void fdoAbort()
 {
     try
     {
         currentUserId = "";
         MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["HT_NGUOIDUNG"]);
         SysPar.SetGridReadOnly(true, gvNguoiDung);
         MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
     }
     catch { }
 }
Exemplo n.º 25
0
 private void fdoAbort()
 {
     DisableEditCode();
     try
     {
         MTSQLServer.getMTSQLServer().Abort(SQLAdaptor, DSetMain.Tables["DM_SANPHAM"]);
         SysPar.SetGridReadOnly(true, gvSanPham);
         MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ABORT");
     }
     catch { }
 }
Exemplo n.º 26
0
        private void BindData()
        {
            try
            {
                cbNguyente.SelectedIndex = 0;
                txtTygia.Text            = "1";
                txtMaKho.Text            = "";
                txtTenkho.Text           = "";
                txtMadv.Text             = "";
                txtTendonvi.Text         = "";
                txtMald.Text             = "";
                txtLydo.Text             = "";
                txtNguoigiao.Text        = "";
                txtGhichu.Text           = "";

                if (pPhieuNXID != "")
                {
                    String mSql = String.Format("SELECT A.*,B.Tenkho,C.Tenkh,D.Lydo FROM NX_PHIEUNX A LEFT JOIN DM_KHO B ON A.Makho=B.Makho "
                                                + "LEFT JOIN DM_KHACHHANG C ON A.Makh=c.Makh  LEFT JOIN DM_LYDO D ON A.Mald=d.Mald " +
                                                " WHERE Phieunxid='{0}'", pPhieuNXID);

                    otblPNX = new MTSQLServer().wRead(mSql, null, false);
                    if (otblPNX != null)
                    {
                        foreach (DataRow vR in otblPNX.Rows)
                        {
                            txtSophieu.Text         = vR["Sophieu"].ToString();
                            dtpNgaylap.EditValue    = vR["Ngayct"].ToString() != "" ? Convert.ToDateTime(vR["Ngayct"].ToString()).ToShortDateString() : "";
                            dtpNgayPS.EditValue     = vR["Ngayps"].ToString() != "" ? Convert.ToDateTime(vR["Ngayps"].ToString()).ToShortDateString() : "";
                            txtSoctgoc.Text         = vR["Soctgoc"].ToString();
                            cbNguyente.SelectedText = vR["Loaitien"].ToString();
                            txtTygia.Text           = vR["Tygia"].ToString();
                            txtMaKho.Text           = vR["Makho"].ToString();
                            txtTenkho.Text          = vR["Tenkho"].ToString();
                            txtMadv.Text            = vR["Makh"].ToString();
                            txtTendonvi.Text        = vR["Tenkh"].ToString();
                            txtMald.Text            = vR["Mald"].ToString();
                            txtLydo.Text            = vR["Lydo"].ToString();
                            txtNguoigiao.Text       = vR["Giaonhan"].ToString();
                            txtGhichu.Text          = vR["Ghichu"].ToString();
                        }
                    }
                }

                otblPNXCT = new MTSQLServer().wRead(String.Format("SELECT * FROM NX_PHIEUNXCT where Phieunxid='{0}' ORDER BY Phieunxctid asc", pPhieuNXID), null, false);
                grdPhieuXuat.DataSource = otblPNXCT;
                SysPar.SetGridReadOnly(true, gvPhieuXuat);
            }
            catch { }
        }
Exemplo n.º 27
0
 private void fdoEdit()
 {
     setReadOnly(false);
     MTGlobal.SetToolStripButtonAction(pACT_ROLE, MTButton, "EDIT");
     isEdit = true;
     txtSophieu.Focus();
     if (SysPar.SetGridReadOnly(false, gvPhieu))
     {
         gvPhieu.OptionsView.NewItemRowPosition = NewItemRowPosition.Bottom;
         gvPhieu.FocusedRowHandle = GridControl.NewItemRowHandle;
         gvPhieu.FocusedColumn    = gvPhieu.Columns[0];
         gvPhieu.ShowEditor();
     }
 }
Exemplo n.º 28
0
        private void BindData()
        {
            cbNguyenTe.SelectedIndex = 0;
            txtMaDT.Text             = "";
            txtTenDoiTuong.Text      = "";
            txtHoTen.Text            = "";
            txtDiaChi.Text           = "";
            txtMaLD.Text             = "";
            txtLD.Text     = "";
            txtManv.Text   = "";
            txtTennv.Text  = "";
            txtGhiChu.Text = "";

            if (pPhieuTCID != "")
            {
                String mSql = String.Format("select A.*, B.Tenkh, B.Diachi, C.Lydo, C.TKNo, C.TKCo, D.Tennv from TC_PHIEUTC A left join DM_KHACHHANG B on A.Madt = B.Makh left join DM_LYDO C on A.Mald = C.Mald left join DM_NHANVIEN D on A.Mant = D.Manv where A.Phieutcid = '{0}'", pPhieuTCID);

                otblPTC = new MTSQLServer().wRead(mSql, null, false);

                if (otblPTC != null)
                {
                    foreach (DataRow vR in otblPTC.Rows)
                    {
                        txtSoPhieu.Text          = vR["Sophieu"].ToString();
                        txtMaDT.Text             = vR["Madt"].ToString();
                        txtTenDoiTuong.Text      = vR["Tenkh"].ToString();
                        txtDiaChi.Text           = vR["Diachi"].ToString();
                        txtHoTen.Text            = vR["Hoten"].ToString();
                        txtMaLD.Text             = vR["Mald"].ToString();
                        txtLD.Text               = vR["Lydo"].ToString();
                        txtManv.Text             = vR["Mant"].ToString();
                        txtTennv.Text            = vR["Tennv"].ToString();
                        txtGhiChu.Text           = vR["Ghichu"].ToString();
                        txtSoCT.Text             = vR["Soctgoc"].ToString();
                        txtNgayCT.EditValue      = vR["Ngayct"].ToString() != "" ? Convert.ToDateTime(vR["Ngayct"].ToString()).ToShortDateString() : "";
                        txtNgayPS.EditValue      = vR["Ngayps"].ToString() != "" ? Convert.ToDateTime(vR["Ngayps"].ToString()).ToShortDateString() : "";
                        cbNguyenTe.SelectedValue = vR["Loaitien"].ToString();
                        txtTyGia.Text            = vR["Tygia"].ToString();

                        TKNo = vR["TKNo"].ToString();
                        TKCo = vR["TKCo"].ToString();
                    }
                }
            }

            otblPTCCT = new MTSQLServer().wRead(String.Format("SELECT * FROM TC_PHIEUTCCT where Phieutcid='{0}' ORDER BY Phieutcctid asc", pPhieuTCID), null, false);
            grdPhieuThuCT.DataSource = otblPTCCT;
            SysPar.SetGridReadOnly(true, gvPhieuThuCT);
        }
Exemplo n.º 29
0
        private void fdoAdd()
        {
            if (SysPar.SetGridReadOnly(false, gvNguoiDung))
            {
                gvNguoiDung.AddNewRow();
                gvNguoiDung.OptionsView.NewItemRowPosition = NewItemRowPosition.Bottom;
                gvNguoiDung.FocusedRowHandle = GridControl.NewItemRowHandle;
                gvNguoiDung.FocusedColumn    = colmanv;
                gvNguoiDung.Focus();
                gvNguoiDung.ShowEditor();
                MTGlobal.SetToolStripButtonAction(MTROLE, MTButton, "ADD");
            }

            colmanv.OptionsColumn.AllowEdit = true;
        }
Exemplo n.º 30
0
 private void fdoEdit()
 {
     setReadOnly(false);
     MTGlobal.SetToolStripButtonAction(pACT_ROLE, MTButton, "EDIT");
     isEdit = true;
     txtMaDT.Focus();
     if (SysPar.SetGridReadOnly(false, gvPhieuThuCT))
     {
         gvPhieuThuCT.OptionsView.NewItemRowPosition = NewItemRowPosition.Bottom;
         //grdPhieuThuCT.DataSource = new modPhieuTC().dtPhieuTCCT();
         gvPhieuThuCT.FocusedRowHandle = GridControl.NewItemRowHandle;
         gvPhieuThuCT.FocusedColumn    = gvPhieuThuCT.VisibleColumns[0];
         gvPhieuThuCT.ShowEditor();
     }
 }