//如果设置了用户名和密码，刷新企业名称和年份列表
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();
}
