第十篇

查单

上单 下单  首单 末单

这几个都是小角色一看就明白

 

 1 private bool hasSheet()
 2         {
 3             return dt11 == null || Sheetid.Text.Equals("") ? false : true;
 4         }
 5 
 6 
 7 
 8         private void SheetSetValue(DataRow Row, Control parentControl)
 9         {
10             DataColumnCollection columns = Row.Table.Columns;
11             foreach (Control aControl in parentControl.Controls)
12             {
13                 BaseEdit edit = aControl as BaseEdit;
14                 if (edit == null)
15                     continue;
16                 foreach (DataColumn column in columns)
17                 {
18                     if (edit.Name.ToUpper() == column.ColumnName.ToUpper())
19                     {
20                         edit.EditValue = Row[column.ColumnName];
21                     }
22                 }
23             }
24         }
25         #endregion
26 
27 
28         private void FirstSheet_Click(object sender, EventArgs e)
29         {
30             if (!hasSheet())
31                 return;
32             DataRow Row = dt11.Rows[0];
33             GetSheet(Row["单据编号"].ToString(), Row);
34 
35             UpdateAcitonState(AcitonState.FirstSheet);
36         }
37 
38         private void PriviewSheet_Click(object sender, EventArgs e)
39         {
40             if (!hasSheet())
41                 return;
42             DataRow[] Rows = dt11.Select("单据编号 < '" + Sheetid.Text.ToString() + "'");
43             DataRow Row = Rows[Rows.Length - 1];
44             GetSheet(Row["单据编号"].ToString(), Row);
45 
46             UpdateAcitonState(AcitonState.PriviewSheet);
47         }
48 
49         private void NextSheet_Click(object sender, EventArgs e)
50         {
51             if (!hasSheet())
52                 return;
53             DataRow row = dt11.Select("单据编号 > '" + Sheetid.Text.ToString() + "'")[0];
54             GetSheet(row["单据编号"].ToString(), row);
55 
56              UpdateAcitonState(AcitonState.NextSheet);
57         }
58 
59         private void LastSheet_Click(object sender, EventArgs e)
60         {
61             if (!hasSheet())
62                 return;
63 
64             DataRow Row = dt11.Rows[dt11.Rows.Count-1];
65             GetSheet(Row["单据编号"].ToString(), Row);
66 
67             UpdateAcitonState(AcitonState.LastSheet);
68         }