第六篇

 保存之前有1大托的验证吧

 

 保存的时候还要生成KEY值 其实新单直接进数据库没什么不妥的

 

 

 1   private string validateDefine()
 2         {
 3             string stringInfo = "";
 4             if (MannueOrder.Text == "")
 5                 return stringInfo = "请输入手工订单号";
 6             if (DeliveryDate.EditValue == null || DeliveryDate.EditValue == "")
 7                 return stringInfo = "请选择交货日期";
 8             if (SaleCompany.EditValue == "")
 9                 return stringInfo = "请选择销售公司";
10             if (SaleGroup.EditValue == "")
11                 return stringInfo = "请选择销售组织";
12             if (CustomCode.EditValue == "")
13                 return stringInfo = "请选择客户名称";
14             if (DeliveryType.EditValue == "")
15                 return stringInfo = "请选择发运方式";
16             if (moneyType.EditValue == "")
17                 return stringInfo = "请选择币种名称";
18             if (BranchRequire.Text.Trim() == "")
19                 return stringInfo = "请输入分公司备注";
20             if (DateTimeCompareTo(DeliveryDate.EditValue, OrderDate.EditValue) < 0)
21                 return stringInfo = "交货日期早于订单日期 请重新选择";
22 
23             if (TreeDataView != null)
24             {
25                 foreach (DataRow aRow in TreeDataView.Table.Rows)
26                 {
27                     if (aRow.RowState == DataRowState.Deleted)
28                         continue;
29                     if(aRow["数量"].ToString()=="0")
30                         return stringInfo ="订单列表中存在数量为0的纪录";
31                 }
32             }
33 
34             if (GridDataView != null)
35             {
36                 foreach (DataRow aRow in GridDataView.Table.Rows)
37                 {
38                     if (aRow["MARK"].ToString() == "0")
39                         continue;
40                     if (aRow["数量"].ToString() == "0")
41                         return stringInfo = "发运列表中存在数量为0的纪录";
42                 }
43             }
44             return stringInfo;
45         }      

 

 

  private int GetKeyId()
        {
            int i = 0;                                   
              if (Keyid == -1)
            {
                Object obj = SqlHelper.ExecuteScalar(connString, CommandType.Text, @"select max(keyid)+1 from Uld_od_OrderHead");
                if (obj != DBNull.Value)
                    i = (int)obj;               
            }
            else
            {
            }
            return i;
        }