private void MonthlyReport_Load(object sender, EventArgs e)
{
decimal FeeRate = 1.8m;
try
{
headerTableAdapter1.Connection = MapPath.BasicConnection;
headerTableAdapter1.Fill(basicDataSet1.Header);
TitleSetup Setup = new TitleSetup();
Setup.Load();
FeeRate = Setup.FeeRate();
}
catch
{
MessageBox.Show("標頭資料讀取錯誤,你的資料庫版本可能不對");
}
int count = basicDataSet1.Header.Count;
if (count == 0)
{
MessageBox.Show("無資料!");
Close();
return;
}
BasicDataSet.HeaderRow row = basicDataSet1.Header[count - 1];
Revenue = new RevenueCalc(row.DataDate, FeeRate / 100);
comboBoxMonth.SelectedIndex = row.DataDate.Month - 1;
labelFeeRate.Text = FeeRate.ToString() + "%";
}
private void FormBrowse_Load(object sender, EventArgs e)
{
/*
* if (!File.Exists(MDB_Name))
* {
* MessageBox.Show("資料庫不存在,無資料庫後續無法執行!", "", MessageBoxButtons.OK);
* Close();
* return;
* }
*/
m_OrderAdapter.Connection = MapPath.BasicConnection;
m_OrderItemAdapter.Connection = MapPath.BasicConnection;
try
{
BasicDataSetTableAdapters.ProductTableAdapter adapter = new BasicDataSetTableAdapters.ProductTableAdapter();
adapter.Connection = MapPath.BasicConnection;
adapter.Fill(basicDataSet1.Product);
}
catch
{
MessageBox.Show("菜單酒水資料庫讀取錯誤, 後續動作無法正常");
}
try
{
headerTableAdapter1.Connection = MapPath.BasicConnection;
headerTableAdapter1.Fill(basicDataSet1.Header);
}
catch
{
MessageBox.Show("標頭資料讀取錯誤,你的資料庫版本可能不對");
}
int count = basicDataSet1.Header.Rows.Count;
DateTime dt;
if (count != 0)
{
BasicDataSet.HeaderRow row = (BasicDataSet.HeaderRow)basicDataSet1.Header.Rows[count - 1]; // 沒指定用最後一個
dt = row.DataDate;
SetupSelectCombo(row.DataDate.Month);
}
else
{
dt = new DateTime(2008, 1, 1);
SetupSelectCombo(1);
}
LoadData(dt.Year, dt.Month, dt.Day);
}
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();
}
