public cColumnInfo add(cColumnInfo c, String key) { try { if (c == null) { c = new cColumnInfo(); } if (key == "") { key = cReportGlobals.getKey(cReportGlobals.getNextKey().ToString()); } else { cReportGlobals.refreshNextKey(key); key = cReportGlobals.getKey(key); } c.setPosition(count()); c.setKey(key); Add(key, c); return(c); } catch { return(null); } }
private bool fillColumns(string sqlstmt) { var db = new cDataBase(csDatabaseEngine.SQL_SERVER); if (db.initDb(m_strConnect)) { DbDataReader rs; if (db.openRs(sqlstmt, out rs, "fillColumns", "cConnect", "Update columns's definition", CSKernelClient.eErrorLevel.eErrorInformation)) { for (int i = 0; i < rs.FieldCount; i++) { var column = new cColumnInfo(); column.setName(rs.GetName(i)); column.setPosition(i); column.setColumnType((csDataType)System.Type.GetTypeCode((rs.GetFieldType(i)))); m_columnsInfo.add(column, ""); } } else { return(false); } } return(true); }
public static void setParametersAux(cConnect connect, cReportConnect rptConnect) { rptConnect.getColumns().clear(); rptConnect.getParameters().clear(); for (int i = 0; i < connect.getColumnsInfo().count(); i++) { CSConnect.cColumnInfo colInfo = connect.getColumnsInfo().item(i); CSReportDll.cColumnInfo rptColInfo = new CSReportDll.cColumnInfo(); rptColInfo.setName(colInfo.getName()); rptColInfo.setPosition(colInfo.getPosition()); rptColInfo.setColumnType(colInfo.getColumnType()); rptConnect.getColumns().add(rptColInfo, ""); } for (int i = 0; i < connect.getParameters().count(); i++) { CSConnect.cParameter parameter = connect.getParameters().item(i); CSReportDll.cParameter rptParameter = new CSReportDll.cParameter(); rptParameter.setName(parameter.getName()); rptParameter.setPosition(parameter.getPosition()); rptParameter.setColumnType(parameter.getColumnType()); rptParameter.setValue(parameter.getValue()); rptConnect.getParameters().add(rptParameter, ""); } }
private bool fillColumns(string sqlstmt) { var db = new cDataBase(csDatabaseEngine.SQL_SERVER); if (db.initDb(m_strConnect)) { DbDataReader rs; if (db.openRs(sqlstmt, out rs, "fillColumns", "cConnect", "Update columns's definition", CSKernelClient.eErrorLevel.eErrorInformation)) { for (int i = 0; i < rs.FieldCount; i++) { var column = new cColumnInfo(); column.setName(rs.GetName(i)); column.setPosition(i); column.setColumnType((csDataType)System.Type.GetTypeCode((rs.GetFieldType(i)))); m_columnsInfo.add(column, ""); } } else { return false; } } return true; }
public cColumnInfo add(cColumnInfo c, String key) { try { if (c == null) { c = new cColumnInfo(); } if (key == "") { key = cReportGlobals.getKey(cReportGlobals.getNextKey().ToString()); } else { cReportGlobals.refreshNextKey(key); key = cReportGlobals.getKey(key); } c.setPosition(count()); c.setKey(key); Add(key, c); return c; } catch { return null; } }