using JiangSu.Models;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Data.SQLite;
|
using System.Linq;
|
using System.Web;
|
|
namespace JiangSu.cs
|
{
|
public class ModelDAL
|
{
|
public static Model SelectById(int id)
|
{
|
string sql = "select * from model where id = @id";
|
|
SQLiteParameter param = new SQLiteParameter("@id");
|
param.Value = id;
|
|
DataTable dt = SQLiteHelper.GetDataTable(sql, param);
|
if (null == dt || dt.Rows.Count == 0)
|
{
|
return null;
|
}
|
|
List<Model> list = ModelHandler.FillModel<Model>(dt);
|
|
return null == list || list.Count == 0 ? null : list[0];
|
}
|
}
|
}
|
