/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.WeightDesignData GetModel(int Id)
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,DesignData_Name,DesignData_Submitter,Helicopter_Name,DataRemark,LastModify_Time,DesignTaking_Weight,MainSystem_Name from T_WeightDesignData ");
strSql.Append(" where Id=" + Id.ToString());
Model.WeightDesignData model = new Model.WeightDesignData();
DataTable table = SQLiteDBHelper.ExecuteDataTable(strSql.ToString(), null);
if (table.Rows.Count > 0)
{
return(DataRowToModel(table.Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 获取所有实体
/// </summary>
/// <returns></returns>
public List <Model.TypeWeightData> GetListModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,Helicopter_Name,Last_ModifyTime,Helicopter_Type,DesignTaking_Weight,MaxTaking_Weight,EmptyWeight,MainSystem_Name,Helicoter_Country from T_TypeWeightData ");
List <Model.TypeWeightData> lstWeightData = new List <Model.TypeWeightData>();
DataTable table = SQLiteDBHelper.ExecuteDataTable(strSql.ToString(), null);
if (table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
Model.TypeWeightData model = DataRowToModel(table.Rows[i]);
lstWeightData.Add(model);
}
}
return(lstWeightData);
}
/// <summary>
/// 获取所有对象实体
/// </summary>
public List <Model.CoreEnvelopeDesign> GetListModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,DesignData_Name,DesignData_Submitter,Helicopter_Name,DataRemark,LastModify_Time,DesignTaking_Weight,CoreEnvelope from T_CoreEnvelopeDesignData ");
List <Model.CoreEnvelopeDesign> lstModel = new List <Model.CoreEnvelopeDesign>();
DataTable table = SQLiteDBHelper.ExecuteDataTable(strSql.ToString(), null);
if (table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
Model.CoreEnvelopeDesign model = DataRowToModel(table.Rows[i]);
lstModel.Add(model);
}
}
return(lstModel);
}
