上午12点到早上7点之间的订单没有显示计时器问题 [英] The orders after 12 am to 7 am not show timer problem

问题描述

大家好



我每天都会通过计时器自动选择数据程序c＃



在sql server 2005中我编写以下查询

Hi guys

I make program to select data every day automatically by timer every second in c#

In sql server 2005 i write the following query

ALTER proc [dbo].[JeddahSalesAll]
as
SELECT     ROW_NUMBER() OVER (ORDER BY dbo.[Jeddah-Live$Sales Header].No_) AS [S.N], dbo.[Jeddah-Live$Sales Line].[Document No_] AS 'OrderNo', 
dbo.[Jeddah-Live$Sales Header].[Bill-to Name] AS 'CustomerNo', dbo.[Jeddah-Live$Sales Line].Area AS 'Shippment Type', dbo.[Jeddah-Live$Sales Line].Description AS 'Description', 
dbo.[Jeddah-Live$Sales Header].[Pump No_] AS 'PumpNo', CAST(ROUND(dbo.[Jeddah-Live$Sales Line].Quantity, 0, 1) AS int) AS 'Required Qunatity', 
CAST(ROUND(dbo.[Jeddah-Live$Sales Line].[Quantity Shipped], 0, 1) AS int) AS 'Shipped Quantity', CAST(ROUND(dbo.[Jeddah-Live$Sales Line].[Outstanding Quantity], 0, 
1) AS int) AS 'Outstanding Qunatity '
FROM         dbo.[Jeddah-Live$Sales Header] INNER JOIN
dbo.[Jeddah-Live$Sales Line] ON dbo.[Jeddah-Live$Sales Header].No_ = dbo.[Jeddah-Live$Sales Line].[Document No_] AND 
dbo.[Jeddah-Live$Sales Header].[Sell-to Customer No_] = dbo.[Jeddah-Live$Sales Line].[Sell-to Customer No_]  
WHERE DATEDIFF(d,dbo.[Jeddah-Live$Sales Line].[Shipment Date],GETDATE()) = 0

在C＃WINDOWS形式VISUAL STUDIO 2008 IN TIMER TICK EVENT INTERVAL是1000MILISECOND（每个第二个）

IN C# WINDOWS FORM VISUAL STUDIO 2008 IN TIMER TICK EVENT INTERVAL IS 1000MILISECOND(EVERY SECOND)

Sales.SalesClass SalesClass1 = new Sales.SalesClass();
DataTable dt = SalesClass1.ShowSalesData("Data Source=192.168.1.5;Initial Catalog=Altawi-last06-01-2015;User ID=admin;Password=123");
dataGridView1.DataSource = dt;
dataGridView1[0, dataGridView1.Rows.Count - 1].Value = "Total Sum";
dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0].Style.BackColor = Color.Yellow;
dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[1].Style.ForeColor = Color.Red;
dataGridView1.Refresh();

CLASS CODE如下

CLASS CODE AS FOLLOWING

class SalesClass
{
public DataTable ShowSalesData(string ConnectionString)
{
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "JeddahSalesAll";
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
return dt;
}

代码以上工作成功没有任何问题



唯一问题订单开始晚上8点在日期（2015年3月31日）和日期上午7点（2015年4月1日）结束



第二天



我做的是显示从上午12点到早上7点完成的订单显示



如果您有解决方案或建议解决问题帮助我如果可能的话



谢谢

code above work success no any problem

only problem the order start 8 pm in date(31/03/2015) and finish 7 am in date(01/04/2015)

at next day

what i do to show the orders done from 12 am to 7 am to show

if you have solution or suggestion to solve problem help me if possible

thanks

推荐答案

销售标题] .No_） AS [SN]，dbo。[Jeddah-Live

Sales Header].No_) AS [S.N], dbo.[Jeddah-Live

Sales Line]。[Document No_] AS ' OrderNo'，
dbo。[Jeddah-Live

Sales Line].[Document No_] AS 'OrderNo', dbo.[Jeddah-Live

Sales Header]。[Bill-to Name] AS ' CustomerNo'，dbo。[Jeddah-Live

Sales Header].[Bill-to Name] AS 'CustomerNo', dbo.[Jeddah-Live

这篇关于上午12点到早上7点之间的订单没有显示计时器问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！