private ServiceModel GetServiceModel(DataTable table)
{
ServiceModel setmodel = new ServiceModel();
if (table == null || table.Rows.Count == 0) return null;
setmodel.ServiceID = Int32.Parse(table.Rows[0]["Id"].ToString());
setmodel.ServiceSale = table.Rows[0]["SZservice"].ToString();
setmodel.ServiceContent = table.Rows[0]["Content"].ToString();
setmodel.ServiceAfterSale = table.Rows[0]["SHservice"].ToString();
setmodel.SetUpdateTime = ((DateTime)table.Rows[0]["Update_Time"]).ToString("yyyy/MM/dd HH:mm:ss.fff ");
return setmodel;
}
private DbParameter[] ExecutionSelectSet(ServiceModel DataPar)
{
DbParameter[] sqliteparList = new DbParameter[5];
sqliteparList[0] = Db_Sqlite.CreateDbParameter("@UpdateTime", DataPar.SetUpdateTime);
sqliteparList[1] = Db_Sqlite.CreateDbParameter("@Id", DataPar.ServiceID);
sqliteparList[2] = Db_Sqlite.CreateDbParameter("@Sale", DataPar.ServiceSale);
sqliteparList[3] = Db_Sqlite.CreateDbParameter("@AfterSale", DataPar.ServiceAfterSale);
sqliteparList[4] = Db_Sqlite.CreateDbParameter("@Content", DataPar.ServiceContent);
return sqliteparList;
}