public List<CodeMasterInfo> FindRecord(CodeMasterFindInfo codeMasterFindInfo) { string sqlString = string.Empty; string sqlWhere = string.Empty; if (codeMasterFindInfo == null) { return null; } sqlWhere = " WHERE 1=1 "; if (codeMasterFindInfo.CmtCKey1.Trim() != "") { sqlWhere += " AND " + this._dataBaseDic[CodeMasterInfoEnum.CmtCKey1.ToString()] + "='" + codeMasterFindInfo.CmtCKey1.Replace("'", "''") + "'"; } if (codeMasterFindInfo.CmtCKey2.Trim() != "") { sqlWhere += " AND " + this._dataBaseDic[CodeMasterInfoEnum.CmtCKey2.ToString()] + "='" + codeMasterFindInfo.CmtCKey2.Replace("'", "''") + "'"; } if (codeMasterFindInfo.CmtCValue.Trim() != "") { sqlWhere += " AND " + this._dataBaseDic[CodeMasterInfoEnum.CmtCValue.ToString()] + "='" + codeMasterFindInfo.CmtCValue.Replace("'", "''") + "'"; } sqlString = "SELECT * FROM " + this._dataBaseDic[CodeMasterInfoEnum.TableName.ToString()] + sqlWhere; DataBaseCommand<CodeMasterInfo> dbCommand = new DataBaseCommand<CodeMasterInfo>(); List<CodeMasterInfo> codeMasterList=null; try { //codeMasterList = dbCommand.GetRecordList(sqlString, DataBaseDictionary.Instance.GetCodeMasterDBD()); } catch (Exception Ex) { throw Ex; } return codeMasterList; }
/// <summary> /// 从字码主档中获得Combobox数据列表 /// </summary> /// <param name="codeMasterKey1">主键一</param> /// <returns></returns> public List<ComboboxDataInfo> GetComboboxDataInfoListFromCodeMaster(string codeMasterKey1) { List<ComboboxDataInfo> comboboxDataInfoList = null; List<CodeMasterInfo> codeMasterInfoList = null; CodeMasterFindInfo codeMasterFindInfo = new CodeMasterFindInfo(); ICodeMasterDA iCodeMasterDA = null; codeMasterFindInfo.CmtCKey1 = codeMasterKey1; iCodeMasterDA = CodeMasterDAFactory.Instance.GetCodeMasterDA(); try { codeMasterInfoList = iCodeMasterDA.FindRecord(codeMasterFindInfo); } catch (Exception Ex) { throw Ex; } if (codeMasterInfoList != null) { if (codeMasterInfoList.Count > 0) { ComboboxDataInfo comboboxDataInfo = null; comboboxDataInfoList = new List<ComboboxDataInfo>(); for (int i = 0; i < codeMasterInfoList.Count; i++) { comboboxDataInfo = new ComboboxDataInfo(); comboboxDataInfo.DisplayMember = codeMasterInfoList[i].CmtCValue; comboboxDataInfo.ValueMember = codeMasterInfoList[i].CmtCKey2; comboboxDataInfoList.Add(comboboxDataInfo); } } } return comboboxDataInfoList; }