/// <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);
}
