本文整理汇总了C#中DataAccess.UpdateBatch方法的典型用法代码示例。如果您正苦于以下问题：C# DataAccess.UpdateBatch方法的具体用法？C# DataAccess.UpdateBatch怎么用？C# DataAccess.UpdateBatch使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataAccess的用法示例。
在下文中一共展示了DataAccess.UpdateBatch方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: DeleteBatch
public void DeleteBatch(DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "DeleteThuocTinh";
sqlCmd.Parameters.Add("@ThuocTinhID", SqlDbType.Int).SourceColumn = "ThuocTinhID";
objDataAccess.UpdateBatch(rowUpdate, sqlCmd, dtTblMapping);
}
}示例2: DeleteBatch
public void DeleteBatch(DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "DeleteCauHinhHeThong";
sqlCmd.Parameters.Add("@Khoa", SqlDbType.VarChar).SourceColumn = "Khoa";
objDataAccess.UpdateBatch(rowUpdate, sqlCmd, dtTblMapping);
}
}示例3: InsertBatch
public void InsertBatch(ref DataRow[] rowInsert)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "InsertAnh_Ref";
sqlCmd.Parameters.Add("@AnhID", SqlDbType.Int).SourceColumn = "AnhID";
sqlCmd.Parameters["@AnhID"].Direction = ParameterDirection.Output;
sqlCmd.Parameters.Add("@SanPhamID", SqlDbType.Int).SourceColumn = "SanPhamID";
sqlCmd.Parameters.Add("@DuongDan", SqlDbType.NVarChar, 4).SourceColumn = "DuongDan";
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 100).SourceColumn = "Bak1";
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).SourceColumn = "Bak2";
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).SourceColumn = "Bak3";
sqlCmd.Parameters.Add("@SanPhamMauID", SqlDbType.Int).SourceColumn = "SanPhamMauID";
objDataAccess.UpdateBatch(ref rowInsert, sqlCmd, dtTblMapping);
}
}示例4: UpdateBatch
public void UpdateBatch(ref DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "UpdateQuangCao";
sqlCmd.Parameters.Add("@QuangCaoID", SqlDbType.Int).SourceColumn = "QuangCaoID";
sqlCmd.Parameters.Add("@DuongDan", SqlDbType.NVarChar, 200).SourceColumn = "DuongDan";
sqlCmd.Parameters.Add("@NoiDungQuangCao", SqlDbType.NVarChar, 4000).SourceColumn = "NoiDungQuangCao";
sqlCmd.Parameters.Add("@DuongDanAnh", SqlDbType.NVarChar, 200).SourceColumn = "DuongDanAnh";
sqlCmd.Parameters.Add("@NguoiDungID", SqlDbType.Int).SourceColumn = "NguoiDungID";
sqlCmd.Parameters.Add("@GhiChu", SqlDbType.NVarChar, 4000).SourceColumn = "GhiChu";
sqlCmd.Parameters.Add("@LoaiAnh", SqlDbType.VarChar, 20).SourceColumn = "LoaiAnh";
sqlCmd.Parameters.Add("@SapXep", SqlDbType.Int).SourceColumn = "SapXep";
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 50).SourceColumn = "Bak1";
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).SourceColumn = "Bak2";
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Bit).SourceColumn = "Bak3";
sqlCmd.Parameters.Add("@Bak4", SqlDbType.Int).SourceColumn = "Bak4";
objDataAccess.UpdateBatch(ref rowUpdate, sqlCmd, dtTblMapping);
}
}示例5: UpdateBatch
public void UpdateBatch(ref DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "UpdateSanPham";
sqlCmd.Parameters.Add("@SanPhamID", SqlDbType.Int).SourceColumn = "SanPhamID";
sqlCmd.Parameters.Add("@TenSanPham", SqlDbType.NVarChar, 200).SourceColumn = "TenSanPham";
sqlCmd.Parameters.Add("@MaSoSanPham", SqlDbType.Char, 12).SourceColumn = "MaSoSanPham";
sqlCmd.Parameters.Add("@GiaSanPham", SqlDbType.Money).SourceColumn = "GiaSanPham";
sqlCmd.Parameters.Add("@DonViTienTe", SqlDbType.NVarChar, 15).SourceColumn = "DonViTienTe";
sqlCmd.Parameters.Add("@MoTaSanPham", SqlDbType.NText).SourceColumn = "MoTaSanPham";
sqlCmd.Parameters.Add("@ThongTinSanPham", SqlDbType.NText).SourceColumn = "ThongTinSanPham";
sqlCmd.Parameters.Add("@NhomSanPhamID", SqlDbType.Int).SourceColumn = "NhomSanPhamID";
sqlCmd.Parameters.Add("@HangSanXuatID", SqlDbType.Int).SourceColumn = "HangSanXuatID";
sqlCmd.Parameters.Add("@NguoiDungID", SqlDbType.Int).SourceColumn = "NguoiDungID";
sqlCmd.Parameters.Add("@AnhSanPham", SqlDbType.NVarChar, 200).SourceColumn = "AnhSanPham";
sqlCmd.Parameters.Add("@KhuyenMai", SqlDbType.Bit).SourceColumn = "KhuyenMai";
sqlCmd.Parameters.Add("@MoTaKhuyenMai", SqlDbType.NVarChar, 200).SourceColumn = "MoTaKhuyenMai";
sqlCmd.Parameters.Add("@GiaKhuyenMai", SqlDbType.Money).SourceColumn = "GiaKhuyenMai";
sqlCmd.Parameters.Add("@BatDauKhuyenMai", SqlDbType.DateTime).SourceColumn = "BatDauKhuyenMai";
sqlCmd.Parameters.Add("@KetThucKhuyenMai", SqlDbType.DateTime).SourceColumn = "KetThucKhuyenMai";
sqlCmd.Parameters.Add("@DongSanPhamID", SqlDbType.Int).SourceColumn = "DongSanPhamID";
sqlCmd.Parameters.Add("@KhuVucID", SqlDbType.Int).SourceColumn = "KhuVucID";
sqlCmd.Parameters.Add("@Uachuong", SqlDbType.Bit).SourceColumn = "Uachuong";
sqlCmd.Parameters.Add("@GiaMoi", SqlDbType.Money).SourceColumn = "GiaMoi";
sqlCmd.Parameters.Add("@GiamGia", SqlDbType.Bit).SourceColumn = "GiamGia";
sqlCmd.Parameters.Add("@MoiCapNhat", SqlDbType.Bit).SourceColumn = "MoiCapNhat";
sqlCmd.Parameters.Add("@NgayThemSanPham", SqlDbType.DateTime).SourceColumn = "NgayThemSanPham";
sqlCmd.Parameters.Add("@SapXep", SqlDbType.Int).SourceColumn = "SapXep";
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 4000).SourceColumn = "Bak1";
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 100).SourceColumn = "Bak2";
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).SourceColumn = "Bak3";
sqlCmd.Parameters.Add("@Bak4", SqlDbType.Int).SourceColumn = "Bak4";
sqlCmd.Parameters.Add("@Bak5", SqlDbType.Bit).SourceColumn = "Bak5";
sqlCmd.Parameters.Add("@bak6", SqlDbType.NVarChar, 50).SourceColumn = "bak6";
sqlCmd.Parameters.Add("@bak7", SqlDbType.NVarChar, 1000).SourceColumn = "bak7";
sqlCmd.Parameters.Add("@SanPhamMauID", SqlDbType.Int).SourceColumn = "SanPhamMauID";
sqlCmd.Parameters.Add("@NgayCapNhat", SqlDbType.DateTime).SourceColumn = "NgayCapNhat";
sqlCmd.Parameters.Add("@TenSanPhamPhu", SqlDbType.NVarChar, 200).SourceColumn = "TenSanPhamPhu";
objDataAccess.UpdateBatch(ref rowUpdate, sqlCmd, dtTblMapping);
}
}示例6: UpdateBatch
public void UpdateBatch(ref DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "UpdateDauGia";
sqlCmd.Parameters.Add("@DauGiaID", SqlDbType.Int).SourceColumn = "DauGiaID";
sqlCmd.Parameters.Add("@SanPhamID", SqlDbType.Int).SourceColumn = "SanPhamID";
sqlCmd.Parameters.Add("@GiaBanNgay", SqlDbType.Money).SourceColumn = "GiaBanNgay";
sqlCmd.Parameters.Add("@GiaKhoiDiem", SqlDbType.Money).SourceColumn = "GiaKhoiDiem";
sqlCmd.Parameters.Add("@BuocGia", SqlDbType.Money).SourceColumn = "BuocGia";
sqlCmd.Parameters.Add("@BatDau", SqlDbType.DateTime).SourceColumn = "BatDau";
sqlCmd.Parameters.Add("@KetThuc", SqlDbType.DateTime).SourceColumn = "KetThuc";
sqlCmd.Parameters.Add("@TraGiaID", SqlDbType.Int).SourceColumn = "TraGiaID";
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 50).SourceColumn = "Bak1";
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).SourceColumn = "Bak2";
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).SourceColumn = "Bak3";
sqlCmd.Parameters.Add("@Bak4", SqlDbType.Bit).SourceColumn = "Bak4";
objDataAccess.UpdateBatch(ref rowUpdate, sqlCmd, dtTblMapping);
}
}示例7: UpdateBatch
public void UpdateBatch(ref DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "UpdateThuocTinh";
sqlCmd.Parameters.Add("@ThuocTinhID", SqlDbType.Int).SourceColumn = "ThuocTinhID";
sqlCmd.Parameters.Add("@NhomSanPhamID", SqlDbType.Int).SourceColumn = "NhomSanPhamID";
sqlCmd.Parameters.Add("@TenThuocTinh", SqlDbType.NVarChar, 100).SourceColumn = "TenThuocTinh";
sqlCmd.Parameters.Add("@ThuocTinhChaID", SqlDbType.Int).SourceColumn = "ThuocTinhChaID";
sqlCmd.Parameters.Add("@thutu", SqlDbType.Int).SourceColumn = "thutu";
objDataAccess.UpdateBatch(ref rowUpdate, sqlCmd, dtTblMapping);
}
}示例8: UpdateBatch
public void UpdateBatch(ref DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "UpdateChiTietDonHang";
sqlCmd.Parameters.Add("@ChiTietDonHangID", SqlDbType.Int).SourceColumn = "ChiTietDonHangID";
sqlCmd.Parameters.Add("@DonHangID", SqlDbType.Int).SourceColumn = "DonHangID";
sqlCmd.Parameters.Add("@SanPhamID", SqlDbType.Int).SourceColumn = "SanPhamID";
sqlCmd.Parameters.Add("@TenSanPham", SqlDbType.NVarChar, 50).SourceColumn = "TenSanPham";
sqlCmd.Parameters.Add("@GiaSanPham", SqlDbType.Money).SourceColumn = "GiaSanPham";
sqlCmd.Parameters.Add("@SoLuong", SqlDbType.Int).SourceColumn = "SoLuong";
sqlCmd.Parameters.Add("@TongTien", SqlDbType.Money).SourceColumn = "TongTien";
sqlCmd.Parameters.Add("@CuaHangID", SqlDbType.Int).SourceColumn = "CuaHangID";
sqlCmd.Parameters.Add("@TenCuaHang", SqlDbType.NVarChar, 100).SourceColumn = "TenCuaHang";
objDataAccess.UpdateBatch(ref rowUpdate, sqlCmd, dtTblMapping);
}
}示例9: UpdateBatch
public void UpdateBatch(ref DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "UpdateDonHang";
sqlCmd.Parameters.Add("@DonHangID", SqlDbType.Int).SourceColumn = "DonHangID";
sqlCmd.Parameters.Add("@NguoiDungID", SqlDbType.Int).SourceColumn = "NguoiDungID";
sqlCmd.Parameters.Add("@HovaTenNguoiNhan", SqlDbType.NVarChar, 50).SourceColumn = "HovaTenNguoiNhan";
sqlCmd.Parameters.Add("@DiaChiNguoiNhan", SqlDbType.NVarChar, 1000).SourceColumn = "DiaChiNguoiNhan";
sqlCmd.Parameters.Add("@EmailNguoiNhan", SqlDbType.NVarChar, 50).SourceColumn = "EmailNguoiNhan";
sqlCmd.Parameters.Add("@DTDDNguoiNhan", SqlDbType.NVarChar, 50).SourceColumn = "DTDDNguoiNhan";
sqlCmd.Parameters.Add("@CMTND", SqlDbType.VarChar, 9).SourceColumn = "CMTND";
objDataAccess.UpdateBatch(ref rowUpdate, sqlCmd, dtTblMapping);
}
}示例10: InsertBatch
public void InsertBatch(ref DataRow[] rowInsert)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "InsertDonHang_Ref";
sqlCmd.Parameters.Add("@DonHangID", SqlDbType.Int).SourceColumn = "DonHangID";
sqlCmd.Parameters["@DonHangID"].Direction = ParameterDirection.Output;
sqlCmd.Parameters.Add("@NguoiDungID", SqlDbType.Int).SourceColumn = "NguoiDungID";
sqlCmd.Parameters.Add("@HovaTenNguoiNhan", SqlDbType.NVarChar, 4).SourceColumn = "HovaTenNguoiNhan";
sqlCmd.Parameters.Add("@DiaChiNguoiNhan", SqlDbType.NVarChar, 50).SourceColumn = "DiaChiNguoiNhan";
sqlCmd.Parameters.Add("@EmailNguoiNhan", SqlDbType.NVarChar, 1000).SourceColumn = "EmailNguoiNhan";
sqlCmd.Parameters.Add("@DTDDNguoiNhan", SqlDbType.NVarChar, 50).SourceColumn = "DTDDNguoiNhan";
sqlCmd.Parameters.Add("@CMTND", SqlDbType.VarChar, 50).SourceColumn = "CMTND";
objDataAccess.UpdateBatch(ref rowInsert, sqlCmd, dtTblMapping);
}
}示例11: UpdateBatch
public void UpdateBatch(ref DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "UpdateLoaiNguoiDung";
sqlCmd.Parameters.Add("@LoaiNguoiDungID", SqlDbType.Int).SourceColumn = "LoaiNguoiDungID";
sqlCmd.Parameters.Add("@LoaiNguoiDung", SqlDbType.NVarChar, 50).SourceColumn = "LoaiNguoiDung";
sqlCmd.Parameters.Add("@SapXep", SqlDbType.Int).SourceColumn = "SapXep";
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 50).SourceColumn = "Bak1";
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).SourceColumn = "Bak2";
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).SourceColumn = "Bak3";
objDataAccess.UpdateBatch(ref rowUpdate, sqlCmd, dtTblMapping);
}
}示例12: InsertBatch
public void InsertBatch(ref DataRow[] rowInsert)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "InsertLoaiNguoiDung_Ref";
sqlCmd.Parameters.Add("@LoaiNguoiDungID", SqlDbType.Int).SourceColumn = "LoaiNguoiDungID";
sqlCmd.Parameters["@LoaiNguoiDungID"].Direction = ParameterDirection.Output;
sqlCmd.Parameters.Add("@LoaiNguoiDung", SqlDbType.NVarChar, 4).SourceColumn = "LoaiNguoiDung";
sqlCmd.Parameters.Add("@SapXep", SqlDbType.Int).SourceColumn = "SapXep";
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 4).SourceColumn = "Bak1";
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).SourceColumn = "Bak2";
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).SourceColumn = "Bak3";
objDataAccess.UpdateBatch(ref rowInsert, sqlCmd, dtTblMapping);
}
}示例13: UpdateBatch
public void UpdateBatch(ref DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "UpdateKhuVuc";
sqlCmd.Parameters.Add("@KhuVucID", SqlDbType.Int).SourceColumn = "KhuVucID";
sqlCmd.Parameters.Add("@TenKhuVuc", SqlDbType.NVarChar, 50).SourceColumn = "TenKhuVuc";
sqlCmd.Parameters.Add("@GhiChu", SqlDbType.NVarChar, 1000).SourceColumn = "GhiChu";
sqlCmd.Parameters.Add("@SapXep", SqlDbType.Int).SourceColumn = "SapXep";
sqlCmd.Parameters.Add("@HienThi", SqlDbType.Bit).SourceColumn = "HienThi";
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 50).SourceColumn = "Bak1";
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).SourceColumn = "Bak2";
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).SourceColumn = "Bak3";
objDataAccess.UpdateBatch(ref rowUpdate, sqlCmd, dtTblMapping);
}
}示例14: InsertBatch
public void InsertBatch(ref DataRow[] rowInsert)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "InsertKhuVuc_Ref";
sqlCmd.Parameters.Add("@KhuVucID", SqlDbType.Int).SourceColumn = "KhuVucID";
sqlCmd.Parameters["@KhuVucID"].Direction = ParameterDirection.Output;
sqlCmd.Parameters.Add("@TenKhuVuc", SqlDbType.NVarChar, 4).SourceColumn = "TenKhuVuc";
sqlCmd.Parameters.Add("@GhiChu", SqlDbType.NVarChar, 50).SourceColumn = "GhiChu";
sqlCmd.Parameters.Add("@SapXep", SqlDbType.Int).SourceColumn = "SapXep";
sqlCmd.Parameters.Add("@HienThi", SqlDbType.Bit).SourceColumn = "HienThi";
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 1).SourceColumn = "Bak1";
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).SourceColumn = "Bak2";
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).SourceColumn = "Bak3";
objDataAccess.UpdateBatch(ref rowInsert, sqlCmd, dtTblMapping);
}
}示例15: UpdateBatch
public void UpdateBatch(ref DataRow[] rowUpdate)
{
DataAccess objDataAccess = new DataAccess();
using (SqlCommand sqlCmd = new SqlCommand())
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "UpdateAnh";
sqlCmd.Parameters.Add("@AnhID", SqlDbType.Int).SourceColumn = "AnhID";
sqlCmd.Parameters.Add("@SanPhamID", SqlDbType.Int).SourceColumn = "SanPhamID";
sqlCmd.Parameters.Add("@DuongDan", SqlDbType.NVarChar, 100).SourceColumn = "DuongDan";
sqlCmd.Parameters.Add("@Bak1", SqlDbType.NVarChar, 50).SourceColumn = "Bak1";
sqlCmd.Parameters.Add("@Bak2", SqlDbType.NVarChar, 50).SourceColumn = "Bak2";
sqlCmd.Parameters.Add("@Bak3", SqlDbType.Int).SourceColumn = "Bak3";
sqlCmd.Parameters.Add("@SanPhamMauID", SqlDbType.Int).SourceColumn = "SanPhamMauID";
objDataAccess.UpdateBatch(ref rowUpdate, sqlCmd, dtTblMapping);
}
}