public int InsertUpdate(Entities.GoiHang nhom) { int rt = 0; try { conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(Common.Constants.Sql.GoiHang.InsertUpdateGoiHang, cn); cmd.Parameters.Add(Common.Constants.GoiHang.HanhDong, SqlDbType.NVarChar).Value = nhom.HanhDong; cmd.Parameters.Add(Common.Constants.GoiHang.GoiHangID, SqlDbType.Int).Value = nhom.GoiHangID; cmd.Parameters.Add(Common.Constants.GoiHang.MaKho, SqlDbType.VarChar, 20).Value = nhom.MaKho.ToUpper(); cmd.Parameters.Add(Common.Constants.GoiHang.MaGoiHang, SqlDbType.VarChar, 50).Value = nhom.MaGoiHang.ToUpper(); cmd.Parameters.Add(Common.Constants.GoiHang.TenGoiHang, SqlDbType.NVarChar, 200).Value = nhom.TenGoiHang; cmd.Parameters.Add(Common.Constants.GoiHang.MaNhomHang, SqlDbType.VarChar, 50).Value = nhom.MaNhomHang; cmd.Parameters.Add(Common.Constants.GoiHang.TenNhomHang, SqlDbType.NVarChar, 200).Value = nhom.TenNhomHang; cmd.Parameters.Add(Common.Constants.GoiHang.GiaNhap, SqlDbType.Float).Value = nhom.GiaNhap; cmd.Parameters.Add(Common.Constants.GoiHang.GiaBanBuon, SqlDbType.Float).Value = nhom.GiaBanBuon; cmd.Parameters.Add(Common.Constants.GoiHang.GiaBanLe, SqlDbType.Float).Value = nhom.GiaBanLe; cmd.Parameters.Add(Common.Constants.GoiHang.Deleted, SqlDbType.Bit).Value = nhom.Deleted; rt = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); rt = 0; } return(rt); }
public GoiHang() { kh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; goihang = null; cn = null; }
public int Delete(Entities.GoiHang nhom) { int rt = 0; try { conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(Common.Constants.Sql.GoiHang.DeleteGoiHang, cn); cmd.Parameters.Add(Common.Constants.GoiHang.GoiHangID, SqlDbType.Int).Value = nhom.GoiHangID; rt = cmd.ExecuteNonQuery(); } catch (Exception ex) { string s = ex.Message.ToString(); rt = 0; } return(rt); }
public Entities.GoiHang[] Select() { Entities.GoiHang[] list = null; try { string sql = Common.Constants.Sql.GoiHang.SelectGoiHang; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { Entities.GoiHang row = new Entities.GoiHang(); row.GoiHangID = Convert.ToInt32(dr[Common.Constants.GoiHang.GoiHangID].ToString()); row.MaKho = dr[Common.Constants.GoiHang.MaKho].ToString(); row.MaGoiHang = dr[Common.Constants.GoiHang.MaGoiHang].ToString(); row.TenGoiHang = dr[Common.Constants.GoiHang.TenGoiHang].ToString(); row.MaNhomHang = dr[Common.Constants.GoiHang.MaNhomHang].ToString(); row.TenNhomHang = dr[Common.Constants.GoiHang.TenNhomHang].ToString(); row.GiaNhap = dr[Common.Constants.GoiHang.GiaNhap].ToString(); row.GiaBanBuon = dr[Common.Constants.GoiHang.GiaBanBuon].ToString(); row.GiaBanLe = dr[Common.Constants.GoiHang.GiaBanLe].ToString(); row.Deleted = Boolean.Parse(dr[Common.Constants.GoiHang.Deleted].ToString()); arr.Add(row); } int n = arr.Count; if (n == 0) { list = null; } list = new Entities.GoiHang[n]; for (int i = 0; i < n; i++) { list[i] = (Entities.GoiHang)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); list = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(list); }
public Entities.GoiHang[] Select(Entities.GoiHang hh) { Entities.GoiHang[] list = null; try { conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(Common.Constants.Sql.GoiHang.SelectTheoMaGoiHang, cn); cmd.Parameters.Add(Common.Constants.GoiHang.MaGoiHang, SqlDbType.VarChar, 50).Value = hh.MaGoiHang; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { Entities.GoiHang row = new Entities.GoiHang(); row.GoiHangID = int.Parse(dr[Common.Constants.GoiHang.GoiHangID].ToString()); row.MaKho = dr[Common.Constants.GoiHang.MaKho].ToString(); row.MaGoiHang = dr[Common.Constants.GoiHang.MaGoiHang].ToString(); row.TenGoiHang = dr[Common.Constants.GoiHang.TenGoiHang].ToString(); row.MaNhomHang = dr[Common.Constants.GoiHang.MaNhomHang].ToString(); row.TenNhomHang = dr[Common.Constants.GoiHang.TenNhomHang].ToString(); row.GiaBanBuon = dr[Common.Constants.GoiHang.GiaBanBuon].ToString(); row.GiaBanLe = dr[Common.Constants.GoiHang.GiaBanLe].ToString(); arr.Add(row); } if (arr.Count > 0) { list = (Entities.GoiHang[])arr.ToArray(typeof(Entities.GoiHang)); } else { list = new Entities.GoiHang[0]; } } catch (Exception ex) { string s = ex.Message.ToString(); list = new Entities.GoiHang[0]; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(list); }
/// <summary> /// GetGVGoiHang /// </summary> /// <param name="maHd"> </param> /// <param name="maGoi"></param> /// <param name="gh"></param> /// <returns></returns> public GiaVonBanHang GetGvGoiHang(string maHd, string maGoi, GoiHang[] gh) { GiaVonBanHang retVal = null; try { foreach (GoiHang item in gh.Where(item => item.MaGoiHang.Trim().ToUpper().Equals(maGoi.Trim().ToUpper()))) { retVal = new GiaVonBanHang { HanhDong = "Insert", MaHangHoa = maGoi.Trim().ToUpper(), MaHoaDon = maHd.Trim().ToUpper(), GiaVon = double.Parse(item.GiaNhap) }; break; } } catch { retVal = null; } return retVal; }
/// <summary> /// Lấy dữ liệu bảng hàng hóa và gói hàng (Chạy 1 lần để lấy dữ liệu và gán vào biến dùng chung) /// </summary> /// <returns></returns> List<ThongTinMaVach> GetHangHoaGoiHang() { List<ThongTinMaVach> dsThongTinMaVachs = new List<ThongTinMaVach>(); try { //Lấy MaHangHoa,TenHangHoa,GiaNhap,GiaBanBuon,GiaBanLe,GhiChu từ bảng HÀNG HÓA cl = new Server_Client.Client(); client = cl.Connect(Luu.IP, Luu.Ports); ThongTinMaVach row1 = new ThongTinMaVach("Select"); clientstrem = cl.SerializeObj(client, "ThongTinMaVachHangHoa", row1); ThongTinMaVach[] dsHangHoa = new ThongTinMaVach[0]; dsHangHoa = (ThongTinMaVach[])cl.DeserializeHepper(clientstrem, dsHangHoa); client.Close(); clientstrem.Close(); if (dsHangHoa != null) dsThongTinMaVachs.AddRange(dsHangHoa); } catch { } try { //Lấy a.GoiHangID,a.MaKho,a.MaGoiHang,a.TenGoiHang,a.MaNhomHang,b.TenNhomHang,a.GiaNhap,a.GiaBanBuon,a.GiaBanLe,a.Deleted //FROM GoiHang a join NhomHang b on a.MaNhomHang=b.MaNhomHang WHERE a.Deleted='False' cl = new Server_Client.Client(); client = cl.Connect(Luu.IP, Luu.Ports); GoiHang goi = new GoiHang("Select"); clientstrem = cl.SerializeObj(client, "GoiHang", goi); GoiHang[] goiHang = new GoiHang[0]; goiHang = (GoiHang[])cl.DeserializeHepper1(clientstrem, goiHang); if (goiHang != null) { foreach (GoiHang item in goiHang) { if (item.Deleted) continue; ThongTinMaVach row = new ThongTinMaVach { MaHangHoa = item.MaGoiHang, TenHangHoa = item.TenGoiHang, GiaNhap = item.GiaNhap, GiaBanBuon = item.GiaBanBuon, GiaBanLe = item.GiaBanLe }; dsThongTinMaVachs.Add(row); } } } catch { } return dsThongTinMaVachs; }
public Entities.GoiHang[] Select() { Entities.GoiHang[] list = null; try { string sql = Common.Constants.Sql.GoiHang.SelectGoiHang; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { Entities.GoiHang row = new Entities.GoiHang(); row.GoiHangID = Convert.ToInt32(dr[Common.Constants.GoiHang.GoiHangID].ToString()); row.MaKho = dr[Common.Constants.GoiHang.MaKho].ToString(); row.MaGoiHang = dr[Common.Constants.GoiHang.MaGoiHang].ToString(); row.TenGoiHang = dr[Common.Constants.GoiHang.TenGoiHang].ToString(); row.MaNhomHang = dr[Common.Constants.GoiHang.MaNhomHang].ToString(); row.TenNhomHang = dr[Common.Constants.GoiHang.TenNhomHang].ToString(); row.GiaNhap = dr[Common.Constants.GoiHang.GiaNhap].ToString(); row.GiaBanBuon = dr[Common.Constants.GoiHang.GiaBanBuon].ToString(); row.GiaBanLe = dr[Common.Constants.GoiHang.GiaBanLe].ToString(); row.Deleted = Boolean.Parse(dr[Common.Constants.GoiHang.Deleted].ToString()); arr.Add(row); } int n = arr.Count; if (n == 0) { list = null; } list = new Entities.GoiHang[n]; for (int i = 0; i < n; i++) { list[i] = (Entities.GoiHang)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); list = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return list; }
public Entities.GoiHang[] Select(Entities.GoiHang hh) { Entities.GoiHang[] list = null; try { conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(Common.Constants.Sql.GoiHang.SelectTheoMaGoiHang, cn); cmd.Parameters.Add(Common.Constants.GoiHang.MaGoiHang, SqlDbType.VarChar, 50).Value = hh.MaGoiHang; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { Entities.GoiHang row = new Entities.GoiHang(); row.GoiHangID = int.Parse(dr[Common.Constants.GoiHang.GoiHangID].ToString()); row.MaKho = dr[Common.Constants.GoiHang.MaKho].ToString(); row.MaGoiHang = dr[Common.Constants.GoiHang.MaGoiHang].ToString(); row.TenGoiHang = dr[Common.Constants.GoiHang.TenGoiHang].ToString(); row.MaNhomHang = dr[Common.Constants.GoiHang.MaNhomHang].ToString(); row.TenNhomHang = dr[Common.Constants.GoiHang.TenNhomHang].ToString(); row.GiaBanBuon = dr[Common.Constants.GoiHang.GiaBanBuon].ToString(); row.GiaBanLe = dr[Common.Constants.GoiHang.GiaBanLe].ToString(); arr.Add(row); } if (arr.Count > 0) { list = (Entities.GoiHang[])arr.ToArray(typeof(Entities.GoiHang)); } else { list = new Entities.GoiHang[0]; } } catch (Exception ex) { string s = ex.Message.ToString(); list = new Entities.GoiHang[0]; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return list; }