private void btnXoa_Click(object sender, System.EventArgs e) { DialogResult dg = BaseMessages.ShowQuestionMessage("Bạn có chắc chắn muốn xóa?"); if (dg == DialogResult.Yes) { try { clsPhieuXuat_ChiTiet cls0 = new clsPhieuXuat_ChiTiet(); cls0.ID_PhieuXuat = int.Parse(fgQDX[fgQDX.Row, "ID_PhieuXuat"].ToString()); cls0.DeleteWID_PhieuXuatLogic(); clsPhieuXuat_ChiTiet_TheKho cls1 = new clsPhieuXuat_ChiTiet_TheKho(); cls1.ID_PhieuXuat = int.Parse(fgQDX[fgQDX.Row, "ID_PhieuXuat"].ToString()); cls1.DeleteWID_PhieuXuatLogic(); clsQD_XuatVatTu cls = new clsQD_XuatVatTu(); cls.ID_PhieuXuat = int.Parse(fgQDX[fgQDX.Row, "ID_PhieuXuat"].ToString()); cls.Delete(); BaseMessages.ShowInformationMessage("Xóa thành công."); Loadfg(); } catch (Exception ex) { BaseMessages.ShowErrorMessage("Lỗi" + ex.ToString()); } } }
private void Duyet(string question, byte trangthai, string message) { if (fgQDX.Row < fgQDX.Rows.Fixed) { BaseMessages.ShowInformationMessage("Chưa chọn quyết định."); return; } if (MessageBox.Show(question, "Xác nhận", MessageBoxButtons.YesNo) == DialogResult.No) { return; } int fgRow = fgQDX.Row; byte previousTrangThai = Convert.ToByte(fgQDX[fgQDX.Row, "TrangThai"]); clsQD_XuatVatTu cls = new clsQD_XuatVatTu(); cls.ID_PhieuXuat = int.Parse(fgQDX.GetDataDisplay(fgQDX.Row, "ID_PhieuXuat")); cls.SelectOne(); cls.TrangThai = trangthai; cls.UpdateTrangThai(); BaseMessages.ShowInformationMessage(message); if (trangthai == (int)GlobalVariables.TrangThai.TrinhDuyet) { fgQDX[fgQDX.Row, "Ten_TrangThai"] = "Trình duyệt"; fgQDX[fgQDX.Row, "TrangThai"] = 1; fgQDX.Rows[fgQDX.Row].Style = cs2; } else if (trangthai == (int)GlobalVariables.TrangThai.HuyDuyet) { fgQDX[fgQDX.Row, "Ten_TrangThai"] = "Hủy duyệt"; fgQDX[fgQDX.Row, "TrangThai"] = 3; fgQDX.Rows[fgQDX.Row].Style = cs3; } else if (trangthai == (int)GlobalVariables.TrangThai.PheDuyet) { fgQDX[fgQDX.Row, "Ten_TrangThai"] = "Phê duyệt"; fgQDX[fgQDX.Row, "TrangThai"] = 5; cls.ID_PhieuXuat = int.Parse(fgQDX.GetDataDisplay(fgQDX.Row, "ID_PhieuXuat")); cls.Nguoi_PheDuyet = "Admin"; cls.UpdateNguoiPheDuyet(); fgQDX.Rows[fgQDX.Row].Style = cs4; } else if (trangthai == (int)GlobalVariables.TrangThai.GhiTheKho) { fgQDX[fgQDX.Row, "Ten_TrangThai"] = "Ghi thẻ kho"; fgQDX[fgQDX.Row, "TrangThai"] = 6; fgQDX.Rows[fgQDX.Row].Style = cs5; } LockEdit(true); Lock(false, false, false, false, false, false); fgQDX.Row = -1; txtSoPhieuXuat.ResetText(); fgChiTietXuat.Rows.Count = fgChiTietXuat.Rows.Fixed; //focus fgQDX.Row = fgRow; }
public void Loadfg() { fgQDX.Tag = 0; fgQDX.BeginUpdate(); clsQD_XuatVatTu cls = new clsQD_XuatVatTu(); DataTable dt = cls.SelectAllDayDu(); dt.DefaultView.RowFilter = "TonTai = 1"; int iSTT = 1; fgQDX.Rows.Count = fgQDX.Rows.Fixed; foreach (DataRow dr in dt.DefaultView.ToTable().Rows) { Row fgRow = fgQDX.Rows.Add(); fgRow["STT"] = iSTT; iSTT++; fgRow["ID_PhieuXuat"] = dr["ID_PhieuXuat"]; fgRow["ID_Kho"] = dr["ID_Kho"]; fgRow["Ten_kho"] = dr["Ten_kho"]; fgRow["So_PhieuXuat"] = dr["So_PhieuXuat"]; fgRow["Ngay_XuatKho"] = dr["Ngay_XuatKho"]; fgRow["Ngay_HachToan"] = dr["Ngay_HachToan"]; fgRow["Nguoi_Lap"] = dr["Nguoi_Lap"]; fgRow["Ngay_Lap"] = dr["Ngay_Lap"]; fgRow["Nguoi_PheDuyet"] = dr["Nguoi_PheDuyet"]; fgRow["Ngay_PheDuyet"] = dr["Ngay_PheDuyet"]; 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; } } fgQDX.Row = -1; fgQDX.AutoSizeRows(); fgQDX.EndUpdate(); fgQDX.Tag = 1; }
private void LoadTrangThai() { var cbo = cboTrangThai; cbo.Tag = 0; clsQD_XuatVatTu cls = new clsQD_XuatVatTu(); DataTable dt = cls.SelectAllDayDu(); dt = dt.DefaultView.ToTable(); //cbo.Properties.DataSource = dt; //cbo.Properties.DisplayMember = "Ten_TrangThai"; //cbo.Properties.ValueMember = "TrangThai"; //cbo.EditValue = 0; cbo.Tag = 1; }