/// <summary>
/// 根据预分装号获取的订单列表获取每条订单的详细信息列表
/// </summary>
/// <param name="list"> 订单列表</param>
/// <returns></returns>
public List <GoodsOrder> getGoodsOrderListByAddvanceId(List <string> list)
{
List <GoodsOrder> returnVal = new List <GoodsOrder>();
string ConnString = ConfigurationManager.AppSettings["Sngoo"];
//string inputPs, readPS;
SqlConnection connection = new SqlConnection(ConnString);
connection.Open();
for (int i = 0; i < list.Count; i++)
{
string ConnQuery = " select * from yl_GoodsOrder where OrderNo= '" + list[i].ToString() + "'";
SqlCommand lo_cmd = new SqlCommand(ConnQuery, connection);
SqlDataReader reader = lo_cmd.ExecuteReader();
reader.Read();
GoodsOrder item = new GoodsOrder();
item.OrderNo = reader["OrderNo"].ToString();
item.PayTime = Convert.ToDateTime(reader["PayTime"]);
item.PickPointName = reader["PickPointName"].ToString();
item.ReceiveTel = reader["ReceiveTel"].ToString();
item.RecevieName = reader["RecevieName"].ToString();
if (reader["CheckerCode"].ToString() != "0" || reader["CheckerCode"].ToString() == "")
{
item.AddvanceSub = 1;
}
else
{
item.AddvanceSub = 0;
}
returnVal.Add(item);
reader.Close();
lo_cmd.Dispose();
}
connection.Close();
connection.Dispose();
//ConnString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=sngoo712;Data Source=(local)";
return(returnVal);
}
/// <summary>
/// 得到与预分装订单信息
/// </summary>
/// <param name="PickPoint"></param>
/// <param name="starTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public List <GoodsOrder> getGoodsOrder(string PickPoint, DateTime starTime, DateTime endTime)
{
List <GoodsOrder> returnVal = new List <GoodsOrder>();
string ConnString = ConfigurationManager.AppSettings["Sngoo"];
//string inputPs, readPS;
string ConnQuery = " select * from yl_GoodsOrder where (PayTime between '" + starTime + "' and '" + endTime + "') and PickPointName='" + PickPoint + "' and (OrderState=1 and ShoppingState=0 and PayState=2) ";
SqlConnection connection = new SqlConnection(ConnString);
connection.Open();
SqlCommand lo_cmd = new SqlCommand(ConnQuery, connection);
SqlDataReader reader = lo_cmd.ExecuteReader();
while (reader.Read())
{
GoodsOrder item = new GoodsOrder();
item.OrderNo = reader["OrderNo"].ToString();
item.PayTime = Convert.ToDateTime(reader["PayTime"]);
item.PickPointName = reader["PickPointName"].ToString();
item.ReceiveTel = reader["ReceiveTel"].ToString();
item.RecevieName = reader["RecevieName"].ToString();
if (reader["CheckerCode"].ToString() != "0" || reader["CheckerCode"].ToString() == "")
{
item.AddvanceSub = 1;
}
else
{
item.AddvanceSub = 0;
}
if (item.AddvanceSub == 0)
{
returnVal.Add(item);
}
}
reader.Close();
connection.Close();
connection.Dispose();
//ConnString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=sngoo712;Data Source=(local)";
return(returnVal);
}
