/// <summary>
/// 生成燃料消耗量数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barBtnGenerate_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (!this.CheckAllDataReady())
{
return;
}
try
{
DataSet ds = this.GetReadyDataFromLocalCoc();
NissanUtils nissanUtils = new NissanUtils();
string msg = nissanUtils.SaveParam(ds);
if (string.IsNullOrEmpty(msg))
{
this.ShowLocalReadyData();
MessageBox.Show("生成成功", "生成成功");
}
else
{
MessageForm mf = new MessageForm("以下数据已经存在\r\n" + msg);
Utils.SetFormMid(mf);
mf.Text = "生成结果";
mf.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show("燃料消耗量数据生成失败：" + ex.Message, "生成失败");
}
}
/// <summary>
/// 更新主表关联燃料数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdate_Click(object sender, EventArgs e)
{
string message = string.Empty;
string strCon = AccessHelper.conn;
DataTable dtCtny = this.GetMainData("CTNY");
DataTable dtFcds = this.GetMainData("FCDS");
DataTable dtCdd = this.GetMainData("CDD");
NissanUtils nissanUtil = new NissanUtils();
DataTable dtCtnyPam = nissanUtil.GetRllxData("传统能源");
DataTable dtFcdsPam = nissanUtil.GetRllxData("非插电式混合动力");
DataTable dtCddPam = nissanUtil.GetRllxData("纯电动");
using (OleDbConnection con = new OleDbConnection(strCon))
{
con.Open();
try
{
foreach (string vin in vinList)
{
DataRow[] drCtny = dtCtny.Select(String.Format("MAIN_ID='{0}'", this.dictVinMainId[vin]));
DataRow[] drFcds = dtFcds.Select(String.Format("MAIN_ID='{0}'", this.dictVinMainId[vin]));
DataRow[] drCdd = dtCdd.Select(String.Format("MAIN_ID='{0}'", this.dictVinMainId[vin]));
if (drCtny.Length > 0)
{
message += this.UpdateFuelData(vin, dictStatus[vin], drCtny[0], dtCtnyPam, con);
}
if (drFcds.Length > 0)
{
message += this.UpdateFuelData(vin, dictStatus[vin], drFcds[0], dtFcdsPam, con);
}
if (drCdd.Length > 0)
{
message += this.UpdateFuelData(vin, dictStatus[vin], drCdd[0], dtCddPam, con);
}
}
}
catch (Exception ex)
{
MessageBox.Show(String.Format("更新失败：{0}\r\n", ex.Message));
}
if (string.IsNullOrEmpty(message))
{
MessageBox.Show("全部更新成功");
}
else
{
MessageForm mf = new MessageForm(message);
Utils.SetFormMid(mf);
mf.Text = "更新结果";
mf.ShowDialog();
}
this.SearchLocal(this.mainIds);
}
}
/// <summary>
/// 导入VIN
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnImportVin_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
NissanUtils utils = new NissanUtils();
FolderDialog openFolder = new FolderDialog();
try
{
if (openFolder.DisplayDialog() == DialogResult.OK)
{
// 获取用户选择的文件夹路径
string folderPath = openFolder.Path;
// 获取folderPath下以格式为utils.CocFileName的所有文件
List <string> fileNameList = utils.GetFileName(folderPath, utils.VinFileName);
if (fileNameList.Count > 0)
{
string fileNameMsg = string.Empty;
string returnMsg = string.Empty;
// 获取全部主表数据，用作合并VIN数据
bool IsMainDataExist = utils.GetMainData();
if (!IsMainDataExist)
{
MessageBox.Show("系统中不存在主表数据，请首先导入主表数据", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
// 遍历读所有文件fileNameList
foreach (string fileName in fileNameList)
{
// fileNameMsg += Path.GetFileName(fileName) + "\r\n";
// 导入filename文件信息
returnMsg += utils.ImportVinData(fileName, folderPath);
}
MessageForm mf = new MessageForm(returnMsg);
Utils.SetFormMid(mf);
mf.Text = "导入结果";
mf.ShowDialog();
}
else
{
MessageBox.Show(String.Format("目录{0}下没有文件{1}", folderPath, utils.VinFileName));
}
}
}
catch (Exception ex)
{
MessageBox.Show("导入失败：" + ex.Message);
}
}
// 更新主表关联数据
private void btnUpdateRelData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
// 获取主表编号
string mainIds = string.Empty;
NissanUtils nissanUtil = new NissanUtils();
try
{
List <string> ctnyList = nissanUtil.GetMainIdFromControl(this.gvCtny, (DataTable)this.dgvCtny.DataSource);
List <string> fcdsList = nissanUtil.GetMainIdFromControl(this.gvFcds, (DataTable)this.dgvFcds.DataSource);
List <string> cddList = nissanUtil.GetMainIdFromControl(this.gvCdd, (DataTable)this.dgvCdd.DataSource);
if (ctnyList.Count + fcdsList.Count + cddList.Count < 1)
{
MessageBox.Show("请选择主表信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
foreach (string ctnyId in ctnyList)
{
mainIds += string.Format(",'{0}'", ctnyId);
}
foreach (string fcdsId in fcdsList)
{
mainIds += string.Format(",'{0}'", fcdsId);
}
foreach (string cddId in cddList)
{
mainIds += string.Format(",'{0}'", cddId);
}
if (!string.IsNullOrEmpty(mainIds))
{
mainIds = mainIds.Substring(1);
}
using (ReviewUpdateVinForm reviewVinForm = new ReviewUpdateVinForm(mainIds))
{
reviewVinForm.ShowDialog();
}
}
catch (Exception)
{
}
}
private void btnGenFuelData_Click(object sender, EventArgs e)
{
try
{
NissanUtils nissanUtils = new NissanUtils();
string msg = nissanUtils.SaveParam(ds);
if (string.IsNullOrEmpty(msg))
{
this.DialogResult = DialogResult.OK;
MessageBox.Show("生成成功", "生成成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageForm mf = new MessageForm("以下数据已经存在\r\n" + msg);
Utils.SetFormMid(mf);
mf.Text = "生成结果";
mf.ShowDialog();
}
}
catch (Exception ex)
{
MessageBox.Show("燃料消耗量数据生成失败：" + ex.Message, "生成失败");
}
}
protected void ImportMainData(string importType)
{
string operateType = string.Empty;
if (importType == "IMPORT")
{
operateType = "导入";
}
else if (importType == "UPDATE")
{
operateType = "修改";
}
NissanUtils utils = new NissanUtils();
FolderDialog openFolder = new FolderDialog();
try
{
if (openFolder.DisplayDialog() == DialogResult.OK)
{
// 获取用户选择的文件夹路径
string folderPath = openFolder.Path;
// 获取folderPath下以格式为utils.CocFileName的所有文件
List <string> fileNameList = utils.GetFileName(folderPath, utils.MainFileName);
if (fileNameList.Count > 0)
{
string fileNameMsg = string.Empty;
string returnMsg = string.Empty;
List <string> mainUpdateList = new List <string>();
// 遍历读所有文件fileNameList
foreach (string fileName in fileNameList)
{
fileNameMsg += Path.GetFileName(fileName) + Environment.NewLine;
// 导入filename文件信息
returnMsg += utils.ImportMainData(fileName, folderPath, importType, mainUpdateList);
}
if (string.IsNullOrEmpty(returnMsg))
{
MessageForm mf = new MessageForm(String.Format("以下文件{0}成功：\r\n{1}", operateType, fileNameMsg));
Utils.SetFormMid(mf);
mf.Text = operateType + "成功";
mf.ShowDialog();
}
else
{
MessageForm mf = new MessageForm(returnMsg);
Utils.SetFormMid(mf);
mf.Text = operateType + "结果";
mf.ShowDialog();
}
if (importType == "IMPORT")
{
this.ShowMainData();
}
else if (importType == "UPDATE")
{
this.ShowUpdatedMainData(mainUpdateList);
}
}
else
{
MessageBox.Show(String.Format("目录{0}下没有文件{1}", folderPath, utils.MainFileName));
}
}
}
catch (Exception ex)
{
MessageBox.Show(String.Format("{0}失败：{1}", operateType, ex.Message), "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
