/// <summary>
/// 更新一条数据
/// </summary>
public int NewUpdate(systemsetEntity Entity)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@setid", Entity.setid),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@key", Entity.key),
new SqlParameter("@val", Entity.val),
new SqlParameter("@status", Entity.status),
new SqlParameter("@descr", Entity.descr),
new SqlParameter("@explain", Entity.explain)
};
return(DBHelper.ExecuteNonQuery("dbo.p_ts_sysset_Update", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int NewAdd(ref systemsetEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@setid", Entity.setid),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@key", Entity.key),
new SqlParameter("@val", Entity.val),
new SqlParameter("@status", Entity.status),
new SqlParameter("@descr", Entity.descr),
new SqlParameter("@explain", Entity.explain)
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_ts_sysset_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.setid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
