Example #1
0
        private void Loadfg()
        {
            fgQD.Tag = 0;
            fgQD.BeginUpdate();
            clsQD_NhapVatTu cls = new clsQD_NhapVatTu();
            DataTable       dt  = cls.SelectAllDayDu();

            dt.DefaultView.RowFilter = "TonTai = 1";

            int iSTT = 1;

            fgQD.Rows.Count = fgQD.Rows.Fixed;
            foreach (DataRow dr in dt.DefaultView.ToTable().Rows)
            {
                Row fgRow = fgQD.Rows.Add();
                fgRow["STT"] = iSTT;
                iSTT++;
                fgRow["ID_QuyetDinh"]   = dr["ID_QuyetDinh"];
                fgRow["So_QuyetDinh"]   = dr["So_QuyetDinh"];
                fgRow["ID_NhaCungCap"]  = dr["ID_NhaCungCap"];
                fgRow["Ten_NhaCungCap"] = dr["Ten_NhaCungCap"];
                fgRow["Ngay_QuyetDinh"] = dr["Ngay_QuyetDinh"];
                fgRow["NgayLap"]        = dr["NgayLap"];
                fgRow["Ngay_SuaCuoi"]   = dr["Ngay_SuaCuoi"];
                fgRow["TrangThai"]      = dr["TrangThai"];
                fgRow["Ten_TrangThai"]  = dr["Ten_TrangThai"];
                fgRow["TonTai"]         = dr["TonTai"];
                if (fgRow["Ten_TrangThai"].ToString() == "Đang lập")
                {
                    fgRow.Style = cs1;
                }
                if (fgRow["Ten_TrangThai"].ToString() == "Trình duyệt")
                {
                    fgRow.Style = cs2;
                }
                else if (fgRow["Ten_TrangThai"].ToString() == "Hủy duyệt")
                {
                    fgRow.Style = cs3;
                }
                else if (fgRow["Ten_TrangThai"].ToString() == "Phê duyệt")
                {
                    fgRow.Style = cs4;
                }
                else if (fgRow["Ten_TrangThai"].ToString() == "Ghi thẻ kho")
                {
                    fgRow.Style = cs5;
                }
            }

            fgQD.Row = -1;
            fgQD.AutoSizeRows();
            fgQD.EndUpdate();
            fgQD.Tag = 1;
        }