//如果设置了用户名和密码,刷新企业名称和年份列表 private void getQyName(string userName, string userPwd) { NewEnergyWeb.qynameByYear[] qynameByyear = NewEnergyUtils.newEnergyservice.getNerdsQyname(userName, userPwd); DataTable dt = NewEnergyUtils.QyNameInfoS2DT(qynameByyear); if (qynameByyear != null && qynameByyear.Length > 0) { using (OleDbConnection conn = new OleDbConnection(AccessHelper.conn)) { if (conn.State == ConnectionState.Closed) { conn.Open(); } using (var tra = conn.BeginTransaction()) { string sql_delete = "delete from NerdsMFRSName"; AccessHelper.ExecuteNonQuery(tra, sql_delete, null); for (int i = 0; i < dt.Rows.Count; i++) { string sql = String.Format("insert into NerdsMFRSName (MFRSName,ClearYear) values ('{0}','{1}')", dt.Rows[i][0].ToString(), dt.Rows[i][1].ToString()); AccessHelper.ExecuteNonQuery(tra, sql, null); } tra.Commit(); } } } }
//同步 private void btn_synchronize_ItemClick(object sender, ItemClickEventArgs e) { //将接口数据同步 string CompanyName = Settings.Default.Vehicle_MFCS; string UserName = Settings.Default.UserName; string Pwd = Settings.Default.UserPwd; string ClearYear = Settings.Default.ClearYear; try { SplashScreenManager.ShowForm(typeof(DevWaitForm)); NewEnergyWeb.newEnergyVehicle[] NoticeParamArr = NewEnergyUtils.newEnergyservice.getNewEnergyVehicleInfo(UserName, Pwd, "", ClearYear, 1000000, 1); DataTable dt = NewEnergyUtils.NewEnergyInfoS2DT(NoticeParamArr); string columnNameStr = string.Empty; foreach (DataColumn dc in dt.Columns) { columnNameStr += dc.ColumnName + ","; } columnNameStr = columnNameStr.TrimEnd(','); if (NoticeParamArr != null && NoticeParamArr.Length > 0) { using (OleDbConnection conn = new OleDbConnection(AccessHelper.conn)) { if (conn.State == ConnectionState.Closed) { conn.Open(); } AccessHelper.ExecuteNonQuery(AccessHelper.conn, "delete from ANNOUNCE_PARAM"); for (int i = 0; i < dt.Rows.Count; i++) { using (var tra = conn.BeginTransaction()) { string columnValuesStr = string.Empty; for (int j = 0; j < dt.Columns.Count; j++) { columnValuesStr += dt.Rows[i][j].ToString().Trim() + "','"; } string MyChar = "','"; columnValuesStr = columnValuesStr.TrimEnd(MyChar.ToCharArray()); string sql = String.Format("insert into ANNOUNCE_PARAM ({0}) values ('{1}')", columnNameStr, columnValuesStr); AccessHelper.ExecuteNonQuery(tra, sql, null); tra.Commit(); } } } } } catch (Exception ex) { MessageBox.Show("操作出现错误:" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { SplashScreenManager.CloseForm(); } this.SearchParamData(); }