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