private void LoadChart()
{
this.fieldY = GetFieldY();
this.Text = this.GetTitle();
ResFormulaService resFormulaService = new ResFormulaService();
DataTable dtHistoryMonthData = resFormulaService.GetDYMonthDataTable(assetsData.DYDM, ycqsrq);
dtHistoryMonthData = DealDataSource(dtHistoryMonthData);
List <NodeEnity> lstNE = assetsData.GetLstNodeEntity();
PreMonthDataService pmds = new PreMonthDataService();
dtPreMonthData = pmds.GetDataTable(assetsData.ProID, pjnd, lstNE);
DYMonthDataService dds = new DYMonthDataService();
double ljcy = dds.GetLJCL(assetsData.DYDM, ycqsrq);
DoWithDT(ref dtPreMonthData, ljcy);
#region 图形加载
try
{
ChartData chartdata = getDefaultData("累产油（万吨）", new List <DataTable>()
{
dtHistoryMonthData, dtPreMonthData
});
CInitializeChart initailize = new CInitializeChart();
initailize.InitializeChart(jrChart1, chartdata);
((OprtFitting)jrChart1.oprt).PredictionEvent += new OprtFitting.Event_Prediction(jrChart1_PredictionEvent);
ChartSeries sr_In = jrChart1.chartdata.serieslst[0];
jrChart1.AllowMouseWheelZoom = true;//鼠标可缩放。
jrChart1.AllowDrop = false;
sr_In.bkclr = Color.White;
sr_In.VLineColor = Color.Black;
sr_In.HLineColor = Color.Black;
this.jrChart1.RepaintAll();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "数据有误不能加载数据");
return;
}
#endregion
}
void bgwLoad_DoWork(object sender, DoWorkEventArgs e)
{
UnitType unitType = (UnitType)e.Argument;
List <string> lstdydm = PublicMethods.GetLstStringByLstT(lstAssetsData, "ID");
DBAccessEx dbAccess = localService.GetNewDBAccessEx();
dbAccess.BeginTransaction();
if (unitType == UnitType.EnUnit)
{
DYDAB01Service dyDAB01Service = new DYDAB01Service(dbAccess);
DataTable dtDydmWithOutYymd = dyDAB01Service.GetDataTableWithOutYYMD(decParams.ProID, decParams.Pjnd, OrganizationType.Dydm, lstdydm);
if (dtDydmWithOutYymd != null && dtDydmWithOutYymd.Rows.Count > 0)
{
dtDydmWithOutYymd.TableName = "yymd";
e.Result = dtDydmWithOutYymd;
return;
}
}
DataTable dtPreMonthData;
PreMonthDataService preMonthDataService = new PreMonthDataService(dbAccess);
if (unitType == UnitType.CnUnit)
{
dtPreMonthData = preMonthDataService.GetDataTableCN(decParams.ProID, decParams.Pjnd, lstdydm);
}
else
{
dtPreMonthData = preMonthDataService.GetDataTableEN(decParams.ProID, decParams.Pjnd, lstdydm);
}
dbAccess.Commit();
DataTable dtEmpty = dtPreMonthData.Clone();
GetEmptyDataTable(ref dtEmpty);
MergerDataTable(ref dtEmpty, dtPreMonthData);
e.Result = dtEmpty;
}
void bgwSave_DoWork(object sender, DoWorkEventArgs e)
{
DataTable dtData = e.Argument as DataTable;
DBAccessEx dbAccess = localService.GetNewDBAccessEx();
dbAccess.BeginTransaction();
//首先删除表中数据，删除数据分主表和字表，主表为preline,字表为premonthdata
PreLineService m_PreLineService = new PreLineService(dbAccess);
m_PreLineService.Delete(decParams.ProID, decParams.Pjnd, decParams.Dydm, StudyType.DYFX);
PreMonthDataService m_PreMonthDataService = new PreMonthDataService(dbAccess);
m_PreMonthDataService.Delete(decParams.ProID, decParams.Pjnd, decParams.Dydm);
//插入线数据
string prelineID_YCY = Guid.NewGuid().ToString(); //月产油
string prelineID_YCQ = Guid.NewGuid().ToString(); //月产气
DataTable dt_preline = m_PreLineService.GetEmptyDataTable();
//插入月产油数据
DataRow dr_line_ycy = dt_preline.NewRow();
dr_line_ycy["prelineID"] = prelineID_YCY;
dr_line_ycy["proID"] = decParams.ProID;
dr_line_ycy["pjnd"] = decParams.Pjnd;
dr_line_ycy["dydm"] = decParams.Dydm;
dr_line_ycy["studyType"] = "DYFX";
dr_line_ycy["seriesName"] = "ycy";
dt_preline.Rows.Add(dr_line_ycy);
//插入月产气数据
DataRow dr_line_ycq = dt_preline.NewRow();
dr_line_ycq["prelineID"] = prelineID_YCQ;
dr_line_ycq["proID"] = decParams.ProID;
dr_line_ycq["pjnd"] = decParams.Pjnd;
dr_line_ycq["dydm"] = decParams.Dydm;
dr_line_ycq["studyType"] = "DYFX";
dr_line_ycq["seriesName"] = "ycq";
dt_preline.Rows.Add(dr_line_ycq);
m_PreLineService.Insert(dt_preline);
//插入预测数据
DataTable dt_data = m_PreMonthDataService.GetEmptyDataTable();
foreach (DataRow dr in dtData.Rows)
{
//添加月产油
DataRow dr_data_ycy = dt_data.NewRow();
dr_data_ycy["prelineID"] = prelineID_YCY;
dr_data_ycy["NY"] = dr["NY"];
double ycy = dr["YCY"].ToDouble();
if (tsbUnitSwich.Text == "切换为英式单位")
{
DYDAB01Service M_DYDAB01Service = new DYDAB01Service();
double YYMD = M_DYDAB01Service.GetYYMD(decParams.ProID, decParams.Dydm);
ycy = InternalMethods.GetWTonByMBBL(ycy, YYMD);
}
dr_data_ycy["YCValue"] = dr["YCY"];
dt_data.Rows.Add(dr_data_ycy);
//添加月产气
DataRow dr_data_ycq = dt_data.NewRow();
dr_data_ycq["prelineID"] = prelineID_YCQ;
dr_data_ycq["NY"] = dr["NY"];
double YCQ = dr["YCQ"].ToDouble();
if (tsbUnitSwich.Text == "切换为英式单位")
{
DYDAB01Service M_DYDAB01Service = new DYDAB01Service();
YCQ = InternalMethods.GetM3ByMCF(YCQ);
}
dr_data_ycq["YCValue"] = YCQ;
dt_data.Rows.Add(dr_data_ycq);
}
e.Result = m_PreMonthDataService.Insert(dt_data);
dbAccess.Commit();
}
