private static List <V_INOUTSTOCK> DoQuery(string sql_str)
{
List <V_INOUTSTOCK> rtn = new List <V_INOUTSTOCK>();
DBHelper_Sqlserver DBHelper_Sqlserver = new DBHelper_Sqlserver();
try
{
using (IDataReader dr = DBHelper_Sqlserver.ExecuteReader(sql_str))
{
while (dr.Read())
{
var p = new V_INOUTSTOCK();
#region 逐个赋值
p.WAREHOUSENO = DBHelper_Sqlserver.GetDataValue <string>(dr, "WAREHOUSENO");
p.CONTAINERNO = DBHelper_Sqlserver.GetDataValue <string>(dr, "CONTAINERNO");
p.TASKTYPE = DBHelper_Sqlserver.GetDataValue <string>(dr, "TASKTYPE");
p.SOURCEPLACE = DBHelper_Sqlserver.GetDataValue <string>(dr, "SOURCEPLACE");
p.TOPLACE = DBHelper_Sqlserver.GetDataValue <string>(dr, "TOPLACE");
p.UPDATEUSER = DBHelper_Sqlserver.GetDataValue <string>(dr, "UPDATEUSER");
p.UPDATETIME = DBHelper_Sqlserver.GetDataValue <string>(dr, "UPDATETIME");
p.TASKCONTENTSTRING = DBHelper_Sqlserver.GetDataValue <string>(dr, "TASKCONTENTSTRING");
#endregion
rtn.Add(p);
}
}
}
catch
{
}
return(rtn);
}
