/// <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); }