/// <summary> /// 读取订单信息 /// </summary> /// <param name="StarTime">开始时间</param> /// <param name="EndTime">结束时间</param> /// <returns></returns> public List <info> readString(string StarTime, string EndTime) { List <info> cacheRead = new List <info>(); info cacheItem = new info(); //string ConnQuery = "declare @startime as datetime "+ // "declare @endtime as datetime set @startime='" + StarTime + "'set @endtime='" + EndTime + "'"+ // "select OrderNo,PayTime,OrderMoney,RecevieName,ReceiveTel,OrderState,ShoppingState,PayState from yl_GoodsOrder where PayTime between @startime and @endtime and OrderState=1 and PayState=2 and (ShoppingState=0 or ShoppingState=1 or ShoppingState=2) or Convert(varchar(10),PayTime,120) = CONVERT(varchar(10),@startime,120) or Convert(varchar(10),PayTime,120) = CONVERT(varchar(10),@endtime,120)"; string ConnQuery = "select OrderNo,PayTime,OrderMoney,RecevieName,ReceiveTel,OrderState,ShoppingState,PayState from yl_GoodsOrder where PayTime between'" + StarTime + "' and'" + EndTime + "'and OrderState=1 and PayState=2 and (ShoppingState=0 or ShoppingState=1 or ShoppingState=2)"; SqlConnection connection = new SqlConnection(ConnString); connection.Open(); SqlCommand lo_cmd = new SqlCommand(ConnQuery, connection); SqlDataReader reader = lo_cmd.ExecuteReader(); if (!reader.HasRows) //读取的行数 { cacheRead = null; } else { int i = 0; while (reader.Read()) { cacheItem.id = i; cacheItem.OrderNo = reader["OrderNo"].ToString(); cacheItem.RecevieName = reader["RecevieName"].ToString(); cacheItem.ReceiveTel = reader["ReceiveTel"].ToString(); cacheItem.OrderMoney = Convert.ToDecimal(reader["OrderMoney"]); cacheItem.PayTime = reader["PayTime"].ToString(); cacheItem.ShoppingState = Convert.ToByte(reader["ShoppingState"]); cacheItem.PayState = Convert.ToByte(reader["PayState"]); cacheItem.OrderState = Convert.ToByte(reader["OrderState"]); cacheRead.Add(cacheItem); i++; } } reader.Close(); connection.Close(); connection.Dispose(); return(cacheRead); }
/// <summary> /// 搜索订单 /// </summary> /// <param name="OrderNo">订单号</param> private void searchOrder(string OrderNo) { if (newTime.starTime != null && newTime.endTime != null) { dataGridView1.Rows.Clear(); dataBase read = new dataBase(); //bool returnBool; //returnBool = read.checkOrder(stockOrOrder.Text.ToString()); if (!read.existSearchOrder(stockOrOrder.Text.ToString())) { MessageBox.Show("没有相应订单"); return; } info searchContent = read.searchOrder(stockOrOrder.Text.ToString()); dataGridView1.Rows.Add(); dataGridView1.Rows[0].Cells["Id"].Value = 0; dataGridView1.Rows[0].Cells["OrderNo"].Value = searchContent.OrderNo; dataGridView1.Rows[0].Cells["PayTime"].Value = searchContent.PayTime; dataGridView1.Rows[0].Cells["RecevieName"].Value = searchContent.RecevieName; dataGridView1.Rows[0].Cells["ReceiveTel"].Value = searchContent.ReceiveTel; dataGridView1.Rows[0].Cells["OrderMoney"].Value = searchContent.OrderMoney; dataGridView1.Rows[0].Cells["Behavior"].Value = "详情"; string ResultStr = string.Empty; switch (searchContent.OrderState) { case 0: ResultStr = "待确认"; break; case 1: ResultStr = "已确认"; break; case 2: ResultStr = "已取消"; break; case 4: ResultStr = "无效"; break; default: break; } switch (searchContent.PayState) { case 0: ResultStr += "未支付"; break; case 2: ResultStr += "已支付"; break; default: break; } switch (searchContent.ShoppingState) { case 0: ResultStr += "未发货"; break; case 1: ResultStr += "备货中"; break; case 2: ResultStr += "发货中"; break; case 3: ResultStr += "已发货"; break; case 4: ResultStr += "确认收货"; break; default: break; } dataGridView1.Rows[0].Cells["OrderState"].Value = ResultStr; } KindView = 0; }