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