第十二篇

具体的取值赋值在这个方法也有很大的作用

  

  1   private void SheetHeadSetValue(DataRow SheetHead)
  2         {
  3             DataRow[] rows;
  4 
  5             Sheetid.Text = SheetHead["SheetID"].ToString();
  6             OrderDate.EditValue = SheetHead["orderdate"];
  7             MannueOrder.Text = SheetHead["MannueOrder"].ToString(); ;
  8             DeliveryDate.EditValue = SheetHead["DeliveryDate"];
  9             ContractNo.Text = SheetHead["ContractNo"].ToString();
 10 
 11             if (dt15 == null)
 12                 dt15 = SqlHelper.ExecuteDataTable(connString, @"select i_id [编码],cexch_name [名称] from  foreigncurrency");
 13             rows = dt15.Select(@"名称='" + SheetHead["moneyType"].ToString() + "'");
 14             if (rows.Length > 0)
 15             {
 16                 moneyType.Tag = rows[0]["编码"];// SheetHead["moneyType"];
 17                 moneyType.EditValue = SheetHead["moneyType"].Equals("") ? "" : rows[0]["名称"];
 18             }
 19 
 20             if (dt17 == null)
 21                 dt17 = SqlHelper.ExecuteDataTable(connString, @"select Code [编码],Name [名称] from  Uld_od_factoryName");
 22             rows = dt17.Select(@"名称='" + SheetHead["factory"].ToString() + "'");
 23             if (rows.Length > 0)
 24             {
 25                 factory.Tag = rows[0]["编码"];// SheetHead["moneyType"];
 26                 factory.EditValue = SheetHead["factory"].Equals("") ? "" : rows[0]["名称"];
 27             }
 28            
 29              
 30 
 31             if (dt16== null)
 32                 dt16 = SqlHelper.ExecuteDataTable(connString, @"Select   EnumName [订单名称],EnumIndex [订单编码] from v_aa_enum  where EnumType='IM.Relation'");
 33             rows = dt16.Select("订单编码='" + SheetHead["OrderNature"].ToString() + "'");
 34 
 35             if (rows.Length > 0)
 36             {
 37                 OrderNature.Tag = SheetHead["OrderNature"];
 38                 OrderNature.EditValue = SheetHead["OrderNature"].Equals("") ? "" : rows[0]["订单名称"];
 39             }
 40 
 41 
 42 
 43             if (dt2 == null)
 44                 dt2 = SqlHelper.ExecuteDataTable(connString, @"select cSTCode [编码],cSTName [名称] from  SaleType");                        
 45             rows = dt2.Select("编码='" + SheetHead["OrderType"].ToString() + "'");
 46             if (rows.Length > 0)
 47             {
 48                 OrderType.Tag = SheetHead["OrderType"];
 49                 OrderType.EditValue = SheetHead["OrderType"].Equals("") ? "" : rows[0]["名称"];
 50             }
 51 
 52                         
 53             FRemark.Text = SheetHead["FRemark"].ToString();
 54 
 55             if (dt1 == null)
 56                 dt1 = SqlHelper.ExecuteDataTable(connString, @"Select  cSCName [发运名称] , cSCCode [发运编码] From  shippingchoice");
 57 
 58             rows = dt1.Select("发运编码='" + SheetHead["DeliveryType"].ToString() + "'");
 59             if (rows.Length > 0)
 60             {
 61                 DeliveryType.Tag = SheetHead["DeliveryType"];
 62                 DeliveryType.EditValue = SheetHead["DeliveryType"].Equals("") ? "" : rows[0]["发运名称"];
 63             }
 64 
 65           
 66             
 67             ProductGroup.EditValue = SheetHead["ProductGroup"];
 68 
 69             //QulityLevel.EditValue=SheetHead["QulityLevel"];
 70             
 71             
 72             if(dt4==null)
 73                 dt4 = SqlHelper.ExecuteDataTable(connString, @"select cWhName [仓库名称] , cWhCode [仓库编码]  from   Warehouse ");
 74             rows = dt4.Select("仓库编码='" + SheetHead["WareRoom"].ToString() + "'");
 75             if (rows.Length > 0)
 76             {
 77                 WareRoom.Tag = SheetHead["WareRoom"];
 78                 WareRoom.EditValue = SheetHead["WareRoom"].Equals("") ? "" : rows[0]["仓库名称"];
 79             }
 80 
 81 
 82             if (dt7 == null)
 83                 dt7 = SqlHelper.ExecuteDataTable(connString, sqlCustomer);
 84             rows = dt7.Select("ccuscode='" + SheetHead["FctCustomNo"].ToString() + "'");
 85             if (rows.Length > 0)
 86             {
 87                 FctCustomNo.Tag = SheetHead["FctCustomNo"];
 88                 FctCustomNo.EditValue = SheetHead["FctCustomNo"].Equals("") ? "" : rows[0]["ccusname"];
 89             }
 90             
 91            
 92 
 93             BranchRequire.Text = SheetHead["BranchRequire"].ToString(); ;
 94             FRemark.Text = SheetHead["FRemark"].ToString(); ;
 95             PackRequire.Text = SheetHead["PackRequire"].ToString(); ;
 96             //ConfirmReason.EditValue = SheetHead["ConfirmReason"];
 97 
 98             if (dt6 == null)
 99                 dt6 = SqlHelper.ExecuteDataTable(connString, sqlCompany);
100 
101             rows = dt6.Select("编码='" + SheetHead["SaleCompany"].ToString() + "'");
102             if (rows.Length > 0)
103             {
104                 SaleCompany.Tag = SheetHead["SaleCompany"];
105                 SaleCompany.EditValue = SheetHead["SaleCompany"].Equals("") ? "" : rows[0]["名称"];
106             }
107 
108             rows = dt6.Select("编码='" + SheetHead["SaleGroup"].ToString() + "'");
109             if (rows.Length > 0)
110             {
111                 SaleGroup.Tag = SheetHead["SaleGroup"];
112                 SaleGroup.EditValue = SheetHead["SaleGroup"].Equals("") ? "" : rows[0]["名称"];
113             }
114 
115             if (dt5 != null)
116             {
117                 rows = dt5.Select("编码='" + SheetHead["CustomCode"].ToString() + "'");
118                 if (rows.Length > 0)
119                 {
120                     CustomCode.Tag = SheetHead["CustomCode"];
121                     CustomCode.EditValue = SheetHead["CustomCode"].Equals("") ? "" : rows[0]["名称"];
122                 }
123             }
124 
125         }