/// <summary> /// 得到一个对象实体 /// </summary> public ModTS_USER GetModel(string C_ACCOUNT) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_NAME,C_ACCOUNT,C_PASSWORD,C_EMAIL,C_MOBILE,N_STATUS,N_TYPE,C_DESC,D_LASTLOGINTIME,C_EMP_ID,C_EMP_NAME,D_MOD_DT,C_MOBILE2,C_PHONE,C_SHORTNAME from TS_USER "); strSql.Append(" where N_TYPE=3 and C_ACCOUNT=:C_ACCOUNT "); OracleParameter[] parameters = { new OracleParameter(":C_ACCOUNT", OracleDbType.Varchar2, 50) }; parameters[0].Value = C_ACCOUNT; ModTS_USER model = new ModTS_USER(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ModTS_ROLE_PCI GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_ROLE_NAME,N_STATUS,C_REMARK,C_EMP_ID,D_MOD_DT from TS_ROLE_PCI "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 50) }; parameters[0].Value = C_ID; ModTS_ROLE_PCI model = new ModTS_ROLE_PCI(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }