public List <UserInformationInfo> FindRecord(UserInformationFindInfo userInformationFindInfo)
{
string sqlString = string.Empty;
string sqlWhere = string.Empty;
if (userInformationFindInfo == null)
{
return(null);
}
sqlWhere = " WHERE 1=1 ";
if (userInformationFindInfo.UsmCUserID.Trim() != "")
{
sqlWhere += " AND " + this._dataBaseDic[UserInformationInfoEnum.UsmCUserID.ToString()] + "='" + userInformationFindInfo.UsmCUserID.Replace("'", "''") + "'";
}
if (userInformationFindInfo.UsmCEngName.Trim() != "")
{
string symbol = "=";
if (userInformationFindInfo.UsmCEngNameIsLike)
{
symbol = "LIKE";
}
sqlWhere += " AND " + this._dataBaseDic[UserInformationInfoEnum.UsmCEngName.ToString()] + symbol + " '" + userInformationFindInfo.UsmCEngName.Replace("'", "''") + "'";
}
if (userInformationFindInfo.UsmCChaName.Trim() != "")
{
string symbol = "=";
if (userInformationFindInfo.UsmCChaNameIsLike)
{
symbol = "LIKE";
}
sqlWhere += " AND " + this._dataBaseDic[UserInformationInfoEnum.UsmCChaName.ToString()] + symbol + " '" + userInformationFindInfo.UsmCChaName.Replace("'", "''") + "'";
}
sqlString = "SELECT * FROM " + UserInformationInfoEnum.TableName.ToString() + sqlWhere;
DataBaseCommand <UserInformationInfo> dbCommand = new DataBaseCommand <UserInformationInfo>();
List <UserInformationInfo> userInformationInfoList = null;
try
{
//userInformationInfoList = dbCommand.GetRecordList(sqlString, DataBaseDictionary.Instance.GetUserInformationDBD());
}
catch (Exception Ex)
{
throw Ex;
}
return(userInformationInfoList);
}
public List<UserInformationInfo> FindRecord(UserInformationFindInfo userInformationFindInfo)
{
string sqlString = string.Empty;
string sqlWhere = string.Empty;
if (userInformationFindInfo == null)
{
return null;
}
sqlWhere = " WHERE 1=1 ";
if (userInformationFindInfo.UsmCUserID.Trim() != "")
{
sqlWhere += " AND " + this._dataBaseDic[UserInformationInfoEnum.UsmCUserID.ToString()] + "='" + userInformationFindInfo.UsmCUserID.Replace("'", "''") + "'";
}
if (userInformationFindInfo.UsmCEngName.Trim() != "")
{
string symbol = "=";
if (userInformationFindInfo.UsmCEngNameIsLike)
{
symbol = "LIKE";
}
sqlWhere += " AND " + this._dataBaseDic[UserInformationInfoEnum.UsmCEngName.ToString()] + symbol + " '" + userInformationFindInfo.UsmCEngName.Replace("'", "''") + "'";
}
if (userInformationFindInfo.UsmCChaName.Trim() != "")
{
string symbol = "=";
if (userInformationFindInfo.UsmCChaNameIsLike)
{
symbol = "LIKE";
}
sqlWhere += " AND " + this._dataBaseDic[UserInformationInfoEnum.UsmCChaName.ToString()] + symbol + " '" + userInformationFindInfo.UsmCChaName.Replace("'", "''") + "'";
}
sqlString = "SELECT * FROM " + UserInformationInfoEnum.TableName.ToString() + sqlWhere;
DataBaseCommand<UserInformationInfo> dbCommand = new DataBaseCommand<UserInformationInfo>();
List<UserInformationInfo> userInformationInfoList=null;
try
{
//userInformationInfoList = dbCommand.GetRecordList(sqlString, DataBaseDictionary.Instance.GetUserInformationDBD());
}
catch (Exception Ex)
{
throw Ex;
}
return userInformationInfoList;
}
