public List <softTime_info> findsoftTime(string findtext)
{
// findtext = sqlAddPCID(findtext);
MySql.Data.MySqlClient.MySqlDataReader reader = NewMySqlHelper.ExecuteReader(findtext);
List <softTime_info> ClaimReport_Server = new List <softTime_info>();
while (reader.Read())
{
softTime_info item = new softTime_info();
if (reader.GetValue(0) != null && Convert.ToString(reader.GetValue(0)) != "")
{
item._id = Convert.ToString(reader.GetValue(0));
}
if (reader.GetValue(1) != null && Convert.ToString(reader.GetValue(1)) != "")
{
item.name = reader.GetString(1);
}
if (reader.GetValue(2) != null && Convert.ToString(reader.GetValue(2)) != "")
{
item.starttime = reader.GetString(2);
}
if (reader.GetValue(3) != null && Convert.ToString(reader.GetValue(3)) != "")
{
item.endtime = reader.GetString(3);
}
ClaimReport_Server.Add(item);
//这里做数据处理....
}
return(ClaimReport_Server);
}
public List <softTime_info> findsoftTime(string findtext)
{
// findtext = sqlAddPCID(findtext);
MySql.Data.MySqlClient.MySqlDataReader reader = NewMySqlHelper.ExecuteReader(findtext);
List <softTime_info> ClaimReport_Server = new List <softTime_info>();
while (reader.Read())
{
softTime_info item = new softTime_info();
if (reader.GetValue(0) != null && Convert.ToString(reader.GetValue(0)) != "")
{
item._id = Convert.ToString(reader.GetValue(0));
}
if (reader.GetValue(1) != null && Convert.ToString(reader.GetValue(1)) != "")
{
item.name = reader.GetString(1);
}
if (reader.GetValue(2) != null && Convert.ToString(reader.GetValue(2)) != "")
{
item.starttime = reader.GetString(2);
}
if (reader.GetValue(3) != null && Convert.ToString(reader.GetValue(3)) != "")
{
item.endtime = reader.GetString(3);
}
if (reader.GetValue(4) != null && Convert.ToString(reader.GetValue(4)) != "")
{
item.soft_name = reader.GetString(4);
}
if (reader.GetValue(5) != null && Convert.ToString(reader.GetValue(5)) != "")
{
item.denglushijian = reader.GetString(5);
}
if (reader.GetValue(6) != null && Convert.ToString(reader.GetValue(6)) != "")
{
item.password = reader.GetString(6);
}
if (reader.GetValue(7) != null && Convert.ToString(reader.GetValue(7)) != "")
{
item.pid = reader.GetString(7);
}
if (reader.GetValue(8) != null && Convert.ToString(reader.GetValue(8)) != "")
{
item.mark1 = reader.GetString(8);
}
if (reader.GetValue(9) != null && Convert.ToString(reader.GetValue(9)) != "")
{
item.mark2 = reader.GetString(9);
}
if (reader.GetValue(10) != null && Convert.ToString(reader.GetValue(10)) != "")
{
item.mark3 = reader.GetString(10);
}
if (reader.GetValue(11) != null && Convert.ToString(reader.GetValue(11)) != "")
{
item.mark4 = reader.GetString(11);
}
if (reader.GetValue(12) != null && Convert.ToString(reader.GetValue(12)) != "")
{
item.mark5 = reader.GetString(12);
}
ClaimReport_Server.Add(item);
//这里做数据处理....
}
reader.Dispose();
reader.Close();
// cmd.Dispose();
return(ClaimReport_Server);
}
