/// <summary>
/// get ds nhung cuoc chua nhạp thông tin trả
/// </summary>
public DataTable GetDSNhungCuocChuaNhapDuThongTin()
{
Data.BanGiaGoc.NhatkyThuebao objNKTB = new Data.BanGiaGoc.NhatkyThuebao();
DataTable dt = objNKTB.GetDSNhungCuocChuaNhapDuThongTin();
return(dt);
}
public DataTable GetAll()
{
Data.BanGiaGoc.NhatkyThuebao NhatkyThuebaoControl = new Data.BanGiaGoc.NhatkyThuebao();
DataTable dt = NhatkyThuebaoControl.GetAll();
return(dt);
}
public static NhatkyThuebao Selectone(int ID)
{
try
{
Data.BanGiaGoc.NhatkyThuebao NhatkyThuebaoControl = new Data.BanGiaGoc.NhatkyThuebao();
DataTable dt = NhatkyThuebaoControl.GetOne(ID);
NhatkyThuebao objNhatkyThuebao = new NhatkyThuebao();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
objNhatkyThuebao.SoHieuXe = dt.Rows[0]["SoHieuXe"].ToString();
objNhatkyThuebao.ThoiDiem = Convert.ToDateTime(dt.Rows[0]["ThoiDiem"]);
objNhatkyThuebao.TenLaiXe = dt.Rows[0]["TenLaiXe"].ToString();
objNhatkyThuebao.TenTuyenDuong = dt.Rows[0]["TenTuyenDuong"].ToString();
objNhatkyThuebao.TuyenDuongID = dt.Rows[0]["TuyenDuongID"].ToString();
objNhatkyThuebao.TienThucThu = Convert.ToDouble(dt.Rows[0]["TienThucThu"]);
objNhatkyThuebao.ThoiGianTra = Convert.ToDateTime(dt.Rows[0]["ThoiGianTra"]);
objNhatkyThuebao.ThoiGianDon = Convert.ToDateTime(dt.Rows[0]["ThoiGianDon"]);
objNhatkyThuebao.KmTra = Convert.ToInt32(dt.Rows[0]["KmTra"]);
objNhatkyThuebao.KmDon = Convert.ToInt32(dt.Rows[0]["KmDon"]);
objNhatkyThuebao.KmThucDi = Convert.ToInt32(dt.Rows[0]["KmThucDi"]);
objNhatkyThuebao.PhuTroi = dt.Rows[0]["PhuTroi"].ToString();
objNhatkyThuebao.MaNhanVienNhap = dt.Rows[0]["MaNhanVienNhap"].ToString();
objNhatkyThuebao.GhiChu = dt.Rows[0]["GhiChu"].ToString();
objNhatkyThuebao.ID = Convert.ToInt32(dt.Rows[0]["ID"]);
objNhatkyThuebao.DongHoTien = Convert.ToInt32(dt.Rows[0]["DongHoTien"]);
objNhatkyThuebao.GiaThueBao = dt.Rows[0]["GiaThueBao"].ToString();
objNhatkyThuebao.IsQuanToan = Convert.ToBoolean(dt.Rows[0]["IsQuanToan"].ToString());
objNhatkyThuebao.LoaiXeID = Convert.ToInt32(dt.Rows[0]["LoaiXeID"]);
objNhatkyThuebao.Chieu = Convert.ToInt32(dt.Rows[0]["Chieu"]);
objNhatkyThuebao.SoDienThoai = dt.Rows[0]["SoDienThoai"].ToString();
objNhatkyThuebao.CSKH_GhiChu = dt.Rows[0]["CSKH_GhiChu"] == DBNull.Value ? "" : dt.Rows[0]["CSKH_GhiChu"].ToString();
objNhatkyThuebao.CSKH_IsDaGoi = dt.Rows[0]["CSKH_IsDaGoi"] != DBNull.Value && Convert.ToBoolean(dt.Rows[0]["CSKH_IsDaGoi"].ToString());
objNhatkyThuebao.CSKH_TrangThaiGoi = dt.Rows[0]["CSKH_TrangThaiGoi"] == DBNull.Value ? (byte)0 : Convert.ToByte(dt.Rows[0]["CSKH_TrangThaiGoi"].ToString());
objNhatkyThuebao.CSKH_KetThuc = dt.Rows[0]["CSKH_KetThuc"] != DBNull.Value && Convert.ToBoolean(dt.Rows[0]["CSKH_KetThuc"].ToString());
//Join với bảng tuyến đường!
objNhatkyThuebao.KieuTuyenDuong = dt.Columns.Contains("KieuTuyenDuong") ? (dt.Rows[0]["KieuTuyenDuong"] == DBNull.Value ? 0 : Convert.ToInt32(dt.Rows[0]["KieuTuyenDuong"])) : 0;
return(objNhatkyThuebao);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
catch (Exception ex)
{
LogError.WriteLogError("Selectone: ", ex);
return(null);
}
}
public int Delete(int ID)
{
Data.BanGiaGoc.NhatkyThuebao NhatkyThuebaoControl = new Data.BanGiaGoc.NhatkyThuebao();
return(NhatkyThuebaoControl.Delete(ID));
}
public int Update(NhatkyThuebao NhatkyThuebaoobj)
{
Data.BanGiaGoc.NhatkyThuebao NhatkyThuebaoControl = new Data.BanGiaGoc.NhatkyThuebao();
return(NhatkyThuebaoControl.Update(NhatkyThuebaoobj.TuyenDuongID, NhatkyThuebaoobj.TenTuyenDuong, NhatkyThuebaoobj.Chieu, NhatkyThuebaoobj.ThoiGianDon, NhatkyThuebaoobj.KmDon, NhatkyThuebaoobj.ThoiGianTra, NhatkyThuebaoobj.KmTra, NhatkyThuebaoobj.KmThucDi, NhatkyThuebaoobj.DongHoTien, NhatkyThuebaoobj.PhuTroi, NhatkyThuebaoobj.TienThucThu, NhatkyThuebaoobj.GhiChu, NhatkyThuebaoobj.ID, NhatkyThuebaoobj.LoaiXeID, NhatkyThuebaoobj.GiaThueBao, NhatkyThuebaoobj.MaNhanVienNhap, NhatkyThuebaoobj.SoDienThoai));
}
public int Insert(NhatkyThuebao pNhatkyThuebao)
{
Data.BanGiaGoc.NhatkyThuebao NhatkyThuebaoControl = new Data.BanGiaGoc.NhatkyThuebao();
return(NhatkyThuebaoControl.Insert(pNhatkyThuebao.ThoiDiem, pNhatkyThuebao.SoHieuXe, pNhatkyThuebao.TenLaiXe, pNhatkyThuebao.TuyenDuongID, pNhatkyThuebao.TenTuyenDuong, pNhatkyThuebao.Chieu, pNhatkyThuebao.ThoiGianDon, pNhatkyThuebao.KmDon, pNhatkyThuebao.ThoiGianTra, pNhatkyThuebao.KmTra, pNhatkyThuebao.KmThucDi, pNhatkyThuebao.DongHoTien, pNhatkyThuebao.PhuTroi, pNhatkyThuebao.TienThucThu, pNhatkyThuebao.MaNhanVienNhap, pNhatkyThuebao.GhiChu, pNhatkyThuebao.LoaiXeID, pNhatkyThuebao.GiaThueBao, pNhatkyThuebao.IsQuanToan, pNhatkyThuebao.SoDienThoai));
}
