public InspectListReportForm()
{
InitializeComponent();
DateTime today = DateTime.Today;
dtpFrom.Value = new DateTime(today.Year, today.Month, 1);
dtpTo.Value = new DateTime(today.Year, today.Month, DateTime.DaysInMonth(today.Year, today.Month));
DataTable lineTable = DatabaseSet.產線Table.Copy();
lineTable.Columns.Add("Display", typeof(string));
foreach (DataRow row in lineTable.Rows)
row["Display"] = row["產線"];
DataRow allRow = lineTable.NewRow();
allRow["產線"] = string.Empty;
allRow["Display"] = "全部";
lineTable.Rows.Add(allRow);
lineTable.DefaultView.Sort = "產線";
cbxLine.DataSource = lineTable;
cbxLine.DisplayMember = "Display";
cbxLine.ValueMember = "產線";
_sortForm = new InspectListReportSortForm();
_sortForm.Columns = new SortColumn[] {
new SortColumn("產線"),
new SortColumn("QCN", "QC#"),
new SortColumn("品號", "料號"),
new SortColumn("工作單號"),
new SortColumn("檢驗日期")
};
}
public InspectListReportForm()
{
InitializeComponent();
DateTime today = DateTime.Today;
dtpFrom.Value = new DateTime(today.Year, today.Month, 1);
dtpTo.Value = new DateTime(today.Year, today.Month, DateTime.DaysInMonth(today.Year, today.Month));
DataTable lineTable = DatabaseSet.產線Table.Copy();
lineTable.Columns.Add("Display", typeof(string));
foreach (DataRow row in lineTable.Rows)
{
row["Display"] = row["產線"];
}
DataRow allRow = lineTable.NewRow();
allRow["產線"] = string.Empty;
allRow["Display"] = "全部";
lineTable.Rows.Add(allRow);
lineTable.DefaultView.Sort = "產線";
cbxLine.DataSource = lineTable;
cbxLine.DisplayMember = "Display";
cbxLine.ValueMember = "產線";
_sortForm = new InspectListReportSortForm();
_sortForm.Columns = new SortColumn[] {
new SortColumn("產線"),
new SortColumn("QCN", "QC#"),
new SortColumn("品號", "料號"),
new SortColumn("工作單號"),
new SortColumn("檢驗日期")
};
}
