public static List <MaintainInfoModel> SelectMaintainInfo()
{
List <MaintainInfoModel> maintainInfoModelList = new List <MaintainInfoModel>();
using (SQLiteConnection conn = new SQLiteConnection(connStr))
{
try
{
conn.Open();
string sql = "SELECT * FROM MaintainInfo";
SQLiteDataAdapter ap = new SQLiteDataAdapter(sql, conn);
DataSet ds = new DataSet();
ap.Fill(ds);
ap.Dispose();
DataTable dt = ds.Tables[0];
foreach (DataRow item in dt.Rows)
{
MaintainInfoModel maintainInfoModel = new MaintainInfoModel();
maintainInfoModel.id = Convert.ToInt32(item["id"]);
maintainInfoModel.Name = (string)item["Name"];
maintainInfoModel.AlramId = (string)item["AlramId"];
maintainInfoModel.Info = (string)item["Info"];
maintainInfoModel.CreateDate = (string)item["CreateDate"];
maintainInfoModel.CreateTime = (string)item["CreateTime"];
maintainInfoModelList.Add(maintainInfoModel);
}
}
catch (Exception ex)
{
LogUtil.LogError(ex);
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(maintainInfoModelList);
}
public static void InsertMaintainInfo(MaintainInfoModel maintainInfoModel)
{
using (SQLiteConnection conn = new SQLiteConnection(connStr))
{
try
{
conn.Open();
string sql = "SELECT * FROM MaintainInfo";
SQLiteDataAdapter ap = new SQLiteDataAdapter(sql, conn);
DataSet ds = new DataSet();
ap.Fill(ds);
ap.Dispose();
DataTable dt = ds.Tables[0];
DataRow dataRow = dt.NewRow();
dt.Rows.Add(dataRow);
sql = "INSERT INTO MaintainInfo(Name,AlramId,Info,CreateDate,CreateTime) " +
"VALUES(@Name,@AlramId,@Info,@CreateDate,@CreateTime)";
object[] paramList = maintainInfoModel.GetObjectList();
SQLiteHelper.ExecuteNonQuery(conn, sql, paramList);
}
catch (Exception ex)
{
LogUtil.LogError(ex);
}
finally
{
conn.Close();
conn.Dispose();
}
}
}