//拼接数据集sql,并记录数据集 private void ConcatSQLByDataSet(UIControls ui) { DataSetTableMapping mapping = GetTableNameByDataSource(ui); foreach (Control c in ui.GroupBoxDataSet.Controls) { ucCheckBoxList uccbl = c as ucCheckBoxList; if (uccbl != null) { //_sql.Append("("); bool checkedPrevious = false; foreach (CheckBox cb in uccbl) { if (cb.Checked) { StringBuilder sql = new StringBuilder(); //sql.Append("DataSetID=(select ").Append(mapping.DataSetIDFieldName) // .Append(" from ").Append(mapping.DatabaseTableName) // .Append(" where ").Append(mapping.DataSetLabelFieldName).Append("='").Append(cb.Text).Append("')"); sql.Append("DataSetID='").Append(cb.Tag.ToString()).Append("'"); AppendOr(ref checkedPrevious, cb.Checked, sql.ToString()); } } _sql.Append(" and "); break; } } }
private DataSetTableMapping GetTableNameByDataSource(UIControls ui) { DataSetTableMapping mapping = new DataSetTableMapping(); foreach (Control c in ui.GroupBoxProductDataSource.Controls) { RadioButton rb = c as RadioButton; if (rb != null && rb.Checked) { switch (rb.Text) { case "MOD06": { mapping.DatabaseTableName = "cp_cldprds2mod06sets_tb"; mapping.DataSetIDFieldName = "Prds2MOD06ID"; mapping.DataSetNameFieldName = "MOD06DataSetName"; mapping.DataSetLabelFieldName = "MOD06SetsLabel"; break; } case "AIRS": { mapping.DatabaseTableName = "cp_cldprds2airssets_tb"; mapping.DataSetIDFieldName = "Prds2AIRSID"; mapping.DataSetNameFieldName = "AIRSDataSetName"; mapping.DataSetLabelFieldName = "AIRSSetsLabel"; break; } case "ISCCP D2": { mapping.DatabaseTableName = "cp_cldprds2isccpbands_tb"; mapping.DataSetIDFieldName = "Prds2CloudSATID"; mapping.DataSetNameFieldName = "CloudSATDataSetName"; mapping.DataSetLabelFieldName = "CloudSATDataSetLabel"; break; } } break; } } return(mapping); }