public static bool updateHDN(EC_HDN cthd) { conn = GetData.KetNoi(); string sTruyVan = "HoaDonNhap_Update"; cmd = new SqlCommand(sTruyVan, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MAHDN", SqlDbType.NVarChar).Value = cthd.MaHDN; cmd.Parameters.Add("@NGAYNHAP", SqlDbType.Date).Value = cthd.NgayNhap; cmd.Parameters.Add("@MANV", SqlDbType.NVarChar).Value = cthd.MaNV; cmd.Parameters.Add("@MANCC", SqlDbType.NVarChar).Value = cthd.MaNCC; cmd.Parameters.Add("@TONGTIEN", SqlDbType.Float).Value = cthd.TongTien; cmd.ExecuteNonQuery(); cmd.Dispose(); try { GetData.ThucThiTruyVanNonQuery(sTruyVan, conn); //Đóng kết nối GetData.DongKetNoi(conn); return(true); } catch (Exception ex) { //Đóng kết nối GetData.DongKetNoi(conn); return(false); } }
public static bool deleteHDN(EC_HDN cthd) { conn = GetData.KetNoi(); string sTruyVan = "HoaDonNhap_Delete"; cmd = new SqlCommand(sTruyVan, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MAHDN", SqlDbType.NVarChar).Value = cthd.MaHDN; cmd.ExecuteNonQuery(); cmd.Dispose(); conn.Close(); try { GetData.ThucThiTruyVanNonQuery(sTruyVan, conn); //Đóng kết nối GetData.DongKetNoi(conn); return(true); } catch (Exception ex) { //Đóng kết nối GetData.DongKetNoi(conn); return(false); } }
private void btnXoa_Click(object sender, EventArgs e) { if (txtMaHDN.Text != "") { if (manv != "") { EC_HDN hdn = new EC_HDN(); hdn.MaHDN = txtMaHDN.Text; if (thucthi.deleteHDN(hdn)) { MessageBox.Show("Xóa thành công"); loaddata(); } else { MessageBox.Show("Xóa thất bại"); } } } else { MessageBox.Show("Mã hóa đơn rỗng"); } }
public void UpdateHDN(EC_HDN _hdn) { string sqlquery = (@"UPDATE tb_HDN SET mancc =N'{0}', ngaynhap ='{1}', manv =N'{2}', tongtien ='{3}' where sohdn=N'{4}'"); sqlquery = string.Format(sqlquery, _hdn.MaNCC, _hdn.NgayNhap, _hdn.MaNV, _hdn.TongTien, _hdn.SoHDN); Connect.ExcuteNonQuery(sqlquery); }
public void AddHDN(EC_HDN _hdn) { string sqlquery = (@"INSERT INTO tb_HDN ( sohdn, mancc, ngaynhap, manv, tongtien) VALUES (N'{0}',N'{1}','{2}',N'{3}','{4}')"); sqlquery = string.Format(sqlquery, _hdn.SoHDN, _hdn.MaNCC, _hdn.NgayNhap, _hdn.MaNV, _hdn.TongTien); Connect.ExcuteNonQuery(sqlquery); }
public void AddHDN(EC_HDN _hdn) { if (!sqlhdn.CheckHDN(_hdn.SoHDN)) { sqlhdn.AddHDN(_hdn); } else { MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public DataTable CreateTbHDN(EC_HDN _hdn) { if (_hdn.NgayNhap != "%") { return(Connect.CreateTable(string.Format("select * from tb_HDN where sohdn like N'%{0}%' and mancc like N'%{1}%' and ngaynhap = '{2}' and manv like N'%{3}%' and tongtien like '%{4}%'", _hdn.SoHDN, _hdn.MaNCC, _hdn.NgayNhap, _hdn.MaNV, _hdn.TongTien))); } else { return(Connect.CreateTable(string.Format("select * from tb_HDN where sohdn like N'%{0}%' and mancc like N'%{1}%' and ngaynhap like '%{2}%' and manv like N'%{3}%' and tongtien like '%{4}%'", _hdn.SoHDN, _hdn.MaNCC, _hdn.NgayNhap, _hdn.MaNV, _hdn.TongTien))); } }
private void btnSua_Click(object sender, EventArgs e) { if (txtMaHDN.Text != "") { EC_HDN hdn = new EC_HDN(); hdn.MaHDN = txtMaHDN.Text; hdn.MaNCC = cbxNCC.SelectedValue.ToString(); hdn.MaNV = manv; hdn.NgayNhap = dateNgayNhap.Value; if (thucthi.updateHDN(hdn)) { MessageBox.Show("Sửa thành công"); loaddata(); } else { MessageBox.Show("Sửa thất bại"); } } else { MessageBox.Show("Mã hóa đơn rỗng"); } }
public void DeleteHDN(EC_HDN _hdn) { sqlhdn.DeleteHDN(_hdn); }
public void UpdateHDN(EC_HDN _hdn) { sqlhdn.UpdateHDN(_hdn); }
public DataTable CreateTbHDN(EC_HDN _hdn) { return(sqlhdn.CreateTbHDN(_hdn)); }
public void DeleteHDN(EC_HDN _hdn) { Connect.ExcuteNonQuery("DELETE FROM [tb_CTHDN] WHERE sohdn=N'" + _hdn.SoHDN + "'"); Connect.ExcuteNonQuery("DELETE FROM [tb_HDN] WHERE sohdn=N'" + _hdn.SoHDN + "'"); }
public bool deleteHDN(EC_HDN cthdn) { return(DA_HDN.deleteHDN(cthdn)); }
public bool updateHDN(EC_HDN cthdn) { return(DA_HDN.updateHDN(cthdn)); }
public bool insertHDN(EC_HDN cthdn) { return(DA_HDN.insertHDN(cthdn)); }