private void btnSubmit_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtOpenSMFile.Text) && !string.IsNullOrEmpty(txtOpenCWDY.Text) && !string.IsNullOrEmpty(txtOpenJHDY.Text))
{
splashScreenManager1.ShowWaitForm();
splashScreenManager1.SetWaitFormCaption("正在导入数模数据");
splashScreenManager1.SetWaitFormDescription("请稍后...");
GetLayer.dtWater.Clear();
GetLayer.dtOil.Clear();
dtExcelCWDY.Clear();
dtExcelJHDY.Clear();
GetLayer gl = new GetLayer();
string[] filePath = txtOpenSMFile.Text.Split(new char[] { ';', '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < filePath.Count(); i++)
{
gl.GetMnLayer(filePath[i]);
}
dtExcelCWDY = ExcelToDataTableUtil.ExcelToDataTable(txtOpenCWDY.Text);
dtExcelJHDY = ExcelToDataTableUtil.ExcelToDataTable(txtOpenJHDY.Text);
//MainForm mf = new MainForm();
string selectedNodeName = MainForm.strTreeNodeText;
//mf.ShowResultView += GetViewData;
//mf.GirdViewResultSource();
ShowResultView(selectedNodeName);
splashScreenManager1.CloseWaitForm();
}
else
{
MessageBox.Show("请检查文件是否选择");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtOpenTracerFile.Text) && !string.IsNullOrEmpty(txtOpenCWDY.Text) && !string.IsNullOrEmpty(txtOpenJHDY.Text))
{
splashScreenManager1.ShowWaitForm();
splashScreenManager1.SetWaitFormCaption("正在导入示踪剂数据");
splashScreenManager1.SetWaitFormDescription("请稍后...");
GetTracerDAL.dtTracer.Clear();
FrmLayerSelectedInfo.dtExcelCWDY.Clear();
FrmLayerSelectedInfo.dtExcelJHDY.Clear();
GetTracerDAL gtd = new GetTracerDAL();
string[] filePath = txtOpenTracerFile.Text.Split(new char[] { ';', '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries);
string[] tracePath = txtSJDY.Text.Split(new char[] { ';', '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < filePath.Count(); i++)
{
gtd.GetTracer(filePath[i], tracePath[i]);
}
FrmLayerSelectedInfo.dtExcelCWDY = ExcelToDataTableUtil.ExcelToDataTable(txtOpenCWDY.Text);
FrmLayerSelectedInfo.dtExcelJHDY = ExcelToDataTableUtil.ExcelToDataTable(txtOpenJHDY.Text);
string selectedNodeName = MainForm.strTreeNodeText;
ShowResultView(selectedNodeName);
splashScreenManager1.CloseWaitForm();
}
else
{
MessageBox.Show("请检查文件是否选择");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
splashScreenManager1.ShowWaitForm();
splashScreenManager1.SetWaitFormCaption("正在处理数据");
splashScreenManager1.SetWaitFormDescription("请稍后...");
//FileStream fs = new FileStream(txtResultPath.Text, FileMode.Append);
//StreamWriter sw = new StreamWriter(fs);
//sw.WriteLine("油井 层位 产液 含水 水井 注水 井距 注采压差 平均圧力 平均含油饱和度 平均储量 平均渗透率 平均地层系数");
ReadFilesDAL.ReadFiles(txtFAPath.Text);
FactorsAnalysisDAL fad = new FactorsAnalysisDAL();
DataTable dtLtjh = ExcelToDataTableUtil.ExcelToDataTable(txtLTKPath.Text);
for (int i = 0; i < dtLtjh.Rows.Count; i++)
{
DataRow[] drJHY = dtOil.Select("JHY = '" + dtLtjh.Rows[i]["JHY"] + "' AND DATE = '" + strDate + "'");
if (drJHY.Count() > 0)
{
foreach (DataRow dr in drJHY)
{
//DataTable dtLtjhy = dtLtjh.Select("JHS = '" + dtLtjh.Rows[i]["JHS"] + "'").CopyToDataTable();
//DataRow[] drJHS = dtWater.Select("JHS = '" + dtLtjh.Rows[i]["JHS"] + "' AND K = " + dr["K"] + " AND DATE = '" + strDate + "'");
DataRow[] drJHS = dtWater.Select("JHS = '" + dtLtjh.Rows[i]["JHS"] + "' AND DATE = '" + strDate + "'");
if (drJHS.Count() > 0)
{
//for (int j = 0; j < dtLtjhy.Rows.Count; j++)
//{
//DataRow[] drOthrJHY = dtOil.Select("JHY = '" + dtLtjhy.Rows[j]["JHY"] + "' AND K = " + dr["K"] + " AND DATE = '" + strDate + "'");
//if (drOthrJHY.Count() > 0)
//{
//foreach (DataRow drOthr in drOthrJHY)
//{
WellModel jhy = new WellModel();
//jhy.x = Convert.ToInt32(drOthr["X"]);
//jhy.y = Convert.ToInt32(drOthr["Y"]);
//jhy.k = Convert.ToInt32(drOthr["K"]);
//DataRow[] drMNCYE = dtOil.Select("JHY = '" + drOthr["JHY"] + "' AND DATE = '" + strDate + "' AND K = " + dr["k"]);
jhy.x = Convert.ToInt32(dr["X"]);
jhy.y = Convert.ToInt32(dr["Y"]);
jhy.k = Convert.ToInt32(dr["K"]);
jhy.mncye = Convert.ToDouble(dr["MNCYE"]);
WellModel jhs = new WellModel();
jhs.x = Convert.ToInt32(drJHS[0]["X"]);
jhs.y = Convert.ToInt32(drJHS[0]["Y"]);
//jhs.k = Convert.ToInt32(drJHS[0]["K"]);
jhs.k = Convert.ToInt32(dr["K"]);
//DataRow[] drMNCS = dtWater.Select("JHS = '" + dtLtjh.Rows[i]["JHS"] + "' AND DATE = '" + strDate + "' AND K = " + dr["k"]);
InfFactorModel ifm = new InfFactorModel();
ifm = fad.InfluencingFactors(jhy, jhs, ReadFilesDAL.lstPressure, ReadFilesDAL.lstSoil, ReadFilesDAL.lstFipoil, ReadFilesDAL.lstKX, ReadFilesDAL.lstDCXS, ReadFilesDAL.lstPORO);
DataRow drResult = dtResult.NewRow();
//drResult["序号"] = i + 1;
drResult["油井"] = dr["JHY"];
drResult["层位"] = dr["k"];
drResult["产液"] = dr["MNCYE"];
drResult["含水"] = dr["HS"];
drResult["水井"] = drJHS[0]["JHS"];
//drResult["注入量"] = drMNCS[0]["MNCS"];
drResult["井距"] = ifm.wellSpacing;
drResult["注采压差"] = ifm.presDiff;
drResult["平均圧力"] = ifm.presAverage;
drResult["平均含油饱和度"] = ifm.soilAverage;
drResult["平均剩余储量"] = ifm.fipoilAverage;
drResult["平均渗透率"] = ifm.kxAverage;
drResult["平均地层系数"] = ifm.dcxsAverage;
drResult["平均孔隙度"] = ifm.poroAverage;
dtResult.Rows.Add(drResult);
// }
//}
//}
}
}
}
//sw.WriteLine("---------------------------------------------------------------------");
}
gridResult.DataSource = dtResult;
DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
gridResult.ExportToXls(txtResultPath.Text);
//sw.Close();
//fs.Close();
splashScreenManager1.CloseWaitForm();
DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
