static Common() { server0 = "LAPTOP-U7HEJ86K"; database0 = "QLVT"; userid0 = "QLVT_HTKN"; password0 = "123"; LoaiHangDataTable = new QLVTDataSet.LoaiHangDataTable(); NhanVienDataTable = new QLVTDataSet.NhanVienDataTable(); NhaCungCapDataTable = new QLVTDataSet.NhaCungCapDataTable(); MatHangDataTable = new QLVTDataSet.MatHangDataTable(); CTDatHangDataTable = new QLVTDataSet.CTDatHangDataTable(); KhoDataTable = new QLVTDataSet.KhoDataTable(); KhachHangDataTable = new QLVTDataSet.KhachHangDataTable(); CTHoaDonDataTable = new QLVTDataSet.CTHoaDonDataTable(); PhieuNhapDataTable = new QLVTDataSet.PhieuNhapDataTable(); CTPhieuNhapDataTable = new QLVTDataSet.CTPhieuNhapDataTable(); NhanVienTableAdapter = new QLVTDataSetTableAdapters.NhanVienTableAdapter(); NhanVienTableAdapter.Adapter.InsertCommand.CommandText = "INSERT INTO NhanVien (Ten,Ho,Phai,DiaChi,SoDienThoai,TrangThai,NgaySinh,ChiNhanhId)" + "VALUES(@Ten,@Ho,@Phai,@DiaChi,@SoDienThoai,@TrangThai,@NgaySinh,@ChiNhanhId)"; KhoTableAdapter = new QLVTDataSetTableAdapters.KhoTableAdapter(); KhoTableAdapter.Adapter.InsertCommand.CommandText = "IF(@KhoId < 0) INSERT INTO Kho (Ten,ViTri,ChiNhanhId) VALUES(@Ten,@ViTri,@ChiNhanhId) " + "ELSE INSERT INTO Kho (KhoId,Ten,ViTri,ChiNhanhId) VALUES(@KhoId,@Ten,@ViTri,@ChiNhanhId)"; KhachHangTableAdapter = new QLVTDataSetTableAdapters.KhachHangTableAdapter(); KhachHangTableAdapter.Adapter.InsertCommand.CommandText = "IF(@KhachHangId < 0) INSERT INTO KhachHang (Ten,SoDienThoai,DiaChi,ChiNhanhId) VALUES(@Ten,@SoDienThoai,@DiaChi,@ChiNhanhId)" + "ELSE INSERT INTO KhachHang (KhachHangId,Ten,SoDienThoai,DiaChi,ChiNhanhId) VALUES(@KhachHangId,@Ten,@SoDienThoai,@DiaChi,@ChiNhanhId)"; NhaCungCapTableAdapter = new QLVTDataSetTableAdapters.NhaCungCapTableAdapter(); NhaCungCapTableAdapter.Adapter.InsertCommand.CommandText = "IF(@NhaCungCapId < 0) INSERT INTO NhaCungCap (Ten,SoDienThoai,DiaChi) VALUES(@Ten,@SoDienThoai,@DiaChi)" + "ELSE INSERT INTO NhaCungCap (NhaCungCapId,Ten,SoDienThoai,DiaChi) VALUES(@NhaCungCapId,@Ten,@SoDienThoai,@DiaChi)"; LoaiHangTableAdapter = new QLVTDataSetTableAdapters.LoaiHangTableAdapter(); LoaiHangTableAdapter.Adapter.InsertCommand.CommandText = "IF(@LoaiHangId < 0) INSERT INTO LoaiHang (Ten) VALUES(@Ten)" + "ELSE INSERT INTO LoaiHang (LoaiHangId,Ten) VALUES(@LoaiHangId,@Ten)"; MatHangTableAdapter = new QLVTDataSetTableAdapters.MatHangTableAdapter(); MatHangTableAdapter.Adapter.InsertCommand.CommandText = "IF(@MatHangId < 0) INSERT INTO MatHang (Ten,DonViTinh,LoaiHangId) VALUES(@Ten,@DonViTinh,@LoaiHangId)" + "ELSE INSERT INTO MatHang (MatHangId,Ten,DonViTinh,LoaiHangId) VALUES(@MatHangId,@Ten,@DonViTinh,@LoaiHangId)"; DatHangTableAdapter = new QLVTDataSetTableAdapters.DatHangTableAdapter(); //DatHangTableAdapter.Adapter.InsertCommand.CommandText = // "IF(@DatHangId < 0) INSERT INTO DatHang (NhanVienId,NhaCungCapId,ThoiGian) VALUES(@NhanVienId,@NhaCungCapId)" // + "ELSE INSERT INTO DatHang (DatHangId,Ten,DonViTinh,LoaiHangId) VALUES(@DatHangId,@NhanVienId,@NhaCungCapId)"; CTDatHangTableAdapter = new QLVTDataSetTableAdapters.CTDatHangTableAdapter(); PhieuNhapTableAdapter = new QLVTDataSetTableAdapters.PhieuNhapTableAdapter(); PhieuNhapTableAdapter.Adapter.InsertCommand.CommandText = "INSERT INTO PhieuNhap (NhanVienId,KhoId,DatHangId) VALUES(@NhanVienId,@KhoId,@DatHangId)"; HoaDonTableAdapter = new QLVTDataSetTableAdapters.HoaDonTableAdapter(); //HoaDonTableAdapter.Adapter.InsertCommand.CommandText= "INSERT INTO HoaDon (NhanVienId,KhoId,DatHangId) VALUES(@NhanVienId,@KhoId,@DatHangId)"; CTHoaDonTableAdapter = new QLVTDataSetTableAdapters.CTHoaDonTableAdapter(); CTPhieuNhapTableAdapter = new QLVTDataSetTableAdapters.CTPhieuNhapTableAdapter(); }
//static AddPhieuNhap() //{ // if (signleton == null) // { // signleton = new AddPhieuNhap(); // } //} public AddPhieuNhap(string dhid) { this.dhId = dhid; InitializeComponent(); ViewModel d = new ViewModel(); dgKho.ItemsSource = Common.KhoDataTable; QLVTDataSet.CTDatHangDataTable dhs = new QLVTDataSet.CTDatHangDataTable(); DataTable tb = Common.CTDatHangDataTable.Select("DatHangId = " + dhId).CopyToDataTable(); if (tb.Rows.Count > 0) { dhs.Merge(tb); } dgCTDH.ItemsSource = dhs; dgCTPN.ItemsSource = ctpn = new QLVTDataSet.CTPhieuNhapDataTable(); d.Kho = dgKho.SelectedValue; this.DataContext = d; //ctpn.ColumnChanging += (e, v) => { // if (v.Row.RowState == DataRowState.Detached) // return; // id = v.Row["MatHangId"]; // old= v.Row["SoLuong"]; //}; bool change = false; ctpn.ColumnChanged += (e, v) => { if (v.Row.RowState == DataRowState.Detached || change) { return; } Object current, id; id = v.Row["MatHangId"]; current = v.Row["SoLuong"]; DataRow[] dataRows = ((QLVTDataSet.CTDatHangDataTable)dgCTDH.ItemsSource).Select("MatHangId = '" + id + "'"); if (dataRows.Length > 0) { int sl = (int)dataRows[0]["SoLuong"]; if (sl < ((int)current)) { change = true; v.Row["SoLuong"] = dataRows[0]["SoLuong"]; MessageBox.Show("Số lượng mặt hàng đang chọn không thể lớn hơn " + sl); } } change = false; }; //EventHandler eventHandler = (o, i) => { signleton = new AddPhieuNhap(); }; //this.Closed += eventHandler; }
private void txbVT_KeyUp(object sender, KeyEventArgs e) { QLVTDataSet.CTDatHangDataTable matHangs = new QLVTDataSet.CTDatHangDataTable(); try { DataTable table; int rs; if (int.TryParse(txbVT.Text, out rs)) { table = Common.CTDatHangDataTable.Select("MatHangId = " + rs).CopyToDataTable(); matHangs.Merge(table); dgCTDH.ItemsSource = matHangs; } } catch (Exception ex) { } }
private AddDatHang() { InitializeComponent(); ViewModel viewModel = new ViewModel(); this.DataContext = viewModel; dgNhaCungCap.ItemsSource = Common.NhaCungCapDataTable; dgMatHang.ItemsSource = Common.MatHangDataTable; dgCTDH.ItemsSource = ctdh = new QLVTDataSet.CTDatHangDataTable(); EventHandler eventHandler = (o, i) => { signleton = new AddDatHang(); }; this.Closed += eventHandler; //viewModel.NhaCungCap = dgNhaCungCap.SelectedValue; //viewModel.ChiTietDatHang = dgCTDH.SelectedValue; }
//private void btnEdit_Click(object sender, RoutedEventArgs e) //{ // if (dgContent.CurrentItem != null) // { // //tableLog.SetRowChange(((DataRowView)dgContent.CurrentItem).Row); // AddKho addKho = new AddKho(((DataRowView)dgContent.CurrentItem).Row); // addKho.dataGrid = this.dgContent; // addKho.Show(); // } // else // { // MessageBox.Show("Không có hàng nào được chọn!"); // } //} private void btnRemove_Click(object sender, RoutedEventArgs e) { if (dgContent.CurrentItem != null) { DataRow row = ((DataRowView)dgContent.CurrentItem).Row; string ms = "Đơn đặt hàng sau khi xóa sẻ không thể khôi phục. Bạn chắn chắn muốn xóa " + row["DatHangId"] + " ?"; System.Windows.Forms.DialogResult result = System.Windows.Forms.MessageBox.Show(ms, "Xóa đơn đặt hàng", System.Windows.Forms.MessageBoxButtons.YesNo); if (result == System.Windows.Forms.DialogResult.Yes) { try { QLVTDataSet.CTDatHangDataTable ctdh = new QLVTDataSet.CTDatHangDataTable(); DataTable dataTable = ((DataRow[])dgCTContent.ItemsSource).CopyToDataTable(); ctdh.Merge(dataTable); foreach (var r in ctdh) { r.Delete(); } Common.CTDatHangTableAdapter.Connection = Common.connection; Common.CTDatHangTableAdapter.Update(ctdh); ((DataRowView)dgContent.CurrentItem).Delete(); Common.DatHangTableAdapter.Connection = Common.connection; Common.DatHangTableAdapter.Update((QLVTDataSet.DatHangDataTable)dgContent.ItemsSource); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else if (result == System.Windows.Forms.DialogResult.No) { //no... } } else { MessageBox.Show("Không có hàng nào được chọn!"); } }
private void btnOk_Click(object sender, RoutedEventArgs e) { ForceValidation(); if (!Validation.GetHasError(dgNhaCungCap) && dgCTDH.Items.Count > 0) { DataRow ncc = ((DataRowView)dgNhaCungCap.SelectedItem).Row; string sql = "exec SP_DATHANG @NhanVien = " + Common.CurrentUser + " ,@NhaCungCap = " + ncc["NhaCungCapId"]; SqlCommand c = new SqlCommand(sql, Common.connection); if (Common.connection.State != ConnectionState.Open) { Common.connection.Open(); } SqlDataReader reader = c.ExecuteReader(); reader.Read(); String dhId = reader.GetValue(0).ToString(); reader.Close(); QLVTDataSet.CTDatHangDataTable datHangRows = (QLVTDataSet.CTDatHangDataTable)dgCTDH.ItemsSource; foreach (DataRow row in datHangRows.Rows) { row["DatHangId"] = dhId; } Common.CTDatHangTableAdapter.Connection = Common.connection; Common.CTDatHangTableAdapter.Update(datHangRows); DatHang.loadData(0); //this.Close(); dgCTDH.SelectedIndex = -1; dgNhaCungCap.SelectedIndex = -1; dgMatHang.SelectedIndex = -1; dgCTDH.ItemsSource = ctdh = new QLVTDataSet.CTDatHangDataTable(); MessageBox.Show("Đã thêm!"); } else if (dgCTDH.Items.Count == 0) { MessageBox.Show("Không được bỏ trống chi tiết đặt hàng."); } }