protected override void WriteHeader()
{
int rptWidth = _table.Columns.Count;
int row = 1;
DatabaseSet.工作單DataTable wsTable = 工作單TableAdapter.Instance.GetBy單號(_worksheetNo);
DatabaseSet.工作單Row wsRow = (DatabaseSet.工作單Row)wsTable.Rows[0];
Range range;
range = this.SheetAdapter.GetRange(row, 1, row, rptWidth);
range.MergeCells = true;
range.HorizontalAlignment = XlHAlign.xlHAlignCenter;
this.SheetAdapter[range] = "安天德百電股份有限公司(ITW Electronic Business Asia Co.,Ltd.)";
row++;
range = this.SheetAdapter.GetRange(row, 1, row, rptWidth);
range.MergeCells = true;
range.Font.Size = 15;
range.Font.Bold = true;
range.HorizontalAlignment = XlHAlign.xlHAlignCenter;
this.SheetAdapter[range] = "製 造 部 訂 料 通 知 單";
row++;
range = this.SheetAdapter.GetRange(row, 1, row, rptWidth);
range.MergeCells = true;
range.HorizontalAlignment = XlHAlign.xlHAlignCenter;
this.SheetAdapter[range] = "* * * * * * * * * * * * * * * *";
row++;
//string line = DatabaseSet.GetLineByWorksheetNo(_worksheetNo);
//DatabaseSet.產線DataTable lineTable = 產線TableAdapter.Instance.GetDataByLine(line);
//DatabaseSet.產線Row lineRow = (DatabaseSet.產線Row)lineTable.Rows[0];
//this.SheetAdapter[row, 1] = "協 力 廠: " + lineRow.代號;
this.SheetAdapter[row, 1] = "協 力 廠: " + _gangerName;
range = this.SheetAdapter.GetRange(row, rptWidth - 1);
range.HorizontalAlignment = XlHAlign.xlHAlignRight;
this.SheetAdapter[range] = "日期: ";
range = this.SheetAdapter.GetRange(row, rptWidth);
range.HorizontalAlignment = XlHAlign.xlHAlignLeft;
this.SheetAdapter[range] = wsRow.單據日期.ToString("yyyy/MM/dd");
row++;
range = this.SheetAdapter.GetRange(row, rptWidth - 1);
range.HorizontalAlignment = XlHAlign.xlHAlignRight;
this.SheetAdapter[range] = "編號: ";
range = this.SheetAdapter.GetRange(row, rptWidth);
range.NumberFormat = "0";
range.HorizontalAlignment = XlHAlign.xlHAlignLeft;
this.SheetAdapter[range] = wsRow.單號;
row++;
base.WriteHeader();
}
private void dgvWorksheet_SelectionChanged(object sender, EventArgs e)
{
if (_raiseDgvWorksheetSelectionChangedEvent)
{
if (bsWorksheet.Current != null)
{
DatabaseSet.工作單Row row = (bsWorksheet.Current as DataRowView).Row as DatabaseSet.工作單Row;
bsPart.DataSource = 工作單品號TableAdapter.Instance.GetBy單號(row.單號);
}
else
{
bsPart.DataSource = null;
}
}
}
private void btnDelWorksheet_Click(object sender, EventArgs e)
{
try
{
if (bsWorksheet.Current != null)
{
DatabaseSet.工作單Row row = (bsWorksheet.Current as DataRowView).Row as DatabaseSet.工作單Row;
string worksheet = row.單號;
OleDbConnection conn = DbConnection.Instance;
conn.Open();
string cmdText = "SELECT COUNT(*) FROM 工時 WHERE 工作單號 = ? ";
OleDbParameter paramWs = new OleDbParameter("工作單號", worksheet);
OleDbCommand cmd = new OleDbCommand(cmdText, conn);
cmd.Parameters.Add(paramWs);
int result = (int)cmd.ExecuteScalar();
if (result != 0)
{
MessageBox.Show("工作單 '" + worksheet + "' 已有工時資料登記，無法刪除。");
}
else if (MessageBox.Show("確定刪除工作單 " + worksheet + " 及其所有相關資料?\n(LaborWage程式裡的相關資料並不會被刪除)", "刪除提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
row.Delete();
MessageBox.Show("刪除了" + 工作單TableAdapter.Instance.Update(row) + "筆資料");
}
conn.Close();
}
}
catch (Exception ex)
{
Global.ShowError(ex);
}
}
