public void LayTenLoaiHang()
{
try
{
cmbLoaihang.Items.Clear();
client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.LoaiHangHoa nh = new Entities.LoaiHangHoa();
nh = new Entities.LoaiHangHoa("Select");
networkStream = client.SerializeObj(this.tcpClient, "LoaiHangHoa", nh);
nh1 = new Entities.LoaiHangHoa[1];
nh1 = (Entities.LoaiHangHoa[])client.DeserializeHepper1(networkStream, nh1);
if (nh1.Length > 0)
{
int sl = nh1.Length;
for (int i = 0; i < sl; i++)
{
if (nh1[i].Deleted == false)
{
cmbLoaihang.Items.Add(nh1[i].TenLoaiHang);
}
}
}
}
catch
{
}
}
public void checkConflict()
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang("Select");
Entities.NhomHang[] nh1 = new Entities.NhomHang[1];
networkStream = client.SerializeObj(this.tcpClient, "NhanVien", nh);
nh1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1);
if (nh1 != null)
{
for (int j = 0; j < nh1.Length; j++)
{
if (nh1[j].MaNhomHang == txtMaNhomHang.Text)
{
MessageBox.Show("Thất bại");
chck = "No";
txtMaNhomHang.Text = new Common.Utilities().ProcessID(txtMaNhomHang.Text);
break;
}
else
chck = "Yes";
}
}
}
//Check Sửa
public void CheckConflictUpdate()
{
try
{
kt1 = true;
cl = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang("Select");
Entities.NhomHang[] pt1 = new Entities.NhomHang[1];
networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh);
pt1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1);
if (pt1 != null)
{
for (int j = 0; j < pt1.Length; j++)
{
if (pt1[j].MaNhomHang == manhomhang)
{
kt1 = Check(pt1[j]);
break;
}
else
{
kt1 = true;
}
}
}
}
catch (Exception ex)
{
kt1 = false;
}
finally
{
}
}
//Thêm
private void tssThem_Click(object sender, EventArgs e)
{
try
{
if (KiemTra() == true)
{
CheckConflictInsert();
if (kt1 == true)
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
string tenLoaiHang = LayMaLoaiHang(cmbLoaihang.Text);
nh = new Entities.NhomHang("Insert", 0, txtMaNhomHang.Text, tenLoaiHang, txtTenNhomHang.Text, txtGhiChu.Text, false, Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap);
networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh);
bool kt = false;
kt = (bool)client.DeserializeHepper(networkStream, kt);
if (kt == true)
{
this.Close();
}
else
{
MessageBox.Show("thất bại - xin kiểm tra lại dữ liệu", "Hệ thống cảnh báo");
}
}
}
}
catch
{
}
}
//Check Thêm
public void CheckConflictInsert()
{
try
{
kt1 = true;
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang("Select");
Entities.NhomHang[] nh1 = new Entities.NhomHang[1];
networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh);
nh1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1);
if (nh1 != null)
{
for (int j = 0; j < nh1.Length; j++)
{
if (nh1[j].MaLoaiHang == cmbLoaihang.Text)
{
MessageBox.Show("Cập nhật mã hàng hóa", "Hệ thống cảnh báo");
kt1 = false;
manhomhang = txtMaNhomHang.Text = ProID("NhomHang");
break;
}
else
{
kt1 = true;
}
}
}
}
catch (Exception ex)
{
kt1 = false;
}
}
//Lấy dữ liệu từ Database
public void SelectData()
{
try
{
dgvNhomHang.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang("Select");
Entities.NhomHang[] nh1 = new Entities.NhomHang[1];
networkStream = cl.SerializeObj(this.tcpClient, "NhomHang", nh);
nh1 = (Entities.NhomHang[])cl.DeserializeHepper1(networkStream, nh1);
if (nh1 == null)
{
tssXoa.Enabled = false;
tssSua.Enabled = false;
hienthi = new Entities.NhomHang[0];
dgvNhomHang.DataSource = new Entities.NhomHang[0];
return;
}
Entities.NhomHang[] pt2 = new Entities.NhomHang[nh1.Length];
int sotang = 0;
for (int j = 0; j < nh1.Length; j++)
{
if (nh1[j].Deleted == false)
{
pt2[sotang] = nh1[j];
sotang++;
}
}
hienthi = new Entities.NhomHang[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = pt2[j];
}
}
else
{
hienthi = new Entities.NhomHang[0];
dgvNhomHang.DataSource = new Entities.NhomHang[0];
tssXoa.Enabled = false;
tssSua.Enabled = false;
return;
}
tssXoa.Enabled = true;
tssSua.Enabled = true;
dgvNhomHang.DataSource = hienthi;
dgvNhomHang.Rows[0].Selected = true;
}
catch (Exception)
{
}
finally
{
fix();
}
}
public void checkConflict()
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang("Select");
Entities.NhomHang[] nh1 = new Entities.NhomHang[1];
networkStream = client.SerializeObj(this.tcpClient, "NhanVien", nh);
nh1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1);
if (nh1 != null)
{
for (int j = 0; j < nh1.Length; j++)
{
if (nh1[j].MaNhomHang == txtMaNhomHang.Text)
{
MessageBox.Show("Thất bại");
chck = "No";
txtMaNhomHang.Text = new Common.Utilities().ProcessID(txtMaNhomHang.Text);
break;
}
else
{
chck = "Yes";
}
}
}
}
public void Select()
{
try
{
dtgvHienThi.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("NH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
Entities.NhomHang[] kh1 = new Entities.NhomHang[0];
kh1 = (Entities.NhomHang[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 == null)
{
hienthi = new Entities.NhomHang[0];
dtgvHienThi.DataSource = new Entities.NhomHang[0];
return;
}
Entities.NhomHang[] ncc2 = new Entities.NhomHang[kh1.Length];
int sotang = 0;
for (int j = 0; j < kh1.Length; j++)
{
if (kh1[j].Deleted == false)
{
ncc2[sotang] = kh1[j];
sotang++;
}
}
hienthi = new Entities.NhomHang[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = ncc2[j];
}
}
else
{
hienthi = new Entities.NhomHang[0];
dtgvHienThi.DataSource = new Entities.NhomHang[0];
return;
}
dtgvHienThi.DataSource = hienthi;
dtgvHienThi.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix();
}
}
public void Select()
{
try
{
dtgvHienThi.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("NH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
Entities.NhomHang[] kh1 = new Entities.NhomHang[0];
kh1 = (Entities.NhomHang[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 == null)
{
hienthi = new Entities.NhomHang[0];
dtgvHienThi.DataSource = new Entities.NhomHang[0];
return;
}
Entities.NhomHang[] ncc2 = new Entities.NhomHang[kh1.Length];
int sotang = 0;
for (int j = 0; j < kh1.Length; j++)
{
if (kh1[j].Deleted == false)
{
ncc2[sotang] = kh1[j];
sotang++;
}
}
hienthi = new Entities.NhomHang[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = ncc2[j];
}
}
else
{
hienthi = new Entities.NhomHang[0];
dtgvHienThi.DataSource = new Entities.NhomHang[0];
return;
}
dtgvHienThi.DataSource = hienthi;
dtgvHienThi.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix();
}
}
private void tssThem_Click(object sender, EventArgs e)
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang();
nh = new Entities.NhomHang("Insert", 0, txtMaNhomHang.Text, txtMaLoaiHang.Text, txtTenNhomHangHoa.Text, txtGhiChu.Text, false);
networkStream = client.SerializeObj(this.tcpClient, "NhomHangHoa", nh);
bool kt = false;
kt = (bool)client.DeserializeHepper(networkStream, kt);
if (kt == true)
{
MessageBox.Show("Thành công");
}
this.Close();
}
public void SelectNhomHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang ctxh = new Entities.NhomHang("Select");
clientstrem = cl.SerializeObj(this.client1, "NhomHang", ctxh);
nh = (Entities.NhomHang[])cl.DeserializeHepper1(clientstrem, nh);
if (nh == null)
{
nh = new Entities.NhomHang[0];
return;
}
}
catch
{
}
}
//Xóa Data trên Data Grid View
#region Xử lý khi Delete
private void tssXoa_Click(object sender, EventArgs e)
{
try
{
if (!Common.Utilities.User.Administrator && !(new Common.Utilities().CheckQuyen(this.Name, 3)))
{
MessageBox.Show("Bạn không có quyền vào", "Hệ thống cảnh báo");
return;
}
if (new Check().CheckReference("NhomHang", dgvNhomHang["MaNhomHang", i].Value.ToString()) == false)
{
MessageBox.Show("Nhóm hàng này đang có giao dịch không thể xóa", "Hệ thống cảnh báo");
return;
}
System.Windows.Forms.DialogResult giatri = System.Windows.Forms.MessageBox.Show("Bạn chắc chắn muốn Xóa không?", "Hệ Thống Cảnh Báo", System.Windows.Forms.MessageBoxButtons.YesNo);
{
if (giatri == System.Windows.Forms.DialogResult.Yes)
{
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang();
nh = new Entities.NhomHang("Delete", int.Parse(dgvNhomHang.CurrentRow.Cells["NhomHangID"].Value.ToString()), Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap);
networkStream = cl.SerializeObj(this.tcpClient, "NhomHang", nh);
bool kt = false;
kt = (bool)cl.DeserializeHepper(networkStream, kt);
if (kt == true)
{
}
else
{
MessageBox.Show("thất bại - xin hãy kiểm tra lại", "Hệ thống cảnh báo");
}
SelectData();
}
}
}
catch
{
}
}
public bool Check(Entities.NhomHang nh)
{
bool gt = true;
if (loaihanghoa != nh.MaLoaiHang)
{
loaihanghoa = nh.MaLoaiHang;
cmbLoaihang.Text = LayTenLoaiHang(loaihanghoa);
gt = false;
}
if (tennhomhang != nh.TenNhomHang)
{
tennhomhang = txtTenNhomHang.Text = nh.TenNhomHang;
gt = false;
}
if (ghichu != nh.GhiChu)
{
ghichu = txtGhiChu.Text = nh.GhiChu;
gt = false;
}
return(gt);
}
//Check Thêm
public void CheckConflictInsert()
{
try
{
kt1 = true;
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang("Select");
Entities.NhomHang[] nh1 = new Entities.NhomHang[1];
networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh);
nh1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1);
if (nh1 != null)
{
for (int j = 0; j < nh1.Length; j++)
{
if (nh1[j].MaLoaiHang == cmbLoaihang.Text)
{
MessageBox.Show("Cập nhật mã hàng hóa", "Hệ thống cảnh báo");
kt1 = false;
manhomhang = txtMaNhomHang.Text = ProID("NhomHang");
break;
}
else
kt1 = true;
}
}
}
catch (Exception ex)
{
kt1 = false;
}
}
private void txttimkiem_TextChanged(object sender, EventArgs e)
{
try
{
if (rdbtimkiem3.Checked == true)
{
return;
}
if (txttimkiem.Text.Length == 0)
{
dgvNhomHang.DataSource = new Entities.NhomHang[0];
return;
}
int soluong = 0;
if (rdbtimkiem1.Checked == true)
{
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].TenNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dgvNhomHang.DataSource = new Entities.NhomHang[0];
return;
}
Entities.NhomHang[] hienthitheoid = new Entities.NhomHang[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].TenNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoid[soluong] = hienthi[i];
soluong++;
}
}
dgvNhomHang.DataSource = hienthitheoid;
}
if (rdbtimkiem2.Checked == true)
{
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dgvNhomHang.DataSource = new Entities.NhomHang[0];
return;
}
Entities.NhomHang[] hienthitheoma = new Entities.NhomHang[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoma[soluong] = hienthi[i];
soluong++;
}
}
dgvNhomHang.DataSource = hienthitheoma;
}
}
finally
{
fix();
}
}
public Entities.BCNhapHangTheoNhomHang Select()
{
Entities.BCNhapHangTheoNhomHang list = null;
try
{
list = new Entities.BCNhapHangTheoNhomHang();
////Lấy hóa đơn nhập
//con = new Connection();
//cn = con.openConnection();
//List<Entities.HoaDonNhap> HoaDonNhap = new List<Entities.HoaDonNhap>();
//cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
//cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HoaDonNhap";
//dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//while (dr.Read())
//{
// Entities.HoaDonNhap row = new Entities.HoaDonNhap();
// row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString();
// row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
// HoaDonNhap.Add(row);
//}
//list.HoaDonNhap = HoaDonNhap;
//cmd.Connection.Dispose();
//cn.Close();
//con.closeConnection();
//Lấy chi tiết hóa đơn nhập
con = new Connection();
cn = con.openConnection();
List <Entities.ChiTietHoaDonNhap> ChiTietHoaDonNhap = new List <Entities.ChiTietHoaDonNhap>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietHoaDonNhap";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.ChiTietHoaDonNhap row = new Entities.ChiTietHoaDonNhap();
row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString();
row.MaHangHoa = dr["MaHangHoa"].ToString();
row.SoLuong = int.Parse(dr["SoLuong"].ToString());
row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
ChiTietHoaDonNhap.Add(row);
}
list.ChiTietHoaDonNhap = ChiTietHoaDonNhap;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
////Lấy khách hàng trả lại
//con = new Connection();
//cn = con.openConnection();
//List<Entities.KhachHangTraLai> KhachHangTraLai = new List<Entities.KhachHangTraLai>();
//cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
//cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "KhachHangTraLai";
//dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//while (dr.Read())
//{
// Entities.KhachHangTraLai row = new Entities.KhachHangTraLai();
// row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString();
// row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
// KhachHangTraLai.Add(row);
//}
//list.KhachHangTraLai = KhachHangTraLai;
//cmd.Connection.Dispose();
//cn.Close();
//con.closeConnection();
//Lấy chi tiết khách hàng trả lại
con = new Connection();
cn = con.openConnection();
List <Entities.ChiTietKhachHangTraLai> ChiTietKhachHangTraLai = new List <Entities.ChiTietKhachHangTraLai>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietKhachHangTraLai";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.ChiTietKhachHangTraLai row = new Entities.ChiTietKhachHangTraLai();
row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString();
row.MaHangHoa = dr["MaHangHoa"].ToString();
row.SoLuong = int.Parse(dr["SoLuong"].ToString());
row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
ChiTietKhachHangTraLai.Add(row);
}
list.ChiTietKhachHangTraLai = ChiTietKhachHangTraLai;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
//Lấy hàng hóa nhóm hàng
con = new Connection();
cn = con.openConnection();
List <Entities.HangHoa> HangHoa = new List <Entities.HangHoa>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HangHoaNhomHang";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.HangHoa row = new Entities.HangHoa();
row.MaHangHoa = dr["MaHangHoa"].ToString();
row.TenHangHoa = dr["TenHangHoa"].ToString();
row.MaNhomHangHoa = dr["MaNhomHang"].ToString();
row.TenNhomHangHoa = dr["TenNhomHang"].ToString();
HangHoa.Add(row);
}
list.HangHoa = HangHoa;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
//Lấy nhóm hàng
con = new Connection();
cn = con.openConnection();
List <Entities.NhomHang> NhomHang = new List <Entities.NhomHang>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "NhomHang";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.NhomHang row = new Entities.NhomHang();
row.MaNhomHang = dr["MaNhomHang"].ToString();
row.TenNhomHang = dr["TenNhomHang"].ToString();
NhomHang.Add(row);
}
list.NhomHang = NhomHang;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
//Lấy gói hàng
con = new Connection();
cn = con.openConnection();
List <Entities.GoiHang> GoiHang = new List <Entities.GoiHang>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "GoiHang";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.GoiHang row = new Entities.GoiHang();
row.MaGoiHang = dr["MaGoiHang"].ToString();
GoiHang.Add(row);
}
list.GoiHang = GoiHang;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
//Lấy chi tiết gói hàng
con = new Connection();
cn = con.openConnection();
List <Entities.ChiTietGoiHang> ChiTietGoiHang = new List <Entities.ChiTietGoiHang>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietGoiHang";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.ChiTietGoiHang row = new Entities.ChiTietGoiHang();
row.MaGoiHang = dr["MaGoiHang"].ToString();
row.MaHangHoa = dr["MaHangHoa"].ToString();
row.SoLuong = int.Parse(dr["SoLuong"].ToString());
ChiTietGoiHang.Add(row);
}
list.ChiTietGoiHang = ChiTietGoiHang;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
}
catch { return(null); }
finally
{
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
}
return(list);
}
public Entities.BCNhapHangTheoNhomHang Select()
{
Entities.BCNhapHangTheoNhomHang list = null;
try
{
list = new Entities.BCNhapHangTheoNhomHang();
////Lấy hóa đơn nhập
//con = new Connection();
//cn = con.openConnection();
//List<Entities.HoaDonNhap> HoaDonNhap = new List<Entities.HoaDonNhap>();
//cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
//cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HoaDonNhap";
//dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//while (dr.Read())
//{
// Entities.HoaDonNhap row = new Entities.HoaDonNhap();
// row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString();
// row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
// HoaDonNhap.Add(row);
//}
//list.HoaDonNhap = HoaDonNhap;
//cmd.Connection.Dispose();
//cn.Close();
//con.closeConnection();
//Lấy chi tiết hóa đơn nhập
con = new Connection();
cn = con.openConnection();
List<Entities.ChiTietHoaDonNhap> ChiTietHoaDonNhap = new List<Entities.ChiTietHoaDonNhap>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietHoaDonNhap";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.ChiTietHoaDonNhap row = new Entities.ChiTietHoaDonNhap();
row.MaHoaDonNhap = dr["MaHoaDonNhap"].ToString();
row.MaHangHoa = dr["MaHangHoa"].ToString();
row.SoLuong = int.Parse(dr["SoLuong"].ToString());
row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
ChiTietHoaDonNhap.Add(row);
}
list.ChiTietHoaDonNhap = ChiTietHoaDonNhap;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
////Lấy khách hàng trả lại
//con = new Connection();
//cn = con.openConnection();
//List<Entities.KhachHangTraLai> KhachHangTraLai = new List<Entities.KhachHangTraLai>();
//cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
//cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "KhachHangTraLai";
//dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//while (dr.Read())
//{
// Entities.KhachHangTraLai row = new Entities.KhachHangTraLai();
// row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString();
// row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
// KhachHangTraLai.Add(row);
//}
//list.KhachHangTraLai = KhachHangTraLai;
//cmd.Connection.Dispose();
//cn.Close();
//con.closeConnection();
//Lấy chi tiết khách hàng trả lại
con = new Connection();
cn = con.openConnection();
List<Entities.ChiTietKhachHangTraLai> ChiTietKhachHangTraLai = new List<Entities.ChiTietKhachHangTraLai>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietKhachHangTraLai";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.ChiTietKhachHangTraLai row = new Entities.ChiTietKhachHangTraLai();
row.MaKhachHangTraLai = dr["MaKhachHangTraLai"].ToString();
row.MaHangHoa = dr["MaHangHoa"].ToString();
row.SoLuong = int.Parse(dr["SoLuong"].ToString());
row.NgayNhap = DateTime.Parse(dr["NgayNhap"].ToString());
ChiTietKhachHangTraLai.Add(row);
}
list.ChiTietKhachHangTraLai = ChiTietKhachHangTraLai;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
//Lấy hàng hóa nhóm hàng
con = new Connection();
cn = con.openConnection();
List<Entities.HangHoa> HangHoa = new List<Entities.HangHoa>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "HangHoaNhomHang";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.HangHoa row = new Entities.HangHoa();
row.MaHangHoa = dr["MaHangHoa"].ToString();
row.TenHangHoa = dr["TenHangHoa"].ToString();
row.MaNhomHangHoa = dr["MaNhomHang"].ToString();
row.TenNhomHangHoa = dr["TenNhomHang"].ToString();
HangHoa.Add(row);
}
list.HangHoa = HangHoa;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
//Lấy nhóm hàng
con = new Connection();
cn = con.openConnection();
List<Entities.NhomHang> NhomHang = new List<Entities.NhomHang>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "NhomHang";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.NhomHang row = new Entities.NhomHang();
row.MaNhomHang = dr["MaNhomHang"].ToString();
row.TenNhomHang = dr["TenNhomHang"].ToString();
NhomHang.Add(row);
}
list.NhomHang = NhomHang;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
//Lấy gói hàng
con = new Connection();
cn = con.openConnection();
List<Entities.GoiHang> GoiHang = new List<Entities.GoiHang>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "GoiHang";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.GoiHang row = new Entities.GoiHang();
row.MaGoiHang = dr["MaGoiHang"].ToString();
GoiHang.Add(row);
}
list.GoiHang = GoiHang;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
//Lấy chi tiết gói hàng
con = new Connection();
cn = con.openConnection();
List<Entities.ChiTietGoiHang> ChiTietGoiHang = new List<Entities.ChiTietGoiHang>();
cmd = new SqlCommand("exec sp_BCNhapHangTheoNhomHangFIX @ThaoTac", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = "ChiTietGoiHang";
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
Entities.ChiTietGoiHang row = new Entities.ChiTietGoiHang();
row.MaGoiHang = dr["MaGoiHang"].ToString();
row.MaHangHoa = dr["MaHangHoa"].ToString();
row.SoLuong = int.Parse(dr["SoLuong"].ToString());
ChiTietGoiHang.Add(row);
}
list.ChiTietGoiHang = ChiTietGoiHang;
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
}
catch { return null; }
finally
{
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
}
return list;
}
private void tssThem_Click(object sender, EventArgs e)
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang();
nh = new Entities.NhomHang("Insert", 0, txtMaNhomHang.Text, txtMaLoaiHang.Text, txtTenNhomHang.Text, txtGhiChu.Text, false);
networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh);
bool kt = false;
kt = (bool)client.DeserializeHepper(networkStream, kt);
if (kt == true)
{
MessageBox.Show("Thành công");
}
this.Close();
}
//Lấy Mã Nhóm Hàng Hóa
public void LayMaNhomHangHoa(string maLH)
{
client = new Server_Client.Client();
this.client1 = client.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang();
nh = new Entities.NhomHang("Select");
clientstrem = client.SerializeObj(this.client1, "NhomHang", nh);
Entities.NhomHang[] nh1 = new Entities.NhomHang[1];
nh1 = (Entities.NhomHang[])client.DeserializeHepper1(clientstrem, nh1);
if (nh1 != null)
{
int count = 0;
for (int i = 0; i < nh1.Length; i++)
{
if (nh1[i].MaLoaiHang == maLH)
{
count++;
}
}
Entities.NhomHang[] nhomhang = new Entities.NhomHang[count];
count = 0;
for (int i = 0; i < nh1.Length; i++)
{
if (nh1[i].MaLoaiHang == maLH)
{
nhomhang[count] = nh1[i];
count++;
}
}
cmbMaNhomHangHoa.DataSource = nhomhang;
cmbMaNhomHangHoa.DisplayMember = "TenNhomHang";
}
}
public void SelectNhomHang()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang ctxh = new Entities.NhomHang("Select");
clientstrem = cl.SerializeObj(this.client1, "NhomHang", ctxh);
nh = (Entities.NhomHang[])cl.DeserializeHepper1(clientstrem, nh);
if (nh == null)
{
nh = new Entities.NhomHang[0];
return;
}
}
catch
{
}
}
public void LayTenLoaiHang()
{
try
{
cmbLoaihang.Items.Clear();
client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.LoaiHangHoa nh = new Entities.LoaiHangHoa();
nh = new Entities.LoaiHangHoa("Select");
networkStream = client.SerializeObj(this.tcpClient, "LoaiHangHoa", nh);
nh1 = new Entities.LoaiHangHoa[1];
nh1 = (Entities.LoaiHangHoa[])client.DeserializeHepper1(networkStream, nh1);
if (nh1.Length > 0)
{
int sl = nh1.Length;
for (int i = 0; i < sl; i++)
{
if (nh1[i].Deleted == false)
cmbLoaihang.Items.Add(nh1[i].TenLoaiHang);
}
}
}
catch
{
}
}
public int cbbLoaiHangHoa_sua(string maNH)
{
client = new Server_Client.Client();
this.client1 = client.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh1 = new Entities.NhomHang();
nh1 = new Entities.NhomHang("Select");
clientstrem = client.SerializeObj(this.client1, "NhomHang", nh1);
Entities.NhomHang[] nh = new Entities.NhomHang[1];
nh = (Entities.NhomHang[])client.DeserializeHepper1(clientstrem, nh);
string maloaihang = "";
if (nh != null)
{
for (int i = 0; i < nh.Length; i++)
{
if (nh[i].MaNhomHang == maNH)
{
maloaihang = nh[i].MaLoaiHang;
break;
}
}
Entities.LoaiHangHoa[] pb = (Entities.LoaiHangHoa[])cbbLoaiHangHoa.DataSource;
for (int i = 0; i < pb.Length; i++)
{
if (pb[i].MaLoaiHang == maloaihang)
{
return i;
}
}
return -1;
}
return -1;
}
//Check Sửa
public void CheckConflictUpdate()
{
try
{
kt1 = true;
cl = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang("Select");
Entities.NhomHang[] pt1 = new Entities.NhomHang[1];
networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh);
pt1 = (Entities.NhomHang[])client.DeserializeHepper1(networkStream, nh1);
if (pt1 != null)
{
for (int j = 0; j < pt1.Length; j++)
{
if (pt1[j].MaNhomHang == manhomhang)
{
kt1 = Check(pt1[j]);
break;
}
else
kt1 = true;
}
}
}
catch (Exception ex)
{
kt1 = false;
}
finally
{
}
}
private void tssXoa_Click(object sender, EventArgs e)
{
try
{
if (!Common.Utilities.User.Administrator && !(new Common.Utilities().CheckQuyen(this.Name, 3)))
{
MessageBox.Show("Bạn không có quyền vào", "Hệ thống cảnh báo");
return;
}
if (new Check().CheckReference("NhomHang", dgvNhomHang["MaNhomHang", i].Value.ToString()) == false)
{
MessageBox.Show("Nhóm hàng này đang có giao dịch không thể xóa", "Hệ thống cảnh báo");
return;
}
System.Windows.Forms.DialogResult giatri = System.Windows.Forms.MessageBox.Show("Bạn chắc chắn muốn Xóa không?", "Hệ Thống Cảnh Báo", System.Windows.Forms.MessageBoxButtons.YesNo);
{
if (giatri == System.Windows.Forms.DialogResult.Yes)
{
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang();
nh = new Entities.NhomHang("Delete", int.Parse(dgvNhomHang.CurrentRow.Cells["NhomHangID"].Value.ToString()),Common.Utilities.User.NhanVienID,Common.Utilities.User.TenDangNhap);
networkStream = cl.SerializeObj(this.tcpClient, "NhomHang", nh);
bool kt = false;
kt = (bool)cl.DeserializeHepper(networkStream, kt);
if (kt == true)
{
}
else
MessageBox.Show("thất bại - xin hãy kiểm tra lại", "Hệ thống cảnh báo");
SelectData();
}
}
}
catch
{
}
}
private void txtGhiChu_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (str == "Insert")
{
try
{
if (KiemTra() == true)
{
CheckConflictInsert();
if (kt1 == true)
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
string tenLoaiHang = LayMaLoaiHang(cmbLoaihang.Text);
nh = new Entities.NhomHang("Insert", 0, txtMaNhomHang.Text, tenLoaiHang, txtTenNhomHang.Text, txtGhiChu.Text, false, Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap);
networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh);
bool kt = false;
kt = (bool)client.DeserializeHepper(networkStream, kt);
if (kt == true)
{
this.Close();
}
else
{
MessageBox.Show("thất bại - xin kiểm tra lại dữ liệu", "Hệ thống cảnh báo");
}
}
}
}
catch
{
}
}
else
{
try
{
if (KiemTra() == true)
{
CheckConflictUpdate();
if (kt1 == true)
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
nh = new Entities.NhomHang();
string tenLoaiHang = LayMaLoaiHang(cmbLoaihang.Text);
nh = new Entities.NhomHang("Update", int.Parse(id), txtMaNhomHang.Text, tenLoaiHang, txtTenNhomHang.Text, txtGhiChu.Text, false, Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap);
networkStream = client.SerializeObj(this.tcpClient, "NhomHang", nh);
bool kt = false;
kt = (bool)client.DeserializeHepper(networkStream, kt);
if (kt == true)
{
this.Close();
}
else
{
MessageBox.Show("thất bại - xin kiểm tra lại dữ liệu", "Hệ thống cảnh báo");
}
}
else
{
MessageBox.Show("Dữ liệu đã bị thay đổi - kiểm tra lại", "Hệ thống cảnh báo");
}
}
}
catch
{
}
}
}
}
private void txttimkiem_TextChanged(object sender, EventArgs e)
{
try
{
if (rdbtimkiem3.Checked == true)
{
return;
}
if (txttimkiem.Text.Length == 0)
{
dgvNhomHang.DataSource = new Entities.NhomHang[0];
return;
}
int soluong = 0;
if (rdbtimkiem1.Checked == true)
{
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].TenNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dgvNhomHang.DataSource = new Entities.NhomHang[0];
return;
}
Entities.NhomHang[] hienthitheoid = new Entities.NhomHang[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].TenNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoid[soluong] = hienthi[i];
soluong++;
}
}
dgvNhomHang.DataSource = hienthitheoid;
}
if (rdbtimkiem2.Checked == true)
{
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dgvNhomHang.DataSource = new Entities.NhomHang[0];
return;
}
Entities.NhomHang[] hienthitheoma = new Entities.NhomHang[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaNhomHang.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoma[soluong] = hienthi[i];
soluong++;
}
}
dgvNhomHang.DataSource = hienthitheoma;
}
}
finally
{
fix();
}
}
//Lấy dữ liệu từ Database
public void SelectData()
{
try
{
dgvNhomHang.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nh = new Entities.NhomHang("Select");
Entities.NhomHang[] nh1 = new Entities.NhomHang[1];
networkStream = cl.SerializeObj(this.tcpClient, "NhomHang", nh);
nh1 = (Entities.NhomHang[])cl.DeserializeHepper1(networkStream, nh1);
if (nh1 == null)
{
tssXoa.Enabled = false;
tssSua.Enabled = false;
hienthi = new Entities.NhomHang[0];
dgvNhomHang.DataSource = new Entities.NhomHang[0];
return;
}
Entities.NhomHang[] pt2 = new Entities.NhomHang[nh1.Length];
int sotang = 0;
for (int j = 0; j < nh1.Length; j++)
{
if (nh1[j].Deleted == false)
{
pt2[sotang] = nh1[j];
sotang++;
}
}
hienthi = new Entities.NhomHang[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = pt2[j];
}
}
else
{
hienthi = new Entities.NhomHang[0];
dgvNhomHang.DataSource = new Entities.NhomHang[0];
tssXoa.Enabled = false;
tssSua.Enabled = false;
return;
}
tssXoa.Enabled = true;
tssSua.Enabled = true;
dgvNhomHang.DataSource = hienthi;
dgvNhomHang.Rows[0].Selected = true;
}
catch (Exception)
{
}
finally
{
fix();
}
}
/// <summary>
/// lấy mã nhóm hàng
/// </summary>
public void LayMaNhomHang()
{
try
{
cbbnhomhangcaptren.Items.Clear();
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.NhomHang nhh = new Entities.NhomHang();
nhh = new Entities.NhomHang("Select");
clientstrem = cl.SerializeObj(this.client1, "NhomHang", nhh);
nhh1 = new Entities.NhomHang[1];
nhh1 = (Entities.NhomHang[])cl.DeserializeHepper1(clientstrem, nhh1);
if (nhh1.Length > 0)
{
int sl = nhh1.Length;
for (int i = 0; i < sl; i++)
{
if (nhh1[i].Deleted == false)
cbbnhomhangcaptren.Items.Add(nhh1[i].TenNhomHang);
}
}
}
catch { }
}
