public static int AddBaoYangYearCard(SqlConnection conn, YearCardParameter yearCard)
{
var sql = @"INSERT INTO BaoYang..BaoYangYearCard
( PID ,
DisplayName ,
Category ,
ImageUrl ,
CreateTime ,
UpdateTime
)
VALUES ( @PID , -- PID - nvarchar(513)
@DisplayName , -- DisplayName - nvarchar(100)
@Category , -- Category - nvarchar(20)
@ImageUrl , -- ImageUrl - nvarchar(200)
GETDATE() , -- CreateTime - datetime
GETDATE() -- UpdateTime - datetime
)
SELECT SCOPE_IDENTITY()";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@PID", yearCard.Pid),
new SqlParameter("@DisplayName", yearCard.DisplayName),
new SqlParameter("@Category", yearCard.CategoryName),
new SqlParameter("@ImageUrl", yearCard.ImageUrl)
};
var data = SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters);
return(data != null?Convert.ToInt32(data) : 0);
}
public static bool UpdateBaoYangYearCardInfo(SqlConnection conn, YearCardParameter yearCard)
{
var sql = @"UPDATE BaoYang..BaoYangYearCard
SET PID = @PID,
DisplayName = @DisplayName,
Category = @Category,
ImageUrl = @ImageUrl,
UpdateTime = GETDATE()
WHERE PKID = @YearCardId";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@YearCardId", yearCard.Pkid),
new SqlParameter("@PID", yearCard.Pid),
new SqlParameter("@DisplayName", yearCard.DisplayName),
new SqlParameter("@Category", yearCard.CategoryName),
new SqlParameter("@ImageUrl", yearCard.ImageUrl)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters) > 0);
}
