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); }