/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.WeightDesignData model) { StringBuilder strBuilder = new StringBuilder(); strBuilder.Append("update T_WeightDesignData set "); strBuilder.Append("Id=" + model.Id + ","); strBuilder.Append("DesignData_Name='" + model.DesignData_Name + "',"); strBuilder.Append("DesignData_Submitter='" + model.DesignData_Submitter + "',"); strBuilder.Append("Helicopter_Name='" + model.Helicopter_Name + "',"); strBuilder.Append("DataRemark='" + model.DataRemark + "',"); strBuilder.Append("LastModify_Time='" + model.LastModify_Time + "',"); strBuilder.Append("DesignTaking_Weight=" + model.DesignTaking_Weight + ","); strBuilder.Append("MainSystem_Name='" + model.MainSystem_Name + "'"); strBuilder.Append(" where Id=" + model.Id.ToString()); int rows = SQLiteDBHelper.ExecuteNonQuery(strBuilder.ToString(), null); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.WeightDesignData model) { StringBuilder strBuilder = new StringBuilder(); strBuilder.Append("insert into T_WeightDesignData("); strBuilder.Append("Id,DesignData_Name,DesignData_Submitter,Helicopter_Name,DataRemark,LastModify_Time,DesignTaking_Weight,MainSystem_Name)"); strBuilder.Append(" values("); strBuilder.Append("" + model.Id + ","); strBuilder.Append("'" + model.DesignData_Name + "',"); strBuilder.Append("'" + model.DesignData_Submitter + "',"); strBuilder.Append("'" + model.Helicopter_Name + "',"); strBuilder.Append("'" + model.DataRemark + "',"); strBuilder.Append("'" + model.LastModify_Time + "',"); strBuilder.Append("" + model.DesignTaking_Weight + ","); strBuilder.Append("'" + model.MainSystem_Name + "'"); strBuilder.Append(")"); int rows = SQLiteDBHelper.ExecuteNonQuery(strBuilder.ToString(), null); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.TypeWeightData model) { StringBuilder strBuilder = new StringBuilder(); strBuilder.Append("update T_TypeWeightData set "); strBuilder.Append("Id=" + model.Id + ","); strBuilder.Append("Helicopter_Name='" + model.Helicopter_Name + "',"); strBuilder.Append("Last_ModifyTime='" + model.Last_ModifyTime + "',"); strBuilder.Append("Helicopter_Type='" + model.Helicopter_Type + "',"); strBuilder.Append("DesignTaking_Weight=" + model.DesignTaking_Weight + ","); strBuilder.Append("MaxTaking_Weight=" + model.MaxTaking_Weight + ","); strBuilder.Append("EmptyWeight=" + model.EmptyWeight + ","); strBuilder.Append("MainSystem_Name='" + model.MainSystem_Name + "',"); strBuilder.Append("Helicoter_Country='" + model.Helicoter_Country + "'"); strBuilder.Append(" where Id=" + model.Id.ToString()); int rows = SQLiteDBHelper.ExecuteNonQuery(strBuilder.ToString(), null); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.TypeWeightData model) { StringBuilder strBuilder = new StringBuilder(); strBuilder.Append("insert into T_TypeWeightData("); strBuilder.Append("Id,Helicopter_Name,Last_ModifyTime,Helicopter_Type,DesignTaking_Weight,MaxTaking_Weight,EmptyWeight,MainSystem_Name,Helicoter_Country)"); strBuilder.Append(" values ("); strBuilder.Append("" + model.Id + ","); strBuilder.Append("'" + model.Helicopter_Name + "',"); strBuilder.Append("'" + model.Last_ModifyTime + "',"); strBuilder.Append("'" + model.Helicopter_Type + "',"); strBuilder.Append("" + model.DesignTaking_Weight + ","); strBuilder.Append("" + model.MaxTaking_Weight + ","); strBuilder.Append("" + model.EmptyWeight + ","); strBuilder.Append("'" + model.MainSystem_Name + "',"); strBuilder.Append("'" + model.Helicoter_Country + "'"); strBuilder.Append(")"); int rows = SQLiteDBHelper.ExecuteNonQuery(strBuilder.ToString(), null); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 创建重心包线设计数据表 /// </summary> public void CreateTableCoreEnvelopeDesignData() { SQLiteDBHelper.CreateDB(strDataBasePath); StringBuilder strBuilder = new StringBuilder(); strBuilder.Append("Create table T_CoreEnvelopeDesignData("); strBuilder.Append("Id integer NOT NULL PRIMARY KEY,"); strBuilder.Append("DesignData_Name varchar(50),"); strBuilder.Append("DesignData_Submitter varchar(50),"); strBuilder.Append("Helicopter_Name varchar(50),"); strBuilder.Append("DataRemark text,"); strBuilder.Append("LastModify_Time varchar(50),"); strBuilder.Append("DesignTaking_Weight float,"); strBuilder.Append("CoreEnvelope text"); strBuilder.Append(")"); SQLiteDBHelper.ExecuteNonQuery(strBuilder.ToString(), null); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int Id) { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from T_WeightDesignData "); strSql.Append(" where Id=" + Id.ToString()); int rows = SQLiteDBHelper.ExecuteNonQuery(strSql.ToString(), null); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 创建型号重量数据表 /// </summary> public void CreateTableTypeWeightData() { SQLiteDBHelper.CreateDB(strDataBasePath); StringBuilder strBuilder = new StringBuilder(); strBuilder.Append("Create table T_TypeWeightData("); strBuilder.Append("Id integer NOT NULL PRIMARY KEY,"); strBuilder.Append("Helicopter_Name varchar(50),"); strBuilder.Append("Last_ModifyTime varchar(50),"); strBuilder.Append("Helicopter_Type varchar(50),"); strBuilder.Append("DesignTaking_Weight float,"); strBuilder.Append("MaxTaking_Weight float,"); strBuilder.Append("EmptyWeight float,"); strBuilder.Append("MainSystem_Name text,"); strBuilder.Append("Helicoter_Country varchar(50)"); strBuilder.Append(")"); SQLiteDBHelper.ExecuteNonQuery(strBuilder.ToString(), null); }