public List <Model.Master.DeptMasterInfo> GetAllRecord()
{
string sqlString = string.Empty;
sqlString = "SELECT * FROM " + this._dataDictionary[DeptMasterInfoEnum.TableName.ToString()] + this._newLineSybm;
DataBaseCommand <DeptMasterInfo> dbCommand = new DataBaseCommand <DeptMasterInfo>();
List <DeptMasterInfo> deptMasterInfoList;
try
{
deptMasterInfoList = dbCommand.GetRecordList(sqlString, this._dataDictionary);
}
catch (Exception Ex)
{
throw Ex;
}
return(deptMasterInfoList);
}
public List <CodeMasterInfo> GetKey1s()
{
string sqlString = string.Empty;
List <CodeMasterInfo> codeMasterList;
DataBaseCommand <CodeMasterInfo> dbCommand = new DataBaseCommand <CodeMasterInfo>();
sqlString = LocalLayer.LocalDefine.Instance.GetInitComboBoxSQL(this._dataBaseDic[CodeMasterInfoEnum.TableName.ToString()], this._dataBaseDic[CodeMasterInfoEnum.CmtCKey1.ToString()], "");
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add(CodeMasterInfoEnum.CmtCKey1.ToString(), this._dataBaseDic[CodeMasterInfoEnum.CmtCKey1.ToString()]);
try
{
codeMasterList = dbCommand.GetRecordList(sqlString, dic);
}
catch (Exception Ex)
{
throw Ex;
}
return(codeMasterList);
}
public List <CodeMasterInfo> GetKey2s(string key1)
{
string sqlString = string.Empty;
List <CodeMasterInfo> codeMasterList;
DataBaseCommand <CodeMasterInfo> dbCommand = new DataBaseCommand <CodeMasterInfo>();
sqlString = "SELECT DISTINCT " + this._dataBaseDic[CodeMasterInfoEnum.CmtCKey2.ToString()] + " FROM " + this._dataBaseDic[CodeMasterInfoEnum.TableName.ToString()];
sqlString += " WHERE " + this._dataBaseDic[CodeMasterInfoEnum.CmtCKey1.ToString()] + "='" + key1.Replace("'", "''") + "'";
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add(CodeMasterInfoEnum.CmtCKey2.ToString(), this._dataBaseDic[CodeMasterInfoEnum.CmtCKey2.ToString()]);
try
{
codeMasterList = dbCommand.GetRecordList(sqlString, dic);
}
catch (Exception Ex)
{
throw Ex;
}
return(codeMasterList);
}
public List<CodeMasterInfo> GetKey2s(string key1)
{
string sqlString = string.Empty;
List<CodeMasterInfo> codeMasterList;
DataBaseCommand<CodeMasterInfo> dbCommand = new DataBaseCommand<CodeMasterInfo>();
sqlString = "SELECT DISTINCT " + this._dataBaseDic[CodeMasterInfoEnum.CmtCKey2.ToString()] + " FROM " + this._dataBaseDic[CodeMasterInfoEnum.TableName.ToString()];
sqlString += " WHERE " + this._dataBaseDic[CodeMasterInfoEnum.CmtCKey1.ToString()] + "='" + key1.Replace("'", "''") + "'";
Dictionary<string, string> dic = new Dictionary<string, string>();
dic.Add(CodeMasterInfoEnum.CmtCKey2.ToString(), this._dataBaseDic[CodeMasterInfoEnum.CmtCKey2.ToString()]);
try
{
codeMasterList = dbCommand.GetRecordList(sqlString, dic);
}
catch (Exception Ex)
{
throw Ex;
}
return codeMasterList;
}
public List<CodeMasterInfo> GetKey1s()
{
string sqlString = string.Empty;
List<CodeMasterInfo> codeMasterList;
DataBaseCommand<CodeMasterInfo> dbCommand = new DataBaseCommand<CodeMasterInfo>();
sqlString = LocalLayer.LocalDefine.Instance.GetInitComboBoxSQL(this._dataBaseDic[CodeMasterInfoEnum.TableName.ToString()], this._dataBaseDic[CodeMasterInfoEnum.CmtCKey1.ToString()], "");
Dictionary<string, string> dic = new Dictionary<string, string>();
dic.Add(CodeMasterInfoEnum.CmtCKey1.ToString(), this._dataBaseDic[CodeMasterInfoEnum.CmtCKey1.ToString()]);
try
{
codeMasterList = dbCommand.GetRecordList(sqlString, dic);
}
catch (Exception Ex)
{
throw Ex;
}
return codeMasterList;
}
public List<Model.Master.DeptMasterInfo> GetAllRecord()
{
string sqlString = string.Empty;
sqlString = "SELECT * FROM " + this._dataDictionary[DeptMasterInfoEnum.TableName.ToString()] + this._newLineSybm;
DataBaseCommand<DeptMasterInfo> dbCommand = new DataBaseCommand<DeptMasterInfo>();
List<DeptMasterInfo> deptMasterInfoList;
try
{
deptMasterInfoList = dbCommand.GetRecordList(sqlString, this._dataDictionary);
}
catch (Exception Ex)
{
throw Ex;
}
return deptMasterInfoList;
}