private void btnDonHang_Click(object sender, EventArgs e) // Lap don hang` { try { int numberRow = gridView3.RowCount; if (numberRow == 0) { MessageBox.Show("Nhập chị tiết đơn hàng của bạn"); return; } for (int i = 0; i < numberRow; i++) { string maddh = labelDDH.Text.ToString(); string mavt = gridView3.GetRowCellValue(i, gridView3.Columns[1]).ToString(); string soluong = gridView3.GetRowCellValue(i, gridView3.Columns[3]).ToString(); string maNV = Access.MANV.ToString(); string nhacc = gridView3.GetRowCellValue(i, gridView3.Columns[4]).ToString(); string makho = gridView3.GetRowCellValue(i, gridView3.Columns[5]).ToString(); string[] param = { maddh, mavt, soluong, maNV, makho, nhacc }; DonDH dondh = new DonDH(); int x = dondh.Create_DonHang(param); if (x == 0 && i == (numberRow - 1)) // vong lap cuoi cung x =0 { MessageBox.Show("Thêm Đơn đặt hàng " + labelDDH.Text + " thành công"); loadDDH(); loadChiTiet_DDH(); EventHandleFor_btnHUY(); } } } catch { MessageBox.Show("Them DDH that bai"); } }
private void btnThietLapDDH_Click(object sender, EventArgs e) // bat dau lap don dat hang tren kho va tu nha cung cap nao` { bool makho = f.CheckNullValueCBox(mAKHOComboBox); bool tenkho = f.CheckNullValueCBox(tENKHOComboBox); bool nhacc = f.CheckNullValueCBox(cBoxNhaCC); if (makho && tenkho && nhacc) { tBoxSoluong.Enabled = true; btnThem.Enabled = true; cBoxNhaCC.Enabled = false; mAKHOComboBox.Enabled = false; tENKHOComboBox.Enabled = false; btnThietLapDDH.Visible = false; btnHuy.Visible = true; gridView3.OptionsBehavior.Editable = true; DonDH dondh = new DonDH(); maDDH = dondh.getMaDDH(); maDDH.Read(); labelDDH.Text = maDDH["MADDH"].ToString(); maDDH.Close(); } }
private void loadDDH() // load don dat hang { DonDH dondh = new DonDH(); ddh = dondh.getDonDatHang(); sP_DS_DONDATHANGGridControl.DataSource = ddh; sP_DS_DONDATHANGGridControl.DataMember = ddh.TableName; }
private void loadKho() { DonDH dondh = new DonDH(); kho = dondh.getKho(); sP_LAYKHOGridControl.DataSource = kho; sP_LAYKHOGridControl.DataMember = kho.TableName; }
private void btnDonHang_Click(object sender, EventArgs e) // Lap don hang` { try { int numberRow = gridView3.RowCount; if (numberRow == 0) { MessageBox.Show("Nhập chị tiết đơn hàng của bạn"); return; } string maddh = labelDDH.Text.ToString(); string maNV = Access.MANV.ToString(); string strXML = "<Root>"; for (int i = 0; i < numberRow; i++) { strXML += "<DonDH MasoDDH = \"" + maddh; strXML += "\" MAVT = \"" + gridView3.GetRowCellValue(i, gridView3.Columns[1]).ToString(); strXML += "\" SOLUONG = \"" + gridView3.GetRowCellValue(i, gridView3.Columns[3]).ToString(); strXML += "\" DONGIA = \"" + gridView3.GetRowCellValue(i, gridView3.Columns[6]).ToString(); strXML += "\" MANV = \"" + maNV; strXML += "\" MAKHO = \"" + gridView3.GetRowCellValue(i, gridView3.Columns[5]).ToString(); strXML += "\" NHACC = \"" + gridView3.GetRowCellValue(i, gridView3.Columns[4]).ToString(); strXML += "\" />"; } strXML += "</Root>"; string[] param = { strXML }; if (strXML == "<Root></Root>") { MessageBox.Show("Thiếu dữ liệu", "Thông Báo"); return; } else { try { DonDH dondh = new DonDH(); int x = dondh.Create_DonHang(param); if (x == 0) // vong lap cuoi cung x =0 { MessageBox.Show("Thêm Đơn đặt hàng " + labelDDH.Text + " thành công"); loadDDH(); loadChiTiet_DDH(); EventHandleFor_btnHUY(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } catch { MessageBox.Show("Them DDH that bai"); } }
private void load_kho() // load kho { DonDH dondh = new DonDH(); kho = dondh.getKho(); foreach (DataRow dr in kho.Rows) { ListKho ckho = new ListKho() // dua gia tri datarow vao array cua ckkho { MaKho = dr[0].ToString(), TenKho = dr[1].ToString(), MaCN = dr[2].ToString(), }; cnnkho.Add(ckho); // add array vao mang cnnkho } }
// ADDD CoLumns vao datatable chitietDDH---------------------------------------------------------------------------------------------------------- // Cac function load khi moi bat dau mo page----------------------------------------------------------------------------------------------- private void load_nhacungcap() { DonDH dondh = new DonDH(); // goi toi model DonDH nhacungcap = dondh.getNhacungcap(); // goi function trong MODEL DonDH foreach (DataRow dr in nhacungcap.Rows) //doc tung gia tri vao Datarow { ListNhacungcap cnhacungcap = new ListNhacungcap() // dua vao array { MaNCC = dr[0].ToString(), TenNCC = dr[1].ToString(), Diachi_NCC = dr[2].ToString(), SDT_NCC = dr[3].ToString(), }; cnnNhacungcap.Add(cnhacungcap); // add array vao cmd_Nhacungcap } }
private void loadChiTiet_DDH() // load Chitiet DDH { DataRow row = gridView1.GetFocusedDataRow(); string[] param = { row["MasoDDH"].ToString() }; DonDH dondh = new DonDH(); ddh = dondh.getChiTietDonDatHang(param); if (ddh == null) { sP_DS_CHITIET_DONDATHANGGridControl.DataSource = null; } else { sP_DS_CHITIET_DONDATHANGGridControl.DataSource = ddh; sP_DS_CHITIET_DONDATHANGGridControl.DataMember = ddh.TableName; } }
private void dgvDonDH_Click(object sender, EventArgs e) //R { int vitri = dgvDonDH.CurrentRow.Index; List <DonDH> list = DonDHClient.HienThiDonDH().ToList(); ddh = list[vitri]; txtHoTenKH.Text = ddh.HoTenKH; txtDiaChi.Text = ddh.DiaChi; txtDienThoai.Text = ddh.DienThoai; txtEmail.Text = ddh.Email; txtGhiChu.Text = ddh.GhiChu; cbTinhTrang.SelectedItem = ddh.TinhTrang; string madondh = dgvDonDH.CurrentRow.Cells[1].Value.ToString(); ctddh.MaDonDH = madondh; Ds_CtDonDH(ctddh); }
//R private void dgvDonDH_Click(object sender, EventArgs e) { int vitri = dgvDonDH.CurrentRow.Index; List<DonDH> list = DonDHClient.HienThiDonDH().ToList(); ddh = list[vitri]; txtHoTenKH.Text = ddh.HoTenKH; txtDiaChi.Text = ddh.DiaChi; txtDienThoai.Text = ddh.DienThoai; txtEmail.Text = ddh.Email; txtGhiChu.Text = ddh.GhiChu; cbTinhTrang.SelectedItem = ddh.TinhTrang; string madondh = dgvDonDH.CurrentRow.Cells[1].Value.ToString(); ctddh.MaDonDH = madondh; Ds_CtDonDH(ctddh); }