public LedgerTableGenerator(Label labelMsg, TitleSetup setup, VEDataSet dataSet1, CalcRevenueDelegate calcRevenue)
#endif
{
LabelMessage = labelMsg;
Setup = setup;
m_DataSet = dataSet1;
CalcRevenue = calcRevenue;
}
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);
}
private void 鎖定資料庫ToolStripMenuItem_Click(object sender, EventArgs e)
{
VoucherExpense.DamaiDataSet DataSet = new DamaiDataSet();
var headerAdapter = new VoucherExpense.DamaiDataSetTableAdapters.VEHeaderTableAdapter();
headerAdapter.Fill(DataSet.VEHeader);
if (DataSet.VEHeader.Count == 0)
{
var row = DataSet.VEHeader.NewVEHeaderRow();
row.Closed = !MyFunction.LockAll;
int y = DateTime.Now.Year;
row.DataYear = new DateTime(y, 1, 1);
DataSet.VEHeader.AddVEHeaderRow(row);
}
var header = DataSet.VEHeader[0];
header.BeginEdit();
header.Closed = !MyFunction.LockAll;
header.EndEdit();
try
{
headerAdapter.Update(header);
}
catch (Exception ex)
{
MessageBox.Show("變更鎖定狀態未成功:" + ex.Message);
return;
}
MyFunction.LockAll = !MyFunction.LockAll;
SetFormTitle();
ToolStripMenuItem i = (ToolStripMenuItem)menu1.Items["查核MenuItem"];
if (MyFunction.LockAll)
{
i.DropDownItems["鎖定資料庫MenuItem"].Text = "解鎖資料庫";
}
else
{
i.DropDownItems["鎖定資料庫MenuItem"].Text = "鎖定資料庫";
}
}
// Operator Apartment 由m_DataSet從上層傳入,
// m_DataSet.OperatorAuthList Copy進來編修
// Save時再回存
public FormOperatorAuthList(int operatorID, DamaiDataSet dataSet)
{
m_OperatorID = operatorID;
m_DataSet = dataSet;
InitializeComponent();
}
private bool ReadTable()
{
operatorSQLAdapter = new DamaiDataSetTableAdapters.OperatorTableAdapter();
headerSQLAdapter = new DamaiDataSetTableAdapters.VEHeaderTableAdapter();
apartmentSQLAdapter = new DamaiDataSetTableAdapters.ApartmentTableAdapter();
authListSQLAdapter = new DamaiDataSetTableAdapters.OperatorAuthListTableAdapter();
operatorSQLAdapter.Connection.ConnectionString = DB.SqlConnectString(m_Cfg);
apartmentSQLAdapter.Connection.ConnectionString = DB.SqlConnectString(m_Cfg);
authListSQLAdapter.Connection.ConnectionString = DB.SqlConnectString(m_Cfg);
damaiDataSet = new DamaiDataSet();
try
{
operatorSQLAdapter.Fill(damaiDataSet.Operator);
headerSQLAdapter.Fill(damaiDataSet.VEHeader);
apartmentSQLAdapter.Fill(damaiDataSet.Apartment);
authListSQLAdapter.Fill(damaiDataSet.OperatorAuthList);
}
catch (Exception ex)
{
MessageBox.Show("操作員資料庫讀取錯誤<" + ex.Message + ">! 無法登入");
return(false);
}
if (damaiDataSet.Operator.Rows.Count == 0)
{
MessageBox.Show("資料庫內沒有設定任何操作員,無法登入");
Close();
return(false);
}
if (damaiDataSet.Apartment.Rows.Count != 0)
{
string Key = "LordAlex";
foreach (var a in damaiDataSet.Apartment)
{
byte[] buf = Encoder.RC2Decrypt(Convert.FromBase64String(a.DatabaseName.Trim()), Key);
string decoded = Encoding.Unicode.GetString(buf);
if (decoded == m_Cfg.Database.Trim()) // 不使用IsCurrent了
{
m_DefaultApartment = a;
break;
}
}
if (m_DefaultApartment == null)
{
MessageBox.Show("部門資料庫內找不到<" + m_Cfg.Database + ">,設定有誤無法登入,請找IT帥哥!");
#if (DEBUG)
m_DefaultApartment = damaiDataSet.Apartment[9];
#else
Close();
return(false);
#endif
}
}
DamaiDataSet.VEHeaderRow header = null;
string sVersion = "";
if (damaiDataSet.VEHeader.Count > 0)
{
header = damaiDataSet.VEHeader[0];
if (!header.IsVersionNull())
{
sVersion = header.Version.Trim();
}
}
CheckAppVersion(sVersion);
return(true);
}
public LedgerTableGenerator(Label labelMsg, TitleSetup setup, DamaiDataSet dataSet1, CalcRevenueDelegate calcRevenue)
// MenualInput代表全部
void CopyDataNotInAccVouch(AccDataSource working, DamaiDataSet sourceDS, DamaiDataSet destDS, DamaiDataSet.AccVouchDetailDataTable accDetailTable)
{
switch (working)
{
case AccDataSource.Bank: destDS.BankDetail.Rows.Clear();
foreach (var r in sourceDS.BankDetail)
{
destDS.BankDetail.ImportRow(r);
}
break;
case AccDataSource.Expense: destDS.Expense.Rows.Clear();
foreach (var r in sourceDS.Expense)
{
destDS.Expense.ImportRow(r);
}
break;
case AccDataSource.PosRevenue: destDS.Header.Rows.Clear();
foreach (var r in sourceDS.Header)
{
destDS.Header.ImportRow(r);
}
break;
case AccDataSource.Shipment: destDS.Shipment.Rows.Clear();
foreach (var r in sourceDS.Shipment)
{
destDS.Shipment.ImportRow(r);
}
break;
case AccDataSource.Voucher: destDS.Voucher.Rows.Clear();
foreach (var r in sourceDS.Voucher)
{
destDS.Voucher.ImportRow(r);
}
break;
default:
destDS.BankDetail.Rows.Clear();
destDS.Expense.Rows.Clear();
destDS.Header.Rows.Clear();
destDS.Shipment.Rows.Clear();
destDS.Voucher.Rows.Clear();
foreach (var r in sourceDS.BankDetail)
{
destDS.BankDetail.ImportRow(r);
}
foreach (var r in sourceDS.Expense)
{
destDS.Expense.ImportRow(r);
}
foreach (var r in sourceDS.Header)
{
destDS.Header.ImportRow(r);
}
foreach (var r in sourceDS.Shipment)
{
destDS.Shipment.ImportRow(r);
}
foreach (var r in sourceDS.Voucher)
{
destDS.Voucher.ImportRow(r);
}
break;
}
//var accDetailRows=from r in accDetailTable
// where (!r.IsSourceDataTypeNull()) && (r.SourceDataID!=(short)AccDataSource.MenualInput)
// orderby r.SourceDataType,r.SourceDataID
// select r ;
foreach (var acc in accDetailTable)
{
if (acc.IsSourceDataTypeNull() || acc.IsSourceDataIDNull())
{
continue;
}
if (acc.SourceDataType == (short)AccDataSource.MenualInput)
{
continue;
}
if (working != AccDataSource.MenualInput)
{
if (acc.SourceDataType != (short)working)
{
continue;
}
}
switch ((AccDataSource)acc.SourceDataType)
{
case AccDataSource.Bank: var bankRow = destDS.BankDetail.FindByID(acc.SourceDataID);
if (bankRow != null)
{
destDS.BankDetail.RemoveBankDetailRow(bankRow);
}
break;
case AccDataSource.Expense: var expenseRow = destDS.Expense.FindByID(acc.SourceDataID);
if (expenseRow != null)
{
destDS.Expense.RemoveExpenseRow(expenseRow);
}
break;
case AccDataSource.PosRevenue:
var posRow = destDS.Header.FindByDataDate(Int2Date(acc.SourceDataID));
if (posRow != null)
{
destDS.Header.RemoveHeaderRow(posRow);
}
break;
case AccDataSource.Shipment:
var shipmentRow = destDS.Shipment.FindByID(acc.SourceDataID);
if (shipmentRow != null)
{
destDS.Shipment.RemoveShipmentRow(shipmentRow);
}
break;
case AccDataSource.Voucher: var voucherRow = destDS.Voucher.FindByID(acc.SourceDataID);
if (voucherRow != null)
{
destDS.Voucher.RemoveVoucherRow(voucherRow);
}
break;
}
}
}
public MonthlyReportData Statics(DamaiDataSet orderSet)
