private void SaleSpendRatio_Load(object sender, EventArgs e)
{
m_OrderSet = m_DataSet;
SetupBindingSource();
var productAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ProductTableAdapter();
var ingredientAdapter = new VoucherExpense.DamaiDataSetTableAdapters.IngredientTableAdapter();
var voucherAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherTableAdapter();
var voucherDetailAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherDetailTableAdapter();
productAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
ingredientAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
try
{
productAdapter.Fill(m_OrderSet.Product);
ingredientAdapter.Fill(m_DataSet.Ingredient);
voucherAdapter.Fill(m_DataSet.Voucher);
voucherDetailAdapter.Fill(m_DataSet.VoucherDetail);
}
catch (Exception ex)
{
MessageBox.Show("資料庫讀取錯誤<" + ex.Message + ">, 後續操作無法進行!");
Close();
return;
}
cSaleItemBindingSource.DataSource = m_SaleList;
this.dgViewSale.DataSource = cSaleItemBindingSource;
stockItemBindingSource.DataSource = m_StockList;
this.dgViewStock.DataSource = stockItemBindingSource;
Reload();
}
public FormShiftDetail(MyDataSet dataSet, MyShiftRow row, List <CShiftCode> list)
{
m_DataSet = dataSet;
Row = row;
m_ShiftCodeList = list;
InitializeComponent();
}
public FormRecipePriceUpdate(decimal packageNo, decimal bakedNo, MyRecipeDetailRow[] details, MyDataSet dataSet)
{
m_PackageNo = packageNo;
m_BakedNo = bakedNo;
m_Details = details;
m_DataSet = dataSet;
InitializeComponent();
}
private void FormScraps_Load(object sender, EventArgs e)
{
m_OrderSet = m_DataSet;
var productAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ProductTableAdapter();
var operatorAdapter = new VoucherExpense.DamaiDataSetTableAdapters.OperatorTableAdapter();
productAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
operatorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
SetupBindingSource();
productScrappedDetailBindingSource1.DataSource = productScrappedBindingSource;
dgvScrappedDetail.DataSource = this.productScrappedDetailBindingSource1;
try
{
productAdapter.Fill(m_OrderSet.Product);
operatorAdapter.Fill(m_DataSet.Operator);
ProductScrappedAdapter.Fill(m_DataSet.ProductScrapped);
ProductScrappedDetailAdapter.Fill(m_DataSet.ProductScrappedDetail);
}
catch (Exception ex)
{
MessageBox.Show("錯誤:" + ex.Message);
}
List <string> scrapeTypeList = new List <string> {
" ", "日報癈", "試吃", "其他"
};
int i = 0;
foreach (string s in scrapeTypeList)
{
m_TableTypeList.Add(new CNameIDForComboBox(i++, s));
}
checkBox1.Text = scrapeTypeList[1];
checkBox2.Text = scrapeTypeList[2];
checkBox3.Text = scrapeTypeList[3];
fromPicker.MaxDate = toPicker.MaxDate = new DateTime(MyFunction.IntHeaderYear, 12, 31);
toPicker.MinDate = toPicker.MinDate = new DateTime(MyFunction.IntHeaderYear, 1, 1);
cNameIDForComboBoxBindingSource.DataSource = m_TableTypeList;
ColumnLocked.ReadOnly = !MyFunction.LockInventory;
}
private void ReportByTitle_Load(object sender, EventArgs e)
{
var headerAdapter = new MyHeaderAdapter();
m_OrderSet = m_DataSet;
var accTitleAdapter = new VoucherExpense.DamaiDataSetTableAdapters.AccountingTitleTableAdapter();
var bankAccountAdapter = new VoucherExpense.DamaiDataSetTableAdapters.BankAccountTableAdapter();
var expenseAdapter = new VoucherExpense.DamaiDataSetTableAdapters.ExpenseTableAdapter();
var voucherAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherTableAdapter();
var voucherDetailAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VoucherDetailTableAdapter();
var bankDetailAdapter = new VoucherExpense.DamaiDataSetTableAdapters.BankDetailTableAdapter();
var accVoucherAdapter = new VoucherExpense.DamaiDataSetTableAdapters.AccVoucherTableAdapter();
accTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
try
{
headerAdapter.Fill(m_OrderSet.Header);
}
catch { MessageBox.Show("標頭資料讀取錯誤,你的資料庫版本可能不對"); }
int count = m_OrderSet.Header.Count;
if (count == 0)
{
MessageBox.Show("無資料!");
Close();
return;
}
var row = m_OrderSet.Header[count - 1];
Revenue = new RevenueCalcBakery(row.DataDate, 0);
AccList.NewAll();
BankDictionary = new Dictionary <int, BankDefault>();
RevenueCache = new MonthlyReportData[12];
MonthBalances = new CMonthBalance[13];
for (int i = 0; i < 13; i++)
{
MonthBalances[i] = new CMonthBalance();
MonthBalances[i].Month = i + 1;
}
MonthBalances[12].Month = 0; // 第13月統計用
cMonthBalanceBindingSource.DataSource = MonthBalances;
string[] Name = new string[6] {
"資產", "負債", "收入", "成本", "費用", "股東權益"
};
comboBox1.Items.Clear();
comboBox2.Items.Clear();
foreach (string str in Name)
{
comboBox1.Items.Add(str);
comboBox2.Items.Add(str);
}
try
{
accTitleAdapter.Fill(m_DataSet.AccountingTitle);
bankAccountAdapter.Fill(m_DataSet.BankAccount);
expenseAdapter.Fill(m_DataSet.Expense); // expense檔案小,先全部讀進記憶體
voucherAdapter.Fill(m_DataSet.Voucher);
voucherDetailAdapter.Fill(m_DataSet.VoucherDetail);
bankDetailAdapter.Fill(m_DataSet.BankDetail);
accVoucherAdapter.Fill(m_DataSet.AccVoucher);
foreach (var r in m_DataSet.AccountingTitle)
{
AccTitle item = new AccTitle(r.TitleCode, r.Name);
if (r.IsInitialValueNull())
{
item.Money = 0;
}
else
{
item.Money = r.InitialValue;
}
if (r.TitleCode.Length == 0)
{
continue;
}
AccList.Add(item);
}
AccList1.CopyTableFrom(AccList);
foreach (var r in m_DataSet.BankAccount)
{
BankDictionary.Add(r.ID, new BankDefault(r.AccountTitleCode, r.DefaultTitleCode));
}
comboBox1.SelectedIndex = 0;
comboBox2.SelectedIndex = 1;
comboBoxStart.SelectedIndex = MyFunction.IntHeaderMonth;
Setup.Load();
dataGridView1.Focus();
}
catch
{
MessageBox.Show("資料庫讀取錯誤!");
}
}
private void FormLedger_Load(object sender, EventArgs e)
{
accountingTitleBindingSource.DataSource = m_DataSet;
m_OrderSet = m_DataSet;
try
{
headerAdapter.Fill(m_DataSet.Header);
}
catch { MessageBox.Show("標頭資料讀取錯誤,你的資料庫版本可能不對"); }
int count = m_DataSet.Header.Count;
if (count == 0)
{
MessageBox.Show("無資料!");
Close();
return;
}
var row = m_DataSet.Header[count - 1];
m_Revenue = new RevenueCalcBakery(row.DataDate, 0);
AccList.NewAll();
var accTitleAdapter = new DamaiDataSetTableAdapters.AccountingTitleTableAdapter();
var bankAccountAdapter = new DamaiDataSetTableAdapters.BankAccountTableAdapter();
var expenseAdapter = new DamaiDataSetTableAdapters.ExpenseTableAdapter();
var voucherAdapter = new DamaiDataSetTableAdapters.VoucherTableAdapter();
var voucherDetailAdapter = new DamaiDataSetTableAdapters.VoucherDetailTableAdapter();
var bankDetailAdapter = new DamaiDataSetTableAdapters.BankDetailTableAdapter();
var accVoucherAdapter = new DamaiDataSetTableAdapters.AccVoucherTableAdapter();
var vendorAdapter = new DamaiDataSetTableAdapters.VendorTableAdapter();
var ingredientAdapter = new DamaiDataSetTableAdapters.IngredientTableAdapter();
try
{
ingredientAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
accTitleAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
vendorAdapter.Connection.ConnectionString = DB.SqlConnectString(MyFunction.HardwareCfg);
accTitleAdapter.Fill(m_DataSet.AccountingTitle);
bankAccountAdapter.Fill(m_DataSet.BankAccount);
expenseAdapter.Fill(m_DataSet.Expense); // expense檔案小,先全部讀進記憶體
voucherAdapter.Fill(m_DataSet.Voucher);
voucherDetailAdapter.Fill(m_DataSet.VoucherDetail);
bankDetailAdapter.Fill(m_DataSet.BankDetail);
accVoucherAdapter.Fill(m_DataSet.AccVoucher);
vendorAdapter.Fill(m_DataSet.Vendor);
ingredientAdapter.Fill(m_DataSet.Ingredient);
foreach (var r in m_DataSet.AccountingTitle)
{
AccTitle item = new AccTitle(r.TitleCode, r.Name);
if (r.IsInitialValueNull())
{
item.Money = 0;
}
else
{
item.Money = r.InitialValue;
}
if (r.TitleCode.Length == 0)
{
continue;
}
AccList.Add(item);
}
AccList1.CopyTableFrom(AccList);
Setup.Load();
m_Generator = new LedgerTableGenerator(labelMessage, Setup, m_DataSet, new CalcRevenueDelegate(CalcRevenue));
cLedgerTableDataGridView.Focus();
}
catch (Exception ex)
{
MessageBox.Show("資料庫讀取錯誤! 原因:" + ex.Message);
}
// 設置comboBoxAccTitle的初值為 <零用金>
if (m_DataSet.BankAccount.Rows.Count > 1)
{
var bank = m_DataSet.BankAccount[0];
if (bank.IsAccountTitleCodeNull())
{
comboBoxAccTitle.SelectedIndex = 0;
}
else
{
comboBoxAccTitle.SelectedValue = bank.AccountTitleCode;
}
}
DontRefresh = false; // Form剛Load不Refresh DataGridView
}
private void FormInitNewYear_Load(object sender, EventArgs e)
{
try
{
m_OrderSet = m_DataSet;
var veHeaderAdapter = new DamaiDataSetTableAdapters.VEHeaderTableAdapter();
veHeaderAdapter.Fill(m_DataSet.VEHeader);
}
catch
{
MessageBox.Show("標頭資料讀取錯誤,你的資料庫版本可能不對");
Close();
return;
}
string path = Application.ExecutablePath;
int len = path.Length;
if (path[len - 1] == '\\')
{
path = path.Substring(0, len - 1); // 去掉最後面的 \
}
len = path.LastIndexOf('\\');
if (len > 0)
{
path = path.Substring(0, len); // 取路
}
DateTime dt = DateTime.Now;
int count = m_DataSet.VEHeader.Rows.Count;
if (count != 0)
{
var row = (DamaiDataSet.VEHeaderRow)m_DataSet.VEHeader.Rows[count - 1]; // 沒指定用最後一個
dt = row.DataYear;
}
m_Year = dt.Year + 1;
NewSqlDB = m_HCfg.Database;
int n = NewSqlDB.Length - 1;
for (; n > 0; n--)
{
if (!char.IsDigit(NewSqlDB[n]))
{
break;
}
}
NewSqlDB = NewSqlDB.Substring(0, n + 1) + m_Year.ToString();
labelYear.Text = "原資料年是 " + dt.Year.ToString() + " 將啟始" + m_Year.ToString() + "年資料";
labelNote.Text = "新年度資料將被放在資料庫[" + NewSqlDB + "] 設定檔HardwareCfg.xml放置於" + System.Net.Dns.GetHostName() + "的";
m_Dir = path + "\\Manage" + m_Year.ToString();
labelPath.Text = m_Dir;
// SQL Server只要一個Table
chListBoxBasic.Visible = false;
List <string> list2 = GetTableName(m_DataSet);
foreach (string s in list2)
{
if (s == "Header")
{
continue; // Header要特殊處理
}
if (s == "VEHeader")
{
continue; // VEHeader要特殊處理
}
if (ReservedTable.Contains(s))
{
chListBoxVE.Items.Add(s, true);
}
else
{
chListBoxVE.Items.Add(s, false);
}
}
}
