public bool rule_mh(PhieuXuatHangDTO pxh) { string query = string.Empty; query += "Update [QuyDinh] set [QuyDinh].[matHangToiDa] = @soMatHang"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@soMatHang", pxh.soMatHang); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
public bool xoa_donVi(PhieuXuatHangDTO pxh) { string query = string.Empty; query += "Delete from [DonVi] where [DonVi].[donViTinh] = @donViTinh"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@donViTinh", pxh.donViTinh); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
public bool Xoa(PhieuXuatHangDTO pxh) { string query = string.Empty; query += "Delete [PhieuXuatHang] where [PhieuXuatHang].[maPhieuXuatHang] = @maPhieuXuat"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@maPhieuXuat", pxh.maPhieuXuat); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
//Phần truy xuất lấy giá trị riêng public void mh_combo_box(ComboBox box, PhieuXuatHangDTO pxh) { string query = string.Empty; query += "select [MatHang].[tenMatHang] from [MatHang] where [MatHang].[maDaiLy] = @maDaiLy"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@maDaiLy", pxh.maDaiLy); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { box.Items.Add(reader[0]); } con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); } } } }
public string getDonVi(PhieuXuatHangDTO pxh) { string donVi; donVi = pxhDAL.getDonViTinh(pxh); return(donVi); }
public string getName(PhieuXuatHangDTO pxh) { string name; name = pxhDAL.getTenDaiLy(pxh); return(name); }
public bool xoa_mh_all(PhieuXuatHangDTO pxh) { string query = string.Empty; query += "delete from [PhieuXuatHang] where [tenMatHang] = @tenMatHang "; query += "delete from [MatHang] where [tenMatHang] = @tenMatHang"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@tenMatHang", pxh.tenMatHang); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
public bool sua_donViToiDa(PhieuXuatHangDTO pxh) { string query = string.Empty; query += "update [QuyDinh] set [QuyDinh].[donViToiDa] = @donViToiDa"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@donViToiDa", pxh.donViToiDa); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
private void matHang_txt_Click(object sender, EventArgs e) { matHang_txt.Items.Clear(); if (maDaiLy_txt.Text.Trim().Length != 0) { PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); pxh.maDaiLy = int.Parse(maDaiLy_txt.Text); pxhBus.add_combo_mh(matHang_txt, pxh); } }
private void matHang_txt_SelectedIndexChanged(object sender, EventArgs e) { PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); if (matHang_txt.Text.Trim().Length > 0) { pxh.tenMatHang = matHang_txt.Text; donViTinh_txt.Text = pxhBus.getDonVi(pxh); donGia_txt.Text = pxhBus.getDonGia(pxh).ToString(); } }
private void sua_donViMax_Click(object sender, EventArgs e) { PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); pxh.donViToiDa = int.Parse(donViMax_txt.Text); bool kq = pxhBUS.donViToiDa(pxh); if (kq == true) { MessageBox.Show("Sửa Thành Công"); } else { MessageBox.Show("Sửa Thất Bại"); } }
public bool sua(PhieuXuatHangDTO pxh) { string query = string.Empty; query += "Update [PhieuXuatHang] Set "; query += "[maDaiLy] = @maDaiLy, "; query += "[ngayLapPhieuXuathang] = @ngayLapPhieuXuatHang, "; query += "[tenMatHang] = @tenMatHang, "; query += "[soLuong] = @soLuong, "; query += "[thanhTien] = @thanhTien, "; query += "[donViTinh] = @donViTinh, "; query += "[donGia] = @donGia "; query += "where [maPhieuXuathang] = @maPhieuXuatHang"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@maDaiLy", pxh.maDaiLy); cmd.Parameters.AddWithValue("@ngayLapPhieuXuatHang", pxh.ngayLapPhieu); cmd.Parameters.AddWithValue("@tenMatHang", pxh.tenMatHang); cmd.Parameters.AddWithValue("@soLuong", pxh.soLuong); cmd.Parameters.AddWithValue("@thanhTien", pxh.donGia * pxh.soLuong); cmd.Parameters.AddWithValue("@donViTinh", pxh.donViTinh); cmd.Parameters.AddWithValue("@donGia", pxh.donGia); cmd.Parameters.AddWithValue("@maPhieuXuathang", pxh.maPhieuXuat); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception Ex) { con.Close(); return(false); } } } return(true); }
private void xoa_btn_Click(object sender, EventArgs e) { PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); pxh.donViTinh = donVi_txt.Text; bool kq = pxhBUS.xoa_donVi(pxh); if (kq == true) { MessageBox.Show("Xóa thành công"); donViGrid.DataSource = pxhBUS.load_donVi(); } else { MessageBox.Show("Xóa thất bại"); } }
private void button3_Click(object sender, EventArgs e) { PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); pxh.soMatHang = int.Parse(matHangMax_txt.Text); bool kq = pxhBus.rule_mhMax(pxh); if (kq == true) { MessageBox.Show("Sửa thành công"); } else { MessageBox.Show("Sửa thất bại"); } }
private void button4_Click(object sender, EventArgs e) { PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); pxh.tenMatHang = matHang_txt.Text; pxh.donViTinh = donViTinh_txt.Text; pxh.donGia = int.Parse(donGia_txt.Text); bool kq = pxhBus.sua_mh(pxh); if (kq == true) { MessageBox.Show("Sửa thành công"); } else { MessageBox.Show("Sửa thất bại"); } }
private void button1_Click(object sender, EventArgs e) { PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); pxh.maDaiLy = int.Parse(maDaiLy_txt.Text); pxh.tenMatHang = matHang_txt.Text; pxh.donViTinh = donViTinh_txt.Text; pxh.donGia = int.Parse(donGia_txt.Text); bool kq = pxhBus.them_mh(pxh); if (kq == false) { MessageBox.Show("Thêm mặt hàng thất bại"); } else { MessageBox.Show("Thêm mặt hàng thành công"); } }
private void maDaiLy_txt_TextChanged(object sender, EventArgs e) { matHang_txt.Items.Clear(); PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); if (maDaiLy_txt.Text.Trim().Length > 0 && maDaiLy_txt.Text.Length > 0) { pxh.maDaiLy = int.Parse(maDaiLy_txt.Text); pxhBus.add_combo_mh(matHang_txt, pxh); tenDaiLy_txt.Text = pxhBus.getName(pxh); } else { tenDaiLy_txt.Text = string.Empty; tenDaiLy_txt.Clear(); donViTinh_txt.Clear(); donGia_txt.Clear(); matHang_txt.Text = string.Empty; } }
public bool Them(PhieuXuatHangDTO pxh) { string query = string.Empty; query += "Insert into [PhieuXuatHang]([maPhieuXuatHang], [maDaiLy], [ngayLapPhieuXuatHang],[tenMatHang],[donViTinh], [soLuong], [donGia], [thanhTien] )"; query += "values(@maPhieuXuatHang , @maDaiLy , @ngayLapPhieuXuatHang, @tenMatHang, " + "(select [MatHang].[donViTinh] from [MatHang] where [MatHang].[tenMatHang] = @tenMatHang ), " + "@soLuong, " + "(select [MatHang].[donGia] from [MatHang] where [MatHang].[tenMatHang] = @tenMatHang ), " + "@soLuong * (select [MatHang].[donGia] from [MatHang] where [MatHang].[tenMatHang] = @tenMatHang ))"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@maPhieuXuatHang", pxh.maPhieuXuat); cmd.Parameters.AddWithValue("@maDaiLy", pxh.maDaiLy); cmd.Parameters.AddWithValue("@ngayLapPhieuXuatHang", pxh.ngayLapPhieu); cmd.Parameters.AddWithValue("@tenMatHang", pxh.tenMatHang); cmd.Parameters.AddWithValue("@soLuong", pxh.soLuong); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
public bool sua_mh(PhieuXuatHangDTO pxh) { string query = string.Empty; query += "update [MatHang] "; query += "set [MatHang].[donViTinh] = @donViTinh , "; query += "[MatHang].[donGia] = @donGia "; query += "where [MatHang].[tenMatHang] = @tenMatHang"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@donViTinh", pxh.donViTinh); cmd.Parameters.AddWithValue("@donGia", pxh.donGia); cmd.Parameters.AddWithValue("@tenMatHang", pxh.tenMatHang); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
private void button2_Click(object sender, EventArgs e) { PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); pxh.tenMatHang = matHang_txt.Text; if ((maDaiLy_txt.Text.Length == 0) || (maDaiLy_txt.Text.Trim().Length == 0)) { DialogResult result = MessageBox.Show("Bạn có chắc muốn xóa mặt hàng này khỏi tất cả đại lý ? ", "Warning!!", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { bool kq = pxhBus.xoa_mh_all(pxh); if (kq == true) { MessageBox.Show("Xóa Thành công"); } else { MessageBox.Show("Xóa thất bại"); } } } else { pxh.maDaiLy = int.Parse(maDaiLy_txt.Text); bool kq = pxhBus.xoa_mh(pxh); if (kq == true) { MessageBox.Show("Xóa Thành công"); } else { MessageBox.Show("Xóa thất bại"); } } }
public int getDonGia(PhieuXuatHangDTO pxh) { int donGia; string query = string.Empty; query += "Select [MatHang].[donGia] from [MatHang] where [MatHang].[tenMatHang] = @tenMatHang"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@tenMatHang", pxh.tenMatHang); con.Open(); donGia = (int)cmd.ExecuteScalar(); con.Close(); con.Dispose(); } } return(donGia); }
public string getTenDaiLy(PhieuXuatHangDTO pxh) { string name = string.Empty; string query = string.Empty; query += "Select [DaiLy].[tenDaiLy] from [DaiLy] where [DaiLy].[maDaiLy] = @maDaiLy"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@maDaiLy", pxh.maDaiLy); con.Open(); name = (string)cmd.ExecuteScalar(); con.Close(); con.Dispose(); } } return(name); }
public bool them_mh(PhieuXuatHangDTO pxh) { string query = string.Empty; query += "insert into MatHang([maDaiLy] ,[tenMatHang], [donViTinh], [donGia]) "; query += "values(@maDaiLy , @tenMatHang, @donViTinh , @donGia)"; using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; cmd.Parameters.AddWithValue("@maDaiLy", pxh.maDaiLy); cmd.Parameters.AddWithValue("@tenMatHang", pxh.tenMatHang); cmd.Parameters.AddWithValue("@donViTinh", pxh.donViTinh); cmd.Parameters.AddWithValue("@donGia", pxh.donGia); try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(false); } } } return(true); }
public bool sua(PhieuXuatHangDTO pxh) { bool re = pxhDAL.sua(pxh); return(re); }
public bool donViToiDa(PhieuXuatHangDTO pxh) { bool re = pxhDAL.sua_donViToiDa(pxh); return(re); }
public bool rule_mhMax(PhieuXuatHangDTO pxh) { bool re = pxhDAL.rule_mh(pxh); return(re); }
public bool xoa_mh(PhieuXuatHangDTO pxh) { bool re = pxhDAL.xoa_mh(pxh); return(re); }
public bool them(PhieuXuatHangDTO pxh) { bool re = pxhDAL.Them(pxh); return(re); }
private void Ok_Click(object sender, EventArgs e) { if (function.Text == "Thêm") { PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); pxh.maPhieuXuat = int.Parse(maPhieuXuat.Text); pxh.ngayLapPhieu = date_txt.Value; pxh.maDaiLy = int.Parse(maDaiLy_txt.Text); pxh.tenMatHang = matHang_txt.Text; pxh.soLuong = int.Parse(soLuong_txt.Text); bool kq = pxhBus.them(pxh); if (kq == false) { MessageBox.Show("Thêm phiếu xuất hàng thất bại"); } else { MessageBox.Show("Thêm phiếu xuất hàng thành công"); } } if (function.Text == "Xóa") { maPhieuXuat.Enabled = true; PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); pxh.maPhieuXuat = int.Parse(maPhieuXuat.Text); bool kq = pxhBus.xoa(pxh); if (kq == true) { MessageBox.Show("Xóa Thành Công"); } else { MessageBox.Show("Xóa Thất Bại"); } } if (function.Text == "Sửa") { PhieuXuatHangDTO pxh = new PhieuXuatHangDTO(); pxh.maPhieuXuat = int.Parse(maPhieuXuat.Text); pxh.maDaiLy = int.Parse(maDaiLy_txt.Text); pxh.ngayLapPhieu = date_txt.Value; pxh.tenMatHang = matHang_txt.Text; pxh.soLuong = int.Parse(soLuong_txt.Text); pxh.donViTinh = donViTinh_txt.Text; pxh.donGia = int.Parse(donGia_txt.Text); bool kq = pxhBus.sua(pxh); if (kq == true) { MessageBox.Show("Sửa Thành Công"); } else { MessageBox.Show("Sửa Thất Bại"); } dataGridView1.DataSource = pxhBus.load_pxh(); } RefreshAll(); DisableEdit(); dataGridView1.DataSource = pxhBus.load_pxh(); }
public bool them_donVi(PhieuXuatHangDTO pxh) { bool re = pxhDAL.them_donVi(pxh); return(re); }