//delete public int Delete(Entities.KhoHang kh1) { int tra = 0; try { kh = new Constants.KhoHang(); Entities.KhoHang khohang = new Entities.KhoHang(); Sql = new Constants.Sql(); string sql = Sql.DeleteKhoHang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(kh.HanhDong, SqlDbType.NVarChar, 20).Value = kh1.HanhDong; cmd.Parameters.Add(kh.KhoHangID, SqlDbType.Int).Value = kh1.KhoHangID; tra = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; } catch (Exception ex) { string s = ex.Message; tra = 0; } return tra; }
//insert update public Entities.KhoHang InsertUpdate(Entities.KhoHang kh1) { Entities.KhoHang k = new Entities.KhoHang(); try { kh = new Constants.KhoHang(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdateKhoHang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(kh.HanhDong, SqlDbType.NVarChar, 20).Value = kh1.HanhDong; cmd.Parameters.Add(kh.KhoHangID, SqlDbType.Int).Value = kh1.KhoHangID; cmd.Parameters.Add(kh.MaKho, SqlDbType.VarChar, 20).Value = kh1.MaKho; cmd.Parameters.Add(kh.TenKho, SqlDbType.NVarChar, 200).Value = kh1.TenKho; cmd.Parameters.Add(kh.DiaChi, SqlDbType.NVarChar, 200).Value = kh1.DiaChi; cmd.Parameters.Add(kh.DienThoai, SqlDbType.NVarChar, 200).Value = kh1.DienThoai; cmd.Parameters.Add(kh.MaNhanVien, SqlDbType.NVarChar, 200).Value = kh1.MaNhanVien; cmd.Parameters.Add(kh.GhiChu, SqlDbType.NVarChar, 100).Value = kh1.GhiChu; cmd.Parameters.Add(kh.Deleted, SqlDbType.Bit).Value = kh1.Deleted; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { k.GhiChu = dr[0].ToString(); } } catch (Exception ex) { string s = ex.Message.ToString(); k.GhiChu = null; } return k; }
//insert update public Entities.KhoHang InsertUpdate(Entities.KhoHang kh1) { Entities.KhoHang k = new Entities.KhoHang(); try { kh = new Constants.KhoHang(); Sql = new Constants.Sql(); string sql = Sql.InsertUpdateKhoHang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(kh.HanhDong, SqlDbType.NVarChar, 20).Value = kh1.HanhDong; cmd.Parameters.Add(kh.KhoHangID, SqlDbType.Int).Value = kh1.KhoHangID; cmd.Parameters.Add(kh.MaKho, SqlDbType.VarChar, 20).Value = kh1.MaKho; cmd.Parameters.Add(kh.TenKho, SqlDbType.NVarChar, 200).Value = kh1.TenKho; cmd.Parameters.Add(kh.DiaChi, SqlDbType.NVarChar, 200).Value = kh1.DiaChi; cmd.Parameters.Add(kh.DienThoai, SqlDbType.NVarChar, 200).Value = kh1.DienThoai; cmd.Parameters.Add(kh.MaNhanVien, SqlDbType.NVarChar, 200).Value = kh1.MaNhanVien; cmd.Parameters.Add(kh.GhiChu, SqlDbType.NVarChar, 100).Value = kh1.GhiChu; cmd.Parameters.Add(kh.Deleted, SqlDbType.Bit).Value = kh1.Deleted; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { k.GhiChu = dr[0].ToString(); } } catch (Exception ex) { string s = ex.Message.ToString(); k.GhiChu = null; } return(k); }
/// <summary> /// lay thong tin cac kho hang /// </summary> /// <returns></returns> public Entities.KhoHang[] sp_SelectKhoHangsAll() { List <Entities.KhoHang> L = new List <Entities.KhoHang>(); try { kh = new Constants.KhoHang(); cn = new Connection().openConnection(); cmd = new SqlCommand("exec sp_SelectKhoHangsAll", cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { khohang = new Entities.KhoHang(); khohang.MaKho = dr[kh.MaKho].ToString(); khohang.TenKho = dr[kh.TenKho].ToString(); khohang.DiaChi = dr[kh.DiaChi].ToString(); khohang.DienThoai = dr[kh.DienThoai].ToString(); khohang.MaNhanVien = dr[kh.MaNhanVien].ToString(); khohang.GhiChu = dr[kh.GhiChu].ToString(); L.Add(khohang); } } catch { return(null); } finally { cmd.Connection.Dispose(); cn.Close(); } return(L.ToArray()); }
/// <summary> /// lay ban ghi dang update /// </summary> public Entities.KhoHang sp_LayBang_TheoTenBang(Entities.TruyenGiaTri chuyen) { Entities.KhoHang giatri = new Entities.KhoHang(); try { string sql = "exec sp_LayBang_TheoTenBang @table,@values"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("table", SqlDbType.NVarChar, 100).Value = chuyen.Giatritruyen; cmd.Parameters.Add("values", SqlDbType.NVarChar, 50).Value = chuyen.Giatrithuhai; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { giatri.KhoHangID = int.Parse(dr[0].ToString()); giatri.MaKho = dr[1].ToString(); giatri.TenKho = dr[2].ToString(); giatri.DiaChi = dr[3].ToString(); giatri.DienThoai = dr[4].ToString(); giatri.MaNhanVien = dr[5].ToString(); giatri.GhiChu = "" + dr[6].ToString(); giatri.Deleted = Boolean.Parse(dr[7].ToString()); } } catch (Exception ex) { string s = ex.Message.ToString(); giatri = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return(giatri); }
//delete public int Delete(Entities.KhoHang kh1) { int tra = 0; try { kh = new Constants.KhoHang(); Entities.KhoHang khohang = new Entities.KhoHang(); Sql = new Constants.Sql(); string sql = Sql.DeleteKhoHang; Connection conn = new Connection(); SqlConnection cn = conn.openConnection(); SqlCommand cmd = new SqlCommand(sql, cn); cmd.Parameters.Add(kh.HanhDong, SqlDbType.NVarChar, 20).Value = kh1.HanhDong; cmd.Parameters.Add(kh.KhoHangID, SqlDbType.Int).Value = kh1.KhoHangID; tra = cmd.ExecuteNonQuery(); cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); cn = null; conn = null; } catch (Exception ex) { string s = ex.Message; tra = 0; } return(tra); }
public KhoHang() { kh = null; Sql = null; conn = null; cmd = null; arr = null; dr = null; khohang = null; cn = null; }
/// <summary> /// lấy kho hàng /// </summary> public void LayKhoHang() { try { cbbkhohang.Items.Clear(); cl = new Server_Client.Client(); this.Client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.KhoHang kh = new Entities.KhoHang(); kh = new Entities.KhoHang("Select"); Clientstrem = cl.SerializeObj(this.Client1, "KhoHang", kh); kh1 = new Entities.KhoHang[1]; kh1 = (Entities.KhoHang[])cl.DeserializeHepper1(Clientstrem, kh1); if (kh1 == null) kh1 = new Entities.KhoHang[0]; if (kh1.Length > 0) { int sl = kh1.Length; for (int i = 0; i < sl; i++) { if (kh1[i].Deleted == false) cbbkhohang.Items.Add(kh1[i].TenKho); } } } catch { cbbkhohang.Items.Clear(); cbbkhohang.Text = ""; } }
/// <summary> /// lay thong tin cac kho hang /// </summary> /// <returns></returns> public Entities.KhoHang[] sp_SelectKhoHangsAll() { List<Entities.KhoHang> L = new List<Entities.KhoHang>(); try { kh = new Constants.KhoHang(); cn = new Connection().openConnection(); cmd = new SqlCommand("exec sp_SelectKhoHangsAll", cn); dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { khohang = new Entities.KhoHang(); khohang.MaKho = dr[kh.MaKho].ToString(); khohang.TenKho = dr[kh.TenKho].ToString(); khohang.DiaChi = dr[kh.DiaChi].ToString(); khohang.DienThoai = dr[kh.DienThoai].ToString(); khohang.MaNhanVien = dr[kh.MaNhanVien].ToString(); khohang.GhiChu = dr[kh.GhiChu].ToString(); L.Add(khohang); } } catch { return null; } finally { cmd.Connection.Dispose(); cn.Close(); } return L.ToArray(); }
/// <summary> /// lay ban ghi dang update /// </summary> public Entities.KhoHang sp_LayBang_TheoTenBang(Entities.TruyenGiaTri chuyen) { Entities.KhoHang giatri = new Entities.KhoHang(); try { string sql = "exec sp_LayBang_TheoTenBang @table,@values"; conn = new Connection(); cn = conn.openConnection(); cmd = new SqlCommand(sql, cn); cmd.Parameters.Add("table", SqlDbType.NVarChar, 100).Value = chuyen.Giatritruyen; cmd.Parameters.Add("values", SqlDbType.NVarChar, 50).Value = chuyen.Giatrithuhai; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { giatri.KhoHangID = int.Parse(dr[0].ToString()); giatri.MaKho = dr[1].ToString(); giatri.TenKho = dr[2].ToString(); giatri.DiaChi = dr[3].ToString(); giatri.DienThoai = dr[4].ToString(); giatri.MaNhanVien = dr[5].ToString(); giatri.GhiChu = ""+dr[6].ToString(); giatri.Deleted = Boolean.Parse(dr[7].ToString()); } } catch (Exception ex) { string s = ex.Message.ToString(); giatri = null; } finally { cmd.Connection.Dispose(); cn.Close(); conn.closeConnection(); } return giatri; }
public void LayKhoHang() { try { cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); Entities.KhoHang ctxh = new Entities.KhoHang("Select"); clientstrem = cl.SerializeObj(this.client1, "KhoHang", ctxh); khohang = (Entities.KhoHang[])cl.DeserializeHepper1(clientstrem, khohang); if (khohang == null) { khohang = new Entities.KhoHang[0]; return; } } catch { } }