/// <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); }