本文整理汇总了C#中Section.GetSectionByAssessmentOID方法的典型用法代码示例。如果您正苦于以下问题:C# Section.GetSectionByAssessmentOID方法的具体用法?C# Section.GetSectionByAssessmentOID怎么用?C# Section.GetSectionByAssessmentOID使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Section
的用法示例。
在下文中一共展示了Section.GetSectionByAssessmentOID方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetAssessmentByOID_QuestionSheet
public Assessment GetAssessmentByOID_QuestionSheet(int OID)
{
//Assessment ass = null;
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcCommand command = new OdbcCommand())
{
command.Connection = connection;
command.CommandText = "{CALL Assessment_BYOID(?)}";
command.CommandType = CommandType.StoredProcedure;
//Parameter Setting
command.Parameters.AddWithValue("@AOID", OID);
connection.Open();
using (OdbcDataReader dataReader = command.ExecuteReader())
{
Section sect = new Section();
if (dataReader.Read())
{
//this = new Assessment();
this.AssessmentName = Convert.ToString(dataReader["AssessmentName"]);
this.AssessmentOID = Convert.ToInt32(dataReader["AssessmentOID"]);
this.CreatedBy = Convert.ToInt32(dataReader["CreatedBy"]);
this.CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]);
this.LastModifiedBy = Convert.ToInt32(dataReader["LastModifiedBy"]);
this.LastModifiedDate = Convert.ToDateTime(dataReader["LastModifiedDate"]);
this.RefMenuID = Convert.ToInt32(dataReader["RefMenuID"]);
this.TotalFlag = Convert.ToInt32(dataReader["TotalFlag"]);
this.TotalFlagPoint = Convert.ToInt32(dataReader["TotalFlagPoint"]);
this.TotalQuestion = Convert.ToInt32(dataReader["TotalQuestion"]);
this.TotalSection = Convert.ToInt32(dataReader["TotalSection"]);
this.SectionList = sect.GetSectionByAssessmentOID(this.AssessmentOID);
}
}
}
}
return this;
}