public void SelectData()
{
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.ChiTietKhachHangTraLai[] ctk = new Entities.ChiTietKhachHangTraLai[1];
ctk[0] = new Entities.ChiTietKhachHangTraLai("Select");
clientstrem = cl.SerializeHepper(this.client1, "ChiTietKhachHangTraLai", ctk);
ctk = (Entities.ChiTietKhachHangTraLai[])cl.DeserializeHepper(clientstrem, ctk);
dgvXemthongtin.DataSource = ctk;
}
catch
{
}
}
/// <summary>
/// hungvv ==================================================
/// </summary>
private void SelectChiTietKhachHangTraLai(string hanhdong)
{
Entities.DonDatHang pt = new Entities.DonDatHang();
pt = new Entities.DonDatHang(hanhdong);
Entities.ChiTietKhachHangTraLai[] pt1 = new Entities.ChiTietKhachHangTraLai[10];
clientstrem = cl.SerializeObj(this.client, "ChiTietKhachHangTraLai", pt);
Binding((Entities.ChiTietKhachHangTraLai[])cl.DeserializeHepper(clientstrem, pt1));
}
/// <summary>
/// add ban ghi --------------------------------hungvv-----------------------------
/// </summary>
/// <param name="dgv"></param>
public Entities.ChiTietKhachHangTraLai[] LuuChiTietKhachHangTraLai(DataGridView dgv, string hanhdong, string madondathang)
{
ArrayList arr = new ArrayList();
int i = dgv.RowCount;
Entities.ChiTietKhachHangTraLai[] mangBanghi = null;
if (i > 0)
{
for (int x = 0; x < i; x++)
{
Entities.ChiTietKhachHangTraLai banghi = new Entities.ChiTietKhachHangTraLai();
banghi.Hanhdong = hanhdong;
banghi.MaKhachHangTraLai = madondathang.ToUpper();
banghi.MaHangHoa = dgv.Rows[x].Cells[0].Value.ToString();
banghi.SoLuong = System.Convert.ToInt32(dgv.Rows[x].Cells[2].Value.ToString());
banghi.PhanTramChietKhau = dgv.Rows[x].Cells[4].Value.ToString();
banghi.GhiChu = dgv.Rows[x].Cells[1].Value.ToString();
banghi.Deleted = false;
arr.Add(banghi);
}
int n = arr.Count;
if (n == 0) { return null; }
mangBanghi = new Entities.ChiTietKhachHangTraLai[n];
for (int j = 0; j < n; j++)
{
mangBanghi[j] = (Entities.ChiTietKhachHangTraLai)arr[j];
}
}
else
{
mangBanghi = null;
mangBanghi = null;
}
return mangBanghi;
}
public Entities.ChiTietKhachHangTraLai[] LayCTKHTL_TheoMaPhieu(string MaPhieu)
{
try
{
if (CTKHTL.Length == 0)
{
return new Entities.ChiTietKhachHangTraLai[0];
}
else
{
int count = 0;
for (int i = 0; i < CTKHTL.Length; i++)
{
if (CTKHTL[i].MaKhachHangTraLai == MaPhieu)
{
count++;
}
}
Entities.ChiTietKhachHangTraLai[] CTKHTL1 = new Entities.ChiTietKhachHangTraLai[count];
count = 0;
for (int i = 0; i < CTKHTL.Length; i++)
{
if (CTKHTL[i].MaKhachHangTraLai == MaPhieu)
{
CTKHTL1[count] = CTKHTL[i];
count++;
}
}
if (CTKHTL1.Length == 0)
{
return new Entities.ChiTietKhachHangTraLai[0];
}
return CTKHTL1;
}
}
catch
{
return new Entities.ChiTietKhachHangTraLai[0];
}
}
public void LayCTKHTL()
{
try
{
Entities.ChiTietKhachHangTraLai[] HDN = new Entities.ChiTietKhachHangTraLai[0];
HDN = new BizLogic.ChiTietKhachHangTraLai().Select();
if (HDN == null)
{
CTKHTL = new Entities.ChiTietKhachHangTraLai[0];
return;
}
CTKHTL = HDN;
}
catch
{
}
}
public Entities.ChiTietKhachHangTraLai[] LuuChiTietKhachHangTraLai(DataGridView dgv, string hanhdong, string madondathang, string makho)
{
Entities.ChiTietKhachHangTraLai[] mangBanghi = null;
try
{
ArrayList arr = new ArrayList();
int i = dgv.RowCount;
if (i > 0)
{
for (int x = 0; x < i; x++)
{
Entities.ChiTietKhachHangTraLai banghi = new Entities.ChiTietKhachHangTraLai();
banghi.Hanhdong = hanhdong;
banghi.MaKhachHangTraLai = madondathang;
banghi.MaHangHoa = dgv.Rows[x].Cells[0].Value.ToString().ToUpper();
banghi.TenHangHoa = dgv.Rows[x].Cells["TenHangHoa"].Value.ToString();
banghi.SoLuong = System.Convert.ToInt32(dgv.Rows[x].Cells[2].Value.ToString());
banghi.PhanTramChietKhau = dgv.Rows[x].Cells[4].Value.ToString();
banghi.DonGia = dgv.Rows[x].Cells["Giaban"].Value.ToString();
banghi.Thue = dgv.Rows[x].Cells["Thuegiatrigiatang"].Value.ToString();
banghi.GhiChu = txtDiengiai.Text;
banghi.Deleted = false;
banghi.Makho = makho;
arr.Add(banghi);
}
int n = arr.Count;
if (n == 0) { return null; }
mangBanghi = new Entities.ChiTietKhachHangTraLai[n];
for (int j = 0; j < n; j++)
{
mangBanghi[j] = (Entities.ChiTietKhachHangTraLai)arr[j];
}
}
else
{
mangBanghi = null;
}
}
catch (Exception ex)
{ string s = ex.Message; mangBanghi = null; }
return mangBanghi;
}
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 LayCTKHTL()
{
try
{
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.CheckRefer ctxh = new Entities.CheckRefer("CTKHTL");
clientstrem = cl.SerializeObj(this.client, "Select", ctxh);
Entities.ChiTietKhachHangTraLai[] HDN = new Entities.ChiTietKhachHangTraLai[0];
HDN = (Entities.ChiTietKhachHangTraLai[])cl.DeserializeHepper1(clientstrem, HDN);
if (HDN == null)
{
CTKHTL = new Entities.ChiTietKhachHangTraLai[0];
return;
}
CTKHTL = HDN;
}
catch
{
}
}