public static List<XeMat> TimXeTheoCMND_List(string CMND)
{
using (DataSetOBJTableAdapters.SP_TimTheoCMNDTableAdapter Adap = new DataSetOBJTableAdapters.SP_TimTheoCMNDTableAdapter { Connection = new System.Data.SqlClient.SqlConnection(ConnectString) })
{
Adap.Fill(DataSet.SP_TimTheoCMND, CMND);
List<XeMat> ListResult = new List<XeMat>();
foreach (System.Data.DataRow i in DataSet.SP_TimTheoCMND)
{
XeMat OBJ = new XeMat();
OBJ.BienSoXe = i[0].ToString();
OBJ.SoMay = i[1].ToString();
OBJ.SoKhung = i[2].ToString();
OBJ.LoaiXe = i[3].ToString();
OBJ.MauXe = i[4].ToString();
OBJ.CMNDSoHuu = i[5].ToString();
OBJ.NoiDangKy = i[6].ToString();
OBJ.DaTimThay = (bool)i[7];
ListResult.Add(OBJ);
}
return ListResult;
}
}
public static System.Data.DataTable TimXeTheoCMND(string CMND)
{
using (DataSetOBJTableAdapters.SP_TimTheoCMNDTableAdapter Adap = new DataSetOBJTableAdapters.SP_TimTheoCMNDTableAdapter { Connection = new System.Data.SqlClient.SqlConnection(ConnectString) })
{
Adap.Fill(DataSet.SP_TimTheoCMND, CMND);
return DataSet.SP_TimTheoCMND;
}
}