private void ganDuLieu(NhaCungCapDTO ncc)
{
ncc.MaNCC = txtMaNCC.Text;
ncc.TenNCC = txtTenNCC.Text;
ncc.DiaChi = txtDiaChi.Text;
ncc.SDT = txtSDT.Text;
}
private void dgvDSNhaCC_SelectionChanged(object sender, EventArgs e)
{
if (dgvDSNhaCC.SelectedRows.Count > 0)
{
XuLyAnHienButton(false);
if (chkNhaCungCap.Checked)
{
btnKhoiPhuc.Visible = true;
btnCapNhat.Visible = false;
btnXoa.Visible = false;
}
else
{
btnKhoiPhuc.Visible = false;
btnXoa.Visible = true;
}
DataRowView dr = (DataRowView)dgvDSNhaCC.SelectedRows[0].DataBoundItem;
nccDTO = new NhaCungCapDTO();
nccDTO.MaNCC = dr[0].ToString();
nccDTO.TenNhaCC = dr[1].ToString();
nccDTO.DiaChiNCC = dr[2].ToString();
nccDTO.SDTNCC = dr[3].ToString();
nccDTO.EmailNCC = dr[4].ToString();
nccDTO.TrangThai = Convert.ToInt32(dr[5]);
DuaDuLieuChoThongTinNCC();
}
else
{
nccDTO = null;
}
}
public static List <NhaCungCapDTO> layDanhSachNCC(int TThai)
{
List <NhaCungCapDTO> KQ = new List <NhaCungCapDTO>();
OleDbConnection conn = DataProvider.getConnection();
try
{
OleDbCommand cm = new OleDbCommand("SELECT * FROM NhaCungCap WHERE TThai=@tthai", conn);
cm.Parameters.Add("@tthai", System.Data.OleDb.OleDbType.Integer).Value = TThai;
OleDbDataReader dr = cm.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
NhaCungCapDTO lsp = new NhaCungCapDTO();
lsp.Ma = dr.GetInt32(0);
lsp.TenNCC = dr.GetString(1);
lsp.DiaChi = dr.GetString(2);
lsp.DienThoai = dr.GetString(3);
KQ.Add(lsp);
}
}
dr.Close();
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
return(KQ);
}
public static NhaCungCap NhaCungCapEditMap(this NhaCungCapDTO dto, NhaCungCap ncc)
{
ncc.MaNCC = dto.MaNCC;
ncc.TenNCC = dto.TenNCC;
ncc.MoTa = dto.MoTa;
return(ncc);
}
public BindingList <NhaCungCapDTO> LayDanhSach()
{
BindingList <NhaCungCapDTO> danhSach = new BindingList <NhaCungCapDTO>();
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Select * From DanhMucNhaCungCap";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
NhaCungCapDTO itemDTO = new NhaCungCapDTO();
itemDTO.Id = (int)dr["Id"];
itemDTO.MaNhaCungCap = (string)dr["MaNhaCungCap"];
itemDTO.TenNhaCungCap = (string)dr["TenNhaCungCap"];
itemDTO.IdNhomNhaCungCap = (int)dr["IdNhomNhaCungCap"];
itemDTO.DiaChi = (string)dr["DiaChi"];
itemDTO.DienThoai = (string)dr["DienThoai"];
itemDTO.Email = (string)dr["Email"];
itemDTO.SoTaiKhoan = (string)dr["SoTaiKhoan"];
itemDTO.TenNganHang = (string)dr["TenNganHang"];
itemDTO.TenChiNhanh = (string)dr["TenChiNhanh"];
itemDTO.GhiChu = (string)dr["GhiChu"];
danhSach.Add(itemDTO);
}
return(danhSach);
}
// add NCC
private void guna2GradientButton1_Click(object sender, EventArgs e)
{
string ten, ma, diachi, sdt, hinhanh, hang;
ten = tbAddTEn.Text;
ma = tbMaNCC.Text;
diachi = tbDiachi.Text;
sdt = tbSdt.Text;
hang = tbHang.Text;
if (hang == "Adidas")
{
hinhanh = "adidas-3-la.jpg";
}
else if (hang == "Nike")
{
hinhanh = "icons8-nike-50.png";
}
else
{
hinhanh = "logo_converse.png";
}
NhaCungCapDTO NCC = new NhaCungCapDTO(ma, ten, diachi, sdt, hang, hinhanh);
if (_addNCC.insertNCC(NCC))
{
MessageBox.Show("Insert Success");
Update();
}
else
{
MessageBox.Show("Insert Fail!");
}
}
private void btnSuaNhaCungCap_Click(object sender, EventArgs e)
{
NhaCungCapDTO nccTam = new NhaCungCapDTO();
nccTam.Mancc = Convert.ToInt32(dtgvNhaCungCap.SelectedCells[0].OwningRow.Cells["colmancc"].Value.ToString());
if (txtTenNhaCungCap.Text == string.Empty || txtDiaChiNhaCungCap.Text == string.Empty || txtSDTNhaCungCap.Text == string.Empty)
{
MessageBox.Show("Bạn chưa nhập đầy đủ thông tin!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
nccTam.Tenncc = txtTenNhaCungCap.Text;
nccTam.Diachi = txtDiaChiNhaCungCap.Text;
nccTam.Sdt = txtSDTNhaCungCap.Text;
}
if (nccBUS.SuaNCC(nccTam))
{
MessageBox.Show("Sửa thành công!", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDsNCC();
AutoCompleteNCC();
}
else
{
MessageBox.Show("Sửa thất bại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Them(NhaCungCapDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Insert into DanhMucNhaCungCap (MaNhaCungCap, TenNhaCungCap, IdNhomNhaCungCap, DiaChi, DienThoai, Email, SoTaiKhoan, TenNganHang, TenChiNhanh, GhiChu) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaNhaCungCap", OleDbType.WChar).Value = itemDTO.MaNhaCungCap;
cmd.Parameters.Add("@TenNhaCungCap", OleDbType.WChar).Value = itemDTO.TenNhaCungCap;
cmd.Parameters.Add("@IdNhomNhaCungCap", OleDbType.Numeric).Value = itemDTO.IdNhomNhaCungCap;
cmd.Parameters.Add("@DiaChi", OleDbType.WChar).Value = itemDTO.DiaChi;
cmd.Parameters.Add("@DienThoai", OleDbType.WChar).Value = itemDTO.DienThoai;
cmd.Parameters.Add("@Email", OleDbType.WChar).Value = itemDTO.Email;
cmd.Parameters.Add("@SoTaiKhoan", OleDbType.WChar).Value = itemDTO.SoTaiKhoan;
cmd.Parameters.Add("@TenNganHang", OleDbType.WChar).Value = itemDTO.TenNganHang;
cmd.Parameters.Add("@TenChiNhanh", OleDbType.WChar).Value = itemDTO.TenChiNhanh;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.ExecuteNonQuery();
cn.Close();
}
public bool UpDateData(NhaCungCapDTO ncc)
{
string query = string.Format("update NhaCungCap set TenNCC =N'{0}', DiaChi =N'{1}', SDT ='{2}', SoNo ={3}, GhiChu =N'{4}' , TinhTrang = 'True' where MaNCC = {5}", ncc.TenNCC, ncc.DiaChi, ncc.Sdt, ncc.SoNo, ncc.GhiChu, ncc.MaNCC);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
public bool AddData(NhaCungCapDTO ncc)
{
string query = string.Format("insert into NhaCungCap(TenNCC,DiaChi,SDT,SoNo,GhiChu,TinhTrang) values (N'{0}',N'{1}','{2}',{3},N'{4}','True')", ncc.TenNCC, ncc.DiaChi, ncc.Sdt, ncc.SoNo, ncc.GhiChu);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return(result > 0);
}
/// <summary>
/// Thay đổi nhà cung cấp thực phẩm
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cbSuplier_SelectedIndexChanged(object sender, EventArgs e)
{
XoaTatCaToolStripMenuItem_Click(this, new EventArgs());
NhaCungCapDTO nhacc = (NhaCungCapDTO)cbSuplier.SelectedItem;
if (nhacc == null)
{
return;
}
if (ckbIsBelow.Checked == true)
{
ThucPhamSource.DataSource = ThucPhamDAO.Instance.getListThucPhamDuoiMucNhap(nhacc.MANCC);
}
else
{
ThucPhamSource.DataSource = ThucPhamDAO.Instance.getListThucPham(nhacc.MANCC);
}
if (cbNameMaterial.SelectedItem == null)
{
txbGia.Text = "0";
return;
}
ThucPhamDTO tp = (ThucPhamDTO)cbNameMaterial.SelectedItem;
txbGia.Text = tp.GiaTP.ToString();
}
/// <summary>
/// Thuc hiện tạo hóa đơn nhập và in hóa đơn
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ptbPrint_Click(object sender, EventArgs e)
{
if (listCTHDN.Count <= 0)
{
return;
}
if (fMessageBox.Show("Tạo hóa đơn nhập thực phẩm?") == DialogResult.Cancel)
{
return;
}
NhaCungCapDTO nhacc = ((NhaCungCapDTO)cbSuplier.SelectedItem);
string MAHD = StaticClass.Random(10);
if (!HoaDonNhapDAO.Instance.insertHoaDonNhap(MAHD, DateTime.Now, 0, 0))
{
fMessageBoxOK.Show("Vui long thuc hien lai!");
return;
}
foreach (CTHDNdto item in listCTHDN)
{
CTHDNdao.Instance.insertCTHDN(MAHD, item.MATP, item.SoLuongThucPham);
CTTPdao.Instance.insertCTTP(item.MATP, nhacc.MANCC);
}
fReport f = new fReport(MAHD, nhacc.MANCC);
f.ShowDialog();
listCTHDN.Clear();
listCTHDN = new List <CTHDNdto>();
dtgvCTHDN.DataSource = listCTHDN;
ptbSearch_Click(this, new EventArgs());
}
public static ArrayList traCuuNhaCungCapThoaYeuCauNguyenLieuCanDatHang(string sqlFROM)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.traCuuNhaCungCapThoaYeuCauNguyenLieuCanDatHang";
DbParameter param = command.CreateParameter();
param.ParameterName = "@sqlFROM";
param.Value = sqlFROM;
param.DbType = DbType.String;
command.Parameters.Add(param);
DataTable dt = DataAccessCode.ExecuteSelectCommand(command);
ArrayList list = new ArrayList();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
NhaCungCapDTO dto = new NhaCungCapDTO();
dto.MaNhaCungCap = Convert.ToInt32(dt.Rows[i]["MaNhaCungCap"]);
dto.SoLuongNguyenLieuToiDaPhuHopYeuCauDatHang = Convert.ToInt32(dt.Rows[i]["SoLuongNguyenLieuDapUng"]);
dto.TenNhaCungCap = dt.Rows[i]["TenNhaCungCap"].ToString();
list.Add(dto);
}
}
return(list);
}
public void BarButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int[] i = GridView1.GetSelectedRows();
NhaCungCapDTO ncc = ((List <NhaCungCapDTO>)GridControl1.DataSource)[i[0]];
DanhMuc_SuaNhaCungCap f = new DanhMuc_SuaNhaCungCap();
f.txtMa.Text = ncc.MaNhaCungCap.ToString();
f.lkpKhuVuc.EditValue = ncc.KhuVuc;
f.txtTen.Text = ncc.TenNhaPhanPhoi.ToString();
f.txtDiaChi.Text = ncc.DiaChi.ToString();
f.txtMaSoThue.Text = ncc.MaSoThue.ToString();
f.txtDienThoai.Text = ncc.SoDienThoaiBan.ToString();
f.txtEmail.Text = ncc.Email.ToString();
f.txtSoTaiKhoan.Text = ncc.SoTaiKhoan.ToString();
f.ceGioiHanNo.Value = Convert.ToDecimal(ncc.GioiHanNo);
f.ceChietKhau.Value = (decimal)ncc.ChietKhau;
f.txtFax.Text = ncc.Fax.ToString();
f.txtMobile.Text = ncc.SoDiDong.ToString();
f.txtWebsite.Text = ncc.Website.ToString();
f.txtNganHang.Text = ncc.NganHang.ToString();
f.txtNoHienTai.Text = ncc.NoHienTai.ToString();
f.txtNguoiLienHe.Text = ncc.NguoiLienHe.ToString();
f.txtChucVu.Text = ncc.ChucVu.ToString();
if (f.chxConQuanLy.Checked == true)
{
ncc.ConQuanLy = true;
}
else
{
ncc.ConQuanLy = false;
}
f.eventSuaXong += LoadDanhSachNCC;
f.ShowDialog();
}
private void btnThemNhaCungCap_Click(object sender, EventArgs e)
{
NhaCungCapDTO nccTam = new NhaCungCapDTO();
if (txtTenNhaCungCap.Text == string.Empty || txtDiaChiNhaCungCap.Text == string.Empty || txtSDTNhaCungCap.Text == string.Empty)
{
MessageBox.Show("Bạn chưa nhập đầy đủ thông tin!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
nccTam.Tenncc = txtTenNhaCungCap.Text;
nccTam.Diachi = txtDiaChiNhaCungCap.Text;
nccTam.Sdt = txtSDTNhaCungCap.Text;
}
if (nccBUS.ThemNCC(nccTam))
{
MessageBox.Show("Thêm thành công!", "Thành công", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadDsNCC();
AutoCompleteNCC();
}
else
{
MessageBox.Show("Thêm thất bại!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Sua(NhaCungCapDTO itemDTO)
{
try
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Update DanhMucNhaCungCap Set MaNhaCungCap = ?, TenNhaCungCap = ?, IdNhomNhaCungCap = ?, DiaChi = ?, DienThoai = ?, Email = ?, SoTaiKhoan = ?, TenNganHang = ?, TenChiNhanh = ?, GhiChu = ? Where Id = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaNhaCungCap", OleDbType.WChar).Value = itemDTO.MaNhaCungCap;
cmd.Parameters.Add("@TenNhaCungCap", OleDbType.WChar).Value = itemDTO.TenNhaCungCap;
cmd.Parameters.Add("@IdNhomNhaCungCap", OleDbType.Numeric).Value = itemDTO.IdNhomNhaCungCap;
cmd.Parameters.Add("@DiaChi", OleDbType.WChar).Value = itemDTO.DiaChi;
cmd.Parameters.Add("@DienThoai", OleDbType.WChar).Value = itemDTO.DienThoai;
cmd.Parameters.Add("@Email", OleDbType.WChar).Value = itemDTO.Email;
cmd.Parameters.Add("@SoTaiKhoan", OleDbType.WChar).Value = itemDTO.SoTaiKhoan;
cmd.Parameters.Add("@TenNganHang", OleDbType.WChar).Value = itemDTO.TenNganHang;
cmd.Parameters.Add("@TenChiNhanh", OleDbType.WChar).Value = itemDTO.TenChiNhanh;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.Parameters.Add("@Id", OleDbType.Numeric).Value = itemDTO.Id;
cmd.ExecuteNonQuery();
cn.Close();
}
catch(Exception )
{
return;
}
}
private void btnTimKiemNhaCungCap_Click(object sender, EventArgs e)
{
NhaCungCapDTO nccTam = new NhaCungCapDTO();
string tenNCC = txtTimKiemNhaCungCap.Text;
nccTam = nccBUS.TimKiemNCC(tenNCC);
if (nccTam != null)
{
foreach (DataGridViewRow row in dtgvNhaCungCap.Rows)
{
if (Convert.ToInt32(row.Cells["colMaNCC"].Value.ToString()) == nccTam.Mancc)
{
row.Selected = true;
dtgvNhaCungCap.CurrentCell = dtgvNhaCungCap.Rows[row.Index].Cells[0];
txtTenNhaCungCap.Text = nccTam.Tenncc;
txtDiaChiNhaCungCap.Text = nccTam.Diachi;
txtSDTNhaCungCap.Text = nccTam.Sdt;
}
}
}
else
{
MessageBox.Show("Không tìm thấy!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void Sua(NhaCungCapDTO itemDTO)
{
try
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Update DanhMucNhaCungCap Set MaNhaCungCap = ?, TenNhaCungCap = ?, IdNhomNhaCungCap = ?, DiaChi = ?, DienThoai = ?, Email = ?, SoTaiKhoan = ?, TenNganHang = ?, TenChiNhanh = ?, GhiChu = ? Where Id = ?";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaNhaCungCap", OleDbType.WChar).Value = itemDTO.MaNhaCungCap;
cmd.Parameters.Add("@TenNhaCungCap", OleDbType.WChar).Value = itemDTO.TenNhaCungCap;
cmd.Parameters.Add("@IdNhomNhaCungCap", OleDbType.Numeric).Value = itemDTO.IdNhomNhaCungCap;
cmd.Parameters.Add("@DiaChi", OleDbType.WChar).Value = itemDTO.DiaChi;
cmd.Parameters.Add("@DienThoai", OleDbType.WChar).Value = itemDTO.DienThoai;
cmd.Parameters.Add("@Email", OleDbType.WChar).Value = itemDTO.Email;
cmd.Parameters.Add("@SoTaiKhoan", OleDbType.WChar).Value = itemDTO.SoTaiKhoan;
cmd.Parameters.Add("@TenNganHang", OleDbType.WChar).Value = itemDTO.TenNganHang;
cmd.Parameters.Add("@TenChiNhanh", OleDbType.WChar).Value = itemDTO.TenChiNhanh;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.Parameters.Add("@Id", OleDbType.Numeric).Value = itemDTO.Id;
cmd.ExecuteNonQuery();
cn.Close();
}
catch (Exception)
{
return;
}
}
public IActionResult Add()
{
NhaCungCapDTO dto = new NhaCungCapDTO();
ViewBag.Title = "Thêm Nhà Sản Xuất";
return(View("~/Views/Admin/Manufactuer/Add.cshtml", dto));
}
public BindingList<NhaCungCapDTO> LayDanhSach()
{
BindingList<NhaCungCapDTO> danhSach = new BindingList<NhaCungCapDTO>();
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Select * From DanhMucNhaCungCap";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
NhaCungCapDTO itemDTO = new NhaCungCapDTO();
itemDTO.Id = (int)dr["Id"];
itemDTO.MaNhaCungCap = (string)dr["MaNhaCungCap"];
itemDTO.TenNhaCungCap = (string)dr["TenNhaCungCap"];
itemDTO.IdNhomNhaCungCap = (int)dr["IdNhomNhaCungCap"];
itemDTO.DiaChi = (string)dr["DiaChi"];
itemDTO.DienThoai = (string)dr["DienThoai"];
itemDTO.Email = (string)dr["Email"];
itemDTO.SoTaiKhoan = (string)dr["SoTaiKhoan"];
itemDTO.TenNganHang = (string)dr["TenNganHang"];
itemDTO.TenChiNhanh = (string)dr["TenChiNhanh"];
itemDTO.GhiChu = (string)dr["GhiChu"];
danhSach.Add(itemDTO);
}
return danhSach;
}
public static int themMoi(NhaCungCapDTO dto)
{
DbCommand command = DataAccessCode.CreateCommand();
command.CommandText = "dbo.ThemNhaCungCap";
//// create a new parameter
DbParameter param = command.CreateParameter();
param.ParameterName = "@tenNhaCungCap";
param.Value = dto.TenNhaCungCap;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@dienThoai";
param.Value = dto.DienThoai;
param.DbType = DbType.String;
command.Parameters.Add(param);
//// create a new parameter
param = command.CreateParameter();
param.ParameterName = "@soTaiKhoan";
param.Value = dto.SoTaiKhoan;
param.DbType = DbType.String;
command.Parameters.Add(param);
return(DataAccessCode.ExecuteNonQuery(command));
}
private void init()
{
grid_ds.Rows.Clear();
ArrayList ds1 = KhoHangBUS.layDanhSachNhaCungCapToiHanDuocThanhToanNoTheoThoiDiemThanhToan(GlobalVariables.maNhaHang);
ArrayList ds2 = KhoHangBUS.layDanhSachNhaCungCapToiHanDuocThanhToanNoTheoDinhMucNo(GlobalVariables.maNhaHang);
for (int i = 0; i < ds1.Count; i++)
{
NhaCungCapDTO dto1 = (NhaCungCapDTO)ds1[i];
grid_ds.Rows.Add();
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cMaNhaCungCap"].Value = dto1.MaNhaCungCap;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cTenNhaCungCap"].Value = dto1;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cDienThoai"].Value = dto1.DienThoai;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cSoTaiKhoan"].Value = dto1.SoTaiKhoan;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cTongNo"].Value = dto1.TongNo;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cThoiDiemThanhToan"].Value = dto1.ThoiDiemThanhToan;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cDinhMucNo"].Value = "Không có";
}
for (int i = 0; i < ds2.Count; i++)
{
NhaCungCapDTO dto2 = (NhaCungCapDTO)ds2[i];
grid_ds.Rows.Add();
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cMaNhaCungCap"].Value = dto2.MaNhaCungCap;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cTenNhaCungCap"].Value = dto2;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cDienThoai"].Value = dto2.DienThoai;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cSoTaiKhoan"].Value = dto2.SoTaiKhoan;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cTongNo"].Value = dto2.TongNo;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cThoiDiemThanhToan"].Value = dto2.ThoiDiemThanhToan;
grid_ds.Rows[grid_ds.RowCount - 1].Cells["cDinhMucNo"].Value = dto2.GiaTriDinhMucNo;
}
}
public int ThemNhaCungCap(NhaCungCapDTO temp)
{
string sql = string.Format("insert into NhaCungCap (MaNCC, TenNCC, MaKV, NguoiLienHe, DiaChi, MaSoThue, DienThoai, DiDong, Fax, Email, Website, SoTaiKhoan, TenNganHang, GioiHanNo, ChietKhau, ChucVu, ConQuanLy)" +
"values('{0}', N'{1}', '{2}', N'{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', N'{12}', N'{13}', '{14}', '{15}', '{16}')",
temp.MaNCC, temp.TenNCC, temp.MaKV, temp.NguoiLienHe, temp.DiaChi, temp.MaSoThue, temp.DienThoai, temp.DiDong, temp.Fax, temp.mail, temp.Website, temp.SoTaiKhoan, temp.TenNganHang, temp.GioiHanNo, temp.ChietKhau, temp.ChietKhau, temp.ConQuanLy);
return(db.ExcuteSql(sql));
}
public int CapNhatNhaCungCapBTN(NhaCungCapDTO temp)
{
string sql = string.Format("update NhaCungCap set TenNCC = N'{0}', MaKV = '{1}', NguoiLienHe = N'{2}', DiaChi = N'{3}', MaSoThue = '{4}', DienThoai = '{5}'," +
"DiDong = '{6}', Fax = '{7}', Email = '{8}', Website = '{9}', SoTaiKhoan = '{10}', TenNganHang = N'{11}', GioiHanNo = '{12}', ChietKhau = '{13}', ChucVu = '{14}', ConQuanLy = '{15}' where MaNCC = '{16}'",
temp.TenNCC, temp.MaKV, temp.NguoiLienHe, temp.DiaChi, temp.MaSoThue, temp.DienThoai, temp.DiDong, temp.Fax, temp.mail, temp.Website, temp.SoTaiKhoan, temp.TenNganHang, temp.GioiHanNo, temp.ChietKhau, temp.ChietKhau, temp.ConQuanLy, temp.MaNCC);
return(db.ExcuteSql(sql));
}
public bool UpdateNCC(NhaCungCapDTO NCC)
{
if (NCC.TenNCC == "" || NCC.Sdt == "" || NCC.DiaChi == "" || NCC.Hang == "")
{
return(false);
}
return(NhaCungCapDAL.Intance.UpdateNCC(NCC));
}
public void NhaCc_Delete()
{
NhaCungCapDTO nhacc = new NhaCungCapDTO();
nhacc.MaNhaCc = txtmanhacc.Text;
DataTable dt = nhacc_bus.NhaCc_Delete(nhacc);
MessageBox.Show(dt.Rows[0][0].ToString(), "Thông báo", MessageBoxButtons.OK);
}
public bool insertNCC(NhaCungCapDTO NCC)
{
if (NCC.TenNCC == "" || NCC.Sdt == "" || NCC.DiaChi == "" || NCC.Hang == "" || NCC.HinhAnh == null)
{
return(false);
}
return(NhaCungCapDAL.Intance.insertNCC(NCC));
}
private void btnLamMoi_Click(object sender, EventArgs e)
{
XuLyAnHienButton(true);
nccDTO = null;
string maNCC = NhaCungCapBUS.LayMaxMaNCC();
txtMaNCC.Text = maNCC;
DuaDuLieuChoThongTinNCC();
}
public DialogSuaNCC(String maNCC)
{
this.maNCC = maNCC;
InitializeComponent();
ncc = nccBul.getNhaCungCap(maNCC);
txtTenNCC.Text = ncc.TenNhaCungCap;
txtDiaChiNCC.Text = ncc.DiaChi;
txtSDT.Text = ncc.SoDienThoai;
}
string GetMaNhaCungCap()
{
string MANCC = null;
NhaCungCapDTO selected = cboNCC.SelectedItem as NhaCungCapDTO;
MANCC = selected.MaNhaCungCap;
return(MANCC);
}
public static NhaCungCap MappingNhaCungCap(this NhaCungCapDTO nhaCungCapDTO)
{
return(new NhaCungCap
{
Id = nhaCungCapDTO.Id,
Ten = nhaCungCapDTO.Ten,
DiaChi = nhaCungCapDTO.DiaChi,
DienThoai = nhaCungCapDTO.DienThoai,
});
}
public void NhaCc_SelectMa()
{
NhaCungCapDTO nhacc = new NhaCungCapDTO();
nhacc.MaNhaCc = cbtennhacc.SelectedValue.ToString();
datanhacc.DataSource = nhacc_bus.NhaCc_SelectMa(nhacc);
txtmanhacc.Text = datanhacc.Rows[0].Cells[0].Value.ToString();
txtsdt.Text = datanhacc.Rows[0].Cells[2].Value.ToString();
txtdiachi.Text = datanhacc.Rows[0].Cells[3].Value.ToString();
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
NhaCungCapDTO dtoNhaCC = new NhaCungCapDTO();
string strAction = btnThem.Tag.ToString();
if (strAction == "add")
{
dtoNhaCC.MaNCC = txtMaNCC.Text;
dtoNhaCC.TenNCC = txtTenNCC.Text;
dtoNhaCC.DiaChi = txtDiaChi.Text;
dtoNhaCC.MaSoThue = txtMaSoThue.Text;
dtoNhaCC.SoTaiKhoan = txtSoTaiKhoan.Text;
dtoNhaCC.NganHang = txtNganHang.Text;
dtoNhaCC.SoDienThoai = txtDienThoai.Text;
dtoNhaCC.Email = txtEmail.Text;
dtoNhaCC.GhiChu = txtGhiChu.Text;
string strRusult = bllNhaCC.InsertNhaCungCap(dtoNhaCC);
if (strRusult == "ok")
{
MessageBox.Show("Thêm Nhà Cung Cấp Thành Công!", "Thêm Nhà Cung Cấp", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show(strRusult, "Thêm Nhà Cung Cấp", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
dtoNhaCC.MaNCC = txtMaNCC.Text;
dtoNhaCC.TenNCC = txtTenNCC.Text;
dtoNhaCC.DiaChi = txtDiaChi.Text;
dtoNhaCC.MaSoThue = txtMaSoThue.Text;
dtoNhaCC.SoTaiKhoan = txtSoTaiKhoan.Text;
dtoNhaCC.NganHang = txtNganHang.Text;
dtoNhaCC.SoDienThoai = txtDienThoai.Text;
dtoNhaCC.Email = txtEmail.Text;
string strRusult = bllNhaCC.UpdateNhaCungCap(dtoNhaCC);
if (strRusult == "ok")
{
MessageBox.Show("Cập Nhật Nhà Cung Cấp Thành Công!", "Cập Nhật Nhà Cung Cấp", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show(strRusult, "Cập Nhật Nhà Cung Cấp", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch { }
}
public bool UpdateNhaCungCap(NhaCungCapDTO dtoNhaCungCap)
{
string strQuery = "Update NHACUNGCAP Set ";
strQuery += "TENNHACUNGCAP = N'" + dtoNhaCungCap.TenNCC + "',";
strQuery += "DIACHI = N'" + dtoNhaCungCap.DiaChi + "',";
strQuery += "MASOTHUE = N'" + dtoNhaCungCap.MaSoThue + "',";
strQuery += "SOTAIKHOAN = N'" + dtoNhaCungCap.SoTaiKhoan + "',";
strQuery += "NGANHANG = N'" + dtoNhaCungCap.NganHang + "',";
strQuery += "DUNO = " + dtoNhaCungCap.DuNo + ",";
strQuery += "SODIENTHOAI = N'" + dtoNhaCungCap.SoDienThoai + "',";
strQuery += "EMAIL = N'" + dtoNhaCungCap.Email + "',";
strQuery += "GHICHU = N'" + dtoNhaCungCap.GhiChu + "' ";
strQuery += "Where MANHACUNGCAP = N'" + dtoNhaCungCap.MaNCC + "'";
return dp.ExecuteNonQuery(strQuery);
}
public bool InsertNhaCungCap(NhaCungCapDTO dtoNhaCungCap)
{
string strQuery = "Insert Into NHACUNGCAP Values(";
strQuery += "N'" + dtoNhaCungCap.MaNCC + "',";
strQuery += "N'" + dtoNhaCungCap.TenNCC + "',";
strQuery += "N'" + dtoNhaCungCap.DiaChi + "',";
strQuery += "N'" + dtoNhaCungCap.MaSoThue + "',";
strQuery += "N'" + dtoNhaCungCap.SoTaiKhoan + "',";
strQuery += "N'" + dtoNhaCungCap.NganHang + "',";
strQuery += dtoNhaCungCap.DuNo + ",";
strQuery += "N'" + dtoNhaCungCap.SoDienThoai + "',";
strQuery += "N'" + dtoNhaCungCap.Email + "',";
strQuery += "N'" + dtoNhaCungCap.GhiChu + "', 1)";
return dp.ExecuteNonQuery(strQuery);
}
public NhaCungCapDTO GetNhaCungCapByID(string strID)
{
string strQuery = "Select * From NHACUNGCAP Where TINHTRANG = 1 and MANHACUNGCAP = N'" + strID + "'";
DataTable dt = dp.ExecuteQuery(strQuery);
NhaCungCapDTO dtoNhaCungCap = new NhaCungCapDTO();
if (dt.Rows.Count > 0)
{
dtoNhaCungCap.MaNCC = dt.Rows[0]["MANHACUNGCAP"].ToString();
dtoNhaCungCap.TenNCC = dt.Rows[0]["TENNHACUNGCAP"].ToString();
dtoNhaCungCap.DiaChi = dt.Rows[0]["DIACHI"].ToString();
dtoNhaCungCap.MaSoThue = dt.Rows[0]["MASOTHUE"].ToString();
dtoNhaCungCap.SoTaiKhoan = dt.Rows[0]["SOTAIKHOAN"].ToString();
dtoNhaCungCap.NganHang = dt.Rows[0]["NGANHANG"].ToString();
dtoNhaCungCap.SoDienThoai = dt.Rows[0]["SODIENTHOAI"].ToString();
dtoNhaCungCap.Email = dt.Rows[0]["EMAIL"].ToString();
}
return dtoNhaCungCap;
}
public string UpdateNhaCungCap(NhaCungCapDTO dtoNhaCungCap)
{
string strError = "";
if (dtoNhaCungCap.TenNCC.Trim().Equals("") == true)
{
strError += " Tên nhà cung cấp không được rỗng.";
}
if (dtoNhaCungCap.DiaChi.Trim().Equals("") == true)
{
strError += " Địa chỉ không được rỗng.";
}
if (dtoNhaCungCap.SoTaiKhoan.Trim().Equals("") == true)
{
strError += "Số tài khoản không được rỗng.";
}
if (dtoNhaCungCap.MaSoThue.Trim().Equals("") == true)
{
strError += "Mã số thuế không được rỗng.";
}
if (dtoNhaCungCap.NganHang.Trim().Equals("") == true)
{
strError += " Tên ngân hàng không được rỗng.";
}
if (dtoNhaCungCap.SoDienThoai.Trim().Equals("") == true)
{
strError += "Số điện thoại không được rỗng.";
}
if (dtoNhaCungCap.Email.Trim().Equals("") == true)
{
strError += " Email không được rỗng.";
}
if (strError == "")
{
bool boolResult = dalNhaCungCap.UpdateNhaCungCap(dtoNhaCungCap);
return "ok";
}
else
{
return strError;
}
}
public void Them(NhaCungCapDTO itemDTO)
{
OleDbConnection cn;
cn = DataProvider.KetNoi();
string strSQL;
strSQL = "Insert into DanhMucNhaCungCap (MaNhaCungCap, TenNhaCungCap, IdNhomNhaCungCap, DiaChi, DienThoai, Email, SoTaiKhoan, TenNganHang, TenChiNhanh, GhiChu) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
cmd.Parameters.Add("@MaNhaCungCap", OleDbType.WChar).Value = itemDTO.MaNhaCungCap;
cmd.Parameters.Add("@TenNhaCungCap", OleDbType.WChar).Value = itemDTO.TenNhaCungCap;
cmd.Parameters.Add("@IdNhomNhaCungCap", OleDbType.Numeric).Value = itemDTO.IdNhomNhaCungCap;
cmd.Parameters.Add("@DiaChi", OleDbType.WChar).Value = itemDTO.DiaChi;
cmd.Parameters.Add("@DienThoai", OleDbType.WChar).Value = itemDTO.DienThoai;
cmd.Parameters.Add("@Email", OleDbType.WChar).Value = itemDTO.Email;
cmd.Parameters.Add("@SoTaiKhoan", OleDbType.WChar).Value = itemDTO.SoTaiKhoan;
cmd.Parameters.Add("@TenNganHang", OleDbType.WChar).Value = itemDTO.TenNganHang;
cmd.Parameters.Add("@TenChiNhanh", OleDbType.WChar).Value = itemDTO.TenChiNhanh;
cmd.Parameters.Add("@GhiChu", OleDbType.WChar).Value = itemDTO.GhiChu;
cmd.ExecuteNonQuery();
cn.Close();
}
public void Sua(NhaCungCapDTO itemDTO)
{
NhaCungCapDAO itemDAO = new NhaCungCapDAO();
itemDAO.Sua(itemDTO);
}
public void Them(NhaCungCapDTO itemDTO)
{
NhaCungCapDAO itemDAO = new NhaCungCapDAO();
itemDAO.Them(itemDTO);
}
private void gvDanhMucNhaCungCap_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e)
{
if (gvDanhMucNhaCungCap.FocusedRowHandle > -1)
{
try
{
NhaCungCapDTO itemDTO = new NhaCungCapDTO();
NhaCungCapBUS itemBUS = new NhaCungCapBUS();
itemDTO.MaNhaCungCap = gvDanhMucNhaCungCap.GetFocusedRowCellValue("MaNhaCungCap").ToString();
itemDTO.TenNhaCungCap = gvDanhMucNhaCungCap.GetFocusedRowCellValue("TenNhaCungCap").ToString();
itemDTO.IdNhomNhaCungCap = int.Parse(gvDanhMucNhaCungCap.GetFocusedRowCellValue("IdNhomNhaCungCap").ToString());
itemDTO.DiaChi = gvDanhMucNhaCungCap.GetFocusedRowCellValue("DiaChi").ToString();
itemDTO.DienThoai = gvDanhMucNhaCungCap.GetFocusedRowCellValue("DienThoai").ToString();
itemDTO.Email = gvDanhMucNhaCungCap.GetFocusedRowCellValue("Email").ToString();
itemDTO.SoTaiKhoan = gvDanhMucNhaCungCap.GetFocusedRowCellValue("SoTaiKhoan").ToString();
itemDTO.TenNganHang = gvDanhMucNhaCungCap.GetFocusedRowCellValue("TenNganHang").ToString();
itemDTO.TenChiNhanh = gvDanhMucNhaCungCap.GetFocusedRowCellValue("TenChiNhanh").ToString();
itemDTO.GhiChu = gvDanhMucNhaCungCap.GetFocusedRowCellValue("GhiChu").ToString();
itemDTO.Id = int.Parse(gvDanhMucNhaCungCap.GetFocusedRowCellValue("Id").ToString());
if (this.flagThem && gvDanhMucNhaCungCap.FocusedRowHandle == gvDanhMucNhaCungCap.RowCount - 2)
{
if (itemDTO.MaNhaCungCap.Length > 0)
{
DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn thêm mới?", "Thêm mới", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (hopThoai == DialogResult.Yes)
{
itemBUS.Them(itemDTO);
this.flagThem = false;
}
}
else
{
MessageBox.Show("Bạn chưa nhập mã!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn cập nhật?", "Cập nhật", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (hopThoai == DialogResult.Yes)
{
itemBUS.Sua(itemDTO);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
this.LayDanhSachNhaCungCap();
}
}
private void btnTraCuu_Click(object sender, EventArgs e)
{
if (dgvMatHang.Rows.Count > 0)
dgvMatHang.Rows.Clear();
DateTime dtNgayBD = dtTuNgay.Value;
DateTime dtNgayKT = dtDenNgay.Value;
string strNhaCungCap = "0";
if (cbxNhaCC.Checked == true)
strNhaCungCap = cmbNhaCungCap.SelectedValue.ToString();
DataTable dtXuatKho = new DataTable();
dtXuatKho = bllNhapKho.TimKiemDuNo(dtNgayBD, dtNgayKT, strNhaCungCap);
for (int i = 0; i < dtXuatKho.Rows.Count; i++)
{
dgvMatHang.Rows.Add();
string strIDNhaCungCap = dtXuatKho.Rows[i]["MANHACUNGCAP"].ToString();
NhaCungCapDTO dtoNhaCungCap = new NhaCungCapDTO();
dtoNhaCungCap = bllNhaCungCap.GetNhaCungCapByID(strIDNhaCungCap);
dgvMatHang.Rows[i].Cells[0].Value = dtoNhaCungCap.TenNCC;
dgvMatHang.Rows[i].Cells[0].Tag = strIDNhaCungCap;
// Nếu dư nợ - thì cần phải thanh toán
// Nếu dư nợ + thì đã thanh toán
if (dtoNhaCungCap.DuNo < 0)
dgvMatHang.Rows[i].Cells[1].Value = Math.Abs(dtoNhaCungCap.DuNo);
else if (dtoNhaCungCap.DuNo > 0)
dgvMatHang.Rows[i].Cells[2].Value = dtoNhaCungCap.DuNo;
else
{
dgvMatHang.Rows[i].Cells[1].Value = 0;
dgvMatHang.Rows[i].Cells[2].Value = 0;
}
// Phải thanh toán
double dbPhaiThanhToan = double.Parse(dtXuatKho.Rows[i]["THANHTIEN"].ToString());
dgvMatHang.Rows[i].Cells[3].Value = dbPhaiThanhToan;
// Đã thanh toán
double dbDaThanhToan = 0;
DataTable dtPhieuThu = new DataTable();
dtPhieuThu = bllPhieuChi.TimKiem(strIDNhaCungCap, dtNgayBD, dtNgayKT);
if (dtPhieuThu.Rows.Count > 0)
{
dbDaThanhToan = double.Parse(dtPhieuThu.Rows[0]["THANHTIEN"].ToString());
dgvMatHang.Rows[i].Cells[4].Value = dbDaThanhToan;
}
// Tính dư nợ cuối kỳ và đầu kỳ
double dbDuNo = dtoNhaCungCap.DuNo - (dbPhaiThanhToan - dbDaThanhToan);
if (dbDuNo < 0)
dgvMatHang.Rows[i].Cells[5].Value = Math.Abs(dbDuNo);
else
dgvMatHang.Rows[i].Cells[6].Value = dbDuNo;
btnChiTiet.Enabled = true;
}
}
