/// <summary> /// 得到一个对象实体 /// </summary> public Model.SYS_PageConfig GetModel(int PC_Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select PC_Id,PC_Name,PC_Memo,PC_HrefUrl,PC_HaveChild,PC_ParentId,PC_State from SYS_PageConfig "); strSql.Append(" where PC_Id=@PC_Id "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "PC_Id", DbType.Int32, PC_Id); Model.SYS_PageConfig model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.SYS_PageConfig DataRowToModel(DataRow row) { Model.SYS_PageConfig model = new Model.SYS_PageConfig(); if (row != null) { if (row["PC_Id"] != null && row["PC_Id"].ToString() != "") { model.PC_Id = int.Parse(row["PC_Id"].ToString()); } if (row["PC_Name"] != null) { model.PC_Name = row["PC_Name"].ToString(); } if (row["PC_Memo"] != null) { model.PC_Memo = row["PC_Memo"].ToString(); } if (row["PC_HrefUrl"] != null) { model.PC_HrefUrl = row["PC_HrefUrl"].ToString(); } if (row["PC_HaveChild"] != null && row["PC_HaveChild"].ToString() != "") { model.PC_HaveChild = int.Parse(row["PC_HaveChild"].ToString()); } if (row["PC_ParentId"] != null && row["PC_ParentId"].ToString() != "") { model.PC_ParentId = int.Parse(row["PC_ParentId"].ToString()); } if (row["PC_State"] != null && row["PC_State"].ToString() != "") { model.PC_State = int.Parse(row["PC_State"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.SYS_PageConfig DataRowToModel(DataRow row) { Model.SYS_PageConfig model = new Model.SYS_PageConfig(); if (row != null) { if (row["PC_Id"] != null && row["PC_Id"].ToString() != "") { model.PC_Id = int.Parse(row["PC_Id"].ToString()); } if (row["PC_Name"] != null) { model.PC_Name = row["PC_Name"].ToString(); } if (row["PC_Memo"] != null) { model.PC_Memo = row["PC_Memo"].ToString(); } if (row["PC_HrefUrl"] != null) { model.PC_HrefUrl = row["PC_HrefUrl"].ToString(); } if (row["PC_HaveChild"] != null && row["PC_HaveChild"].ToString() != "") { model.PC_HaveChild = int.Parse(row["PC_HaveChild"].ToString()); } if (row["PC_ParentId"] != null && row["PC_ParentId"].ToString() != "") { model.PC_ParentId = int.Parse(row["PC_ParentId"].ToString()); } if (row["PC_State"] != null && row["PC_State"].ToString() != "") { model.PC_State = int.Parse(row["PC_State"].ToString()); } } return model; }
/// <summary> /// 对象实体绑定数据 /// </summary> public Model.SYS_PageConfig ReaderBind(IDataReader dataReader) { Model.SYS_PageConfig model = new Model.SYS_PageConfig(); object ojb; ojb = dataReader["PC_Id"]; if (ojb != null && ojb != DBNull.Value) { model.PC_Id = (int)ojb; } model.PC_Name = dataReader["PC_Name"].ToString(); model.PC_Memo = dataReader["PC_Memo"].ToString(); model.PC_HrefUrl = dataReader["PC_HrefUrl"].ToString(); ojb = dataReader["PC_HaveChild"]; if (ojb != null && ojb != DBNull.Value) { model.PC_HaveChild = (int)ojb; } ojb = dataReader["PC_ParentId"]; if (ojb != null && ojb != DBNull.Value) { model.PC_ParentId = (int)ojb; } ojb = dataReader["PC_State"]; if (ojb != null && ojb != DBNull.Value) { model.PC_State = (int)ojb; } return model; }