private void button1_Click(object sender, EventArgs e)
{
List <OilSimilarSearchEntity> list = new List <OilSimilarSearchEntity>();
/*添加第一个物性选项*/
OilSimilarSearchEntity item = new OilSimilarSearchEntity();
item.ItemName = textBox2.Text.Trim();
item.Fvalue = float.Parse(textBox3.Text.Trim());
list.Add(item);
//添加第二个物性选项
item = new OilSimilarSearchEntity();
item.ItemName = textBox5.Text.Trim();
item.Fvalue = float.Parse(textBox6.Text.Trim());
list.Add(item);
oilName _oilName = new oilName();
string crudeIndex = _oilName.GetOilName(list);//原油名称
if (crudeIndex == "")
{
//this.dataGridView1.ClearSelection();
MessageBox.Show("未查询到对应的原油", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
OilInfoBEntity _oil = new OilInfoBEntity(); //新建一条原油
OilApplyBll oilApplyBll = new OilApplyBll();
//_oil = oilApplyBll.GetCutResult(crudeIndex);
//_oil = oilApplyBll.GetCutResult(crudeIndex);
this.dataGridView1.DataSource = _oil.dataTable;
//List<OilDataTableBEntity> OilDataTableBEntityList = _oil.OilDataTableBEntityList ;//返回类型
}
private void button1_Click(object sender, EventArgs e)
{
if (this.textBox1.Text.Trim() == "" || this.textBox3.Text.Trim() == "")
{
MessageBox.Show("原油名称不能为空", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (this.textBox2.Text.Trim() == "" || this.textBox4.Text.Trim() == "")
{
MessageBox.Show("切割比率不能为空", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if ((int.Parse(this.textBox2.Text.Trim()) + +int.Parse(this.textBox4.Text.Trim())) != 100)
{
MessageBox.Show("切割比率加和不等于100%!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//切割比率
List <CutOilRateEntity> cutOilRates = new List <CutOilRateEntity>();
CutOilRateEntity CutOilRateEntity1 = new CutOilRateEntity();
CutOilRateEntity1.crudeIndex = this.textBox1.Text.Trim();//原油名称
CutOilRateEntity1.rate = int.Parse(this.textBox2.Text.Trim());
cutOilRates.Add(CutOilRateEntity1);
CutOilRateEntity CutOilRateEntity2 = new CutOilRateEntity();
CutOilRateEntity2.crudeIndex = this.textBox3.Text.Trim();//原油名称
CutOilRateEntity2.rate = int.Parse(this.textBox4.Text.Trim());
cutOilRates.Add(CutOilRateEntity2);
OilInfoBEntity _oil = new OilInfoBEntity(); //新建一条原油
OilApplyBll oilApplyBll = new OilApplyBll();
//_oil = oilApplyBll.GetCutResult(cutOilRates);
this.dataGridView1.DataSource = _oil.dataTable;
//List<OilDataTableBEntity> OilDataTableBEntityList = _oil.OilDataTableBEntityList;
}
/// <summary>
/// 获取切割数据
/// </summary>
/// <returns></returns>
public List <OilDataSearchEntity> GetCutResult()
{
List <CutMothedEntity> cutMothedEntityList = OilSearchCutMothed();//切割方案
OilApplyBll oilApplyBll = new OilApplyBll();
OilInfoBEntity OilB = oilApplyBll.GetCutResult(this._oilB, cutMothedEntityList);
List <OilDataSearchEntity> list = new List <OilDataSearchEntity> ();
//List<CutDataEntity> D20List = OilB.CutDataEntityList.Where(o => o.YItemCode == "D20").ToList();
if (this._oilA == null)
{
list = findOilDataSearch(OilB.CutDataEntityList);
}
else
{
list = findOilDataSearch(this._oilA, OilB);
}
return(list);
}
private void button1_Click(object sender, EventArgs e)
{
CutOilRateEntity cutOilRate = new CutOilRateEntity();
cutOilRate.crudeIndex = "test原油1";
cutOilRate.rate = 100;
_cutOilRates.Add(cutOilRate);
CutMothedEntity cutMothed = new CutMothedEntity(200, 300, "Cut1");
_cutMotheds.Add(cutMothed);
DateTime start = DateTime.Now;
OilApplyBll oilApplyBll = new OilApplyBll();
oilApplyBll.GetCutResult(_cutOilRates, _cutMotheds);
DateTime end = DateTime.Now;
TimeSpan a = end.Subtract(start);
this.label7.Text = a.TotalMilliseconds.ToString() + "毫秒";
}
/// <summary>
/// 接口方式一
/// </summary>
/// <param name="crudeIndex">原油编号</param>
/// <param name="cutMotheds">定制切割方案</param>
/// <returns>原油数据</returns>
public OilInfoBEntity GetCutResultAPI(string crudeIndex, List <CutMothedAPIEntity> cutMotheds)
{
if (string.IsNullOrWhiteSpace(crudeIndex))
{
return(null);
}
if (cutMotheds.Count <= 0)
{
return(null);
}
List <CutMothedEntity> cutMothedList = new List <CutMothedEntity> ();
for (int index = 0; index < cutMotheds.Count; index++)
{
CutMothedEntity cutMothed = new CutMothedEntity();
cutMothed.ICP = cutMotheds[index].ICP;
cutMothed.ECP = cutMotheds[index].ECP;
cutMothed.Name = cutMotheds[index].Name.GetDescription();
cutMothedList.Add(cutMothed);
}
OilApplyBll oilApplyBll = new OilApplyBll();
OilInfoBEntity oilB = oilApplyBll.GetCutResult(crudeIndex, cutMothedList);
List <OilDataTableBAPIEntity> OilDataTableBAPIEntityList = new List <OilDataTableBAPIEntity>();
if (oilB != null)
{
if (oilB.CutDataEntityList != null)
{
#region "数据格式转换"
foreach (CutDataEntity cutData in oilB.CutDataEntityList)
{
string strCal = cutData.CutData != null?cutData.CutData.ToString() : string.Empty;
float fData = 0;
if (strCal != string.Empty && float.TryParse(strCal, out fData))
{
OilDataTableBAPIEntity oilDataTable = new OilDataTableBAPIEntity();
OilDataTableBAPIEntityList.Add(oilDataTable);
oilDataTable.CalData = fData;
oilDataTable.ItemCode = cutData.YItemCode;
#region "CutTableName"
CutTableName cutName = CutTableName.ChaiYou;
string strName = cutData.CutName;
if (strName == CutTableName.ChaiYou.GetDescription())
{
cutName = CutTableName.ChaiYou;
}
else if (strName == CutTableName.LaYou.GetDescription())
{
cutName = CutTableName.LaYou;
}
else if (strName == CutTableName.MeiYou.GetDescription())
{
cutName = CutTableName.MeiYou;
}
else if (strName == CutTableName.ShiNaoYou.GetDescription())
{
cutName = CutTableName.ShiNaoYou;
}
else if (strName == CutTableName.YuanYouXingZhi.GetDescription())
{
cutName = CutTableName.YuanYouXingZhi;
}
else if (strName == CutTableName.ZhaYou.GetDescription())
{
cutName = CutTableName.ZhaYou;
}
#endregion
oilDataTable.cutTableName = cutName;
}
}
#endregion
}
oilB.OilDataTableBAPIEntityList = OilDataTableBAPIEntityList;
}
return(oilB);
return(oilB);
}
/// <summary>
/// 接口方式三
/// </summary>
/// <param name="oilPropertyAPIEntity">定制的获取性质</param>
/// <param name="cutMotheds">定制切割方案</param>
/// <returns>原油数据</returns>
public OilInfoBEntity GetCutResultAPI(OilPropertyAPIEntity oilPropertyAPIEntity, List <CutMothedAPIEntity> cutMotheds)
{
List <CutMothedEntity> cutMothedList = new List <CutMothedEntity>();
for (int index = 0; index < cutMotheds.Count; index++)
{
CutMothedEntity cutMothed = new CutMothedEntity();
cutMothed.ICP = cutMotheds[index].ICP;
cutMothed.ECP = cutMotheds[index].ECP;
cutMothed.Name = cutMotheds[index].Name.GetDescription();
cutMothedList.Add(cutMothed);
}
OilDataSearchColAccess oilDataColAccess = new OilDataSearchColAccess();
List <OilDataSearchColEntity> OilDataCols = oilDataColAccess.Get("1=1");
OilDataSearchRowAccess oilDataRowAccess = new OilDataSearchRowAccess();
List <OilDataSearchRowEntity> OilDataRows = oilDataRowAccess.Get("1=1");
IList <OilSimilarSearchEntity> oilSimilarSearchList = new List <OilSimilarSearchEntity>();
OilDataSearchColEntity wholeCol = OilDataCols.Where(o => o.OilTableName.Contains("原油性质")).FirstOrDefault();
if (wholeCol != null)
{
#region "原油性质"
OilDataSearchRowEntity D20SearchRow = OilDataRows.Where(o => o.OilTableRow.itemCode == "D20" && o.OilDataColID == wholeCol.ID).FirstOrDefault();
OilDataSearchRowEntity WAXSearchRow = OilDataRows.Where(o => o.OilTableRow.itemCode == "WAX" && o.OilDataColID == wholeCol.ID).FirstOrDefault();
OilDataSearchRowEntity SULSearchRow = OilDataRows.Where(o => o.OilTableRow.itemCode == "SUL" && o.OilDataColID == wholeCol.ID).FirstOrDefault();
OilDataSearchRowEntity N2SearchRow = OilDataRows.Where(o => o.OilTableRow.itemCode == "N2" && o.OilDataColID == wholeCol.ID).FirstOrDefault();
OilDataSearchRowEntity CCRSearchRow = OilDataRows.Where(o => o.OilTableRow.itemCode == "CCR" && o.OilDataColID == wholeCol.ID).FirstOrDefault();
if (D20SearchRow != null && !oilPropertyAPIEntity.D20.Equals(float.NaN))
{
OilSimilarSearchEntity D20OilSimilarSearch = new OilSimilarSearchEntity();
oilSimilarSearchList.Add(D20OilSimilarSearch);
D20OilSimilarSearch.Fvalue = oilPropertyAPIEntity.D20;
D20OilSimilarSearch.Weight = 10;
D20OilSimilarSearch.ItemCode = "D20";
D20OilSimilarSearch.OilTableColID = wholeCol.OilTableColID;
D20OilSimilarSearch.OilTableRowID = D20SearchRow.OilTableRowID;
}
if (WAXSearchRow != null && !oilPropertyAPIEntity.WAX.Equals(float.NaN))
{
OilSimilarSearchEntity WAXOilSimilarSearch = new OilSimilarSearchEntity();
oilSimilarSearchList.Add(WAXOilSimilarSearch);
WAXOilSimilarSearch.Fvalue = oilPropertyAPIEntity.WAX;
WAXOilSimilarSearch.Weight = 1;
WAXOilSimilarSearch.ItemCode = "WAX";
WAXOilSimilarSearch.OilTableColID = wholeCol.OilTableColID;
WAXOilSimilarSearch.OilTableRowID = WAXSearchRow.OilTableRowID;
}
if (SULSearchRow != null && !oilPropertyAPIEntity.SUL.Equals(float.NaN))
{
OilSimilarSearchEntity SULOilSimilarSearch = new OilSimilarSearchEntity();
oilSimilarSearchList.Add(SULOilSimilarSearch);
SULOilSimilarSearch.Fvalue = oilPropertyAPIEntity.SUL;
SULOilSimilarSearch.Weight = 1;
SULOilSimilarSearch.ItemCode = "SUL";
SULOilSimilarSearch.OilTableColID = wholeCol.OilTableColID;
SULOilSimilarSearch.OilTableRowID = SULSearchRow.OilTableRowID;
}
if (N2SearchRow != null && !oilPropertyAPIEntity.N2.Equals(float.NaN))
{
OilSimilarSearchEntity N2OilSimilarSearch = new OilSimilarSearchEntity();
oilSimilarSearchList.Add(N2OilSimilarSearch);
N2OilSimilarSearch.Fvalue = oilPropertyAPIEntity.N2;
N2OilSimilarSearch.Weight = 1;
N2OilSimilarSearch.ItemCode = "N2";
N2OilSimilarSearch.OilTableColID = wholeCol.OilTableColID;
N2OilSimilarSearch.OilTableRowID = N2SearchRow.OilTableRowID;
}
if (CCRSearchRow != null && !oilPropertyAPIEntity.CCR.Equals(float.NaN))
{
OilSimilarSearchEntity CCROilSimilarSearch = new OilSimilarSearchEntity();
oilSimilarSearchList.Add(CCROilSimilarSearch);
CCROilSimilarSearch.Fvalue = oilPropertyAPIEntity.CCR;
CCROilSimilarSearch.Weight = 1;
CCROilSimilarSearch.ItemCode = "CCR";
CCROilSimilarSearch.OilTableColID = wholeCol.OilTableColID;
CCROilSimilarSearch.OilTableRowID = CCRSearchRow.OilTableRowID;
}
#endregion
}
OilDataSearchColEntity Col15_140 = OilDataCols.Where(o => o.ICP == 15 && o.ECP == 140).FirstOrDefault();
OilDataSearchColEntity Col15_180 = OilDataCols.Where(o => o.ICP == 15 && o.ECP == 180).FirstOrDefault();
OilDataSearchColEntity Col140_240 = OilDataCols.Where(o => o.ICP == 140 && o.ECP == 240).FirstOrDefault();
OilDataSearchColEntity Col240_350 = OilDataCols.Where(o => o.ICP == 240 && o.ECP == 350).FirstOrDefault();
#region "TWY"
if (Col15_140 != null)
{
OilDataSearchRowEntity DSearchRow15_140 = OilDataRows.Where(o => o.OilTableRow.itemCode == "TWY" && o.OilDataColID == Col15_140.ID).FirstOrDefault();
if (DSearchRow15_140 != null && !oilPropertyAPIEntity.TWY140.Equals(float.NaN))
{
OilSimilarSearchEntity TWY15_140OilSimilarSearch = new OilSimilarSearchEntity();
oilSimilarSearchList.Add(TWY15_140OilSimilarSearch);
TWY15_140OilSimilarSearch.Fvalue = oilPropertyAPIEntity.TWY140;
TWY15_140OilSimilarSearch.Weight = 1;
TWY15_140OilSimilarSearch.ItemCode = "TWY15_140";
TWY15_140OilSimilarSearch.OilTableColID = Col15_140.OilTableColID;
TWY15_140OilSimilarSearch.OilTableRowID = DSearchRow15_140.OilTableRowID;
}
}
if (Col15_180 != null)
{
OilDataSearchRowEntity DSearchRow15_180 = OilDataRows.Where(o => o.OilTableRow.itemCode == "TWY" && o.OilDataColID == Col15_180.ID).FirstOrDefault();
if (DSearchRow15_180 != null && !oilPropertyAPIEntity.TWY180.Equals(float.NaN))
{
OilSimilarSearchEntity TWY15_180OilSimilarSearch = new OilSimilarSearchEntity();
oilSimilarSearchList.Add(TWY15_180OilSimilarSearch);
TWY15_180OilSimilarSearch.Fvalue = oilPropertyAPIEntity.TWY180;
TWY15_180OilSimilarSearch.Weight = 1;
TWY15_180OilSimilarSearch.ItemCode = "TWY15_180";
TWY15_180OilSimilarSearch.OilTableColID = Col15_180.OilTableColID;
TWY15_180OilSimilarSearch.OilTableRowID = DSearchRow15_180.OilTableRowID;
}
}
if (Col140_240 != null)
{
OilDataSearchRowEntity DSearchRow140_240 = OilDataRows.Where(o => o.OilTableRow.itemCode == "TWY" && o.OilDataColID == Col140_240.ID).FirstOrDefault();
if (DSearchRow140_240 != null && !oilPropertyAPIEntity.TWY240.Equals(float.NaN))
{
OilSimilarSearchEntity TWY140_240OilSimilarSearch = new OilSimilarSearchEntity();
oilSimilarSearchList.Add(TWY140_240OilSimilarSearch);
TWY140_240OilSimilarSearch.Fvalue = oilPropertyAPIEntity.TWY240;
TWY140_240OilSimilarSearch.Weight = 1;
TWY140_240OilSimilarSearch.ItemCode = "TWY140_240";
TWY140_240OilSimilarSearch.OilTableColID = Col140_240.OilTableColID;
TWY140_240OilSimilarSearch.OilTableRowID = DSearchRow140_240.OilTableRowID;
}
}
if (Col240_350 != null)
{
OilDataSearchRowEntity DSearchRow240_350 = OilDataRows.Where(o => o.OilTableRow.itemCode == "TWY" && o.OilDataColID == Col240_350.ID).FirstOrDefault();
if (DSearchRow240_350 != null && !oilPropertyAPIEntity.TWY350.Equals(float.NaN))
{
OilSimilarSearchEntity TWY240_350OilSimilarSearch = new OilSimilarSearchEntity();
oilSimilarSearchList.Add(TWY240_350OilSimilarSearch);
TWY240_350OilSimilarSearch.Fvalue = oilPropertyAPIEntity.TWY350;
TWY240_350OilSimilarSearch.Weight = 1;
TWY240_350OilSimilarSearch.ItemCode = "TWY240_350";
TWY240_350OilSimilarSearch.OilTableColID = Col240_350.OilTableColID;
TWY240_350OilSimilarSearch.OilTableRowID = DSearchRow240_350.OilTableRowID;
}
}
#endregion
OilApplyBll oilApplyBll = new OilApplyBll();
OilInfoBEntity oilB = oilApplyBll.GetCutResult(oilSimilarSearchList, cutMothedList);
List <OilDataTableBAPIEntity> OilDataTableBAPIEntityList = new List <OilDataTableBAPIEntity>();
if (oilB != null)
{
if (oilB.CutDataEntityList != null)
{
#region "数据格式转换"
foreach (CutDataEntity cutData in oilB.CutDataEntityList)
{
string strCal = cutData.CutData != null?cutData.CutData.ToString() : string.Empty;
float fData = 0;
if (strCal != string.Empty && float.TryParse(strCal, out fData))
{
OilDataTableBAPIEntity oilDataTable = new OilDataTableBAPIEntity();
OilDataTableBAPIEntityList.Add(oilDataTable);
oilDataTable.CalData = fData;
oilDataTable.ItemCode = cutData.YItemCode;
#region "CutTableName"
CutTableName cutName = CutTableName.ChaiYou;
string strName = cutData.CutName;
if (strName == CutTableName.ChaiYou.GetDescription())
{
cutName = CutTableName.ChaiYou;
}
else if (strName == CutTableName.LaYou.GetDescription())
{
cutName = CutTableName.LaYou;
}
else if (strName == CutTableName.MeiYou.GetDescription())
{
cutName = CutTableName.MeiYou;
}
else if (strName == CutTableName.ShiNaoYou.GetDescription())
{
cutName = CutTableName.ShiNaoYou;
}
else if (strName == CutTableName.YuanYouXingZhi.GetDescription())
{
cutName = CutTableName.YuanYouXingZhi;
}
else if (strName == CutTableName.ZhaYou.GetDescription())
{
cutName = CutTableName.ZhaYou;
}
#endregion
oilDataTable.cutTableName = cutName;
}
}
#endregion
}
oilB.OilDataTableBAPIEntityList = OilDataTableBAPIEntityList;
}
return(oilB);
}
/// <summary>
/// GC计算
/// </summary>
/// <param name="GCLevelDataList">GC标准表的数据集合</param>
/// <param name="ECP_TWYCurve">已经存在的ECP—TWY绘图曲线</param>
/// <param name="B_X">馏分曲线中的已知的18个点数据集合</param>
/// <param name="itemCode">判断哪个物性进行GC内插计算</param>
/// <returns>表格中需要填充的数据，和B_X数据对应</returns>
public static Dictionary <float, float> getGCInterpolationDIC(List <OilDataEntity> GCLevelDataList, CurveEntity ECP_TWYCurve, List <float> B_X, string itemCode)
{
Dictionary <float, float> DIC = new Dictionary <float, float>();//GC字典
#region "输入处理"
if (GCLevelDataList.Count <= 0)
{
return(DIC);
}
if (ECP_TWYCurve == null)
{
return(DIC);
}
if (ECP_TWYCurve.curveDatas.Count <= 0)
{
return(DIC);
}
if (B_X.Count <= 0)
{
return(DIC);
}
OilDataEntity ICPEntity = GCLevelDataList.Where(o => o.OilTableRow.itemCode == "ICP").FirstOrDefault();
OilDataEntity ECPEntity = GCLevelDataList.Where(o => o.OilTableRow.itemCode == "ECP").FirstOrDefault();
if (ICPEntity == null || ECPEntity == null)
{
return(DIC);
}
if (ICPEntity.calData == string.Empty || ECPEntity.calData == string.Empty)
{
return(DIC);
}
float TotalICP = 0, TotalECP = 0;
if (!(float.TryParse(ICPEntity.calData, out TotalICP) && float.TryParse(ECPEntity.calData, out TotalECP)))
{
return(DIC);
}
#endregion
List <float> XList = B_X.Where(o => o >= TotalICP && o <= TotalECP).ToList();
if (XList.Count <= 0)
{
return(DIC);
}
if (XList.Count == 1)
{
float CUTICP = TotalICP; float CUTECP = XList[0];
}
else if (XList.Count > 1)
{
for (int i = 1; i < XList.Count; i++)
{
float CUTICP = XList[i - 1]; float CUTECP = XList[i];
CurveDataEntity ICPData = ECP_TWYCurve.curveDatas.Where(o => o.xValue == CUTICP).FirstOrDefault();
CurveDataEntity ECPData = ECP_TWYCurve.curveDatas.Where(o => o.xValue == CUTECP).FirstOrDefault();
if (ICPData == null || ECPData == null)
{
continue;
}
if (ICPData.yValue.Equals(float.NaN) || ECPData.yValue.Equals(float.NaN))
{
continue;
}
float WY = ECPData.yValue - ICPData.yValue;
Dictionary <string, float> gcDIC = OilApplyBll.getGCInterpolationDIC(GCLevelDataList, CUTICP, CUTECP, WY);
List <float> tempList = gcDIC.Values.ToList();
float sum = 0;
foreach (string key in gcDIC.Keys)
{
sum += gcDIC[key];
}
float?result = null;
switch (itemCode)
{
case "D20":
result = OilApplySupplement.getGC_D20Value(gcDIC, WY);
break;
case "MW":
result = OilApplySupplement.getGC_MWValue(gcDIC, WY);
break;
case "RNC":
result = OilApplySupplement.getGC_RNCValue(gcDIC, WY);
break;
case "PAN":
result = OilApplySupplement.getGC_PANValue(gcDIC, WY);
break;
case "PAO":
result = OilApplySupplement.getGC_PAOValue(gcDIC, WY);
break;
case "NAH":
result = OilApplySupplement.getGC_NAHValue(gcDIC, WY);
break;
case "MON":
result = OilApplySupplement.getGC_MONValue(gcDIC, WY);
break;
case "ARM":
result = OilApplySupplement.getGC_ARMValue(gcDIC, WY);
break;
case "ARP":
result = OilApplySupplement.getGC_ARPValue(gcDIC, WY);
break;
case "RVP":
// result = OilApplySupplement.getGC_RVPValue(gcDIC, WY);
break;
}
if (!DIC.Keys.Contains(CUTECP) && result != null)
{
DIC.Add(CUTECP, result.Value);
}
}
}
return(DIC);
}
