/// <summary> /// 对象实体绑定数据 /// </summary> public UserPermission.Model.USER_SHARE_ACCOUNT ReaderBind(IDataReader dataReader) { UserPermission.Model.USER_SHARE_ACCOUNT model = new UserPermission.Model.USER_SHARE_ACCOUNT(); object ojb; ojb = dataReader["ACCOUNTID"]; if (ojb != null && ojb != DBNull.Value) { model.ACCOUNTID = (decimal)ojb; } model.ACCOUNTNAME = dataReader["ACCOUNTNAME"].ToString(); ojb = dataReader["COMPANYID"]; if (ojb != null && ojb != DBNull.Value) { model.COMPANYID = (decimal)ojb; } model.ACCOUNTPWD = dataReader["ACCOUNTPWD"].ToString(); model.ORIGNALPWD = dataReader["ORIGNALPWD"].ToString(); model.REALNAME = dataReader["REALNAME"].ToString(); model.EMAIL = dataReader["EMAIL"].ToString(); model.ROLEIDS = dataReader["ROLEIDS"].ToString(); model.LINKPHONE = dataReader["LINKPHONE"].ToString(); ojb = dataReader["CREATEDATE"]; if (ojb != null && ojb != DBNull.Value) { model.CREATEDATE = (DateTime)ojb; } ojb = dataReader["CREATORID"]; if (ojb != null && ojb != DBNull.Value) { model.CREATORID = (decimal)ojb; } ojb = dataReader["ISADMIN"]; if (ojb != null && ojb != DBNull.Value) { model.ISADMIN = (decimal)ojb; } ojb = dataReader["STATUS"]; if (ojb != null && ojb != DBNull.Value) { model.STATUS = (decimal)ojb; } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public UserPermission.Model.USER_SHARE_ACCOUNT GetModel(decimal ACCOUNTID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ACCOUNTID,ACCOUNTNAME,COMPANYID,ACCOUNTPWD,ORIGNALPWD,REALNAME,EMAIL,ROLEIDS,LINKPHONE,CREATEDATE,CREATORID,ISADMIN,STATUS from USER_SHARE_ACCOUNT "); strSql.Append(" where ACCOUNTID=@ACCOUNTID "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "ACCOUNTID", DbType.String, ACCOUNTID); UserPermission.Model.USER_SHARE_ACCOUNT model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }