public void ProcessNewOrders(HttpContext context)
{
DateTime lastTime = DateTime.Now;
string text = context.Request["lastTime"];
DateTime now;
if (!DateTime.TryParse(context.Request["lastTime"], out lastTime))
{
now = DateTime.Now;
lastTime = now.AddHours(-1.0);
}
RecentlyOrderStatic recentlyOrderStatic = new RecentlyOrderStatic();
recentlyOrderStatic.HasOrderSatic = false;
recentlyOrderStatic = SalesHelper.GetNewlyOrdersCountAndPayCount(lastTime, 0, 0);
this.jsondict.Clear();
IDictionary <string, string> dictionary = this.jsondict;
int num = recentlyOrderStatic.OrdersCount;
dictionary.Add("OrdersCount", num.ToString());
IDictionary <string, string> dictionary2 = this.jsondict;
num = recentlyOrderStatic.PayCount;
dictionary2.Add("PayCount", num.ToString());
IDictionary <string, string> dictionary3 = this.jsondict;
num = recentlyOrderStatic.RefundOrderCount;
dictionary3.Add("RefundOrderCount", num.ToString());
IDictionary <string, string> dictionary4 = this.jsondict;
num = recentlyOrderStatic.ReplacementOrderCount;
dictionary4.Add("ReplacementOrderCount", num.ToString());
IDictionary <string, string> dictionary5 = this.jsondict;
num = recentlyOrderStatic.ReturnsOrderCount;
dictionary5.Add("ReturnsOrderCount", num.ToString());
IDictionary <string, string> dictionary6 = this.jsondict;
now = DateTime.Now;
dictionary6.Add("lastTime", now.ToString("yyyy/MM/dd HH:mm:ss"));
if (recentlyOrderStatic.HasOrderSatic)
{
this.WriteJson(context, 1);
}
else
{
this.WriteJson(context, 0);
}
}
public RecentlyOrderStatic GetNewlyOrdersCountAndPayCount(DateTime dt, int StoreId = 0, int SupplierId = 0)
{
RecentlyOrderStatic recentlyOrderStatic = new RecentlyOrderStatic();
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(" ");
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("SELECT Count(*) as OrderCount ");
if (StoreId > 0)
{
stringBuilder.AppendFormat("FROM Hishop_Orders WHERE OrderStatus= {0} AND ParentOrderId<>'-1' AND DATEDIFF(s,OrderDate,'{1}')<=0 AND StoreId = {2};", 1, dt.ToString(), StoreId);
stringBuilder.AppendFormat("SELECT Count(*) as PayOrderCount FROM Hishop_Orders WHERE OrderStatus = {0} AND ParentOrderId<>'-1' AND DATEDIFF(s,payDate,'{1}') <= 0 AND StoreId = {2};", 2, dt.ToString(), StoreId);
stringBuilder.AppendFormat("SELECT Count(*) as RefundOrderCount FROM Hishop_OrderRefund WHERE HandleStatus = 0 AND DATEDIFF(s,ApplyForTime,'{0}') <= 0 AND StoreId = {1};", dt.ToString(), StoreId);
stringBuilder.AppendFormat("SELECT Count(*) as ReplacementOrderCount FROM Hishop_OrderReplace WHERE HandleStatus = 0 AND DATEDIFF(s,ApplyForTime,'{0}') <= 0 AND StoreId = {1};", dt.ToString(), StoreId);
stringBuilder.AppendFormat("SELECT Count(*) as ReturnsOrderCount FROM Hishop_OrderReturns WHERE HandleStatus = 0 AND DATEDIFF(s,ApplyForTime,'{0}') <= 0 AND StoreId = {1};", dt.ToString(), StoreId);
}
else if (SupplierId > 0)
{
stringBuilder.AppendFormat("FROM Hishop_Orders WHERE OrderStatus= {0} AND ParentOrderId<>'-1' AND DATEDIFF(s,OrderDate,'{1}')<=0 AND SupplierId = {2};", 1, dt.ToString(), SupplierId);
stringBuilder.AppendFormat("SELECT Count(*) as PayOrderCount FROM Hishop_Orders WHERE OrderStatus = {0} AND ParentOrderId<>'-1' AND DATEDIFF(s,payDate,'{1}') <= 0 AND SupplierId = {2};", 2, dt.ToString(), SupplierId);
stringBuilder.AppendFormat("SELECT Count(*) as RefundOrderCount FROM Hishop_OrderRefund orf join Hishop_Orders o on orf.OrderId=o.OrderId WHERE orf.HandleStatus = 0 AND DATEDIFF(s,ApplyForTime,'{0}') <= 0 AND SupplierId = {1};", dt.ToString(), SupplierId);
stringBuilder.AppendFormat("SELECT Count(*) as ReplacementOrderCount FROM Hishop_OrderReplace orp join Hishop_Orders o on orp.OrderId=o.OrderId WHERE HandleStatus = 0 AND DATEDIFF(s,ApplyForTime,'{0}') <= 0 AND SupplierId = {1};", dt.ToString(), SupplierId);
stringBuilder.AppendFormat("SELECT Count(*) as ReturnsOrderCount FROM Hishop_OrderReturns ort join Hishop_Orders o on ort.OrderId=o.OrderId WHERE HandleStatus = 0 AND DATEDIFF(s,ApplyForTime,'{0}') <= 0 AND SupplierId = {1};", dt.ToString(), SupplierId);
}
else
{
stringBuilder.AppendFormat("FROM Hishop_Orders WHERE OrderStatus= {0} AND ParentOrderId<>'-1' AND DATEDIFF(s,OrderDate,'{1}')<=0 AND SupplierId = 0 AND StoreId=0;", 1, dt.ToString());
stringBuilder.AppendFormat("SELECT Count(*) as PayOrderCount FROM Hishop_Orders WHERE OrderStatus = {0} AND ParentOrderId<>'-1' AND DATEDIFF(s,payDate,'{1}') <= 0 AND SupplierId = 0 AND StoreId=0;", 2, dt.ToString());
stringBuilder.AppendFormat("SELECT Count(*) as RefundOrderCount FROM Hishop_OrderRefund orf join Hishop_Orders o on orf.OrderId=o.OrderId WHERE orf.HandleStatus = 0 AND DATEDIFF(s,ApplyForTime,'{0}') <= 0 AND o.SupplierId = 0 AND o.StoreId=0;", dt.ToString());
stringBuilder.AppendFormat("SELECT Count(*) as ReplacementOrderCount FROM Hishop_OrderReplace orp join Hishop_Orders o on orp.OrderId=o.OrderId WHERE HandleStatus = 0 AND DATEDIFF(s,ApplyForTime,'{0}') <= 0 AND o.SupplierId = 0 AND o.StoreId=0;", dt.ToString());
stringBuilder.AppendFormat("SELECT Count(*) as ReturnsOrderCount FROM Hishop_OrderReturns ort join Hishop_Orders o on ort.OrderId=o.OrderId WHERE HandleStatus = 0 AND DATEDIFF(s,ApplyForTime,'{0}') <= 0 AND o.SupplierId = 0 AND o.StoreId=0;", dt.ToString());
}
sqlStringCommand.CommandText = stringBuilder.ToString();
recentlyOrderStatic.OrdersCount = 0;
recentlyOrderStatic.PayCount = 0;
recentlyOrderStatic.RefundOrderCount = 0;
recentlyOrderStatic.ReplacementOrderCount = 0;
recentlyOrderStatic.ReturnsOrderCount = 0;
try
{
using (IDataReader dataReader = base.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
recentlyOrderStatic.OrdersCount = dataReader.GetInt32(0);
}
if (dataReader.NextResult() && dataReader.Read())
{
recentlyOrderStatic.PayCount = dataReader.GetInt32(0);
}
if (dataReader.NextResult() && dataReader.Read())
{
recentlyOrderStatic.RefundOrderCount = dataReader.GetInt32(0);
}
if (dataReader.NextResult() && dataReader.Read())
{
recentlyOrderStatic.ReplacementOrderCount = dataReader.GetInt32(0);
}
if (dataReader.NextResult() && dataReader.Read())
{
recentlyOrderStatic.ReturnsOrderCount = dataReader.GetInt32(0);
}
}
}
catch (Exception ex)
{
Globals.WriteLog("/static.txt", ex.Message + "-" + dt.ToString());
}
if (recentlyOrderStatic.OrdersCount > 0 || recentlyOrderStatic.PayCount > 0 || recentlyOrderStatic.RefundOrderCount > 0 || recentlyOrderStatic.ReplacementOrderCount > 0 || recentlyOrderStatic.ReturnsOrderCount > 0)
{
recentlyOrderStatic.HasOrderSatic = true;
}
else
{
recentlyOrderStatic.HasOrderSatic = false;
}
return(recentlyOrderStatic);
}
public void ProcessNewOrders(HttpContext context)
{
int storeId = HiContext.Current.Manager.StoreId;
DateTime lastTime = DateTime.Now;
string text = context.Request["lastTime"];
DateTime now;
if (!DateTime.TryParse(context.Request["lastTime"], out lastTime))
{
now = DateTime.Now;
lastTime = now.AddHours(-1.0);
}
RecentlyOrderStatic recentlyOrderStatic = new RecentlyOrderStatic();
recentlyOrderStatic.HasOrderSatic = false;
int num = 0;
while (!recentlyOrderStatic.HasOrderSatic)
{
recentlyOrderStatic = SalesHelper.GetNewlyOrdersCountAndPayCount(lastTime, storeId, 0);
Thread.Sleep(1000);
num++;
if (num == 25)
{
break;
}
}
this.jsondict.Clear();
IDictionary <string, string> dictionary = this.jsondict;
int num2 = recentlyOrderStatic.OrdersCount;
dictionary.Add("OrdersCount", num2.ToString());
IDictionary <string, string> dictionary2 = this.jsondict;
num2 = recentlyOrderStatic.PayCount;
dictionary2.Add("PayCount", num2.ToString());
IDictionary <string, string> dictionary3 = this.jsondict;
num2 = recentlyOrderStatic.RefundOrderCount;
dictionary3.Add("RefundOrderCount", num2.ToString());
IDictionary <string, string> dictionary4 = this.jsondict;
num2 = recentlyOrderStatic.ReplacementOrderCount;
dictionary4.Add("ReplacementOrderCount", num2.ToString());
IDictionary <string, string> dictionary5 = this.jsondict;
num2 = recentlyOrderStatic.ReturnsOrderCount;
dictionary5.Add("ReturnsOrderCount", num2.ToString());
IDictionary <string, string> dictionary6 = this.jsondict;
now = DateTime.Now;
dictionary6.Add("lastTime", now.ToString("yyyy/MM/dd HH:mm:ss"));
if (recentlyOrderStatic.HasOrderSatic)
{
this.WriteJson(context, 1);
}
else
{
this.WriteJson(context, 0);
}
}
