/// <summary>
/// ��ӽ�
/// </summary>
/// <param name="mSection">����ӵĽڵ�Id</param>
/// <returns>����Ƿ�ɹ�,�ɹ���true,ʧ����false</returns>
public bool AddSection(SectionInfo mSection)
{
SqlParameter[] parms = {
new SqlParameter("@sectionNO",Int32.Parse(mSection.StrSectionNO)),
new SqlParameter("@descriptions",mSection.StrDescription),
new SqlParameter("@chapterId",mSection.IChapterId)
};
bool isSuccess = false;
int affectedRows = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringQuesBase,
CommandType.StoredProcedure, "SP_AddSection", parms);
if (affectedRows > 0)
{
isSuccess = true;
}
return isSuccess;
}
/// <summary>
/// ��ӽ�
/// </summary>
/// <param name="mSection">����ӵĽڵ�Id</param>
/// <returns>����Ƿ�ɹ�,�ɹ���true,ʧ����false</returns>
public bool AddSection(SectionInfo mSection)
{
return dal.AddSection(mSection);
}
/// <summary>
/// �Ľ�
/// </summary>
/// <param name="mSection">���ĵĽڶ�������Ӧ�����ڵ�Id�ͽڵ�������</param>
/// <returns>���Ƿ�ɹ����ɹ���true,ʧ����false</returns>
public bool EditSection(SectionInfo mSection)
{
SqlParameter[] parms = {
new SqlParameter("@sectionId",mSection.ISectionId),
new SqlParameter("@name",mSection.StrDescription)
};
bool isSuccess = false;
int affectedRows = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionStringQuesBase,
CommandType.StoredProcedure, "SP_EditSectionByID", parms);
if (affectedRows > 0)
{
isSuccess = true;
}
return isSuccess;
}
/// <summary>
/// �Ľ�
/// </summary>
/// <param name="mSection">���ĵĽڶ�������Ӧ�����ڵ�Id�ͽڵ�������</param>
/// <returns>���Ƿ�ɹ����ɹ���true,ʧ����false</returns>
public bool EditSection(SectionInfo mSection)
{
return dal.EditSection(mSection);
}