void LoadData(int year, int month, int from, int to, bool Use12)
{
string sql;
try
{
if (Use12)
{
TimeSpan oneDay = new TimeSpan(24, 0, 0);
DateTime prev = new DateTime(year, month, from).Subtract(oneDay);
DateTime next = new DateTime(year, month, to);
sql = "Where (INT(ID/10000)>=" + DateStr(prev)
+ " And INT(ID/10000)<=" + DateStr(next) + ")";
BasicDataSet.OrderDataTable temp = new BasicDataSet.OrderDataTable();
m_OrderAdapter.FillBySelectStr(temp, "Select * From [Order] " + sql + " Order by ID");
int nextID = IDTagHead(next.Year, next.Month, next.Day);
int prevID = IDTagHead(prev.Year, prev.Month, prev.Day);
basicDataSet.Order.Clear();
foreach (BasicDataSet.OrderRow r in temp)
{
int idHead = r.ID / 10000;
if (idHead == nextID)
{
if (r.PrintTime.Hour < 7)
{
continue;
}
}
else if (idHead == prevID)
{
if (r.PrintTime.Hour >= 7)
{
continue;
}
}
BasicDataSet.OrderRow oRow = basicDataSet.Order.NewOrderRow();
oRow.ItemArray = r.ItemArray;
basicDataSet.Order.AddOrderRow(oRow);
}
}
else
{
sql = "Where (INT(ID/10000)>=" + DateStr(year, month, from)
+ " And INT(ID/10000)<=" + DateStr(year, month, to) + ")";
m_OrderAdapter.FillBySelectStr(basicDataSet.Order, "Select * From [Order] " + sql + " Order by ID");
}
m_OrderItemAdapter.FillBySelectStr(basicDataSet.OrderItem, "Select * From [OrderItem] " + sql);
}
catch (Exception ex)
{
string str = ex.Message;
MessageBox.Show("訂菜單資料庫讀取錯誤!");
}
}
public bool LoadData(DamaiDataSet orderSet, int month, int day)
{
int count = orderSet.Header.Rows.Count;
if (count == 0)
{
return(false);
}
if (month < 1 || month > 12)
{
return(false);
}
if (day < 1 || day > 31)
{
return(false);
}
DamaiDataSet.HeaderRow row;
foreach (var r in orderSet.Header)
{
if (r.DataDate.Year != MyFunction.IntHeaderYear)
{
continue;
}
if (r.DataDate.Month != month)
{
continue;
}
if (r.DataDate.Day == day)
{
row = r;
goto Yes;
}
}
return(false);
Yes:
string sql = CreateSql(row.DataDate.Month, row.DataDate.Day);
try
{
m_OrderAdapter.FillBySelectStr(orderSet.Order, "Select * From [Order] " + sql + " Order by ID");
m_WorkingDay.Set(row.DataDate);
return(true);
}
catch (Exception ex)
{
LastErrorString = ex.Message;
if (MessageBox.Show(LastErrorString, "", MessageBoxButtons.RetryCancel) == DialogResult.Cancel)
{
throw ex;
}
}
return(false);
}
int LoadData(int m, int d)
{
string sql = "Where " + FloorStr + "(ID/1000000)=" + m.ToString("d2") + d.ToString("d2");
int MaxID = 0;
try
{
m_OrderSet.OrderItem.Rows.Clear();
m_OrderSet.Order.Rows.Clear();
m_OrderTableAdapter.FillBySelectStr(m_OrderSet.Order, "Select * From [Order] " + sql + " Order by ID");
m_OrderItemTableAdapter.FillBySelectStr(m_OrderSet.OrderItem, "Select * From [OrderItem] " + sql);
foreach (var R in m_OrderSet.Order)
{
int id = PureID(R.ID); // 資料定義為 MMDDNN9999 N POS机号,店長收資料時,再自動填上
if (id > MaxID)
{
MaxID = id;
}
}
return(MaxID);
}
catch (Exception ex)
{
string str = ex.Message;
MessageBox.Show("Order OrderItem讀取錯誤!" + str);
return(-1);
}
}
//int IDTagHead(int y, int m, int d)
//{
// int tag = y % 100;
// tag = tag * 10000 + m * 100 + d;
// return tag;
//}
// BakeryOrder的ID格式是 MMDDNN9999
void LoadData(int month, int from, int to)
{
string sql;
sql = "Where (Floor(ID/1000000)>=" + DateStr(month, from)
+ " And Floor(ID/1000000)<=" + DateStr(month, to) + ")";
try
{
m_OrderAdapter.FillBySelectStr(m_OrderSet.Order, "Select * From [Order] " + sql + " Order by ID");
m_OrderItemAdapter.FillBySelectStr(m_OrderSet.OrderItem, "Select * From [OrderItem] " + sql);
}
catch (Exception ex)
{
string str = ex.Message;
MessageBox.Show("訂菜單資料庫讀取錯誤!");
}
}
// BakeryOrderSet.Order.ID ==> MMDDNN9999
void LoadData(int year, int month, int from, int to)
{
string sql;
string sqlShipment;
try
{
sql = "Where (Floor(ID/1000000)>=" + DateStr(month, from)
+ " And Floor(ID/1000000)<=" + DateStr(month, to) + ")";
DateTime t = new DateTime(year, month, to).AddDays(1);
sqlShipment = "where a.ShipTime>= '" + year + DateStr(month, from) + "' and a.ShipTime< '" + t.Year.ToString() + DateStr(t.Month, t.Day) + "'";
m_OrderSet.OrderItem.Rows.Clear();
m_OrderSet.Order.Rows.Clear();
m_OrderSet.ShipmentDetail.Rows.Clear();
m_OrderSet.Shipment.Rows.Clear();
IsSold = cBSold.Checked;
IsShipment = cBShipment.Checked;
if (IsSold)
{
m_OrderAdapter.FillBySelectStr(m_OrderSet.Order, "Select * From [Order] " + sql + " Order by ID");
m_OrderItemAdapter.FillBySelectStr(m_OrderSet.OrderItem, "Select * From [OrderItem] " + sql);
}
if (IsShipment)
{
sqlShipment = sqlShipment + " and (a.customer=0 ";
for (int i = 0; i < checkedListBox1.Items.Count; i++)
{
if (checkedListBox1.GetItemChecked(i))
{
MyCustomer mc = checkedListBox1.Items[i] as MyCustomer;
sqlShipment = sqlShipment + "or a.customer=" + mc.GetID() + " ";
}
}
sqlShipment = sqlShipment + " )";
m_ShipmentAdapter.FillBySelectStr(m_OrderSet.Shipment, "Select * From [Shipment] a " + sqlShipment);
m_ShipmentItemAdapter.FillBySelectStr(m_OrderSet.ShipmentDetail, "Select b.* From [Shipment] a,[ShipmentDetail] b " + sqlShipment + " and b.ShipmentID=a.ID and b.cost is not null");
}
}
catch (Exception ex)
{
string str = ex.Message;
MessageBox.Show("訂菜單資料庫讀取錯誤!");
}
}
decimal selectData(DateTime time1, DateTime time2)
{
if (m_ProductDic.Count == 0)
{
Message("載入產品估算成本...");
foreach (var pd in Product)
{
if (pd.Code > 0)
{
m_ProductDic.Add(pd.ProductID, pd.IsEvaluatedCostNull()? 0 : pd.EvaluatedCost);
}
}
}
TimeData timedata = new TimeData();
decimal costtemp = 0;
string sT1 = time1.ToString("MMdd");
string sT2 = time2.ToString("MMdd");
string duration = "<" + sT1 + "-" + sT2 + ">";
#if (UseSQLServer)
string sqlstr = "Where Floor(ID/1000000)>" + sT1 + " and Floor(ID/1000000)<=" + sT2;
#else
string sqlstr = "Where INT(ID/1000000)>" + sT1 + " and INT(ID/1000000)<=" + sT2;
#endif
MyOrderSet.OrderDataTable Order = new MyOrderSet.OrderDataTable();
MyOrderSet.OrderItemDataTable OrderItem = new MyOrderSet.OrderItemDataTable();
//m_OrderAdapter.FillBySelectStr(Order, "Select * From [Order] " + sqlstr + " and oldid=0 And deleted=false Order by ID");
//m_OrderItemAdapter.FillBySelectStr(OrderItem, "Select * From [OrderItem] " + sqlstr + " Order by ID");
m_OrderSet.OrderItem.Clear();
m_OrderSet.Order.Clear();
//try // 讓上一級處理
{
Message("載入" + duration + "售出單...");
m_OrderAdapter.FillBySelectStr(m_OrderSet.Order, "Select * From [Order] " + sqlstr + " Order by ID");
Message("載入" + duration + "售出明細...");
m_OrderItemAdapter.FillBySelectStr(m_OrderSet.OrderItem, "Select * From [OrderItem] " + sqlstr + " Order by ID");
}
//catch (Exception ex) { MessageBox.Show(ex.Message); }
Message("開始計算" + duration + "銷售品總成本...");
progressBar1.Visible = true;
progressBar1.Maximum = m_OrderSet.Order.Count + 1;
int i = 0;
foreach (var item in m_OrderSet.Order)
{
progressBar1.Value = i++;
Application.DoEvents();
if (item.Deleted)
{
continue;
}
if (item.OldID != 0)
{
continue;
}
//var orderItem = from row in OrderItem where (row.ID == item.ID) select row;
//foreach (var item1 in orderItem)
var rows = item.GetOrderItemRows();
foreach (MyOrderSet.OrderItemRow item1 in rows)
{
decimal cost = 0;
if (m_ProductDic.TryGetValue(item1.ProductID, out cost))
{
costtemp += cost * item1.No;
}
}
}
progressBar1.Visible = false;
Application.DoEvents();
return(costtemp);
}
void LoadData(int year, int month, int day)
{
string sql = "80101";
int count = basicDataSet1.Header.Rows.Count;
if (count != 0)
{
BasicDataSet.HeaderRow row = (BasicDataSet.HeaderRow)basicDataSet1.Header.Rows[count - 1]; // 沒指定用最後一個
if (month != 0 && day > 0) // 有指定找到那天
{
foreach (BasicDataSet.HeaderRow r in basicDataSet1.Header.Rows)
{
if (r.DataDate.Month != month)
{
continue;
}
if (r.DataDate.Year != year)
{
continue;
}
if (r.DataDate.Day == day)
{
row = r;
break;
}
}
}
else
{
SetupSelectCombo(row.DataDate.Month);
}
sql = CreateSql(row.DataDate.Year, row.DataDate.Month, row.DataDate.Day);
// "Where INT(ID/10000)=" + (row.DataDate.Year % 100).ToString() + row.DataDate.Month.ToString("d2") + row.DataDate.Day.ToString("d2");
SetTitle(row.DataDate, row.Closed);
}
else
{
sql = CreateSql(2000, 1, 1);
SetTitle(new DateTime(2000, 1, 1), false);
}
MaxID = 0;
try
{
// orderTableAdapter1.Fill(basicDataSet1.Order);
// orderItemTableAdapter1.Fill(basicDataSet1.OrderItem);
if (checkBoxUse12.Checked)
{
BasicDataSet.OrderDataTable temp = new BasicDataSet.OrderDataTable();
m_OrderAdapter.FillBySelectStr(temp, "Select * From [Order] " + sql + " Order by ID");
int todayID = WorkingDay.IDTagHead(year, month, day);
DateTime d = new DateTime(year, month, day);
d = d.Subtract(new TimeSpan(24, 0, 0));
int prevID = WorkingDay.IDTagHead(d.Year, d.Month, d.Day);
basicDataSet1.Order.Clear();
foreach (BasicDataSet.OrderRow r in temp)
{
int idHead = r.ID / 10000;
if (idHead == todayID)
{
if (r.PrintTime.Hour < 7)
{
continue;
}
}
else if (idHead == prevID)
{
if (r.PrintTime.Hour >= 7)
{
continue;
}
}
BasicDataSet.OrderRow oRow = basicDataSet1.Order.NewOrderRow();
oRow.ItemArray = r.ItemArray;
basicDataSet1.Order.AddOrderRow(oRow);
}
}
else
{
m_OrderAdapter.FillBySelectStr(basicDataSet1.Order, "Select * From [Order] " + sql + " Order by ID");
}
m_OrderItemAdapter.FillBySelectStr(basicDataSet1.OrderItem, "Select * From [OrderItem] " + sql);
foreach (BasicDataSet.OrderRow R in basicDataSet1.Order.Rows)
{
int id = R.ID % 10000;
if (id > MaxID)
{
MaxID = id;
}
}
}
catch (Exception ex)
{
string str = ex.Message;
MessageBox.Show("訂菜單資料庫讀取錯誤!");
}
Table2ListView();
}
public bool LoadData(BasicDataSet basicDataSet1, int year, int month, int day, bool Use12)
{
int count = basicDataSet1.Header.Rows.Count;
if (count == 0)
{
return(false);
}
if (month < 1 || month > 12)
{
return(false);
}
if (day < 1 || day > 31)
{
return(false);
}
if (year < 2008 || year > 2020)
{
return(false);
}
BasicDataSet.HeaderRow row;
foreach (BasicDataSet.HeaderRow r in basicDataSet1.Header.Rows)
{
if (r.DataDate.Month != month)
{
continue;
}
if (r.DataDate.Year != year)
{
continue;
}
if (r.DataDate.Day == day)
{
row = r;
goto Yes;
}
}
return(false);
Yes:
string sql = CreateSql(row.DataDate.Year, row.DataDate.Month, row.DataDate.Day, Use12);
try
{
if (Use12)
{
BasicDataSet.OrderDataTable temp = new BasicDataSet.OrderDataTable();
m_OrderAdapter.FillBySelectStr(temp, "Select * From [Order] " + sql + " Order by ID");
int todayID = WorkingDay.IDTagHead(year, month, day);
DateTime d = new DateTime(year, month, day);
d = d.Subtract(new TimeSpan(24, 0, 0));
int prevID = WorkingDay.IDTagHead(d.Year, d.Month, d.Day);
basicDataSet1.Order.Clear();
foreach (BasicDataSet.OrderRow r in temp)
{
int idHead = r.ID / 10000;
if (idHead == todayID)
{
if (r.PrintTime.Hour < 7)
{
continue;
}
}
else if (idHead == prevID)
{
if (r.PrintTime.Hour >= 7)
{
continue;
}
}
BasicDataSet.OrderRow oRow = basicDataSet1.Order.NewOrderRow();
oRow.ItemArray = r.ItemArray;
basicDataSet1.Order.AddOrderRow(oRow);
}
}
else
{
m_OrderAdapter.FillBySelectStr(basicDataSet1.Order, "Select * From [Order] " + sql + " Order by ID");
}
// m_OrderItemAdapter.FillBySelectStr(basicDataSet1.OrderItem, "Select * From [OrderItem] " + sql);
m_WorkingDay.Set(row.DataDate);
return(true);
}
catch (Exception ex)
{
LastErrorString = ex.Message;
}
return(false);
}
