示例#1
0
 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;
     }
 }
示例#2
0
 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;
     }
 }