Esempio n. 1
0
        /**
         * お客データ同期
         */
        private static void CustomerSync()
        {
            DataSet ds = new DataSet();

            if (db.GetCustomerDB(0, 0, "*", "", "", ref ds) && ds.Tables[0].Rows.Count > 0)
            {
                for (int idx = 0; idx < ds.Tables[0].Rows.Count; idx++)
                {
                    string[] fields = new string[14];
                    fields[0]  = ds.Tables[0].Rows[idx]["mail"].ToString();
                    fields[1]  = ds.Tables[0].Rows[idx]["Cname"].ToString();
                    fields[2]  = ds.Tables[0].Rows[idx]["name"].ToString();
                    fields[3]  = ds.Tables[0].Rows[idx]["postcode"].ToString();
                    fields[4]  = ds.Tables[0].Rows[idx]["address"].ToString();
                    fields[5]  = ds.Tables[0].Rows[idx]["tel"].ToString();
                    fields[6]  = ds.Tables[0].Rows[idx]["fax"].ToString();
                    fields[7]  = ds.Tables[0].Rows[idx]["kind"].ToString();
                    fields[8]  = ds.Tables[0].Rows[idx]["format"].ToString();
                    fields[9]  = ds.Tables[0].Rows[idx]["scale"].ToString();
                    fields[10] = ds.Tables[0].Rows[idx]["CYMD"].ToString();
                    fields[11] = ds.Tables[0].Rows[idx]["other"].ToString();
                    fields[12] = ds.Tables[0].Rows[idx]["web"].ToString();
                    fields[13] = ds.Tables[0].Rows[idx]["jCName"].ToString();

                    String strId         = ds.Tables[0].Rows[idx]["id"].ToString();
                    String strDBType     = ds.Tables[0].Rows[idx]["dbType"].ToString();
                    String strServerName = ds.Tables[0].Rows[idx]["ServerName"].ToString();
                    String strUserName   = ds.Tables[0].Rows[idx]["UserName"].ToString();
                    String strPassword   = ds.Tables[0].Rows[idx]["Password"].ToString();
                    String strDBName     = ds.Tables[0].Rows[idx]["DBName"].ToString();
                    String strTableName  = ds.Tables[0].Rows[idx]["TableName"].ToString();
                    if (NCDb.GetAllDBData(strDBType, strServerName, strUserName,
                                          strPassword, strDBName, strTableName, fields, ref ds) && ds.Tables.Count > 0)
                    {
                        int successCount = 0;
                        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                        {
                            int    id        = 0;
                            String valueList = "'" + ds.Tables[0].Rows[i][fields[1]] + "','" + ds.Tables[0].Rows[i][fields[2]]
                                               + "','" + ds.Tables[0].Rows[i][fields[3]] + "','"
                                               + ds.Tables[0].Rows[i][fields[4]] + "','" + ds.Tables[0].Rows[i][fields[5]]
                                               + "','" + ds.Tables[0].Rows[i][fields[6]] + "','" + ds.Tables[0].Rows[i][fields[7]]
                                               + "','" + ds.Tables[0].Rows[i][fields[8]] + "','" + ds.Tables[0].Rows[i][fields[9]]
                                               + "','" + ds.Tables[0].Rows[i][fields[10]] + "','" + ds.Tables[0].Rows[i][fields[11]]
                                               + "','" + ds.Tables[0].Rows[i][fields[12]] + "','" + ds.Tables[0].Rows[i][fields[13]]
                                               + "','" + ds.Tables[0].Rows[i][fields[13]] + "','"
                                               + System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "','Y','" + db.UserID + "'";
                            if (db.SetCustomer(0, 0, "Cname,name,postcode,address,tel,fax,kind,format,scale,CYMD,other,mail,web,jCNAME,createtime,subscripted,UserID",
                                               "", valueList, out id))
                            {
                                successCount++;
                            }
                        }
                    }
                }
            }
        }
Esempio n. 2
0
 /// <summary>
 /// 客户数据库连接测试
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void btnTest_Click(object sender, EventArgs e)
 {
     if (dataGridView1.SelectedRows.Count > 0)
     {
         string[] fields = new string[14];
         fields[0]  = txtMail.Text;
         fields[1]  = txtCname.Text;
         fields[2]  = txtName.Text;
         fields[3]  = txtPostCode.Text;
         fields[4]  = txtAddress.Text;
         fields[5]  = txtTel.Text;
         fields[6]  = txtFax.Text;
         fields[7]  = txtKind.Text;
         fields[8]  = txtFormat.Text;
         fields[9]  = txtScale.Text;
         fields[10] = txtCYMD.Text;
         fields[11] = txtOther.Text;
         fields[12] = txtWeb.Text;
         fields[13] = txtJCname.Text;
         DataSet ds = new DataSet();
         if (NCDb.GetAllDBData(cmbDBType.Text, txtServerName.Text, txtUserName.Text,
                               txtPassword.Text, txtDBName.Text, txtTableName.Text, fields, ref ds) && ds.Tables.Count > 0)
         {
             int successCount = 0;
             for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
             {
                 int    id        = 0;
                 String valueList = "'" + ds.Tables[0].Rows[i][txtCname.Text] + "','" + ds.Tables[0].Rows[i][txtName.Text]
                                    + "','" + ds.Tables[0].Rows[i][txtPostCode.Text] + "','"
                                    + ds.Tables[0].Rows[i][txtAddress.Text] + "','" + ds.Tables[0].Rows[i][txtTel.Text]
                                    + "','" + ds.Tables[0].Rows[i][txtFax.Text] + "','" + ds.Tables[0].Rows[i][txtKind.Text]
                                    + "','" + ds.Tables[0].Rows[i][txtFormat.Text] + "','" + ds.Tables[0].Rows[i][txtScale.Text]
                                    + "','" + ds.Tables[0].Rows[i][txtCYMD.Text] + "','" + ds.Tables[0].Rows[i][txtOther.Text]
                                    + "','" + ds.Tables[0].Rows[i][txtMail.Text] + "','" + ds.Tables[0].Rows[i][txtWeb.Text]
                                    + "','" + ds.Tables[0].Rows[i][txtJCname.Text] + "','"
                                    + System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "','Y','" + db.UserID + "'";
                 if (db.SetCustomer(0, 0, "Cname,name,postcode,address,tel,fax,kind,format,scale,CYMD,other,mail,web,jCNAME,createtime,subscripted,UserID",
                                    "", valueList, out id))
                 {
                     successCount++;
                 }
             }
             string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0126I", db.Language);
             msg = string.Format(msg, ds.Tables[0].Rows.Count.ToString(), successCount.ToString());
             MessageBox.Show(msg);
         }
     }
     else
     {
         string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0119I", db.Language);
         MessageBox.Show(msg);
     }
 }
