public List <UserBasicDataObject> GetUserBasicDataByCriteria(string colName, string colValue) { String sqlString = //"SELECT TOP " + num + "SELECT * " + " FROM zza_file " + " WHERE " + colName + "=" + "'" + colValue + "'" + " ORDER BY zza01 DESC" + ""; List <UserBasicDataObject> userBasicDataObjectList = new List <UserBasicDataObject>(); OpenConnection(); actionResult = "SUCCESS"; try { SqlCommand sqlCommand = sqlConnection.CreateCommand(); sqlCommand.Connection = sqlConnection; sqlCommand.CommandText = sqlString; SqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { UserBasicDataObject userBasicDataObject = new UserBasicDataObject(); userBasicDataObject.Zza01 = dataReader["Zza01"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza01")); userBasicDataObject.Zza02 = dataReader["Zza02"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza02")); userBasicDataObject.Zza03 = dataReader["Zza03"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza03")); userBasicDataObject.Zza04 = dataReader["Zza04"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza04")); userBasicDataObject.Zza05 = dataReader["Zza05"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza05")); userBasicDataObject.Zza06 = dataReader["Zza06"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza06")); userBasicDataObject.Zza07 = dataReader["Zza07"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza07")); userBasicDataObject.Zza08 = dataReader["Zza08"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza08")); userBasicDataObjectList.Add(userBasicDataObject); } } } catch (Exception ex) { string v = "FAIL" + ex.Message; actionResult = v; } finally { CloseConnection(); } return(userBasicDataObjectList); }
public List <UserBasicDataObject> GetUserBasicDataByCriteria(string where, string and) { String sqlString; if (and == "" || and.Length == 0) { sqlString = //"SELECT TOP " + num + " SELECT * " + " FROM zza_file , zzb_file , zzc_file " + " WHERE zza06 = zzb01 and zza08 = zzc02 and " + where + //" AND " + and + " ORDER BY zzc01 ASC" + ""; } else { sqlString = //"SELECT TOP " + num + " SELECT * " + " FROM zza_file , zzb_file , zzc_file " + " WHERE zza06 = zzb01 and zza08 = zzc02 and " + where + " AND " + and + " ORDER BY zzc01 ASC" + ""; } List <UserBasicDataObject> userBasicDataObjectList = new List <UserBasicDataObject>(); OpenConnection(); actionResult = "SUCCESS"; try { SqlCommand sqlCommand = sqlConnection.CreateCommand(); sqlCommand.Connection = sqlConnection; sqlCommand.CommandText = sqlString; SqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { UserBasicDataObject userBasicDataObject = new UserBasicDataObject(); userBasicDataObject.Zza01 = dataReader["Zza01"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza01")); userBasicDataObject.Zza02 = dataReader["Zza02"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza02")); userBasicDataObject.Zza03 = dataReader["Zza03"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza03")); userBasicDataObject.Zza04 = dataReader["Zza04"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza04")); userBasicDataObject.Zza05 = dataReader["Zza05"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza05")); userBasicDataObject.Zza06 = dataReader["Zza06"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza06")); userBasicDataObject.Zza07 = dataReader["Zza07"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza07")); userBasicDataObject.Zza08 = dataReader["Zza08"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza08")); userBasicDataObject.Zza09 = dataReader["Zza09"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zza09")); userBasicDataObject.Zzb01 = dataReader["Zzb01"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zzb01")); userBasicDataObject.Zzb02 = dataReader["Zzb02"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Zzb02")); userBasicDataObjectList.Add(userBasicDataObject); } } } catch (Exception ex) { string v = "FAIL" + ex.Message; actionResult = v; } finally { CloseConnection(); } return(userBasicDataObjectList); }