コード例 #1
0
        public static void process()
        {
            sqlCe = new CE();
            api = new CERPService();
            dt = new DataTable("table");
            dt = sqlCe.dt(api.GetMaterialIssuance());
            DataRow[] result1 = dt.Select();

            foreach (DataRow m in result1)
            {
                int i = Convert .ToInt32(m["id"]);
                if (!id(i))
                {
                    // save material issuance into local database
                    SaveMaterialIssuance(i,
                    m["request_no"].ToString(),
                    m["batch_no"].ToString(),
                    m["requested_date"].ToString(),
                    m["expected_date"].ToString(),
                    m["remarks"].ToString(),
                    m["completion_status"].ToString());

                    System.Threading.Thread.Sleep(100);

                    // get material issuance items
                    DataRow[] result2 = sqlCe.dt(api.GetMaterialIssuanceItems(i)).Select();
                    foreach (DataRow l in result2)
                    {
                        // save material issuance items into local database
                        SaveMaterialIssuanceItems(i,
                        l["issue_id"].ToString(),
                        l["code"].ToString(),
                        l["lot_no"].ToString(),
                        l["qty"].ToString(),
                        l["status"].ToString(),
                        l["address"].ToString());
                    }
                }
            }
        }
コード例 #2
0
 public static DataTable getMaterialIssuanceItems(int id)
 {
     sqlCe = new CE();
     api = new CERPService();
     return sqlCe.dt(api.GetMaterialIssuanceItems(id));
 }