/// <summary>
/// 增加一条数据,及其子表数据
/// </summary>
public bool Add(ResolveResXml.Model.res_project model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into res_project(");
strSql.Append("id,project_Name,project_CountryCode)");
strSql.Append(" values (");
strSql.Append("@id,@project_Name,@project_CountryCode)");
SQLiteParameter[] parameters = {
new SQLiteParameter("@id", DbType.Int32,8),
new SQLiteParameter("@project_Name", DbType.String),
new SQLiteParameter("@project_CountryCode", DbType.String)};
parameters[0].Value = model.id;
parameters[1].Value = model.project_Name;
parameters[2].Value = model.project_CountryCode;
List<CommandInfo> sqllist = new List<CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
StringBuilder strSql2;
foreach (ResolveResXml.Model.res_XML models in model.res_XMLs)
{
strSql2=new StringBuilder();
strSql2.Append("insert into res_XML(");
strSql2.Append("id,key,value,projectId)");
strSql2.Append(" values (");
strSql2.Append("@id,@key,@value,@projectId)");
SQLiteParameter[] parameters2 = {
new SQLiteParameter("@id", DbType.Int32,8),
new SQLiteParameter("@key", DbType.String),
new SQLiteParameter("@value", DbType.String),
new SQLiteParameter("@projectId", DbType.Int32,4)};
parameters2[0].Value = models.id;
parameters2[1].Value = models.key;
parameters2[2].Value = models.value;
parameters2[3].Value = models.projectId;
cmd = new CommandInfo(strSql2.ToString(), parameters2);
sqllist.Add(cmd);
}
int result= DbHelperSQLite.ExecuteSqlTran(sqllist);
if (result > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ResolveResXml.Model.res_XML model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ResolveResXml.Model.res_XML model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ResolveResXml.Model.res_project model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update res_project set ");
strSql.Append("project_Name=@project_Name,");
strSql.Append("project_CountryCode=@project_CountryCode");
strSql.Append(" where id=@id ");
SQLiteParameter[] parameters = {
new SQLiteParameter("@id", DbType.Int32,8),
new SQLiteParameter("@project_Name", DbType.String),
new SQLiteParameter("@project_CountryCode", DbType.String)};
parameters[0].Value = model.id;
parameters[1].Value = model.project_Name;
parameters[2].Value = model.project_CountryCode;
int rowsAffected=DbHelperSQLite.ExecuteSql(strSql.ToString(),parameters);
if (rowsAffected > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ResolveResXml.Model.res_project model)
{
return dal.Add(model);
}
