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);
}
