/// <summary>
///更新记录
/// </summary>
/// <param name="Courseware"></param>
/// <returns></returns>
public bool GetUpdate(M_Courseware courseware)
{
string sqlStr = "UPDATE [dbo].[ZL_Courseware] SET [Courseware] = @Courseware,[CoursNum] = @CoursNum,[Listen] = @Listen,[UpdateTime] = @UpdateTime,[FileUrl] = @FileUrl,[CourseID] = @CourseID,[Speaker]=@Speaker,[SJName]=@SJName,[Status]=@Status,[Description]=@Description,[Classification]=@Classification,[CoursType]=@CoursType,[CreationTime]=@CreationTime WHERE [ID] = @ID";
SqlParameter[] cmdParams = courseware.GetParameters();
return(SqlHelper.ExecuteSql(sqlStr, cmdParams));
}
/// <summary>
///添加记录
/// </summary>
/// <param name="Courseware"></param>
/// <returns></returns>
public int GetInsert(M_Courseware courseware)
{
string sqlStr = "INSERT INTO [dbo].[ZL_Courseware] ([Courseware],[CoursNum],[Listen],[UpdateTime],[FileUrl],[CourseID],[Speaker],[SJName],[Status],[Description],[Classification],[CoursType],[CreationTime]) VALUES (@Courseware,@CoursNum,@Listen,@UpdateTime,@FileUrl,@CourseID,@Speaker,@SJName,@Status,@Description,@Classification,@CoursType,@CreationTime);select @@IDENTITY";
SqlParameter[] cmdParams = courseware.GetParameters();
return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams)));
}