public static List <string> GetListSoHieuXe()
{
List <string> listSoHieuXe = new List <string>();
try
{
DataTable dt = new DataTable();
List <Xe> lstXe = new List <Xe>();
dt = new Data.DM.Xe().GetTatCaCacXe();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
listSoHieuXe.Add(StringTools.TrimSpace(dr["PK_SoHieuXe"].ToString()));
}
}
else
{
listSoHieuXe = null;
}
}
catch (Exception ex)
{
listSoHieuXe = null;
}
return(listSoHieuXe);
}
/// <summary>
/// kiem tra xem mot so hieu xe da co chua
/// </summary>
/// <param name="SoHieuXe"></param>
/// <returns></returns>
public static bool KiemTraTonTaiCuaSoHieuXe(string SoHieuXe)
{
DataTable dt = new DataTable();
dt = new Data.DM.Xe().GetChiTietMotXe(SoHieuXe);
if (dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
public List <Xe> GetListXes()
{
try
{
DataTable dt = new DataTable();
List <Xe> lstXe = new List <Xe>();
dt = new Data.DM.Xe().GetTatCaCacXe();
if (dt == null)
{
return(lstXe);
}
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Xe objXe = new Xe();
objXe.SoHieuXe = !dr.Table.Columns.Contains("PK_SoHieuXe") ? "" : dr["PK_SoHieuXe"].ToString();
objXe.BienKiemSoat = !dr.Table.Columns.Contains("BienKiemSoat") ? "" : dr["BienKiemSoat"].ToString();
objXe.SoMay = !dr.Table.Columns.Contains("SoMay") ? "" : dr["SoMay"].ToString();
objXe.SoKhung = !dr.Table.Columns.Contains("SoKhung") ? "" : dr["SoKhung"].ToString();
int loaiXeId = 0;
if (dr.Table.Columns.Contains("FK_LoaiXeID") && dr["FK_LoaiXeID"] != DBNull.Value && int.TryParse(dr["FK_LoaiXeID"].ToString(), out loaiXeId))
{
objXe.LoaiXeID = loaiXeId;
}
objXe.TenLoaiXe = !dr.Table.Columns.Contains("TenLoaiXe") ? "" : dr["TenLoaiXe"].ToString();
objXe.LoaiXe = objXe.TenLoaiXe;
int garaID = 0;
if (dr.Table.Columns.Contains("FK_GaraID") && dr["FK_GaraID"] != DBNull.Value && int.TryParse(dr["FK_GaraID"].ToString(), out garaID))
{
objXe.GaraID = garaID;
}
objXe.GaraName = !dr.Table.Columns.Contains("GaraName") ? "" : dr["GaraName"].ToString();
int soCho = 0;
if (dr.Table.Columns.Contains("SoCho") && dr["SoCho"] != DBNull.Value && int.TryParse(dr["SoCho"].ToString(), out soCho))
{
objXe.SoCho = soCho;
}
lstXe.Add(objXe);
}
return(lstXe);
}
else
{
return(null);
}
}
catch (Exception ex)
{
LogError.WriteLogError("GetListXes", ex);
return(null);
}
}
/// <summary>
/// Danh sách Mã loại xe ứng với Loại xe bên GPS
/// </summary>
/// <param name="NhomXe">4,7,0</param>
/// <returns>12,23,34,45</returns>
public string LayDanhSachLoaiXe_GPS(string NhomXe)
{
string strID = "";
DataTable dt = new Data.DM.Xe().LayDanhSachLoaiXe_GPS(NhomXe);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
strID = string.Format("{0}{1},", strID, row["LoaiXeID_GPS"]);
}
strID = strID.Substring(0, strID.Length - 1);
}
}
return(strID);
}
public Xe GetChiTietXe(string SoHieuXe)
{
try
{
DataTable dt = new DataTable();
dt = new Data.DM.Xe().GetChiTietMotXe(SoHieuXe);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
Xe objXe = new Xe();
objXe.SoHieuXe = dr["PK_SoHieuXe"] == DBNull.Value ? string.Empty : dr["PK_SoHieuXe"].ToString();
objXe.BienKiemSoat = dr["BienKiemSoat"] == DBNull.Value ? string.Empty : dr["BienKiemSoat"].ToString();
objXe.SoMay = dr["SoMay"] == DBNull.Value ? string.Empty : dr["SoMay"].ToString();
objXe.SoKhung = dr["SoKhung"] == DBNull.Value ? string.Empty : dr["SoKhung"].ToString();
objXe.LoaiXeID = dr["FK_LoaiXeID"] == DBNull.Value ? 0 : int.Parse(dr["FK_LoaiXeID"].ToString());
objXe.TenLoaiXe = dr["TenLoaiXe"].ToString();
objXe.GaraID = dr["FK_GaraID"] == DBNull.Value ? 0 : int.Parse(dr["FK_GaraID"].ToString());
objXe.GaraName = dr["GaraName"].ToString();
objXe.SoCho = dr["SoCho"] == DBNull.Value ? 4 : int.Parse(dr["SoCho"].ToString());
objXe.TenNhanVien = dr["TenNhanVien"] == DBNull.Value ? string.Empty : dr["TenNhanVien"].ToString();
objXe.DienThoai = dr["DienThoai"] == DBNull.Value ? string.Empty : dr["DienThoai"].ToString();
return(objXe);
}
else
{
return(null);
}
}
catch (Exception ex)
{
LogError.WriteLogError("GetChiTietXe", ex);
return(null);
}
}