/// <summary> /// 得到一个对象实体 /// </summary> public SHMetroTestSysModel.jc_LoginItem DataRowToModel(DataRow row) { SHMetroTestSysModel.jc_LoginItem model = new SHMetroTestSysModel.jc_LoginItem(); if (row != null) { if (row["ItemId"] != null && row["ItemId"].ToString() != "") { model.ItemId = int.Parse(row["ItemId"].ToString()); } if (row["ItemTitle"] != null) { model.ItemTitle = row["ItemTitle"].ToString(); } if (row["ItemName"] != null) { model.ItemName = row["ItemName"].ToString(); } if (row["Show"] != null && row["Show"].ToString() != "") { if ((row["Show"].ToString() == "1") || (row["Show"].ToString().ToLower() == "true")) { model.Show = true; } else { model.Show = false; } } if (row["ItemContent"] != null) { model.ItemContent = row["ItemContent"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public SHMetroTestSysModel.jc_LoginItem GetModel(int ItemId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ItemId,ItemTitle,ItemName,Show,ItemContent from jc_LoginItem "); strSql.Append(" where ItemId=@ItemId"); SqlParameter[] parameters = { new SqlParameter("@ItemId", SqlDbType.Int,4) }; parameters[0].Value = ItemId; SHMetroTestSysModel.jc_LoginItem model = new SHMetroTestSysModel.jc_LoginItem(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }