public List <CodeMasterInfo> GetMasterList(CodeMasterFindInfo codeMasterFindInfo) { try { return(_codeMasterDA.FindRecord(codeMasterFindInfo)); } catch (Exception Ex) { throw Ex; } }
public CodeMasterInfo[] FindRecord(CodeMasterFindInfo codeMasterFindInfo) { List <CodeMasterInfo> recordList; try { recordList = _codeMasterDA.FindRecord(codeMasterFindInfo); } catch (Exception Ex) { throw Ex; } CodeMasterInfo[] infos = null; infos = recordList.ToArray(); return(infos); }
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); }