public Entities.ChiTietGoiHang[] ChiTietGoiHang() { Entities.ChiTietGoiHang[] nkh1 = new BizLogic.ChiTietGoiHang().Select(); if (nkh1 == null) { nkh1 = new Entities.ChiTietGoiHang[0]; } return(nkh1); }
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 SelectData1() { try { dgvInsertOrder.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.ChiTietGoiHang[] pt = new Entities.ChiTietGoiHang[1]; pt[0] = new Entities.ChiTietGoiHang("Select"); // khởi tạo mảng đối tượng để hứng giá trị ctddh = new Entities.ChiTietGoiHang[1]; clientstrem = cl.SerializeObj(this.client1, "ChiTietGoiHang", pt); // đổ mảng đối tượng vào datagripview ctddh = (Entities.ChiTietGoiHang[])cl.DeserializeHepper1(clientstrem, ctddh); if (ctddh == null) { dgvInsertOrder.DataSource = new Entities.ChiTietGoiHang[0]; return; } foreach (Entities.ChiTietGoiHang item in ctddh) { if (item.MaGoiHang.ToUpper().Equals(magoihang.ToUpper())) { array.Add(item); } } if (array != null && array.Count > 0) { tempcheck = new Entities.ChiTietGoiHang[array.Count + 1]; sotang = 0; foreach (Entities.ChiTietGoiHang item in (Entities.ChiTietGoiHang[])array.ToArray(typeof(Entities.ChiTietGoiHang))) { soluong = item.SoLuong; giaNhap += double.Parse(item.GiaNhap); giaBanBuon += double.Parse(item.GiaBanBuon); giaBanLe += double.Parse(item.GiaBanLe); tongSoLuong += item.SoLuong; tempcheck[sotang] = item; sotang++; } tempcheck[tempcheck.Length - 1] = new Entities.ChiTietGoiHang(); tempcheck[tempcheck.Length - 1].TenHangHoa = "Tổng Cộng"; tempcheck[tempcheck.Length - 1].GiaNhap = (new Common.Utilities().FormatMoney(giaNhap)); tempcheck[tempcheck.Length - 1].GiaBanBuon = (new Common.Utilities().FormatMoney(giaBanBuon)); tempcheck[tempcheck.Length - 1].GiaBanLe = (new Common.Utilities().FormatMoney(giaBanLe)); tempcheck[tempcheck.Length - 1].SoLuong = tongSoLuong; dgvInsertOrder.DataSource = tempcheck; } } catch { } finally { try { fix(); } 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 void NewRow() { try { if (tempcheck == null) { bool kt1 = false; string sl = " 0 "; if (toolStripTextBox2.Text == "") sl = "0"; else sl = toolStripTextBox2.Text; string soluongsp = (soluong + int.Parse(sl)).ToString(); //giá nhập string gianhap = "0"; gianhap = toolStrip_txtTonkho.Text; double gianhapsp = double.Parse(gianhap) * soluong; //giá bán buôn string giabanbuon = "0"; giabanbuon = toolStrip_txtTonThucTe.Text; double giabanbuonsp = double.Parse(giabanbuon) * soluong; //giá bán lẻ string giabanle = "0"; giabanle = toolStripTextBox1.Text; double giabanlesp = double.Parse(giabanle) * soluong; tempcheck = new Entities.ChiTietGoiHang[1]; tempcheck[0] = new Entities.ChiTietGoiHang("Insert", 0, txtmagoihang.Text.ToUpper(), toolStrip_txtTracuu.Text, toolStrip_txtTenhang.Text, gianhapsp.ToString(), giabanbuonsp.ToString(), giabanlesp.ToString(), int.Parse(sl)); dgvInsertOrder.DataSource = tempcheck; return; } int sohangtrongbang = tempcheck.Length; //sohangtrongbang = tempcheck.Length; // số lượng bảng ghi khác 0 //if (sohangtrongbang != 0) //{ // for (int j = 0; j < dgvInsertOrder.RowCount; j++) // { // // nếu tìm được mã đã có trong list view // if (mahanghoa == dgvInsertOrder["MaHangHoa", j].Value.ToString()) // { // tempcheck = new Entities.ChiTietGoiHang[sohangtrongbang]; // break; // } // // nếu không tìm được // else // tempcheck = new Entities.ChiTietGoiHang[sohangtrongbang + 1]; // } //} // số lượng bảng ghi = 0 //else //tempcheck = new Entities.ChiTietGoiHang[sohangtrongbang + 1]; // nếu số lượng bảng ghi khác 0 if (sohangtrongbang != 0) { ArrayList li = new ArrayList(); try { // số lượng bảng ghi = số lượng row list view //if (tempcheck.Length == dgvInsertOrder.RowCount) //{ Boolean ch = false; for (int j = 0; j < tempcheck.Length; j++) { // nếu mã = mã trong list view if (mahanghoa == tempcheck[j].MaHangHoa)// dgvInsertOrder["MaHangHoa", j].Value.ToString()) { ch = true; int soluongcu = Convert.ToInt32(tempcheck[j].SoLuong);//dgvInsertOrder["SoLuong", j].Value.ToString()); string sl = "0"; if (toolStripTextBox2.Text == "") sl = "1"; else sl = toolStripTextBox2.Text; int soluongmoi = Convert.ToInt32(sl); int soluonghientai = soluongcu + soluongmoi; //giá nhập string gianhap = "0"; gianhap = toolStrip_txtTonkho.Text; double gianhapmoi = double.Parse(gianhap); double gianhaphientai = gianhapmoi * soluonghientai; // giá bán buôn string giabanbuon = "0"; giabanbuon = toolStrip_txtTonThucTe.Text; double giabanbuonmoi = double.Parse(giabanbuon); double giabanbuonhientai = giabanbuonmoi * soluonghientai; // giá bán lẻ string giabanle = "0"; giabanle = toolStripTextBox1.Text; double giabanlemoi = double.Parse(giabanle); double giabanlehientai = giabanlemoi * soluonghientai; // Entities.ChiTietGoiHang g = new Entities.ChiTietGoiHang("Insert", 0, txtmagoihang.Text, toolStrip_txtTracuu.Text, toolStrip_txtTenhang.Text, gianhaphientai.ToString(), giabanbuonhientai.ToString(), giabanlehientai.ToString(), soluonghientai); li.Add(g); //tempcheck[j] = new Entities.ChiTietGoiHang("Insert", 0, txtmagoihang.Text, // toolStrip_txtTracuu.Text, toolStrip_txtTenhang.Text, gianhaphientai.ToString(), // giabanbuonhientai.ToString(), giabanlehientai.ToString(), soluonghientai); } // nếu mã không = mã trong list view else { if (!string.IsNullOrEmpty(tempcheck[j].MaHangHoa)) li.Add(tempcheck[j]); } } if (ch == false) { bool kt1 = false; string sl = " 0 "; if (toolStripTextBox2.Text == "") sl = "0"; else sl = toolStripTextBox2.Text; string soluongsp = (soluong + int.Parse(sl)).ToString(); //giá nhập string gianhap = "0"; gianhap = toolStrip_txtTonkho.Text; double gianhapsp = double.Parse(gianhap) * soluong; //giá bán buôn string giabanbuon = "0"; giabanbuon = toolStrip_txtTonThucTe.Text; double giabanbuonsp = double.Parse(giabanbuon) * soluong; //giá bán lẻ string giabanle = "0"; giabanle = toolStripTextBox1.Text; double giabanlesp = double.Parse(giabanle) * soluong; Entities.ChiTietGoiHang r = new Entities.ChiTietGoiHang("Insert", 0, txtmagoihang.Text, toolStrip_txtTracuu.Text, toolStrip_txtTenhang.Text, gianhapsp.ToString(), giabanbuonsp.ToString(), giabanlesp.ToString(), int.Parse(sl)); li.Add(r); } } catch (Exception ex) { string sl = "0"; if (toolStripTextBox2.Text == "") sl = "0"; else sl = toolStripTextBox2.Text; string soluongsp = (soluong + int.Parse(sl).ToString()); //giá nhập string gianhap = "0"; gianhap = toolStrip_txtTonkho.Text; double gianhapsp = double.Parse(gianhap) * soluong; // giá bán buôn string giabanbuon = "0"; giabanbuon = toolStrip_txtTonThucTe.Text; double giabanbuonsp = double.Parse(giabanbuon) * soluong; // giá bán lẻ string giabanle = "0"; giabanle = toolStripTextBox1.Text; double giabanlesp = double.Parse(giabanle) * soluong; Entities.ChiTietGoiHang r = new Entities.ChiTietGoiHang("Insert", 0, txtmagoihang.Text, toolStrip_txtTracuu.Text, toolStrip_txtTenhang.Text, gianhapsp.ToString(), giabanbuonsp.ToString(), giabanlesp.ToString(), int.Parse(sl)); //tempcheck[tempcheck.Length - 1] = new Entities.ChiTietGoiHang("Insert", 0, txtmagoihang.Text, toolStrip_txtTracuu.Text, toolStrip_txtTenhang.Text, gianhapsp.ToString(), giabanbuonsp.ToString(), giabanlesp.ToString(), int.Parse(sl)); li.Add(r); } int f = li.Count; if (f <= 0) { tempcheck = new Entities.ChiTietGoiHang[0]; } else { tempcheck = new Entities.ChiTietGoiHang[f]; for (int i = 0; i < f; i++) { tempcheck[i] = (Entities.ChiTietGoiHang)li[i]; } } dgvInsertOrder.DataSource = tempcheck; } } catch { string sl = "0"; if (toolStripTextBox2.Text == "") sl = "0"; else sl = toolStripTextBox2.Text; string soluongsp = (soluong + int.Parse(sl).ToString()); //giá nhập string gianhap = "0"; gianhap = toolStrip_txtTonkho.Text; double gianhapsp = double.Parse(gianhap) * soluong; // giá bán buôn string giabanbuon = "0"; giabanbuon = toolStrip_txtTonThucTe.Text; double giabanbuonsp = double.Parse(giabanbuon) * soluong; //giá bán lẻ string giabanle = "0"; giabanle = toolStripTextBox1.Text; double giabanlesp = double.Parse(giabanle) * soluong; tempcheck = new Entities.ChiTietGoiHang[1]; tempcheck[0] = new Entities.ChiTietGoiHang("Insert", 0, txtmagoihang.Text, toolStrip_txtTracuu.Text, toolStrip_txtTenhang.Text, gianhapsp.ToString(), giabanbuonsp.ToString(), giabanlesp.ToString(), int.Parse(sl)); dgvInsertOrder.DataSource = tempcheck; } finally { try { Entities.ChiTietGoiHang[] goi; ArrayList l = new ArrayList(); sotang = 0; foreach (Entities.ChiTietGoiHang item in tempcheck) { soluong = item.SoLuong; gn += double.Parse(item.GiaNhap); gbb += double.Parse(item.GiaBanBuon); gbl += double.Parse(item.GiaBanLe); tsl += item.SoLuong; l.Add(item); tempcheck[sotang] = item; sotang++; } //for (int i = 0; i < tempcheck.Length; i++) //{ // l.Add(tempcheck[i]); // soluong = tempcheck[i].SoLuong; // giaNhap += double.Parse(tempcheck[i].GiaNhap) * soluong; // giaBanBuon += double.Parse(tempcheck[i].GiaBanBuon) * soluong; // giaBanLe += double.Parse(tempcheck[i].GiaBanLe) * soluong; //} int k = l.Count; if (k <= 0) { goi = null; } else { Entities.ChiTietGoiHang r = new Entities.ChiTietGoiHang(); r.TenHangHoa = "Tổng Cộng"; r.GiaNhap = (new Common.Utilities().FormatMoney(gn)); r.GiaBanBuon = (new Common.Utilities().FormatMoney(gbb)); r.GiaBanLe = (new Common.Utilities().FormatMoney(gbl)); r.SoLuong = tsl; l.Add(r); int x = l.Count; goi = new Entities.ChiTietGoiHang[x]; for (int i = 0; i < x; i++) { goi[i] = (Entities.ChiTietGoiHang)l[i]; } } dgvInsertOrder.DataSource = goi; txtgianhap.Text = gn.ToString(); txtgiabanbuon.Text = gbb.ToString(); txtgiabanle.Text = gbl.ToString(); gn = 0; gbb = 0; gbl = 0; tsl = 0; fix(); } catch { } } }
public Entities.ChiTietGoiHang[] GetChiTietGoiHang() { List<Entities.ChiTietGoiHang> list = null; Entities.ChiTietGoiHang chitiet = null; int rowCount = dgvInsertOrder.RowCount; if (rowCount > 1) { list = new List<Entities.ChiTietGoiHang>(); for (int i = 0; i < rowCount - 1; i++) { chitiet = new Entities.ChiTietGoiHang(); chitiet.MaGoiHang = this.txtmagoihang.Text; chitiet.MaHangHoa = dgvInsertOrder.Rows[i].Cells["MaHangHoa"].Value.ToString(); chitiet.TenHangHoa = dgvInsertOrder.Rows[i].Cells["TenHangHoa"].Value.ToString(); chitiet.SoLuong = int.Parse(dgvInsertOrder.Rows[i].Cells["SoLuong"].Value.ToString()); chitiet.GiaNhap = dgvInsertOrder.Rows[i].Cells["GiaNhap"].Value.ToString(); chitiet.GiaBanBuon = dgvInsertOrder.Rows[i].Cells["GiaBanBuon"].Value.ToString(); chitiet.GiaBanLe = dgvInsertOrder.Rows[i].Cells["GiaBanLe"].Value.ToString(); chitiet.HanhDong = "Insert"; list.Add(chitiet); } } return (Entities.ChiTietGoiHang[])list.ToArray(); }
public bool CheckDataGridDelete(DataGridView dgv) { bool kkt = false; try { if (dgv.RowCount != 0) { List<Entities.ChiTietGoiHang> list = new List<Entities.ChiTietGoiHang>(); Entities.ChiTietGoiHang chitietgoihang = null; chitietgoihang = new Entities.ChiTietGoiHang("Delete", 0, txtmagoihang.Text, "", "", "0", "0", "0", 0); list.Add(chitietgoihang); Entities.ChiTietGoiHang[] ctghArr = (Entities.ChiTietGoiHang[])list.ToArray(); kkt = DeleteMang(ctghArr); return kkt; } return kkt; } catch { return false; } }
void SuaRow() { if (i < 0) return; if (dgvInsertOrder.RowCount > 1) { txtmagoihang.Text = dgvInsertOrder["MaGoiHang", i].Value.ToString().ToUpper(); toolStrip_txtTracuu.Text = dgvInsertOrder["MaHangHoa", i].Value.ToString().ToUpper(); toolStrip_txtTenhang.Text = dgvInsertOrder["TenHangHoa", i].Value.ToString(); toolStrip_txtTonkho.Text = new Common.Utilities().FormatMoney(double.Parse(dgvInsertOrder["GiaNhap", i].Value.ToString()) / double.Parse(dgvInsertOrder["SoLuong", i].Value.ToString())); toolStrip_txtTonThucTe.Text = new Common.Utilities().FormatMoney(double.Parse(dgvInsertOrder["GiaBanBuon", i].Value.ToString()) / double.Parse(dgvInsertOrder["SoLuong", i].Value.ToString())); toolStripTextBox1.Text = new Common.Utilities().FormatMoney(double.Parse(dgvInsertOrder["GiaBanLe", i].Value.ToString()) / double.Parse(dgvInsertOrder["SoLuong", i].Value.ToString())); toolStripTextBox2.Text = dgvInsertOrder["SoLuong", i].Value.ToString(); tempcheck = new Entities.ChiTietGoiHang[dgvInsertOrder.RowCount - 1]; int sotang = 0; for (int j = 0; j < dgvInsertOrder.RowCount - 1; j++) { if (dgvInsertOrder["MaHangHoa", j].Value.ToString() != dgvInsertOrder["MaHangHoa", i].Value.ToString()) { tempcheck[sotang] = new Entities.ChiTietGoiHang("Delete", 0, dgvInsertOrder["MaGoiHang", j].Value.ToString(), dgvInsertOrder["MaHangHoa", j].Value.ToString(), dgvInsertOrder["TenHangHoa", j].Value.ToString(), dgvInsertOrder["GiaNhap", j].Value.ToString(), dgvInsertOrder["GiaBanBuon", j].Value.ToString(), dgvInsertOrder["GiaBanLe", j].Value.ToString(), int.Parse(dgvInsertOrder["SoLuong", j].Value.ToString())); sotang++; } } dgvInsertOrder.DataSource = tempcheck; } else { txtmagoihang.Text = dgvInsertOrder["MaGoiHang", i].Value.ToString().ToUpper(); toolStrip_txtTracuu.Text = dgvInsertOrder["MaHangHoa", i].Value.ToString().ToUpper(); toolStrip_txtTenhang.Text = dgvInsertOrder["TenHangHoa", i].Value.ToString(); toolStrip_txtTonkho.Text = new Common.Utilities().FormatMoney(double.Parse(dgvInsertOrder["GiaNhap", i].Value.ToString())); toolStrip_txtTonThucTe.Text = new Common.Utilities().FormatMoney(double.Parse(dgvInsertOrder["GiaBanBuon", i].Value.ToString())); toolStripTextBox1.Text = new Common.Utilities().FormatMoney(double.Parse(dgvInsertOrder["GiaBanLe", i].Value.ToString())); toolStripTextBox2.Text = dgvInsertOrder["SoLuong", i].Value.ToString(); dgvInsertOrder.DataSource = new Entities.ChiTietGoiHang[0]; toolStrip_txtTracuu.Text = toolStrip_txtTenhang.Text = toolStrip_txtTonkho.Text = toolStrip_txtTonThucTe.Text = toolStripTextBox1.Text = toolStripTextBox2.Text = "0"; } }
public Entities.ChiTietGoiHang[] ChiTietGoiHang() { Entities.ChiTietGoiHang[] nkh1 = new BizLogic.ChiTietGoiHang().Select(); if (nkh1 == null) nkh1 = new Entities.ChiTietGoiHang[0]; return nkh1; }