Guest User

Untitled

a guest
Jan 19th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.57 KB | None | 0 0
  1. public void GetWorkorderItems()
  2. {
  3. Workorders wo = new Workorders();
  4. ItemTable = wo.LoadWorkorderItemsTable(_ID);
  5.  
  6.  
  7. this.datagridWorkorderItems.DataSource = ItemTable;
  8. this.datagridWorkorderItems.AutoGenerateColumns = true;
  9. this.datagridWorkorderItems.Columns[0].Visible = false;
  10. this.datagridWorkorderItems.Columns[1].HeaderText = "Qty";
  11. this.datagridWorkorderItems.Columns[1].Width = 100;
  12. this.datagridWorkorderItems.Columns[2].HeaderText = "Part";
  13. this.datagridWorkorderItems.Columns[2].Width = 100;
  14. this.datagridWorkorderItems.Columns[3].HeaderText = "Labor";
  15. this.datagridWorkorderItems.Columns[3].Width = 100;
  16. this.datagridWorkorderItems.Columns[4].HeaderText = "Price";
  17. this.datagridWorkorderItems.Columns[4].Width = 150;
  18. this.datagridWorkorderItems.Columns[5].HeaderText = "Description";
  19. this.datagridWorkorderItems.Columns[5].Width = 150;
  20.  
  21. Parts part = new Parts();
  22. DataTable partdata = new DataTable();
  23. partdata = part.LoadPartTable();
  24. DataGridViewComboBoxColumn pcb = (DataGridViewComboBoxColumn)this.datagridWorkorderItems.Columns[2];
  25. pcb.DataSource = partdata;
  26. pcb.DisplayMember = "PartName";
  27. pcb.ValueMember = "PartID";
  28. datagridWorkorderItems.Columns.Add(pcb);
  29.  
  30. Labor labor = new Labor();
  31. DataTable data = new DataTable();
  32. data = labor.LoadLaborTable();
  33. DataGridViewComboBoxColumn cb = (DataGridViewComboBoxColumn)this.datagridWorkorderItems.Columns[3];
  34. cb.DataSource = data;
  35. cb.DisplayMember = "LaborItem";
  36. cb.ValueMember = "LaborID";
  37. datagridWorkorderItems.Columns.Add(cb);
  38.  
  39. }
  40.  
  41. DataGridViewTextBoxColumn col1 = (DataGridViewTextBoxColumn)this.datagridWorkorderItems.Columns[1];
  42. this.datagridWorkorderItems.Columns[1].DataPropertyName = "Quantity";
  43. this.datagridWorkorderItems.Columns[1].HeaderText = "Qty";
  44. this.datagridWorkorderItems.Columns[1].Width = 100;
  45. this.datagridWorkorderItems.Columns.Add(col1);
  46.  
  47. DataGridViewComboBoxColumn pcb = (DataGridViewComboBoxColumn)this.datagridWorkorderItems.Columns[2];
  48. pcb.DataSource = partdata;
  49. pcb.DisplayMember = "PartName";
  50. pcb.ValueMember = "PartID";
  51. datagridWorkorderItems.Columns.Add(pcb);
  52.  
  53. public void GetWorkorderItems()
  54. {
  55. Workorders wo = new Workorders();
  56. ItemTable = wo.LoadWorkorderItemsTable(_ID);
  57.  
  58. Parts part = new Parts();
  59. DataTable partdata = new DataTable();
  60. partdata = part.LoadPartTable();
  61.  
  62. Labor labor = new Labor();
  63. DataTable data = new DataTable();
  64. data = labor.LoadLaborTable();
  65.  
  66.  
  67. this.datagridWorkorderItems.AutoGenerateColumns = false;
  68.  
  69. DataGridViewTextBoxColumn col0 = new DataGridViewTextBoxColumn();
  70. col0.DataPropertyName = "WOItemID";
  71. col0.Visible = false;
  72. this.datagridWorkorderItems.Columns.Add(col0);
  73.  
  74. DataGridViewTextBoxColumn col1 = new DataGridViewTextBoxColumn();
  75. col1.DataPropertyName = "Quantity";
  76. col1.HeaderText = "Qty";
  77. col1.Width = 100;
  78. this.datagridWorkorderItems.Columns.Add(col1);
  79.  
  80. DataGridViewComboBoxColumn col2 = new DataGridViewComboBoxColumn();
  81. col2.DataPropertyName = "PartID";
  82. col2.DataSource = partdata;
  83. col2.DisplayMember = "PartName";
  84. col2.ValueMember = "PartID";
  85. col2.HeaderText = "Part";
  86. datagridWorkorderItems.Columns.Add(col2);
  87.  
  88. DataGridViewComboBoxColumn col3 = new DataGridViewComboBoxColumn();
  89. col3.DataPropertyName = "LaborID";
  90. col3.DataSource = data;
  91. col3.DisplayMember = "LaborItem";
  92. col3.ValueMember = "LaborID";
  93. col3.HeaderText = "Labor";
  94. datagridWorkorderItems.Columns.Add(col3);
  95.  
  96. DataGridViewTextBoxColumn col4 = new DataGridViewTextBoxColumn();
  97. col4.DataPropertyName = "Price";
  98. col4.HeaderText = "Price";
  99. col4.Width = 100;
  100. this.datagridWorkorderItems.Columns.Add(col4);
  101.  
  102. DataGridViewTextBoxColumn col5 = new DataGridViewTextBoxColumn();
  103. col5.DataPropertyName = "Description";
  104. col5.HeaderText = "Description";
  105. col5.Width = 100;
  106. this.datagridWorkorderItems.Columns.Add(col5);
  107.  
  108. this.datagridWorkorderItems.DataSource = ItemTable;
  109.  
  110. }
  111.  
  112. public ExampleForm()
  113. {
  114. InitializeComponent();
  115. datagridWorkorderItems.AutoGenerateColumns = false;
  116.  
  117. DataGridViewTextBoxColumn qtyColumn = new DataGridViewTextBoxColumn();
  118. qtyColumn.DataPropertyName = "Qty";
  119. qtyColumn.HeaderText = "Qty";
  120. datagridWorkorderItems.Columns.Add(qtyColumn);
  121.  
  122. DataGridViewComboBoxColumn partColumn = new DataGridViewComboBoxColumn();
  123. partColumn.Items.Add(new Part() { ID = 0, PartName = "Tire" });
  124. partColumn.Items.Add(new Part() { ID = 1, PartName = "Motor" });
  125. partColumn.HeaderText = "Part";
  126. partColumn.DataPropertyName = "PartID";
  127. partColumn.ValueMember = "ID";
  128. partColumn.DisplayMember = "PartName";
  129. datagridWorkorderItems.Columns.Add(partColumn);
  130.  
  131. List<WorkOrder> workOrders = new List<WorkOrder>();
  132. workOrders.Add(new WorkOrder() { Qty = 0, PartID = 0});
  133. workOrders.Add(new WorkOrder() { Qty = 2, PartID = 1});
  134.  
  135. datagridWorkorderItems.DataSource = workOrders;
  136. }
  137. }
  138.  
  139. public class WorkOrder
  140. {
  141. public int Qty { get; set; }
  142. public int PartID { get; set; }
  143. }
  144.  
  145. public class Part
  146. {
  147. public int ID { get; set; }
  148. public string PartName { get; set; }
  149. }
Add Comment
Please, Sign In to add comment