/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Model.DBVersion_Script model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DBVersion_Script(");
strSql.Append("script_version,script_title,script_desc,script_sql,script_extend,script_date");
strSql.Append(") values (");
strSql.Append("@script_version,@script_title,@script_desc,@script_sql,@script_extend,@script_date");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@script_version", SqlDbType.Int, 4),
new SqlParameter("@script_title", SqlDbType.NVarChar, 50),
new SqlParameter("@script_desc", SqlDbType.NVarChar, 250),
new SqlParameter("@script_sql", SqlDbType.NVarChar, -1),
new SqlParameter("@script_extend", SqlDbType.NVarChar, 250),
new SqlParameter("@script_date", SqlDbType.DateTime)
};
parameters[0].Value = model.script_version;
parameters[1].Value = model.script_title;
parameters[2].Value = model.script_desc;
parameters[3].Value = model.script_sql;
parameters[4].Value = model.script_extend;
parameters[5].Value = model.script_date;
DbHelperSQL.ExecuteSql(1, strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.DBVersion_Script model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update DBVersion_Script set ");
strSql.Append(" script_version = @script_version , ");
strSql.Append(" script_title = @script_title , ");
strSql.Append(" script_desc = @script_desc , ");
strSql.Append(" script_sql = @script_sql , ");
strSql.Append(" script_extend = @script_extend , ");
strSql.Append(" script_date = @script_date ");
strSql.Append(" where script_version=@script_version ");
SqlParameter[] parameters =
{
new SqlParameter("@script_version", SqlDbType.Int, 4),
new SqlParameter("@script_title", SqlDbType.NVarChar, 50),
new SqlParameter("@script_desc", SqlDbType.NVarChar, 250),
new SqlParameter("@script_sql", SqlDbType.NVarChar, -1),
new SqlParameter("@script_extend", SqlDbType.NVarChar, 250),
new SqlParameter("@script_date", SqlDbType.DateTime)
};
parameters[0].Value = model.script_version;
parameters[1].Value = model.script_title;
parameters[2].Value = model.script_desc;
parameters[3].Value = model.script_sql;
parameters[4].Value = model.script_extend;
parameters[5].Value = model.script_date;
int rows = DbHelperSQL.ExecuteSql(1, strSql.ToString(), parameters);
return(rows > 0 ? true : false);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.DBVersion_Script GetModel(int script_version)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select script_version, script_title, script_desc, script_sql, script_extend, script_date ");
strSql.Append(" from DBVersion_Script ");
strSql.Append(" where script_version=@script_version ");
SqlParameter[] parameters =
{
new SqlParameter("@script_version", SqlDbType.Int, 4)
};
parameters[0].Value = script_version;
Model.DBVersion_Script model = null;
DataTable dt = DbHelperSQL.Query(1, strSql.ToString(), parameters).Tables[0];
if (dt.Rows.Count > 0)
{
model = new Model.DBVersion_Script();
if (dt.Rows[0]["script_version"].ToString() != "")
{
model.script_version = int.Parse(dt.Rows[0]["script_version"].ToString());
}
model.script_title = dt.Rows[0]["script_title"].ToString();
model.script_desc = dt.Rows[0]["script_desc"].ToString();
model.script_sql = dt.Rows[0]["script_sql"].ToString();
model.script_extend = dt.Rows[0]["script_extend"].ToString();
if (dt.Rows[0]["script_date"].ToString() != "")
{
model.script_date = DateTime.Parse(dt.Rows[0]["script_date"].ToString());
}
}
return(model);
}
