/// <summary> /// 得到一个对象实体 /// </summary> public SHMetroTestSysModel.jc_Library GetModel(int LibraryNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 LibraryNo,SubjectNo,LibraryType,LibraryProperties,LibraryName,LibraryIntroduction,LibraryLayout,Radio,More,Bool,Fill,QA,Total,RadioInfo,MoreInfo,BoolInfo,FillInfo,QAInfo,LibraryScore,PassingGrade,TotalScore,TestTime,fixedNo,Reexam,StartDate,EndDate from jc_Library "); strSql.Append(" where LibraryNo=@LibraryNo"); SqlParameter[] parameters = { new SqlParameter("@LibraryNo", SqlDbType.Int,4) }; parameters[0].Value = LibraryNo; SHMetroTestSysModel.jc_Library model = new SHMetroTestSysModel.jc_Library(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
/// <summary> /// 得到一个对象实体 /// </summary> public SHMetroTestSysModel.jc_Library DataRowToModel(DataRow row) { SHMetroTestSysModel.jc_Library model = new SHMetroTestSysModel.jc_Library(); if (row != null) { if (row["LibraryNo"] != null && row["LibraryNo"].ToString() != "") { model.LibraryNo = int.Parse(row["LibraryNo"].ToString()); } if (row["SubjectNo"] != null) { model.SubjectNo = row["SubjectNo"].ToString(); } if (row["LibraryType"] != null) { model.LibraryType = row["LibraryType"].ToString(); } if (row["LibraryProperties"] != null) { model.LibraryProperties = row["LibraryProperties"].ToString(); } if (row["LibraryName"] != null) { model.LibraryName = row["LibraryName"].ToString(); } if (row["LibraryIntroduction"] != null) { model.LibraryIntroduction = row["LibraryIntroduction"].ToString(); } if (row["LibraryLayout"] != null) { model.LibraryLayout = row["LibraryLayout"].ToString(); } if (row["Radio"] != null && row["Radio"].ToString() != "") { model.Radio = int.Parse(row["Radio"].ToString()); } if (row["More"] != null && row["More"].ToString() != "") { model.More = int.Parse(row["More"].ToString()); } if (row["Bool"] != null && row["Bool"].ToString() != "") { model.Bool = int.Parse(row["Bool"].ToString()); } if (row["Fill"] != null && row["Fill"].ToString() != "") { model.Fill = int.Parse(row["Fill"].ToString()); } if (row["QA"] != null && row["QA"].ToString() != "") { model.QA = int.Parse(row["QA"].ToString()); } if (row["Total"] != null && row["Total"].ToString() != "") { model.Total = int.Parse(row["Total"].ToString()); } if (row["RadioInfo"] != null) { model.RadioInfo = row["RadioInfo"].ToString(); } if (row["MoreInfo"] != null) { model.MoreInfo = row["MoreInfo"].ToString(); } if (row["BoolInfo"] != null) { model.BoolInfo = row["BoolInfo"].ToString(); } if (row["FillInfo"] != null) { model.FillInfo = row["FillInfo"].ToString(); } if (row["QAInfo"] != null) { model.QAInfo = row["QAInfo"].ToString(); } if (row["LibraryScore"] != null) { model.LibraryScore = row["LibraryScore"].ToString(); } if (row["PassingGrade"] != null && row["PassingGrade"].ToString() != "") { model.PassingGrade = int.Parse(row["PassingGrade"].ToString()); } if (row["TotalScore"] != null && row["TotalScore"].ToString() != "") { model.TotalScore = int.Parse(row["TotalScore"].ToString()); } if (row["TestTime"] != null && row["TestTime"].ToString() != "") { model.TestTime = int.Parse(row["TestTime"].ToString()); } if (row["fixedNo"] != null) { model.fixedNo = row["fixedNo"].ToString(); } if (row["Reexam"] != null && row["Reexam"].ToString() != "") { if ((row["Reexam"].ToString() == "1") || (row["Reexam"].ToString().ToLower() == "true")) { model.Reexam = true; } else { model.Reexam = false; } } if (row["StartDate"] != null && row["StartDate"].ToString() != "") { model.StartDate = DateTime.Parse(row["StartDate"].ToString()); } if (row["EndDate"] != null && row["EndDate"].ToString() != "") { model.EndDate = DateTime.Parse(row["EndDate"].ToString()); } } return model; }