Esempio n. 3
0
        /// <summary>
        /// 客户数据库同期
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnTest_Click(object sender, EventArgs e)
        {
            for (int ix = 0; ix < dataGridView4.SelectedRows.Count; ix++)
            {
                string  ids = dataGridView4.SelectedRows[ix].Cells[0].Value.ToString();
                DataSet ds  = new DataSet();
                if (db.GetCustomerDB(0, 0, "*", "id=" + ids, "", ref ds) && ds.Tables[0].Rows.Count > 0)
                {
                    for (int idx = 0; idx < ds.Tables[0].Rows.Count; idx++)
                    {
                        string[] fields = new string[14];
                        fields[0]  = ds.Tables[0].Rows[idx]["mail"].ToString();
                        fields[1]  = ds.Tables[0].Rows[idx]["Cname"].ToString();
                        fields[2]  = ds.Tables[0].Rows[idx]["name"].ToString();
                        fields[3]  = ds.Tables[0].Rows[idx]["postcode"].ToString();
                        fields[4]  = ds.Tables[0].Rows[idx]["address"].ToString();
                        fields[5]  = ds.Tables[0].Rows[idx]["tel"].ToString();
                        fields[6]  = ds.Tables[0].Rows[idx]["fax"].ToString();
                        fields[7]  = ds.Tables[0].Rows[idx]["kind"].ToString();
                        fields[8]  = ds.Tables[0].Rows[idx]["format"].ToString();
                        fields[9]  = ds.Tables[0].Rows[idx]["scale"].ToString();
                        fields[10] = ds.Tables[0].Rows[idx]["CYMD"].ToString();
                        fields[11] = ds.Tables[0].Rows[idx]["other"].ToString();
                        fields[12] = ds.Tables[0].Rows[idx]["web"].ToString();
                        fields[13] = ds.Tables[0].Rows[idx]["jCName"].ToString();

                        String strId         = ds.Tables[0].Rows[idx]["id"].ToString();
                        String strDBType     = ds.Tables[0].Rows[idx]["dbType"].ToString();
                        String strServerName = ds.Tables[0].Rows[idx]["ServerName"].ToString();
                        String strUserName   = ds.Tables[0].Rows[idx]["UserName"].ToString();
                        String strPassword   = ds.Tables[0].Rows[idx]["Password"].ToString();
                        String strDBName     = ds.Tables[0].Rows[idx]["DBName"].ToString();
                        String strTableName  = ds.Tables[0].Rows[idx]["TableName"].ToString();
                        if (NCDb.GetAllDBData(strDBType, strServerName, strUserName,
                                              strPassword, strDBName, strTableName, fields, ref ds) && ds.Tables.Count > 0)
                        {
                            int successCount = 0;
                            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                            {
                                int    id        = 0;
                                String valueList = "'" + ds.Tables[0].Rows[i][fields[1]] + "','" + ds.Tables[0].Rows[i][fields[2]]
                                                   + "','" + ds.Tables[0].Rows[i][fields[3]] + "','"
                                                   + ds.Tables[0].Rows[i][fields[4]] + "','" + ds.Tables[0].Rows[i][fields[5]]
                                                   + "','" + ds.Tables[0].Rows[i][fields[6]] + "','" + ds.Tables[0].Rows[i][fields[7]]
                                                   + "','" + ds.Tables[0].Rows[i][fields[8]] + "','" + ds.Tables[0].Rows[i][fields[9]]
                                                   + "','" + ds.Tables[0].Rows[i][fields[10]] + "','" + ds.Tables[0].Rows[i][fields[11]]
                                                   + "','" + ds.Tables[0].Rows[i][fields[12]] + "','" + ds.Tables[0].Rows[i][fields[13]]
                                                   + "','" + ds.Tables[0].Rows[i][fields[13]] + "','"
                                                   + System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "','Y','" + db.UserID + "'";
                                if (db.SetCustomer(0, 0, "Cname,name,postcode,address,tel,fax,kind,format,scale,CYMD,other,mail,web,jCNAME,createtime,subscripted,UserID",
                                                   "", valueList, out id))
                                {
                                    successCount++;
                                }
                            }
                            string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0126I", db.Language);
                            msg = string.Format(msg, ds.Tables[0].Rows.Count.ToString(), successCount.ToString());
                            MessageBox.Show(msg);
                        }
                    }
                }
                Application.DoEvents();
            }
            init();
        }