/// <summary>
 /// 上报国家局分拣线数据表
 /// </summary>
 /// <param name="idpsTable"></param>
 public void UploadSortingIdps(DataTable idpsTable)
 {
     foreach (DataRow row in idpsTable.Rows)
     {  //上报分拣细表数据
         using (PersistentManager persistentManager = new PersistentManager("DB2Connection"))
         {
             UploadSortingDao udao = new UploadSortingDao();
             udao.SetPersistentManager(persistentManager);
             string sql = string.Format("INSERT INTO DWV_IDPS_SORTING(SORTING_CODE,SORTING_NAME,SORTING_TYPE,ISACTIVE,UPDATE_DATE," +
             "IS_IMPORT)VALUES('{0}','{1}','{2}','{3}','{4}','{5}')",
             row["LINECODE"], row["LINENAME"], row["LINETYPE"], row["STATUS"], DateTime.Now.ToString("yyyyMMddHHmmss"), row["IS_IMPORT"]);
             udao.setData(sql);
         }
         //修改本地上报状态
         using (PersistentManager persistentManager = new PersistentManager())
         {
             UploadSortingDao udao = new UploadSortingDao();
             string sql = string.Format("UPDATE AS_BI_LINEINFO SET IS_IMPORT=1 WHERE LINECODE='{0}'", row["LINECODE"]);
             udao.setData(sql);
         }
     }
 }
 /// <summary>
 /// 上报国家局分拣数据主表
 /// </summary>
 /// <param name="masterTable"></param>
 public void UploadSortingOrderMaster(DataTable masterTable)
 {
     //上报分拣主表数据
     using (PersistentManager pm = new PersistentManager("DB2Connection"))
     {
         UploadSortingDao udao = new UploadSortingDao();
         udao.SetPersistentManager(pm);
         try
         {
             pm.BeginTransaction();
             foreach (DataRow row in masterTable.Rows)
             {
                 string sql = string.Format("INSERT INTO DWV_IORD_ORDER(ORDER_ID,ORG_CODE,SALE_REG_CODE,ORDER_DATE,ORDER_TYPE," +
                     "CUST_CODE,CUST_NAME,QUANTITY_SUM,AMOUNT_SUM,DETAIL_NUM,ISACTIVE,UPDATE_DATE,IS_IMPORT)VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}',{7},{8},{9},'{10}','{11}','{12}')",
                     row["ORDER_ID"], row["ORG_CODE"], row["SALE_REG_CODE"], Convert.ToDateTime(row["ORDER_DATE"]).ToString("yyyyMMdd"), row["ORDER_TYPE"], row["CUST_CODE"], row["CUST_NAME"],
                     row["QUANTITY_SUM"], row["AMOUNT_SUM"], row["DETAIL_NUM"], row["ISACTIVE"], DateTime.Now.ToString("yyyyMMddHHmmss"), row["IS_IMPORT"]);
                 udao.setData(sql);
             }
             pm.Commit();
         }
         catch (Exception exp)
         {
             pm.Rollback();
             throw exp;
         }
         
     }
 }
 /// <summary>
 /// 上报国家局分拣数据细表
 /// </summary>
 /// <param name="detailTable"></param>
 public void UploadSortingOrderDetail(DataTable detailTable)
 {
     //上报分拣细表数据
     using (PersistentManager pm = new PersistentManager("DB2Connection"))
     {
         UploadSortingDao udao = new UploadSortingDao();
         udao.SetPersistentManager(pm);
         try
         {
             pm.BeginTransaction();
             foreach (DataRow row in detailTable.Rows)
             {
                 string sql = string.Format("INSERT INTO DWV_IORD_ORDER_DETAIL(ORDER_DETAIL_ID,ORDER_ID,BRAND_CODE,BRAND_NAME,BRAND_UNIT_NAME," +
                     "QTY_DEMAND,QUANTITY,PRICE,AMOUNT,IS_IMPORT)VALUES('{0}','{1}','{2}','{3}','{4}',{5},{6},{7},{8},'{9}')",
                     row["ORDER_DETAIL_ID"], row["ORDER_ID"], row["BRAND_CODE"], row["BRAND_NAME"], row["BRAND_UNIT_NAME"], row["QTY_DEMAND"], row["QUANTITY"],
                     row["PRICE"], row["AMOUNT"], row["IS_IMPORT"]);
                 udao.setData(sql);
             }
             pm.Commit();
         }
         catch (Exception exp)
         {
             pm.Rollback();
             throw exp;
         }
     }
 }