Пример #1
0
        private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                this.textBox1.AppendText("Start..." + Environment.NewLine);

                //strat get U2 data

                U2ConnectionStringBuilder conn_bldr = new U2ConnectionStringBuilder();
                conn_bldr.UserID = "admin";
                conn_bldr.Password = "******";
                conn_bldr.Server = "192.168.102.132";
                conn_bldr.ServerType = "universe";
                conn_bldr.Database = "HS.SALES";
                conn_bldr.AccessMode = "Native";
                conn_bldr.RpcServiceType = "uvcs";
                string lConnStr = conn_bldr.ConnectionString;
                U2Connection lConn = new U2Connection();
                lConn.ConnectionString = lConnStr;
                lConn.Open();
                Console.WriteLine("Connected...");
                U2Command cmd = lConn.CreateCommand();

                // CUSTID,FNAME,LNAME : Single Value
                //PRODID, BUY_DATE    : Multi Value
                //Syntax : Action=?;File=?;Attributes=?;Where=?;Sort

                cmd.CommandText = string.Format("Action=Select;File=CUSTOMER;Attributes=CUSTID,FNAME,LNAME,PRODID,BUY_DATE;Where=CUSTID>0;Sort=CUSTID");

                U2DataAdapter da = new U2DataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);
                DataTable dt = ds.Tables[0];

                //end get U2 data

                //load table storage
                string lTableStorageName = "CUSTOMER3";
                StorageCredentials creds = new StorageCredentials(accountName, accountKey);
                CloudStorageAccount account = new CloudStorageAccount(creds, useHttps: true);
                CloudTableClient client = account.CreateCloudTableClient();
                CloudTable table = client.GetTableReference("CUSTOMER6");
                table.CreateIfNotExists();
                string lUri = table.Uri.ToString();
                //  Console.WriteLine(table.Uri.ToString());
                this.textBox1.AppendText(lUri + Environment.NewLine);
                foreach (DataRow item in dt.Rows)
                {
                    var t1 = item["CUSTID"].ToString();
                    var t2 = item["Z_MV_KEY"].ToString();
                    DateTime lhiredate;
                    if (item["BUY_DATE"] == DBNull.Value)
                    {
                        lhiredate = DateTime.Now;// new DateTime();
                    }
                    else
                    {
                        lhiredate = (DateTime)item["BUY_DATE"];
                    }
                    CustomerEntity entity = new CustomerEntity(t1,t2)
                    {
                        FNAME = (string)item["FNAME"],
                        LNAME = (string)item["LNAME"],
                        PRODID = (string)item["PRODID"],
                        BUY_DATE = lhiredate
                    };
                    TableOperation insertOperation = TableOperation.InsertOrReplace(entity);
                    table.Execute(insertOperation);
                    this.textBox1.AppendText("Entity inserted!" + Environment.NewLine);
                }
                this.textBox1.AppendText("End..." + Environment.NewLine);
            }

            catch (Exception ex)
            {

                this.textBox1.AppendText(ex.Message + Environment.NewLine);

            }

        }