public Entities.GoiHang[] GoiHang()
{
Entities.GoiHang[] nkh1 = new BizLogic.GoiHang().Select();
if (nkh1 == null)
{
nkh1 = new Entities.GoiHang[0];
}
return(nkh1);
}
public void SelectGoiHang()
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.GoiHang goi = new Entities.GoiHang("Select");
clientstrem = cl.SerializeObj(this.client, "GoiHang", goi);
Entities.GoiHang[] GoiHang = new Entities.GoiHang[1];
GoiHang = (Entities.GoiHang[])cl.DeserializeHepper1(clientstrem, GoiHang);
try
{
for (int j = 0; j < GoiHang.Length; j++)
{
if (GoiHang[j].Deleted == false)
{
Entities.ThongTinMaVach row = new Entities.ThongTinMaVach();
row.MaHangHoa = GoiHang[j].MaGoiHang;
row.TenHangHoa = GoiHang[j].TenGoiHang;
list.Add(row);
}
}
}
catch { }
try
{
for (int i = 0; i < this.search.Length; i++)
{
list.Add(this.search[i]);
}
}
catch { }
int k = list.Count;
if (k <= 0)
{
this.search = null;
}
else
{
this.search = new Entities.ThongTinMaVach[k];
for (int i = 0; i < k; i++)
{
this.search[i] = (Entities.ThongTinMaVach)list[i];
}
}
}
catch { }
}
public void SelectGoiHang()
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.GoiHang goi = new Entities.GoiHang("Select");
clientstrem = cl.SerializeObj(this.client, "GoiHang", goi);
Entities.GoiHang[] GoiHang = new Entities.GoiHang[1];
GoiHang = (Entities.GoiHang[])cl.DeserializeHepper1(clientstrem, GoiHang);
try
{
for (int j = 0; j < GoiHang.Length; j++)
{
if (GoiHang[j].Deleted == false)
{
Entities.ThongTinMaVach row = new Entities.ThongTinMaVach();
row.MaHangHoa = GoiHang[j].MaGoiHang;
row.TenHangHoa = GoiHang[j].TenGoiHang;
list.Add(row);
}
}
}
catch { }
try
{
for (int i = 0; i < this.search.Length; i++)
{
list.Add(this.search[i]);
}
}
catch { }
int k = list.Count;
if (k <= 0)
{
this.search = null;
}
else
{
this.search = new Entities.ThongTinMaVach[k];
for (int i = 0; i < k; i++)
{
this.search[i] = (Entities.ThongTinMaVach)list[i];
}
}
}
catch { }
}
private void tsslbl_Click(object sender, EventArgs e)
{
string maKH = dgvHienThi.Rows[i].Cells["MaGoiHang"].Value.ToString();
if (!frmDangNhap.User.Administrator && !CheckQuyen(this.Name, 3))
{
MessageBox.Show("Bạn Không có quyền vào chức năng này.");
return;
}
if (new Check().CheckReference("GH", maKH))
{
DialogResult dlgResult = MessageBox.Show("Bạn Có Chắc Chắn muốn Xóa Gói Hàng này không?", "Đồng ý?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlgResult == DialogResult.Yes)
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.GoiHang kh = new Entities.GoiHang();
kh = new Entities.GoiHang("Delete", int.Parse(dgvHienThi.Rows[i].Cells["GoiHangID"].Value.ToString()), Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap);
clientstrem = cl.SerializeObj(this.client1, "GoiHang", kh);
bool kt = false;
kt = (bool)cl.DeserializeHepper(clientstrem, kt);
if (kt == true)
{
}
//}
else
{
MessageBox.Show("Mã Gói Hàng này đã bị xóa");
}
SelectData();
}
catch (Exception ex)
{
}
}
}
else
{
MessageBox.Show("mã gói hàng này này không thể xóa! Hiện tại đang có giao dịch");
}
}
/// <summary>
/// select dữ liệu từ server
/// </summary>
public void SelectData()
{
try
{
i = 0;
dgvHienThi.RowHeadersVisible = false;
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.GoiHang kh = new Entities.GoiHang();
// truyền HanhDong
kh = new Entities.GoiHang("Select");
// khởi tạo mảng đối tượng để hứng giá trị
kh1 = new Entities.GoiHang[1];
clientstrem = cl.SerializeObj(this.client1, "GoiHang", kh);
// đổ mảng đối tượng vào datagripview
kh1 = (Entities.GoiHang[])cl.DeserializeHepper1(clientstrem, kh1);
// lbltongs.Text = kh1.Length.ToString();
if (kh1 == null)
{
toolStripStatus_Xoa.Enabled = false;
hienthi = new Entities.GoiHang[0];
dgvHienThi.DataSource = new Entities.GoiHang[0];
return;
}
toolStripStatus_Xoa.Enabled = true;
Entities.GoiHang[] pt2 = new Entities.GoiHang[kh1.Length];
int sotang = 0;
for (int j = 0; j < kh1.Length; j++)
{
if (kh1[j].Deleted == false)
{
pt2[sotang] = kh1[j];
sotang++;
}
}
hienthi = new Entities.GoiHang[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = pt2[j];
}
}
else
{
dgvHienThi.DataSource = new Entities.GoiHang[0];
return;
}
dgvHienThi.DataSource = hienthi;
new Common.Utilities().CountDatagridview(dgvHienThi);
dgvHienThi.Rows[0].Selected = true;
}
finally
{
try
{
for (int j = 1; j < dgvHienThi.ColumnCount; j++)
{
dgvHienThi.Columns[j].Visible = false;
}
dgvHienThi.Columns[0].Visible = true;
dgvHienThi.Columns[0].HeaderText = "STT";
dgvHienThi.Columns["MaGoiHang"].HeaderText = "Mã Gói Hàng";
dgvHienThi.Columns["TenGoiHang"].HeaderText = "Tên Gói Hàng";
dgvHienThi.Columns["GiaNhap"].HeaderText = "Giá Nhập";
dgvHienThi.Columns["GiaBanBuon"].HeaderText = "Giá Bán Buôn";
dgvHienThi.Columns["GiaBanLe"].HeaderText = "Giá Bán Lẻ";
dgvHienThi.Columns["MaGoiHang"].Visible = true;
dgvHienThi.Columns["TenGoiHang"].Visible = true;
dgvHienThi.Columns["GiaNhap"].Visible = true;
dgvHienThi.Columns["GiaBanBuon"].Visible = true;
dgvHienThi.Columns["GiaBanLe"].Visible = true;
dgvHienThi.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvHienThi.AllowUserToAddRows = false;
dgvHienThi.AllowUserToDeleteRows = false;
dgvHienThi.AllowUserToResizeRows = false;
dgvHienThi.RowHeadersVisible = false;
}
catch
{ }
}
}
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;
}
/// <summary>
/// select dữ liệu từ server
/// </summary>
public void SelectData()
{
try
{
i = 0;
dgvHienThi.RowHeadersVisible = false;
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.GoiHang kh = new Entities.GoiHang();
// truyền HanhDong
kh = new Entities.GoiHang("Select");
// khởi tạo mảng đối tượng để hứng giá trị
kh1 = new Entities.GoiHang[1];
clientstrem = cl.SerializeObj(this.client1, "GoiHang", kh);
// đổ mảng đối tượng vào datagripview
kh1 = (Entities.GoiHang[])cl.DeserializeHepper1(clientstrem, kh1);
// lbltongs.Text = kh1.Length.ToString();
if (kh1 == null)
{
toolStripStatus_Xoa.Enabled = false;
hienthi = new Entities.GoiHang[0];
dgvHienThi.DataSource = new Entities.GoiHang[0];
return;
}
toolStripStatus_Xoa.Enabled = true;
Entities.GoiHang[] pt2 = new Entities.GoiHang[kh1.Length];
int sotang = 0;
for (int j = 0; j < kh1.Length; j++)
{
if (kh1[j].Deleted == false)
{
pt2[sotang] = kh1[j];
sotang++;
}
}
hienthi = new Entities.GoiHang[sotang];
if (sotang != 0)
{
for (int j = 0; j < sotang; j++)
{
hienthi[j] = pt2[j];
}
}
else
{
dgvHienThi.DataSource = new Entities.GoiHang[0];
return;
}
dgvHienThi.DataSource = hienthi;
new Common.Utilities().CountDatagridview(dgvHienThi);
dgvHienThi.Rows[0].Selected = true;
}
finally
{
try
{
for (int j = 1; j < dgvHienThi.ColumnCount; j++)
{
dgvHienThi.Columns[j].Visible = false;
}
dgvHienThi.Columns[0].Visible = true;
dgvHienThi.Columns[0].HeaderText = "STT";
dgvHienThi.Columns["MaGoiHang"].HeaderText = "Mã Gói Hàng";
dgvHienThi.Columns["TenGoiHang"].HeaderText = "Tên Gói Hàng";
dgvHienThi.Columns["GiaNhap"].HeaderText = "Giá Nhập";
dgvHienThi.Columns["GiaBanBuon"].HeaderText = "Giá Bán Buôn";
dgvHienThi.Columns["GiaBanLe"].HeaderText = "Giá Bán Lẻ";
dgvHienThi.Columns["MaGoiHang"].Visible = true;
dgvHienThi.Columns["TenGoiHang"].Visible = true;
dgvHienThi.Columns["GiaNhap"].Visible = true;
dgvHienThi.Columns["GiaBanBuon"].Visible = true;
dgvHienThi.Columns["GiaBanLe"].Visible = true;
dgvHienThi.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvHienThi.AllowUserToAddRows = false;
dgvHienThi.AllowUserToDeleteRows = false;
dgvHienThi.AllowUserToResizeRows = false;
dgvHienThi.RowHeadersVisible = false;
}
catch
{ }
}
}
private void tsslbl_Click(object sender, EventArgs e)
{
string maKH = dgvHienThi.Rows[i].Cells["MaGoiHang"].Value.ToString();
if (!frmDangNhap.User.Administrator && !CheckQuyen(this.Name, 3))
{
MessageBox.Show("Bạn Không có quyền vào chức năng này.");
return;
}
if (new Check().CheckReference("GH", maKH))
{
DialogResult dlgResult = MessageBox.Show("Bạn Có Chắc Chắn muốn Xóa Gói Hàng này không?", "Đồng ý?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlgResult == DialogResult.Yes)
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.GoiHang kh = new Entities.GoiHang();
kh = new Entities.GoiHang("Delete", int.Parse(dgvHienThi.Rows[i].Cells["GoiHangID"].Value.ToString()), Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap);
clientstrem = cl.SerializeObj(this.client1, "GoiHang", kh);
bool kt = false;
kt = (bool)cl.DeserializeHepper(clientstrem, kt);
if (kt == true)
{
}
//}
else
{
MessageBox.Show("Mã Gói Hàng này đã bị xóa");
}
SelectData();
}
catch (Exception ex)
{
}
}
}
else
{
MessageBox.Show("mã gói hàng này này không thể xóa! Hiện tại đang có giao dịch");
}
}
public bool Sua()
{
bool retVal = false;
try
{
//if (!CheckRefer())
//{
// MessageBox.Show("Gói hàng đang có gia dịch, không được sửa", "Hệ thống cảnh báo");
// return false;
//}
if (!KiemTra())
{
return false;
}
if (CheckConflictUpdate())
{
MessageBox.Show("Dữ liệu đã thay đổi hãy kiểm tra lại", "Hệ thống cảnh báo");
return false;
}
ktgiatri = "a";
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.GoiHang nv = new Entities.GoiHang();
Entities.NhomHang nh = (Entities.NhomHang)cmbMaNhomHangHoa.SelectedItem;
string giaNhap = "0";
string giaBanBuon = "0";
string giaBanLe = "0";
if (!string.IsNullOrEmpty(txtgianhap.Text))
giaNhap = txtgianhap.Text;
if (!string.IsNullOrEmpty(txtgiabanbuon.Text))
giaBanBuon = txtgiabanbuon.Text;
if (!string.IsNullOrEmpty(txtgiabanle.Text))
giaBanLe = txtgiabanle.Text;
nv = new Entities.GoiHang("Update", 0, this.maKho, txtmagoihang.Text, txttengoihang.Text, nh.MaNhomHang, "", giaNhap, giaBanBuon, giaBanLe, false, Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap);
clientstrem = cl.SerializeObj(this.client1, "GoiHang", nv);
int msg = 0;
msg = (int)cl.DeserializeHepper(clientstrem, msg);
if (msg == 0)
{
this.Close();
}
if (msg == 1)
{
CheckDataGridDelete(this.dgvInsertOrder);
InsertMang();
this.Close();
}
else
{
MessageBox.Show("mã gói hàng đã thay đổi - kiểm tra lại dữ liệu");
txtmagoihang.Text = new Common.Utilities().ProcessID(txtmagoihang.Text);
}
}
catch (Exception)
{
retVal = false;
}
return retVal;
}
public frmXuLyGoiHang(string str1, string str2, DataGridViewRow dgvr)
{
try
{
InitializeComponent();
XuLyString(str1, str2);
if (str1 == "Thu" && str2 == "Sua")
{
id = dgvr.Cells["GoiHangID"].Value.ToString();
magoihang = dgvr.Cells["MaGoiHang"].Value.ToString();
tengoihang = dgvr.Cells["TenGoiHang"].Value.ToString();
cbbLoaiHangHoa.SelectedIndex = cbbLoaiHangHoa_sua(dgvr.Cells["MaNhomHang"].Value.ToString());
Entities.LoaiHangHoa lh = (Entities.LoaiHangHoa)cbbLoaiHangHoa.SelectedItem;
maLoaiHang = lh.MaLoaiHang;
cmbMaNhomHangHoa.SelectedIndex = cmbmaMaNhomHangHoa_sua(dgvr.Cells["MaNhomHang"].Value.ToString());
Entities.NhomHang nh = (Entities.NhomHang)cmbMaNhomHangHoa.SelectedItem;
maNhomHang = nh.MaNhomHang;
gianhap = dgvr.Cells["GiaNhap"].Value.ToString();
giabanbuon = dgvr.Cells["GiaBanBuon"].Value.ToString();
giabanle = dgvr.Cells["GiaBanLe"].Value.ToString();
this.txtmagoihang.Text = magoihang;
this.txttengoihang.Text = tengoihang;
this.txtgianhap.Text = gianhap;
this.txtgiabanbuon.Text = giabanbuon;
this.txtgiabanle.Text = giabanle;
ghOld = new Entities.GoiHang();
ghOld.GoiHangID = int.Parse(id);
ghOld.MaGoiHang = magoihang;
ghOld.TenGoiHang = tengoihang;
ghOld.MaNhomHang = dgvr.Cells["MaNhomHang"].Value.ToString();
ghOld.GiaNhap = gianhap;
ghOld.GiaBanBuon = giabanbuon;
ghOld.GiaBanLe = giabanle;
if (magoihang == txtmagoihang.Text)
{
SelectData1();
}
}
}
catch { }
}
/// <summary>
/// Check Conflic Update , true = su thay doi
/// </summary>
/// <returns></returns>
public bool CheckConflictUpdate()
{
bool retVal = false;
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.GoiHang kh = new Entities.GoiHang("Select");
// khởi tạo mảng đối tượng để hứng giá trị
kh1 = new Entities.GoiHang[1];
clientstrem = cl.SerializeObj(this.client1, "GoiHang", kh);
// đổ mảng đối tượng vào datagripview
kh1 = (Entities.GoiHang[])cl.DeserializeHepper1(clientstrem, kh1);
if (kh1 != null)
{
for (int j = 0; j < kh1.Length; j++)
{
if (kh1[j].MaGoiHang.ToUpper().Equals(ghOld.MaGoiHang.ToUpper()))
{
bool blTenGoiHang = kh1[j].TenGoiHang.Equals(ghOld.TenGoiHang);
bool blMaNhomHangHoa = kh1[j].MaNhomHang.Equals(ghOld.MaNhomHang);
bool blGiaNhap = kh1[j].GiaNhap.Equals(ghOld.GiaNhap);
bool blGiaBanBuon = kh1[j].GiaBanBuon.Equals(ghOld.GiaBanBuon);
bool blGiaBanLe = kh1[j].GiaBanLe.Equals(ghOld.GiaBanLe);
if (!blTenGoiHang || !blMaNhomHangHoa || !blGiaNhap || !blGiaBanBuon || !blGiaBanLe)
{
retVal = true;
break;
}
}
}
}
}
catch
{
retVal = false;
}
return retVal;
}
/// <summary>
/// Check conflic Insert , true= tim thay hang hoa do roi.
/// </summary>
public bool CheckConflictInsert()
{
bool retVal = false;
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.GoiHang ncc = new Entities.GoiHang("Select");
// khởi tạo mảng đối tượng để hứng giá trị
Entities.GoiHang[] ncc1 = new Entities.GoiHang[1];
clientstrem = cl.SerializeObj(this.client1, "GoiHang", ncc);
// đổ mảng đối tượng vào datagripview
ncc1 = (Entities.GoiHang[])cl.DeserializeHepper1(clientstrem, ncc1);
if (ncc1 != null)
{
for (int j = 0; j < ncc1.Length; j++)
{
if (ncc1[j].MaGoiHang.ToUpper().Equals(txtmagoihang.Text.ToUpper()))
{
retVal = true;
break;
}
}
}
}
catch
{
retVal = false;
}
return retVal;
}
private void toolStripStatus_Themmoi_Click(object sender, EventArgs e)
{
try
{
if (!KiemTra())
{
return;
}
if (CheckConflictInsert())
{
MessageBox.Show("Mã gói hàng đã tồn tại", "");
txtmagoihang.Focus();
return;
}
if (CheckData())
{
ktgiatri = "a";
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.GoiHang nv = new Entities.GoiHang();
Entities.NhomHang nh = (Entities.NhomHang)cmbMaNhomHangHoa.SelectedItem;
string giaNhap = "0";
string giaBanBuon = "0";
string giaBanLe = "0";
if (!string.IsNullOrEmpty(txtgianhap.Text))
giaNhap = txtgianhap.Text;
if (!string.IsNullOrEmpty(txtgiabanbuon.Text))
giaBanBuon = txtgiabanbuon.Text;
if (!string.IsNullOrEmpty(txtgiabanle.Text))
giaBanLe = txtgiabanle.Text;
nv = new Entities.GoiHang("Insert", 0, this.maKho, txtmagoihang.Text, txttengoihang.Text, nh.MaNhomHang, "", giaNhap, giaBanBuon, giaBanLe, false, Common.Utilities.User.NhanVienID, Common.Utilities.User.TenDangNhap);
clientstrem = cl.SerializeObj(this.client1, "GoiHang", nv);
int msg = 0;
msg = (int)cl.DeserializeHepper(clientstrem, msg);
if (msg == 1)
{
Boolean k = InsertMang();
this.Close();
}
else
{
MessageBox.Show("mã gói hàng đã thay đổi - kiểm tra lại dữ liệu");
//txtmagoihang.Text = new Common.Utilities().ProcessID(txtmagoihang.Text);
txtmagoihang.Focus();
return;
}
// }
}
}
catch { }
}
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();
}
}
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();
}
}
public Entities.GoiHang[] GoiHang()
{
Entities.GoiHang[] nkh1 = new BizLogic.GoiHang().Select();
if (nkh1 == null)
nkh1 = new Entities.GoiHang[0];
return nkh1;
}
