本文整理汇总了C#中DataService.Load方法的典型用法代码示例。如果您正苦于以下问题：C# DataService.Load方法的具体用法？C# DataService.Load怎么用？C# DataService.Load使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataService的用法示例。
在下文中一共展示了DataService.Load方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: LayDsKhoanChi
public DataTable LayDsKhoanChi()
{
SqlCommand cmd = new SqlCommand(TruyVanChung());
DataService dS = new DataService();
dS.Load(cmd);
m_KhoanChiData = dS;
return m_KhoanChiData;
}示例2: CapNhatTimKiemTuDong
public static int CapNhatTimKiemTuDong(Boolean timKiemTuDong)
{
DataService m_QuyDinhData = new DataService();
SqlCommand cmd = new SqlCommand("UPDATE QUYDINH SET TimKiemTuDong= @timKiemTuDong");
cmd.Parameters.Add("timKiemTuDong", SqlDbType.Bit).Value = timKiemTuDong;
return m_QuyDinhData.Load(cmd);
}示例3: CapNhatTaiKhoanCo
public static int CapNhatTaiKhoanCo(Int64 taiKhoanCo)
{
DataService m_QuyDinhData = new DataService();
SqlCommand cmd = new SqlCommand("UPDATE QUYDINH SET TaiKhoanCo = TaiKhoanCo + @taiKhoanCo");
cmd.Parameters.Add("taiKhoanCo", SqlDbType.BigInt).Value = taiKhoanCo;
return m_QuyDinhData.Load(cmd);
}示例4: LayDsQuyDinh
public DataTable LayDsQuyDinh()
{
SqlCommand cmd = new SqlCommand("SELECT * FROM QUYDINH");
DataService dS = new DataService();
dS.Load(cmd);
m_QuyDinhData = dS;
return m_QuyDinhData;
}示例5: LayDsNhanVien
public DataTable LayDsNhanVien(String sqlString)
{
SqlCommand cmd = new SqlCommand(sqlString);
DataService dS = new DataService();
dS.Load(cmd);
m_NhanVienData = dS;
return m_NhanVienData;
}示例6: LayDsLoaiNguoiDung
public DataTable LayDsLoaiNguoiDung()
{
SqlCommand cmd = new SqlCommand("SELECT * FROM LOAINGUOIDUNG");
DataService dS = new DataService();
dS.Load(cmd);
m_LoaiNguoiDungData = dS;
return m_LoaiNguoiDungData;
}示例7: CapNhatThongTinSaoLuu
public static int CapNhatThongTinSaoLuu(int lichSaoLuu, String viTriSaoLuu)
{
DataService m_QuyDinhData = new DataService();
SqlCommand cmd = new SqlCommand("UPDATE QUYDINH SET LichSaoLuu = @lichSaoLuu, ThoiDiemSaoLuuTiepTheo = dateadd(dd, @lichSaoLuu, getdate()), viTriSaoLuu = @viTriSaoLuu");
cmd.Parameters.Add("lichSaoLuu", SqlDbType.Int).Value = lichSaoLuu;
cmd.Parameters.Add("viTriSaoLuu", SqlDbType.VarChar).Value = viTriSaoLuu;
return m_QuyDinhData.Load(cmd);
}示例8: TimTheoMa
public DataTable TimTheoMa(String id)
{
SqlCommand cmd = new SqlCommand("SELECT * FROM KhoanChi WHERE MaKC LIKE '%' + @id + '%'");
cmd.Parameters.Add("id", SqlDbType.VarChar).Value = id;
DataService dS = new DataService();
dS.Load(cmd);
m_KhoanChiData = dS;
return m_KhoanChiData;
}示例9: LayDsNguoiDung
public DataTable LayDsNguoiDung(String tenDangNhap)
{
SqlCommand cmd = new SqlCommand("SELECT * FROM NGUOIDUNG WHERE TenDangNhap = @ten");
cmd.Parameters.Add("ten", SqlDbType.VarChar).Value = tenDangNhap;
DataService dS = new DataService();
dS.Load(cmd);
m_NguoiDungData = dS;
return m_NguoiDungData;
}示例10: TimTheoTen
public DataTable TimTheoTen(String TenKC)
{
SqlCommand cmd = new SqlCommand("SELECT * FROM KhoanChi WHERE TenKC LIKE '%' + @TenKC + '%'");
cmd.Parameters.Add("TenKC", SqlDbType.NVarChar).Value = TenKC;
DataService dS = new DataService();
dS.Load(cmd);
m_KhoanChiData = dS;
return m_KhoanChiData;
}示例11: CapNhatThongTinCongTy
public static int CapNhatThongTinCongTy(String tenTenCongTy, String diaChi, String dienThoai)
{
DataService m_QuyDinhData = new DataService();
SqlCommand cmd = new SqlCommand("UPDATE QUYDINH SET TenCongTy = @tenCongTy, DiaChi = @diaChi, DienThoai = @dienThoai");
cmd.Parameters.Add("tenCongTy", SqlDbType.NVarChar).Value = tenTenCongTy;
cmd.Parameters.Add("diaChi", SqlDbType.NVarChar).Value = diaChi;
cmd.Parameters.Add("dienThoai", SqlDbType.NVarChar).Value = dienThoai;
return m_QuyDinhData.Load(cmd);
}示例12: LuuKhachHang
public void LuuKhachHang(String maKH, String tenKH, String diaChi, String dienThoai)
{
SqlCommand cmd = new SqlCommand("INSERT INTO KhachHang VALUES(@maKH, @tenKH, @diaChi, @dienThoai)");
cmd.Parameters.Add("maKH", SqlDbType.VarChar).Value = maKH;
cmd.Parameters.Add("tenKH", SqlDbType.NVarChar).Value = tenKH;
cmd.Parameters.Add("diaChi", SqlDbType.NVarChar).Value = diaChi;
cmd.Parameters.Add("dienThoai", SqlDbType.VarChar).Value = dienThoai;
DataService dS = new DataService();
dS.Load(cmd);
m_KhachHangData = dS;
}示例13: LuuNhaCungCap
public void LuuNhaCungCap(String maNCC, String tenNCC, String diaChi, String dienThoai)
{
SqlCommand cmd = new SqlCommand("INSERT INTO NhaCungCap VALUES(@maNCC, @tenNCC, @diaChi, @dienThoai)");
cmd.Parameters.Add("maNCC", SqlDbType.VarChar).Value = maNCC;
cmd.Parameters.Add("tenNCC", SqlDbType.NVarChar).Value = tenNCC;
cmd.Parameters.Add("diaChi", SqlDbType.NVarChar).Value = diaChi;
cmd.Parameters.Add("dienThoai", SqlDbType.VarChar).Value = dienThoai;
DataService dS = new DataService();
dS.Load(cmd);
m_NhaCungCapData = dS;
}示例14: TimKiemPhieuThu
public DataTable TimKiemPhieuThu(String tinhTrang, String tuKhoa)
{
SqlCommand cmd = new SqlCommand();
String sql = TruyVanChung() + "WHERE SoPT LIKE '%' + @tuKhoa + '%' " +
"AND TinhTrang LIKE '%' + @tinhTrang + '%' ORDER BY SoPT DESC";
cmd.Parameters.Add("tuKhoa", SqlDbType.VarChar).Value = tuKhoa;
cmd.Parameters.Add("tinhTrang", SqlDbType.VarChar).Value = tinhTrang;
cmd.CommandText = sql;
DataService dS = new DataService();
dS.Load(cmd);
m_PhieuThuData = dS;
return m_PhieuThuData;
}示例15: LuuNhanVien
public void LuuNhanVien(String maNV, String tenNV, DateTime ngaySinh, Boolean gioiTinh, String CMND, String diaChi, String dienThoai)
{
SqlCommand cmd = new SqlCommand("INSERT INTO NhanVien VALUES(@maNV, @tenNV, @ngaySinh, @gioiTinh, @CMND, @diaChi, @dienThoai)");
cmd.Parameters.Add("maNV", SqlDbType.VarChar).Value = maNV;
cmd.Parameters.Add("tenNV", SqlDbType.NVarChar).Value = tenNV;
cmd.Parameters.Add("ngaySinh", SqlDbType.DateTime).Value = ngaySinh;
cmd.Parameters.Add("gioiTinh", SqlDbType.Bit).Value = gioiTinh;
cmd.Parameters.Add("CMND", SqlDbType.VarChar).Value = CMND;
cmd.Parameters.Add("diaChi", SqlDbType.NVarChar).Value = diaChi;
cmd.Parameters.Add("dienThoai", SqlDbType.VarChar).Value = dienThoai;
DataService dS = new DataService();
dS.Load(cmd);
m_NhanVienData = dS;
}