public void checkConflict()
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa hh = new Entities.HangHoa("Select");
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
networkStream = client.SerializeObj(this.tcpClient, "NhanVien", hh);
hh1 = (Entities.HangHoa[])client.DeserializeHepper1(networkStream, hh1);
if (hh1 != null)
{
for (int j = 0; j < hh1.Length; j++)
{
if (hh1[j].MaHangHoa == txtMaHangHoa.Text)
{
MessageBox.Show("Thất bại");
chck = "No";
txtMaHangHoa.Text = new Common.Utilities().ProcessID(txtMaHangHoa.Text);
break;
}
else
chck = "Yes";
}
}
}
public void checkConflict()
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa hh = new Entities.HangHoa("Select");
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
networkStream = client.SerializeObj(this.tcpClient, "NhanVien", hh);
hh1 = (Entities.HangHoa[])client.DeserializeHepper1(networkStream, hh1);
if (hh1 != null)
{
for (int j = 0; j < hh1.Length; j++)
{
if (hh1[j].MaHangHoa == txtMaHangHoa.Text)
{
MessageBox.Show("Thất bại");
chck = "No";
txtMaHangHoa.Text = new Common.Utilities().ProcessID(txtMaHangHoa.Text);
break;
}
else
{
chck = "Yes";
}
}
}
}
public Entities.HangHoa[] HangHoaTheoKho(string makho)
{
Entities.HangHoa[] hanghoa = new BizLogic.HangHoa().SelectHHTheoKho(makho);
if (hanghoa == null)
{
hanghoa = new Entities.HangHoa[0];
}
return(hanghoa);
}
public void Select()
{
try
{
dtgvKH.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("HH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
Entities.HangHoa[] kh1 = new Entities.HangHoa[0];
kh1 = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 == null)
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
Entities.HangHoa[] ncc2 = new Entities.HangHoa[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.HangHoa[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = ncc2[j];
}
}
else
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
dtgvKH.DataSource = hienthi;
dtgvKH.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix1();
}
}
public Entities.HangHoa[] SelectHHTheoKho(string maKho)
{
List <Entities.HangHoa> l = new List <Entities.HangHoa>();
try
{
cn = new Connection().openConnection();
cmd = new SqlCommand("exec sp_HangHoaFIX @ThaoTac,@MaHangHoa,@MaNhomHangHoa,@TenHangHoa,@MaDonViTinh,@GiaNhap,@GiaBanBuon,@GiaBanLe,@MaThueGiaTriGiaTang,@KieuHangHoa,@SeriLo,@MucDatHang,@MucTonToiThieu,@GhiChu,@Deleted", cn);
Entities.HangHoa input = new Entities.HangHoa();
input.ThaoTac = "select_TheoKho";
input.GhiChu = maKho;
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = input.ThaoTac;
cmd.Parameters.Add("MaHangHoa", SqlDbType.VarChar).Value = input.MaHangHoa;
cmd.Parameters.Add("MaNhomHangHoa", SqlDbType.NVarChar).Value = input.MaNhomHangHoa;
cmd.Parameters.Add("TenHangHoa", SqlDbType.NVarChar).Value = input.TenHangHoa;
cmd.Parameters.Add("MaDonViTinh", SqlDbType.NVarChar).Value = input.MaDonViTinh;
cmd.Parameters.Add("GiaNhap", SqlDbType.Float).Value = 0;
cmd.Parameters.Add("GiaBanBuon", SqlDbType.Float).Value = 0;
cmd.Parameters.Add("GiaBanLe", SqlDbType.Float).Value = 0;
cmd.Parameters.Add("MaThueGiaTriGiaTang", SqlDbType.NVarChar).Value = input.MaThueGiaTriGiaTang;
cmd.Parameters.Add("KieuHangHoa", SqlDbType.NVarChar).Value = input.KieuHangHoa;
cmd.Parameters.Add("SeriLo", SqlDbType.NVarChar).Value = input.SeriLo;
cmd.Parameters.Add("MucDatHang", SqlDbType.NVarChar).Value = input.MucDatHang;
cmd.Parameters.Add("MucTonToiThieu", SqlDbType.NVarChar).Value = input.MucTonToiThieu;
cmd.Parameters.Add("GhiChu", SqlDbType.NVarChar).Value = input.GhiChu;
cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
hanghoa = new Entities.HangHoa();
hanghoa.MaHangHoa = dr[Constants.HangHoaSTATIC.MaHangHoa].ToString();
hanghoa.MaNhomHangHoa = dr[Constants.HangHoaSTATIC.MaNhomHangHoa].ToString();
hanghoa.TenHangHoa = dr[Constants.HangHoaSTATIC.TenHangHoa].ToString();
hanghoa.MaDonViTinh = dr[Constants.HangHoaSTATIC.MaDonViTinh].ToString();
hanghoa.TenDonViTinh = dr[Constants.HangHoaSTATIC.TenDonViTinh].ToString();
hanghoa.GiaNhap = dr[Constants.HangHoaSTATIC.GiaNhap].ToString();
hanghoa.GiaBanBuon = dr[Constants.HangHoaSTATIC.GiaBanBuon].ToString();
hanghoa.GiaBanLe = dr[Constants.HangHoaSTATIC.GiaBanLe].ToString();
hanghoa.MaThueGiaTriGiaTang = dr[Constants.HangHoaSTATIC.MaThueGiaTriGiaTang].ToString();
hanghoa.KieuHangHoa = dr[Constants.HangHoaSTATIC.KieuHangHoa].ToString();
hanghoa.SeriLo = dr[Constants.HangHoaSTATIC.SeriLo].ToString();
hanghoa.MucDatHang = Convert.ToInt32(dr[Constants.HangHoaSTATIC.MucDatHang].ToString());
hanghoa.MucTonToiThieu = Convert.ToInt32(dr[Constants.HangHoaSTATIC.MucTonToiThieu].ToString());
hanghoa.GhiChu = dr[Constants.HangHoaSTATIC.GhiChu].ToString();
l.Add(hanghoa);
}
}
catch { return(null); }
finally
{
cmd.Connection.Dispose();
cn.Close();
}
return(l.ToArray());
}
public HangHoa()
{
hh = null;
Sql = null;
conn = null;
cmd = null;
arr = null;
dr = null;
hanghoa = null;
cn = null;
}
public HangHoa()
{
hh = null;
Sql = null;
conn = null;
cmd = null;
arr = null;
dr = null;
hanghoa = null;
cn = null;
}
public void SelectDataHHTK()
{
try
{
ArrayList array = new ArrayList();
dtgvKH.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa kh = new Entities.HangHoa("SelectTheoKho", maKho);
Entities.HangHoa[] kh1 = new Entities.HangHoa[1];
clientstrem = cl.SerializeObj(this.client1, "HangHoa", kh);
kh1 = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 == null)
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
foreach (Entities.HangHoa item in kh1)
{
if (item.Deleted == false)
{
array.Add(item);
}
}
if (array.Count != 0)
{
Entities.HangHoa[] save = Common.Utilities.CheckGoiHang((Entities.HangHoa[])array.ToArray(typeof(Entities.HangHoa)), goihang, chitietgoihang);
foreach (Entities.HangHoa item in save)
{
array.Add(item);
}
hienthi = (Entities.HangHoa[])array.ToArray(typeof(Entities.HangHoa));
}
else
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
dtgvKH.DataSource = hienthi;
dtgvKH.Rows[0].Selected = true;
}
catch
{
}
finally
{
fix();
}
}
public void LayBangHangHoa()
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "Select", new Entities.CheckRefer("HH", ""));
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = (Entities.HangHoa[])cl.DeserializeHepper(clientstrem, hh1);
if (hh1 == null)
{
hanghoa = new Entities.HangHoa[0];
}
hanghoa = hh1;
}
public void LayBangHangHoa()
{
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = new BizLogic.HangHoa().Select();
if (hh1 != null)
{
hanghoa = hh1;
}
else
{
hanghoa = new Entities.HangHoa[0];
}
}
//Xử Lý Thêm
#region Xử Lý Thêm
private void btnThem_Click(object sender, EventArgs e)
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa hh = new Entities.HangHoa();
//hh = new Entities.HangHoa("Insert", 0, txtMaHangHoa.Text,txtMaNhomHangHoa.Text,txtTenHangHoa.Text,cmbMaNhaSanXuat.SelectedItem.ToString(),txtMaVachNSX.Text,cmbMaDonViTinh.SelectedItem.ToString(),int.Parse(txtGiaNhap.Text),int.Parse(txtGiaBanBuon.Text),int.Parse(txtGiaBanLe.Text),cmbMaThueGTGT.SelectedItem.ToString(),cmbKieuHangHoa.SelectedItem.ToString(),txtSeri.Text,int.Parse(txtMucDatHang.Text),int.Parse(txtMucTonToiThieu.Text),txtGhiChu.Text,false);
networkStream = client.SerializeObj(this.tcpClient, "HangHoa", hh);
bool kt = false;
kt = (bool)client.DeserializeHepper(networkStream, kt);
if (kt == true)
{
MessageBox.Show("Thành công");
}
this.Close();
}
public void LayHangHoa()
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa ctxh = new Entities.HangHoa("Select");
clientstrem = cl.SerializeObj(this.client, "HangHoa", ctxh);
HangHoa = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, HangHoa);
if (HangHoa == null)
{
HangHoa = new Entities.HangHoa[0];
return;
}
}
catch { }
}
//Sửa Hàng Hóa
#region Xử lý Khi Sửa
private void tssSua_Click(object sender, EventArgs e)
{
if (KiemTra() == true)
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa hh = new Entities.HangHoa();
hh = new Entities.HangHoa("Update", int.Parse(txtHangHoaID.Text), txtMaHangHoa.Text, txtMaNhomHang.Text, txtTenHangHoa.Text, cmbMaNhaSanXuat.Text, txtMaVachNSX.Text, cmbMaDonViTinh.Text, float.Parse(txtGiaNhap.Text), float.Parse(txtGiaBanBuon.Text), float.Parse(txtGiaBanLe.Text), cmbMathueNhapKhau.Text, cmbMaThueXuatKhau.Text, cmbMaThueTieuThuDacBiet.Text, cmbMaThueGTGT.Text, txtKieuHangHoa.Text, txtSeri.Text, int.Parse(txtMucDatHang.Text), int.Parse(txtMucTonToiThieu.Text), txtChiTietThem.Text, txtNgungTheoDoi.Text, txtGhiChu.Text, false);
networkStream = client.SerializeObj(this.tcpClient, "HangHoa", hh);
bool kt = false;
kt = (bool)client.DeserializeHepper(networkStream, kt);
if (kt == true)
{
MessageBox.Show("Thành công");
}
this.Close();
}
}
//delete
public int Delete(Entities.HangHoa hh1)
{
hh = new Constants.HangHoa();
Entities.HangHoa hanghoa = new Entities.HangHoa();
Sql = new Constants.Sql();
string sql = Sql.DeleteHangHoa;
Connection conn = new Connection();
SqlConnection cn = conn.openConnection();
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add(hh.HanhDong, SqlDbType.NVarChar, 20).Value = hh1.HanhDong;
cmd.Parameters.Add(hh.HangHoaID, SqlDbType.Int).Value = hh1.HangHoaID;
int i = cmd.ExecuteNonQuery();
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
cn = null;
conn = null;
return i;
}
//delete
public int Delete(Entities.HangHoa hh1)
{
hh = new Constants.HangHoa();
Entities.HangHoa hanghoa = new Entities.HangHoa();
Sql = new Constants.Sql();
string sql = Sql.DeleteHangHoa;
Connection conn = new Connection();
SqlConnection cn = conn.openConnection();
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add(hh.HanhDong, SqlDbType.NVarChar, 20).Value = hh1.HanhDong;
cmd.Parameters.Add(hh.HangHoaID, SqlDbType.Int).Value = hh1.HangHoaID;
int i = cmd.ExecuteNonQuery();
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
cn = null;
conn = null;
return(i);
}
//insert update
public int InsertUpdate(Entities.HangHoa hh1)
{
try
{
hh = new Constants.HangHoa();
Sql = new Constants.Sql();
string sql = Sql.InsertUpdateHangHoa;
Connection conn = new Connection();
SqlConnection cn = conn.openConnection();
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add(hh.HanhDong, SqlDbType.NVarChar, 20).Value = hh1.HanhDong;
cmd.Parameters.Add(hh.MaHangHoa, SqlDbType.NVarChar, 50).Value = hh1.MaHangHoa;
cmd.Parameters.Add(hh.MaNhomHangHoa, SqlDbType.NVarChar, 20).Value = hh1.MaNhomHangHoa;
cmd.Parameters.Add(hh.TenHangHoa, SqlDbType.NVarChar, 200).Value = hh1.TenHangHoa;
cmd.Parameters.Add(hh.MaDonViTinh, SqlDbType.NVarChar, 20).Value = hh1.MaDonViTinh;
cmd.Parameters.Add(hh.GiaNhap, SqlDbType.Float).Value = hh1.GiaNhap;
cmd.Parameters.Add(hh.GiaBanBuon, SqlDbType.Float).Value = hh1.GiaBanBuon;
cmd.Parameters.Add(hh.GiaBanLe, SqlDbType.Float).Value = hh1.GiaBanLe;
cmd.Parameters.Add(hh.MaThueGiaTriGiaTang, SqlDbType.NVarChar, 20).Value = hh1.MaThueGiaTriGiaTang;
cmd.Parameters.Add(hh.KieuHangHoa, SqlDbType.NVarChar, 20).Value = hh1.KieuHangHoa;
cmd.Parameters.Add(hh.SeriLo, SqlDbType.NVarChar, 20).Value = hh1.SeriLo;
cmd.Parameters.Add(hh.MucDatHang, SqlDbType.Int).Value = hh1.MucDatHang;
cmd.Parameters.Add(hh.MucTonToiThieu, SqlDbType.Int).Value = hh1.MucTonToiThieu;
cmd.Parameters.Add(hh.GhiChu, SqlDbType.NVarChar, 100).Value = hh1.GhiChu;
cmd.Parameters.Add(hh.Deleted, SqlDbType.Bit).Value = hh1.Deleted;
int i = cmd.ExecuteNonQuery();
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
cn = null;
conn = null;
return(i);
}
catch { return(0); }
}
public void LayBangHangHoa()
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
clientstrem = cl.SerializeObj(this.client, "Select", new Entities.CheckRefer("HH", ""));
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = (Entities.HangHoa[])cl.DeserializeHepper(clientstrem, hh1);
if (hh1 == null)
{
hanghoa = new Entities.HangHoa[0];
return;
}
hanghoa = hh1;
}
catch { }
}
/// <summary>
/// lấy hàng hóa theo mã
/// </summary>
private void LayHangHoaTheoMa()
{
Entities.HangHoa[] kh1;
try
{
ArrayList array = new ArrayList();
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa kh = new Entities.HangHoa();
string makho = LayMaKho(cbxMaKho.Text);
kh = new Entities.HangHoa("SelectTheoKho", makho);
clientstrem = cl.SerializeObj(this.client1, "HangHoa", kh);
kh1 = new Entities.HangHoa[1];
kh1 = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 == null)
kh1 = new Entities.HangHoa[0];
if (kh1.Length > 0)
{
foreach (Entities.HangHoa item in kh1)
{
array.Add(item);
}
Entities.HangHoa[] save = Common.Utilities.CheckGoiHang(kh1, goihang, chitietgoihang);
foreach (Entities.HangHoa item in save)
{
array.Add(item);
}
kh1 = (Entities.HangHoa[])array.ToArray(typeof(Entities.HangHoa));
bool ktdata = false;
int sl = kh1.Length;
for (int i = 0; i < sl; i++)
{
if (kh1[i].Deleted == false)
if (kh1[i].MaHangHoa.ToUpper() == toolStrip_txtTracuu.Text.ToUpper())
{
mahanghoa = toolStrip_txtTracuu.Text = kh1[i].MaHangHoa.ToUpper();
toolStrip_txtTenhang.Text = kh1[i].TenHangHoa;
toolStrip_txtGiagoc.Text = kh1[i].GiaBanBuon.ToString();
try
{
SelectMaCapNhatKH();
KiemTraCK(cngkh);
}
catch
{
phantramchietkhau = toolStrip_txtChietkhauphantram.Text = "0";
}
LayGiaTriThue(kh1[i].MaThueGiaTriGiaTang);
toolStrip_txtTracuu.ReadOnly = true;
toolStrip_txtSoluong.Focus();
ktdata = true;
break;
}
}
if (ktdata == false)
{
MessageBox.Show("Không có hàng hóa trong kho", "Hệ thống cảnh báo");
toolStrip_txtTenhang.Text = "";
toolStrip_txtGiagoc.Text = "0";
toolStrip_txtChietkhauphantram.Text = "0";
toolStrip_txtThuegiatrigiatang.Text = "0";
toolStrip_txtTracuu.ReadOnly = false;
}
}
else
{
MessageBox.Show("Không có hàng hóa trong kho", "Hệ thống cảnh báo");
toolStrip_txtTenhang.Text = "";
toolStrip_txtGiagoc.Text = "0";
toolStrip_txtChietkhauphantram.Text = "0";
toolStrip_txtThuegiatrigiatang.Text = "0";
toolStrip_txtTracuu.ReadOnly = false;
}
}
catch
{
return;
}
finally
{
}
}
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 void SelectData()
{
try
{
dgvHangHoa.RowHeadersVisible = false;
cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa hh = new Entities.HangHoa("Select");
networkStream = cl.SerializeObj(this.tcpClient, "HangHoa", hh);
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = (Entities.HangHoa[])cl.DeserializeHepper1(networkStream, hh1);
// goi hang
cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("GH");
networkStream = cl.SerializeObj(this.tcpClient, "Select", ctxh);
Entities.GoiHang[] goihang = new Entities.GoiHang[0];
goihang = (Entities.GoiHang[])cl.DeserializeHepper1(networkStream, goihang);
if (hh1 == null && goihang == null)
{
dgvHangHoa.DataSource = new Entities.HangHoa[0];
return;
}
List<Entities.HangHoa> listHangHoa = new List<Entities.HangHoa>();
// for hang hoa
foreach (Entities.HangHoa hanghoa in hh1)
{
if (hanghoa != null && hanghoa.Deleted == false && hanghoa.MaNhomHangHoa.Equals(manhomhang))
{
listHangHoa.Add(hanghoa);
}
}
// for goi hang
foreach (Entities.GoiHang gh in goihang)
{
if (gh != null && gh.Deleted == false && gh.MaNhomHang.Equals(manhomhang))
{
Entities.HangHoa hanghoa = new Entities.HangHoa();
hanghoa.MaHangHoa = gh.MaGoiHang;
hanghoa.TenHangHoa = gh.TenGoiHang;
hanghoa.MaNhomHangHoa = gh.MaNhomHang;
hanghoa.GiaNhap = gh.GiaNhap;
hanghoa.GiaBanBuon = gh.GiaBanBuon;
hanghoa.GiaBanLe = gh.GiaBanLe;
listHangHoa.Add(hanghoa);
}
}
dgvHangHoa.DataSource = (Entities.HangHoa[])listHangHoa.ToArray();
dgvHangHoa.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix1();
}
}
//Entities
public Entities.HangHoa[] sp_SelectHangHoasAll(Entities.HangHoa input)
{
List<Entities.HangHoa> l = new List<Entities.HangHoa>();
try
{
cn = new Connection().openConnection();
cmd = new SqlCommand("exec sp_HangHoaFIX @ThaoTac,@MaHangHoa,@MaNhomHangHoa,@TenHangHoa,@MaDonViTinh,@GiaNhap,@GiaBanBuon,@GiaBanLe,@MaThueGiaTriGiaTang,@KieuHangHoa,@SeriLo,@MucDatHang,@MucTonToiThieu,@GhiChu,@Deleted", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = input.ThaoTac;
cmd.Parameters.Add("MaHangHoa", SqlDbType.VarChar).Value = input.MaHangHoa;
cmd.Parameters.Add("MaNhomHangHoa", SqlDbType.NVarChar).Value = input.MaNhomHangHoa;
cmd.Parameters.Add("TenHangHoa", SqlDbType.NVarChar).Value = input.TenHangHoa;
cmd.Parameters.Add("MaDonViTinh", SqlDbType.NVarChar).Value = input.MaDonViTinh;
cmd.Parameters.Add("GiaNhap", SqlDbType.Float).Value = 0;
cmd.Parameters.Add("GiaBanBuon", SqlDbType.Float).Value = 0;
cmd.Parameters.Add("GiaBanLe", SqlDbType.Float).Value = 0;
cmd.Parameters.Add("MaThueGiaTriGiaTang", SqlDbType.NVarChar).Value = input.MaThueGiaTriGiaTang;
cmd.Parameters.Add("KieuHangHoa", SqlDbType.NVarChar).Value = input.KieuHangHoa;
cmd.Parameters.Add("SeriLo", SqlDbType.NVarChar).Value = input.SeriLo;
cmd.Parameters.Add("MucDatHang", SqlDbType.NVarChar).Value = input.MucDatHang;
cmd.Parameters.Add("MucTonToiThieu", SqlDbType.NVarChar).Value = input.MucTonToiThieu;
cmd.Parameters.Add("GhiChu", SqlDbType.NVarChar).Value = input.GhiChu;
cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
hanghoa = new Entities.HangHoa();
hanghoa.HangHoaID = int.Parse(dr[Constants.HangHoaSTATIC.HangHoaID].ToString());
hanghoa.MaHangHoa = dr[Constants.HangHoaSTATIC.MaHangHoa].ToString();
hanghoa.MaNhomHangHoa = dr[Constants.HangHoaSTATIC.MaNhomHangHoa].ToString();
hanghoa.TenHangHoa = dr[Constants.HangHoaSTATIC.TenHangHoa].ToString();
hanghoa.MaDonViTinh = dr[Constants.HangHoaSTATIC.MaDonViTinh].ToString();
hanghoa.TenDonViTinh = dr[Constants.HangHoaSTATIC.TenDonViTinh].ToString();
hanghoa.GiaNhap = dr[Constants.HangHoaSTATIC.GiaNhap].ToString();
hanghoa.GiaBanBuon = dr[Constants.HangHoaSTATIC.GiaBanBuon].ToString();
hanghoa.GiaBanLe = dr[Constants.HangHoaSTATIC.GiaBanLe].ToString();
hanghoa.MaThueGiaTriGiaTang = dr[Constants.HangHoaSTATIC.MaThueGiaTriGiaTang].ToString();
hanghoa.KieuHangHoa = dr[Constants.HangHoaSTATIC.KieuHangHoa].ToString();
hanghoa.SeriLo = dr[Constants.HangHoaSTATIC.SeriLo].ToString();
hanghoa.MucDatHang = Convert.ToInt32(dr[Constants.HangHoaSTATIC.MucDatHang].ToString());
hanghoa.MucTonToiThieu = Convert.ToInt32(dr[Constants.HangHoaSTATIC.MucTonToiThieu].ToString());
hanghoa.GhiChu = dr[Constants.HangHoaSTATIC.GhiChu].ToString();
l.Add(hanghoa);
}
}
catch { return null; }
finally
{
cmd.Connection.Dispose();
cn.Close();
}
return l.ToArray();
}
public void Select()
{
try
{
dtgvKH.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("HH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
Entities.HangHoa[] kh1 = new Entities.HangHoa[0];
kh1 = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 == null)
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
Entities.HangHoa[] ncc2 = new Entities.HangHoa[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.HangHoa[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = ncc2[j];
}
}
else
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
dtgvKH.DataSource = hienthi;
dtgvKH.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix1();
}
}
public void SelectDataHHTK()
{
try
{
ArrayList array = new ArrayList();
dtgvKH.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa kh = new Entities.HangHoa("SelectTheoKho", maKho);
Entities.HangHoa[] kh1 = new Entities.HangHoa[1];
clientstrem = cl.SerializeObj(this.client1, "HangHoa", kh);
kh1 = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 == null)
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
foreach (Entities.HangHoa item in kh1)
{
if (item.Deleted == false)
array.Add(item);
}
if (array.Count != 0)
{
Entities.HangHoa[] save = Common.Utilities.CheckGoiHang((Entities.HangHoa[])array.ToArray(typeof(Entities.HangHoa)), goihang, chitietgoihang);
foreach (Entities.HangHoa item in save)
{
array.Add(item);
}
hienthi = (Entities.HangHoa[])array.ToArray(typeof(Entities.HangHoa));
}
else
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
dtgvKH.DataSource = hienthi;
dtgvKH.Rows[0].Selected = true;
}
catch
{
}
finally
{
fix();
}
}
public Entities.HangHoa[] SelectAll()
{
Entities.HangHoa temp = new Entities.HangHoa(); temp.ThaoTac = "select";
return(sp_SelectHangHoasAll(temp));
}
public void LayBangHangHoa()
{
try
{
Entities.CheckRefer Checkrefer;
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Checkrefer = new Entities.CheckRefer("HH", "");
clientstrem = cl.SerializeObj(this.client1, "Select", Checkrefer);
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = (Entities.HangHoa[])cl.DeserializeHepper(clientstrem, hh1);
if (hh1 != null)
{
hanghoa = hh1;
}
else
{
hanghoa = new Entities.HangHoa[0];
}
}
catch
{
}
}
/// <summary>
/// select hàng hóa
/// </summary>
public void SelectHangHoa()
{
try
{
cl = new Server_Client.Client();
// gán TCPclient
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
// khởi tạo biến truyền vào với hàm khởi tạo
Entities.HangHoa pt = new Entities.HangHoa("Select");
// khởi tạo mảng đối tượng để hứng giá trị
hh1 = new Entities.HangHoa[1];
clientstrem = cl.SerializeObj(this.client1, "HangHoa", pt);
// đổ mảng đối tượng vào datagripview
hh1 = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, hh1);
}
catch { }
}
public void LayHangHoa()
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa ctxh = new Entities.HangHoa("Select");
clientstrem = cl.SerializeObj(this.client, "HangHoa", ctxh);
HangHoa = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, HangHoa);
if (HangHoa == null)
{
HangHoa = new Entities.HangHoa[0];
return;
}
}
catch { }
}
/// <summary>
/// lấy hàng hóa
/// </summary>
private void LayHangHoaTheoMa()
{
Entities.HangHoa[] kh1;
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa kh = new Entities.HangHoa();
string makho = LayMaKho(cbbkhohang.Text);
kh = new Entities.HangHoa("SelectTheoKho", makho);
clientstrem = cl.SerializeObj(this.client1, "HangHoa", kh);
kh1 = new Entities.HangHoa[1];
kh1 = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 == null)
kh1 = new Entities.HangHoa[0];
if (kh1.Length > 0)
{
bool ktdata = false;
int sl = kh1.Length;
for (int i = 0; i < sl; i++)
{
if (kh1[i].Deleted == false)
if (kh1[i].MaHangHoa == toolStrip_txtTracuu.Text)
{
mahanghoa = toolStrip_txtTracuu.Text = kh1[i].MaHangHoa;
tssltenhang.Text = kh1[i].TenHangHoa;
tsslgia.Text = kh1[i].GiaBanLe.ToString();
toolStrip_txtTracuu.ReadOnly = true;
tsslsoluong.Focus();
ktdata = true;
break;
}
}
if (ktdata == false)
{
tssltenhang.Text = "";
tsslgia.Text = "0";
tsslsoluong.Text = "";
tsslthanhtien.Text = "0";
toolStrip_txtTracuu.ReadOnly = false;
this.khongcohanghoatrongkho = true;
}
}
else
{
tssltenhang.Text = "";
tsslgia.Text = "0";
tsslsoluong.Text = "";
tsslthanhtien.Text = "0";
toolStrip_txtTracuu.ReadOnly = false;
MessageBox.Show("Không có hàng hóa trong kho!");
}
}
catch (Exception ex)
{
tssltenhang.Text = "";
tsslgia.Text = "0";
tsslsoluong.Text = "";
tsslthanhtien.Text = "0";
toolStrip_txtTracuu.ReadOnly = false;
}
finally
{
timerRun.Stop();
run = 0;
}
}
public Entities.HangHoa[] SelectAll()
{
Entities.HangHoa temp = new Entities.HangHoa(); temp.ThaoTac = "select";
return sp_SelectHangHoasAll(temp);
}
public Entities.HangHoa[] SelectHangHoa_Theo_MaHangHoa(string mahanghoa)
{
Entities.HangHoa temp = new Entities.HangHoa(); temp.ThaoTac = "select_TheoMaHangHoa"; temp.MaHangHoa = mahanghoa.ToUpper();
return(sp_SelectHangHoasAll(temp));
}
/// <summary>
/// Lay tat ca hang hoa theo kho
/// </summary>
/// <param name="maKho"></param>
/// <returns></returns>
public Entities.HangHoa[] GetHangHoaTheoKho(string maKho)
{
Entities.HangHoa hh = null;
Entities.HangHoa[] hhArr = null;
try
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
hh = new Entities.HangHoa("SelectTheoKho", maKho);
hhArr = new Entities.HangHoa[1];
clientstrem = cl.SerializeObj(this.client1, "HangHoa", hh);
hhArr = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, hhArr);
return hhArr;
}
catch (Exception)
{
hhArr = null;
}
return hhArr;
}
public Entities.HangHoa[] Select(string Cot, string Kieu, string Giatri)
{
Entities.HangHoa[] arrC = null;
try
{
hh = new Constants.HangHoa();
Sql = new Constants.Sql();
string sql = "";
if (Kieu == "like")
sql = "select * from HangHoa where " + Cot + " " + Kieu + " '%" + Giatri + "%' and Deleted =0 ";
else
sql = "select * from HangHoa where " + Cot + " " + Kieu + " '" + Giatri + "' and Deleted =0 ";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
arr = new ArrayList();
while (dr.Read())
{
hanghoa = new Entities.HangHoa();
hanghoa.HangHoaID = Convert.ToInt32(dr[hh.HangHoaID].ToString());
hanghoa.MaHangHoa = dr[hh.MaHangHoa].ToString();
hanghoa.MaNhomHangHoa = dr[hh.MaNhomHangHoa].ToString();
hanghoa.TenHangHoa = dr[hh.TenHangHoa].ToString();
hanghoa.MaDonViTinh = dr[hh.MaDonViTinh].ToString();
hanghoa.TenDonViTinh = LayDVT(hanghoa.MaDonViTinh);
hanghoa.GiaNhap = dr[hh.GiaNhap].ToString();
hanghoa.GiaBanBuon = dr[hh.GiaBanBuon].ToString();
hanghoa.GiaBanLe = dr[hh.GiaBanLe].ToString();
hanghoa.MaThueGiaTriGiaTang = dr[hh.MaThueGiaTriGiaTang].ToString();
hanghoa.KieuHangHoa = dr[hh.KieuHangHoa].ToString();
hanghoa.SeriLo = dr[hh.SeriLo].ToString();
hanghoa.MucDatHang = Convert.ToInt32(dr[hh.MucDatHang].ToString());
hanghoa.MucTonToiThieu = Convert.ToInt32(dr[hh.MucTonToiThieu].ToString());
hanghoa.GhiChu = dr[hh.GhiChu].ToString();
hanghoa.Deleted = (Boolean)dr[hh.Deleted];
arr.Add(hanghoa);
}
int n = arr.Count;
if (n == 0) { return null; }
arrC = new Entities.HangHoa[n];
for (int i = 0; i < n; i++)
{
arrC[i] = (Entities.HangHoa)arr[i];
}
}
catch { }
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return arrC;
}
public void LayBangHangHoa()
{
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = new BizLogic.HangHoa().Select();
if (hh1 != null)
{
hanghoa = hh1;
}
else
{
hanghoa = new Entities.HangHoa[0];
}
}
public Entities.HangHoa[] Select(string Cot, string Kieu, string Giatri)
{
Entities.HangHoa[] arrC = null;
try
{
hh = new Constants.HangHoa();
Sql = new Constants.Sql();
string sql = "";
if (Kieu == "like")
{
sql = "select * from HangHoa where " + Cot + " " + Kieu + " '%" + Giatri + "%' and Deleted =0 ";
}
else
{
sql = "select * from HangHoa where " + Cot + " " + Kieu + " '" + Giatri + "' and Deleted =0 ";
}
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
arr = new ArrayList();
while (dr.Read())
{
hanghoa = new Entities.HangHoa();
hanghoa.HangHoaID = Convert.ToInt32(dr[hh.HangHoaID].ToString());
hanghoa.MaHangHoa = dr[hh.MaHangHoa].ToString();
hanghoa.MaNhomHangHoa = dr[hh.MaNhomHangHoa].ToString();
hanghoa.TenHangHoa = dr[hh.TenHangHoa].ToString();
hanghoa.MaDonViTinh = dr[hh.MaDonViTinh].ToString();
hanghoa.TenDonViTinh = LayDVT(hanghoa.MaDonViTinh);
hanghoa.GiaNhap = dr[hh.GiaNhap].ToString();
hanghoa.GiaBanBuon = dr[hh.GiaBanBuon].ToString();
hanghoa.GiaBanLe = dr[hh.GiaBanLe].ToString();
hanghoa.MaThueGiaTriGiaTang = dr[hh.MaThueGiaTriGiaTang].ToString();
hanghoa.KieuHangHoa = dr[hh.KieuHangHoa].ToString();
hanghoa.SeriLo = dr[hh.SeriLo].ToString();
hanghoa.MucDatHang = Convert.ToInt32(dr[hh.MucDatHang].ToString());
hanghoa.MucTonToiThieu = Convert.ToInt32(dr[hh.MucTonToiThieu].ToString());
hanghoa.GhiChu = dr[hh.GhiChu].ToString();
hanghoa.Deleted = (Boolean)dr[hh.Deleted];
arr.Add(hanghoa);
}
int n = arr.Count;
if (n == 0)
{
return(null);
}
arrC = new Entities.HangHoa[n];
for (int i = 0; i < n; i++)
{
arrC[i] = (Entities.HangHoa)arr[i];
}
}
catch { }
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return(arrC);
}
/// <summary>
///
/// </summary>
/// <param name="isBanLe"></param>
public void SelectData(bool isBanLe)
{
try
{
ArrayList array = new ArrayList();
dtgvKH.RowHeadersVisible = false;
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa kh = new Entities.HangHoa("SelectTheoKho", maKho);
Entities.HangHoa[] kh1 = new Entities.HangHoa[1];
clientstrem = cl.SerializeObj(this.client1, "HangHoa", kh);
kh1 = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, kh1);
// gói hàng
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("GH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
goihang = new Entities.GoiHang[0];
goihang = (Entities.GoiHang[])cl.DeserializeHepper1(clientstrem, goihang);
if (goihang == null)
{
goihang = new Entities.GoiHang[0];
return;
}
// chi tiết gói hàng
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
ctxh = new Entities.CheckRefer("CTGH");
clientstrem = cl.SerializeObj(this.client1, "Select", ctxh);
chitietgoihang = new Entities.ChiTietGoiHang[0];
chitietgoihang = (Entities.ChiTietGoiHang[])cl.DeserializeHepper1(clientstrem, chitietgoihang);
if (chitietgoihang == null)
{
chitietgoihang = new Entities.ChiTietGoiHang[0];
return;
}
if (kh1 == null)
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
foreach (Entities.HangHoa item in kh1)
{
if (item.Deleted == false)
array.Add(item);
}
if (array.Count != 0)
{
Entities.HangHoa[] save = Common.Utilities.CheckGoiHang((Entities.HangHoa[])array.ToArray(typeof(Entities.HangHoa)), goihang, chitietgoihang);
foreach (Entities.HangHoa item in save)
{
array.Add(item);
}
hienthi = (Entities.HangHoa[])array.ToArray(typeof(Entities.HangHoa));
}
else
{
hienthi = new Entities.HangHoa[0];
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
dtgvKH.DataSource = hienthi;
dtgvKH.Rows[0].Selected = true;
}
catch
{
}
finally
{
if (isBanLe)
fixBL();
else
fixBB();
}
}
private void btnThem_Click(object sender, EventArgs e)
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa hh = new Entities.HangHoa();
//hh = new Entities.HangHoa("Insert", 0, txtMaHangHoa.Text,txtMaNhomHangHoa.Text,txtTenHangHoa.Text,cmbMaNhaSanXuat.SelectedItem.ToString(),txtMaVachNSX.Text,cmbMaDonViTinh.SelectedItem.ToString(),int.Parse(txtGiaNhap.Text),int.Parse(txtGiaBanBuon.Text),int.Parse(txtGiaBanLe.Text),cmbMaThueGTGT.SelectedItem.ToString(),cmbKieuHangHoa.SelectedItem.ToString(),txtSeri.Text,int.Parse(txtMucDatHang.Text),int.Parse(txtMucTonToiThieu.Text),txtGhiChu.Text,false);
networkStream = client.SerializeObj(this.tcpClient, "HangHoa", hh);
bool kt = false;
kt = (bool)client.DeserializeHepper(networkStream, kt);
if (kt == true)
{
MessageBox.Show("Thành công");
}
this.Close();
}
/// <summary>
/// xử lý khi tìm kiếm
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txttimkiem_TextChanged(object sender, EventArgs e)
{
try
{
// Tat ca
if (rdbtimkiem3.Checked == true)
{
return;
}
int soluong = 0;
// Theo Ten san pham
if (rdbtimkiem1.Checked == true)
{
if (txttimkiem.Text.Length == 0)
{
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].TenHangHoa.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
Entities.HangHoa[] hienthitheoid = new Entities.HangHoa[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].TenHangHoa.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoid[soluong] = hienthi[i];
soluong++;
}
}
dtgvKH.DataSource = hienthitheoid;
}
// Theo ma san pham
if (rdbtimkiem2.Checked == true)
{
if (txttimkiem.Text.Length == 0)
{
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaHangHoa.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
Entities.HangHoa[] hienthitheoma = new Entities.HangHoa[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaHangHoa.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoma[soluong] = hienthi[i];
soluong++;
}
}
dtgvKH.DataSource = hienthitheoma;
}
}
finally
{
// Ban le
if (this.isBanLe)
fixBL();
// ban buon
else if (this.isBanBuon)
fixBB();
// truong hop khac
else
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;
}
/// <summary>
/// xử lý khi tìm kiếm
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void txttimkiem_TextChanged(object sender, EventArgs e)
{
try
{
// Tat ca
if (rdbtimkiem3.Checked == true)
{
return;
}
int soluong = 0;
// Theo Ten san pham
if (rdbtimkiem1.Checked == true)
{
if (txttimkiem.Text.Length == 0)
{
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].TenHangHoa.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
Entities.HangHoa[] hienthitheoid = new Entities.HangHoa[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].TenHangHoa.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoid[soluong] = hienthi[i];
soluong++;
}
}
dtgvKH.DataSource = hienthitheoid;
}
// Theo ma san pham
if (rdbtimkiem2.Checked == true)
{
if (txttimkiem.Text.Length == 0)
{
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaHangHoa.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
soluong++;
}
}
if (soluong == 0)
{
dtgvKH.DataSource = new Entities.HangHoa[0];
return;
}
Entities.HangHoa[] hienthitheoma = new Entities.HangHoa[soluong];
soluong = 0;
for (int i = 0; i < hienthi.Length; i++)
{
int kiemtra = hienthi[i].MaHangHoa.ToString().ToUpper().IndexOf(txttimkiem.Text.ToUpper());
if (kiemtra >= 0)
{
hienthitheoma[soluong] = hienthi[i];
soluong++;
}
}
dtgvKH.DataSource = hienthitheoma;
}
}
finally
{
// Ban le
if (this.isBanLe)
{
fixBL();
}
// ban buon
else if (this.isBanBuon)
{
fixBB();
}
// truong hop khac
else
{
fix();
}
}
}
public Entities.HangHoa[] SelectHangHoa_Theo_MaHangHoa(string mahanghoa)
{
Entities.HangHoa temp = new Entities.HangHoa(); temp.ThaoTac = "select_TheoMaHangHoa"; temp.MaHangHoa = mahanghoa.ToUpper();
return sp_SelectHangHoasAll(temp);
}
void KiemTraHangHoaTrongKho()
{
Entities.HangHoa[] kh1;
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa kh = new Entities.HangHoa();
string makho = LayMaKho(this.cbxTukho.Text);
kh = new Entities.HangHoa("SelectTheoKho", makho);
clientstrem = cl.SerializeObj(this.client1, "HangHoa", kh);
kh1 = new Entities.HangHoa[1];
kh1 = (Entities.HangHoa[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 == null)
kh1 = new Entities.HangHoa[0];
if (kh1.Length > 0)
{
bool ktdata = false;
int sl = kh1.Length;
for (int i = 0; i < sl; i++)
{
if (kh1[i].Deleted == false)
if (kh1[i].MaHangHoa == toolStrip_txtTracuu.Text)
{
toolStrip_txtTracuu.Text = kh1[i].MaHangHoa;
toolStrip_txtTen.Text = kh1[i].TenHangHoa;
toolStrip_txtSoluong.Focus();
ktdata = true;
break;
}
}
if (ktdata == false)
{
toolStrip_txtTen.Text = "";
toolStrip_txtSoluong.Text = "1";
this.khongcohanghoatrongkho = true;
}
}
else
{
toolStrip_txtTen.Text = "";
toolStrip_txtSoluong.Text = "1";
this.khongcohanghoatrongkho = true;
}
}
private void tssSua_Click(object sender, EventArgs e)
{
if (KiemTra() == true)
{
Server_Client.Client client = new Server_Client.Client();
this.tcpClient = client.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa hh = new Entities.HangHoa();
hh = new Entities.HangHoa("Update", int.Parse(txtHangHoaID.Text), txtMaHangHoa.Text, txtMaNhomHang.Text, txtTenHangHoa.Text, cmbMaNhaSanXuat.Text, txtMaVachNSX.Text, cmbMaDonViTinh.Text, float.Parse(txtGiaNhap.Text), float.Parse(txtGiaBanBuon.Text), float.Parse(txtGiaBanLe.Text), cmbMathueNhapKhau.Text, cmbMaThueXuatKhau.Text, cmbMaThueTieuThuDacBiet.Text, cmbMaThueGTGT.Text, txtKieuHangHoa.Text, txtSeri.Text, int.Parse(txtMucDatHang.Text), int.Parse(txtMucTonToiThieu.Text), txtChiTietThem.Text, txtNgungTheoDoi.Text, txtGhiChu.Text, false);
networkStream = client.SerializeObj(this.tcpClient, "HangHoa", hh);
bool kt = false;
kt = (bool)client.DeserializeHepper(networkStream, kt);
if (kt == true)
{
MessageBox.Show("Thành công");
}
this.Close();
}
}
public Entities.HangHoa[] HangHoaTheoKho(string makho)
{
Entities.HangHoa[] hanghoa = new BizLogic.HangHoa().SelectHHTheoKho(makho);
if (hanghoa == null)
hanghoa = new Entities.HangHoa[0];
return hanghoa;
}
public void SelectData()
{
try
{
dgvHangHoa.RowHeadersVisible = false;
cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.HangHoa hh = new Entities.HangHoa("Select");
networkStream = cl.SerializeObj(this.tcpClient, "HangHoa", hh);
Entities.HangHoa[] hh1 = new Entities.HangHoa[1];
hh1 = (Entities.HangHoa[])cl.DeserializeHepper1(networkStream, hh1);
// goi hang
cl = new Server_Client.Client();
this.tcpClient = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("GH");
networkStream = cl.SerializeObj(this.tcpClient, "Select", ctxh);
Entities.GoiHang[] goihang = new Entities.GoiHang[0];
goihang = (Entities.GoiHang[])cl.DeserializeHepper1(networkStream, goihang);
if (hh1 == null && goihang == null)
{
dgvHangHoa.DataSource = new Entities.HangHoa[0];
return;
}
List <Entities.HangHoa> listHangHoa = new List <Entities.HangHoa>();
// for hang hoa
foreach (Entities.HangHoa hanghoa in hh1)
{
if (hanghoa != null && hanghoa.Deleted == false && hanghoa.MaNhomHangHoa.Equals(manhomhang))
{
listHangHoa.Add(hanghoa);
}
}
// for goi hang
foreach (Entities.GoiHang gh in goihang)
{
if (gh != null && gh.Deleted == false && gh.MaNhomHang.Equals(manhomhang))
{
Entities.HangHoa hanghoa = new Entities.HangHoa();
hanghoa.MaHangHoa = gh.MaGoiHang;
hanghoa.TenHangHoa = gh.TenGoiHang;
hanghoa.MaNhomHangHoa = gh.MaNhomHang;
hanghoa.GiaNhap = gh.GiaNhap;
hanghoa.GiaBanBuon = gh.GiaBanBuon;
hanghoa.GiaBanLe = gh.GiaBanLe;
listHangHoa.Add(hanghoa);
}
}
dgvHangHoa.DataSource = (Entities.HangHoa[])listHangHoa.ToArray();
dgvHangHoa.Rows[0].Selected = true;
}
catch (Exception ex)
{
}
finally
{
fix1();
}
}
