public bool Insert(NhaCCDTO nhaCCDTO) { var lenh = "insert into NhaCungCap values(" + "N'" + nhaCCDTO.MaNCC.Trim() + "'," + "N'" + nhaCCDTO.TenNCC.Trim() + "'," + "N'" + nhaCCDTO.DiaChi.Trim() + "'," + "N'" + nhaCCDTO.DienThoai.Trim() + "'," + "N'" + nhaCCDTO.Fax.Trim() + "'," + "N'" + nhaCCDTO.Email.Trim() + "'" + ")"; try { var cmd = new SqlCommand(lenh, Connection.Cnn); Connection.Open(); int kq = cmd.ExecuteNonQuery(); Connection.Close(); if (kq <= 0) { return(false); } } catch (Exception ex) { _error = ex.Message; return(false); } return(true); }
/// <summary> /// delete NCC /// </summary> /// <param name="ncc"></param> public static void Delete_NCC(NhaCCDTO ncc) { try { cnn = DataProvider.ConnectData(); string insert = string.Format("DELETE FROM db_nha_cung_cap WHERE ma_ncc='{0}'", ncc.ma_ncc); DataProvider.Execute(cnn, insert); cnn.Close(); } catch (Exception ex) { throw ex; } }
/// <summary> /// update nha cung cap /// </summary> /// <param name="ncc"></param> public static void Update_NCC(NhaCCDTO ncc) { try { cnn = DataProvider.ConnectData(); string insert = string.Format("UPDATE db_nha_cung_cap SET ten_ncc='{1}',sdt_ncc='{2}',email='{3}' WHERE ma_ncc='{0}'", ncc.ma_ncc, ncc.ten_ncc, ncc.sdt_ncc, ncc.email); DataProvider.Execute(cnn, insert); cnn.Close(); } catch (Exception ex) { throw ex; } }
/// <summary> /// them ncc /// </summary> /// <param name="ncc"></param> public static void Insert_NCC(NhaCCDTO ncc) { try { cnn = DataProvider.ConnectData(); string insert = string.Format("insert into db_nha_cung_cap(ma_ncc,ten_ncc,sdt_ncc,email) values ('{0}','{1}','{2}','{3}')", ncc.ma_ncc, ncc.ten_ncc, ncc.sdt_ncc, ncc.email); DataProvider.Execute(cnn, insert); cnn.Close(); } catch (Exception ex) { throw ex; } }
private void btnThem_Click(object sender, EventArgs e) { _nhaCCDTO = new NhaCCDTO { MaNCC = txtMaNCC.Text, TenNCC = txtNhaCC.Text, DiaChi = txtDiaChi.Text, DienThoai = txtDienThoai.Text, Fax = txtFax.Text, Email = txtEmail.Text }; _nhaCCBLO.nhaCCDTO = _nhaCCDTO; if (!_nhaCCBLO.Insert()) { MessageBox.Show(_nhaCCBLO.Error, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("Đã thêm thành công nhà cung cấp", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void button1_Click_1(object sender, EventArgs e) { NhaCCDTO ncc = new NhaCCDTO(); ncc.ma_ncc = txtMaNCC.Text; ncc.ten_ncc = txtTenNCC.Text; ncc.email = txtEmailNCC.Text; ncc.sdt_ncc = txtSDTNCC.Text; NhaCCBUS.Insert_NCC(ncc); txtMaNCC.Clear(); txtTenNCC.Clear(); txtEmailNCC.Clear(); txtSDTNCC.Clear(); load_data(); }
/// <summary> /// tìm theo ten ncc /// </summary> /// <returns></returns> public static DataTable Search_tenNCC(NhaCCDTO ncc) { try { DataTable dt = new DataTable(); cnn = DataProvider.ConnectData(); string select = string.Format("SELECT * FROM db_nha_cung_cap WHERE ten_ncc = '{0}'", ncc.ten_ncc); dt = DataProvider.Load_database(select, cnn); cnn.Close(); return(dt); } catch (Exception ex) { throw ex; } }
/// <summary> /// tìm theo nhà cung cấp /// </summary> /// <param name="pn"></param> /// <returns></returns> public static DataTable Search_NCC(NhaCCDTO ncc) { try { cnn = DataProvider.ConnectData(); string Search_ma = string.Format("SELECT ma_phieu_nhap,db_nhanvien.ten_nv,db_nha_cung_cap.ten_ncc,ngay_lap_pn,tong_tien FROM db_phieu_nhap inner join db_nhanvien on db_phieu_nhap.ma_nv = db_nhanvien.ma_nv inner join db_nha_cung_cap on db_phieu_nhap.ma_ncc = db_nha_cung_cap.ma_ncc WHERE db_nha_cung_cap.ten_ncc='{0}'", ncc.ten_ncc); DataTable dt = new DataTable(); dt = DataProvider.Load_database(Search_ma, cnn); cnn.Close(); return(dt); } catch (Exception ex) { throw ex; } }
public static DataTable Search_NCC(NhaCCDTO ncc) { return(PhieuNhapDAO.Search_NCC(ncc)); }
public NhaCCBLO() { _error = ""; _nhaCCDTO = new NhaCCDTO(); _nhaCCDAO = new NhaCCDAO(); }
public static DataTable Search_tenNCC(NhaCCDTO ncc) { return(NhaCCDAO.Search_tenNCC(ncc)); }
public static void Delete_NCC(NhaCCDTO ncc) { NhaCCDAO.Delete_NCC(ncc); }
public static void Update_NCC(NhaCCDTO ncc) { NhaCCDAO.Update_NCC(ncc); }
public static void Insert_NCC(NhaCCDTO ncc) { NhaCCDAO.Insert_NCC(ncc); }