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); } }