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 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)); }