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;
}
