public bool KiemTraGoiHang(Entities.ChiTietDonDatHang chitietdonhang) { bool kiemtra = false; Entities.GoiHang[] goihang = new BizLogic.GoiHang().Select(); for (int i = 0; i < goihang.Length; i++) { if (goihang[i].MaGoiHang == chitietdonhang.MaHangHoa) { Entities.HienThi_ChiTiet_DonDatHang row = new Entities.HienThi_ChiTiet_DonDatHang(); row.MaHangHoa = chitietdonhang.MaHangHoa; row.TenHangHoa = goihang[i].TenGoiHang; row.SoLuongDat = chitietdonhang.SoLuong; row.GiaGoc = chitietdonhang.DonGia; row.Giabanbuon = goihang[i].GiaBanBuon; row.Giabanle = goihang[i].GiaBanLe; row.PhanTramChietKhau = chitietdonhang.PhanTramChietKhau; row.Thuegiatrigiatang = "0"; ar.Add(row); kiemtra = true; break; } } return(kiemtra); }
/// <summary> /// vuong hung ================================= /// </summary> /// <param name="HanhDong"></param> /// <param name="PhieuThuID"></param> public int sp_Xoa_ChiTietDonDatHang(Entities.ChiTietDonDatHang ddh) { int Trave = 0; try { Sql = new Constants.Sql(); string sql = Sql.sp_Xoa_ChiTietDonDatHang; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(dh.HanhDong, SqlDbType.NVarChar, 20).Value = ddh.Hanhdong; cmd.Parameters.Add(dh.MaDonDatHang, SqlDbType.Int).Value = ddh.MaDonDatHang; cmd.Parameters.Add(dh.MaHangHoa, SqlDbType.Int).Value = ddh.MaHangHoa; Trave = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(Trave); }
/// <summary> /// vuong hung =================xu ly don dat hang================ /// </summary> /// <returns></returns> public int sp_XuLy_ChiTietDonDatHang(Entities.ChiTietDonDatHang ddh) { int Trave = 0; try { Sql = new Constants.Sql(); string sql = Sql.sp_XuLy_ChiTietDonDatHang; conn = new Connection(); cn = conn.openConnection(); dh = new Constants.ChiTietDonDatHang(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(dh.HanhDong, SqlDbType.NVarChar, 20).Value = ddh.Hanhdong; cmd.Parameters.Add(dh.MaDonDatHang, SqlDbType.NVarChar, 20).Value = ddh.MaDonDatHang; cmd.Parameters.Add(dh.MaHangHoa, SqlDbType.NVarChar).Value = ddh.MaHangHoa; cmd.Parameters.Add("TenHangHoa", SqlDbType.NVarChar, 200).Value = ddh.TenHangHoa; cmd.Parameters.Add(dh.SoLuong, SqlDbType.Int).Value = ddh.SoLuong; cmd.Parameters.Add(dh.DonGia, SqlDbType.Float, 20).Value = ddh.DonGia; cmd.Parameters.Add(dh.Thue, SqlDbType.Float, 20).Value = ddh.Thue; cmd.Parameters.Add(dh.PhanTramChietKhau, SqlDbType.Float, 20).Value = ddh.PhanTramChietKhau; cmd.Parameters.Add(dh.GhiChu, SqlDbType.NVarChar).Value = ddh.GhiChu; cmd.Parameters.Add(dh.Deleted, SqlDbType.Bit).Value = ddh.Deleted; Trave = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(Trave); }
/// <summary> /// khoi tao gia tri /// </summary> public ChiTietDonDatHang() { dh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; dondathang = null; cn = null; }
/// <summary> /// vuong hung =================lay bang DonDatHang================ /// </summary> /// <returns></returns> public Entities.ChiTietDonDatHang[] sp_LayBang_ChiTietDonDatHang() { Entities.ChiTietDonDatHang[] arrC = null; try { dh = new Constants.ChiTietDonDatHang(); Sql = new Constants.Sql(); string sql = Sql.sp_LayBang_ChiTietDonDatHang; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { dondathang = new Entities.ChiTietDonDatHang(); dondathang.MaDonDatHang = dr[dh.MaDonDatHang].ToString(); dondathang.MaHangHoa = dr[dh.MaHangHoa].ToString(); dondathang.TenHangHoa = dr["TenHangHoa"].ToString(); dondathang.SoLuong = int.Parse(0 + dr[dh.SoLuong].ToString()); dondathang.DonGia = Double.Parse(0 + dr[dh.DonGia].ToString()).ToString(); dondathang.Thue = Double.Parse(0 + dr[dh.Thue].ToString()).ToString(); dondathang.PhanTramChietKhau = Double.Parse(0 + dr[dh.PhanTramChietKhau].ToString()).ToString(); dondathang.GhiChu = "" + dr[dh.GhiChu].ToString(); dondathang.Deleted = Convert.ToBoolean(dr[dh.Deleted].ToString()); arr.Add(dondathang); } int n = arr.Count; if (n == 0) { return(null); } arrC = new Entities.ChiTietDonDatHang[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.ChiTietDonDatHang)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(arrC); }
/// <summary> /// vuong hung =================xu ly don dat hang================ /// </summary> /// <returns></returns> public int LuuLai(Entities.ChiTietDonDatHang[] ddh) { int Trave = 0; Entities.ChiTietDonDatHang tl = new Entities.ChiTietDonDatHang(); for (int i = 0; i < ddh.Length; i++) { tl.Hanhdong = ddh[i].Hanhdong; tl.MaDonDatHang = ddh[i].MaDonDatHang; tl.MaHangHoa = ddh[i].MaHangHoa; tl.TenHangHoa = ddh[i].TenHangHoa; tl.SoLuong = ddh[i].SoLuong; tl.DonGia = ddh[i].DonGia; tl.Thue = ddh[i].Thue; tl.PhanTramChietKhau = ddh[i].PhanTramChietKhau; tl.GhiChu = ddh[i].GhiChu; tl.Deleted = ddh[i].Deleted; Trave = sp_XuLy_ChiTietDonDatHang(tl); } return Trave; }
/// <summary> /// vuong hung =================xu ly don dat hang================ /// </summary> /// <returns></returns> public int LuuLai(Entities.ChiTietDonDatHang[] ddh) { int Trave = 0; Entities.ChiTietDonDatHang tl = new Entities.ChiTietDonDatHang(); for (int i = 0; i < ddh.Length; i++) { tl.Hanhdong = ddh[i].Hanhdong; tl.MaDonDatHang = ddh[i].MaDonDatHang; tl.MaHangHoa = ddh[i].MaHangHoa; tl.TenHangHoa = ddh[i].TenHangHoa; tl.SoLuong = ddh[i].SoLuong; tl.DonGia = ddh[i].DonGia; tl.Thue = ddh[i].Thue; tl.PhanTramChietKhau = ddh[i].PhanTramChietKhau; tl.GhiChu = ddh[i].GhiChu; tl.Deleted = ddh[i].Deleted; Trave = sp_XuLy_ChiTietDonDatHang(tl); } return(Trave); }
/// <summary> /// select chi tiết hóa đơn bán hàng /// </summary> public void SelectData1(string maDonDatHang) { try { dtgvsanpham.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.ChiTietDonDatHang[] pt = new Entities.ChiTietDonDatHang[1]; pt[0] = new Entities.ChiTietDonDatHang("Select", maDonDatHang); // khởi tạo mảng đối tượng để hứng giá trị ctddh = new Entities.ChiTietDonDatHang[1]; clientstrem = cl.SerializeObj(this.client1, "ChiTietDonDatHang", pt); // đổ mảng đối tượng vào datagripview ctddh = (Entities.ChiTietDonDatHang[])cl.DeserializeHepper1(clientstrem, ctddh); if (ctddh == null) { dtgvsanpham.DataSource = new Entities.HangHoaHienThi[0]; return; } Entities.ChiTietDonDatHang[] pt2 = new Entities.ChiTietDonDatHang[ctddh.Length]; int sotang = 0; for (int j = 0; j < ctddh.Length; j++) { if (ctddh[j].Deleted == false) { if (ctddh[j].MaDonDatHang == txtDondatbanhang.Text) { pt2[sotang] = ctddh[j]; sotang++; } } } Entities.HangHoaHienThi[] hhht = new Entities.HangHoaHienThi[sotang]; if (sotang != 0) { SelectHangHoa(); for (int j = 0; j < sotang; j++) { string giasp = pt2[j].DonGia; string soluongsp = pt2[j].SoLuong.ToString(); string thanhtien = (Convert.ToDouble(giasp) * Convert.ToDouble(soluongsp)).ToString(); thuegtgt = pt2[j].Thue; hhht[j] = new Entities.HangHoaHienThi(pt2[j].MaDonDatHang, pt2[j].MaHangHoa.ToUpper(), pt2[j].TenHangHoa, giasp, soluongsp, pt2[j].PhanTramChietKhau.ToString(), thuegtgt, thanhtien); } } else { dtgvsanpham.DataSource = new Entities.HangHoaHienThi[0]; txtkhachtra.Text = txtTienhang.Text = txtGTGT.Text = txtTongtien.Text = txtTongchietkhau.Text = txtConphaitra.Text = txtThanhtoanngay.Text = "0"; return; } dtgvsanpham.DataSource = hhht; } catch { } finally { try { fix(); maDonDatHang = ""; } catch { } } }
/// <summary> /// vuong hung =================lay bang DonDatHang================ /// </summary> /// <returns></returns> public Entities.ChiTietDonDatHang[] sp_LayBang_ChiTietDonDatHang() { Entities.ChiTietDonDatHang[] arrC = null; try { dh = new Constants.ChiTietDonDatHang(); Sql = new Constants.Sql(); string sql = Sql.sp_LayBang_ChiTietDonDatHang; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { dondathang = new Entities.ChiTietDonDatHang(); dondathang.MaDonDatHang = dr[dh.MaDonDatHang].ToString(); dondathang.MaHangHoa = dr[dh.MaHangHoa].ToString(); dondathang.TenHangHoa = dr["TenHangHoa"].ToString(); dondathang.SoLuong = int.Parse(0+dr[dh.SoLuong].ToString()); dondathang.DonGia = Double.Parse(0+dr[dh.DonGia].ToString()).ToString(); dondathang.Thue = Double.Parse(0 + dr[dh.Thue].ToString()).ToString(); dondathang.PhanTramChietKhau = Double.Parse(0+dr[dh.PhanTramChietKhau].ToString()).ToString(); dondathang.GhiChu = ""+dr[dh.GhiChu].ToString(); dondathang.Deleted = Convert.ToBoolean(dr[dh.Deleted].ToString()); arr.Add(dondathang); } int n = arr.Count; if (n == 0) { return null; } arrC = new Entities.ChiTietDonDatHang[n]; for (int i = 0; i < n; i++) { arrC[i] = (Entities.ChiTietDonDatHang)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return arrC; }