private void Next_Click(object sender, RoutedEventArgs e) { DataTable table = new DataTable(); DataColumn column; DataRow row; // column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "产品编号"; table.Columns.Add(column); // column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "市场编号"; table.Columns.Add(column); // column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "数量"; table.Columns.Add(column); // column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "账期"; table.Columns.Add(column); // column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "售价"; table.Columns.Add(column); // // Convert foreach (Order order in orderData) { row = table.NewRow(); row["产品编号"] = (int)order.产品类型; row["市场编号"] = (int)order.市场类型; row["数量"] = order.订购数量; row["账期"] = order.订单账期; row["售价"] = order.订单总价; table.Rows.Add(row); } int year = (int)(App.Current as App).action.year; int season = (int)(App.Current as App).action.season; season = MainAction.ConvertSeason(season); EnterOrderAction enterOrderAction = new EnterOrderAction((App.Current as App).accessDB, year, season, (App.Current as App).action.name); enterOrderAction.addNewOrders(table); (App.Current as App).action.Update(); }
private void Next_Click(object sender, RoutedEventArgs e) { DataTable table = new DataTable(); DataColumn column; DataRow row; // column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "产品编号"; table.Columns.Add(column); // column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "市场编号"; table.Columns.Add(column); // column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "数量"; table.Columns.Add(column); // column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "账期"; table.Columns.Add(column); // column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "售价"; table.Columns.Add(column); // // !!! for (int i = 0; i <= 3; i++) { row = table.NewRow(); row["产品编号"] = i; row["市场编号"] = i + 1; row["数量"] = 2; row["账期"] = 3; row["售价"] = 20; table.Rows.Add(row); } int year = (int)(App.Current as App).action.year; int season = (int)(App.Current as App).action.season; season = MainAction.ConvertSeason(season); EnterOrderAction enterOrderAction = new EnterOrderAction((App.Current as App).accessDB, year, season, (App.Current as App).action.name); enterOrderAction.addNewOrders(table); (App.Current as App).action.Update(); }