private void btnOK_Click(object sender, System.EventArgs e) { this.DialogResult = DialogResult.OK; clsAbsorptionCoefficient_Find1 = new clsAbsorptionCoefficient_FindDetail(); clsAbsorptionCoefficient_Find1.strName = edtName.Text; clsAbsorptionCoefficient_Find1.strAlpha = edtAlpha.Text; clsAbsorptionCoefficient_Find1.str400 = edt400.Text; clsAbsorptionCoefficient_Find1.str500 = edt500.Text; clsAbsorptionCoefficient_Find1.str630 = edt630.Text; clsAbsorptionCoefficient_Find1.str800 = edt800.Text; clsAbsorptionCoefficient_Find1.str1000 = edt1000.Text; clsAbsorptionCoefficient_Find1.str1250 = edt1250.Text; clsAbsorptionCoefficient_Find1.str1600 = edt1600.Text; clsAbsorptionCoefficient_Find1.str2000 = edt2000.Text; clsAbsorptionCoefficient_Find1.str3150 = edt3150.Text; clsAbsorptionCoefficient_Find1.str4000 = edt4000.Text; clsAbsorptionCoefficient_Find1.str5000 = edt5000.Text; clsAbsorptionCoefficient_Find1.str6300 = edt6300.Text; clsAbsorptionCoefficient_Find1.str8000 = edt8000.Text; clsAbsorptionCoefficient_Find1.str10000 = edt10000.Text; this.Close(); }
public void Search(string Category,string IncidenceCondition,string MaterialType,string Option,string Frequency, clsAbsorptionCoefficient_FindDetail clsAbsorptionCoefficient_RB,clsAbsorptionCoefficient_FindDetail clsAbsorptionCoefficient_AT, clsAbsorptionCoefficient_FindDetail clsAbsorptionCoefficient_TL,clsParameters clsParameters1,clsMultiLayer_Find clsMultiLayer_Find1,string strVendor, string strProducing,string strDate,int dMeasured) { string strIDs = ""; bool bFlag = false; MD_DB MD_DB1 = new MD_DB(); switch(Option) { case "Absorption coefficient-rigid backing": dsSearchResult = MD_DB1.Search(Category,IncidenceCondition,MaterialType,Frequency,clsAbsorptionCoefficient_RB.strName,strVendor,strProducing,strDate,dMeasured); strIDs = AbsorptionCoefficient_RigidBackingCheck(dsSearchResult,clsAbsorptionCoefficient_RB); break; case "Absorption coefficient-anechoic termination": dsSearchResult = MD_DB1.Search(Category,IncidenceCondition,MaterialType,Frequency,clsAbsorptionCoefficient_AT.strName,strVendor,strProducing,strDate,dMeasured); strIDs = AbsorptionCoefficient_AnechoicTerminationCheck(dsSearchResult,clsAbsorptionCoefficient_AT); break; case "Transmission Loss": dsSearchResult = MD_DB1.Search(Category,IncidenceCondition,MaterialType,Frequency,clsAbsorptionCoefficient_TL.strName,strVendor,strProducing,strDate,dMeasured); strIDs = TransmissionLossCheck(dsSearchResult,clsAbsorptionCoefficient_TL); break; case "Parameters": dsSearchResult = MD_DB1.Search(Category,IncidenceCondition,MaterialType,Frequency,clsParameters1.strName,strVendor,strProducing,strDate,dMeasured); strIDs = ParametersCheck(dsSearchResult,clsParameters1); pSeries_Search = null; break; case "MultiLayer": dsSearchResult = MD_DB1.Search("Multi",IncidenceCondition,MaterialType,Frequency,"",strVendor,strProducing,strDate,dMeasured); Category = "Multi"; strIDs = MultiLayerCheck(dsSearchResult,clsMultiLayer_Find1.strName,clsMultiLayer_Find1.strTotalThick); bFlag = true; pSeries_Search = null; break; case "Select": dsSearchResult = MD_DB1.Search(Category,IncidenceCondition,MaterialType,Frequency,"",strVendor,strProducing,strDate,dMeasured); bFlag = true; pSeries_Search = null; break; } if(bFlag == false) { dsSearchResult = MD_DB1.Search_IDs(Category,strIDs); } strSingle_Multi = Category; lstSearchResultList.Items.Clear(); if(dsSearchResult != null) { if(Category != "Single") { MultiListSetting(); } else { SearchResultList_Init(); MeterialTypeChange(this.strMeterialTypeChange); } for(int i = 0 ; i < dsSearchResult.Tables[0].Rows.Count ; i++) { ListViewItem item = new ListViewItem(); if(Category == "Single") { item.SubItems[0].Text = dsSearchResult.Tables[0].Rows[i]["SID"].ToString(); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["Name"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["Thick"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["BulkDens"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["LossFactor"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["FlowRes"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["Ymodulus"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["PoissionR"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["ThermalCL"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["ViscousCL"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["Prosity"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["Sfactor"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["EmP1"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["PRatioP1"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["DensityP1"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["EmP2"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["HP2"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["HP2"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["HP1"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["PRatioP2"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["MID"].ToString()); bIsSingle = true; } else { item.SubItems[0].Text = dsSearchResult.Tables[0].Rows[i]["LID"].ToString(); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["MultiLayer.Name"].ToString()); item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["TotalThick"].ToString()); bIsSingle = false; } lstSearchResultList.Items.Add(item); //strSearchResult_Selected_ID = item.SubItems[0].Text; } } if(dsSearchResult == null || dsSearchResult.Tables[0].Rows.Count == 0) { MessageBox.Show("�˻� ����� �����ϴ�"); } pnlGraphOption.Enabled = false; pnlGraphOption2.Enabled = false; }
private void btnOK_Click(object sender, System.EventArgs e) { this.DialogResult = DialogResult.OK; clsAbsorptionCoefficient_Find1 = new clsAbsorptionCoefficient_FindDetail(); clsAbsorptionCoefficient_Find1.strName = edtName.Text; clsAbsorptionCoefficient_Find1.strAlpha = edtAlpha.Text; clsAbsorptionCoefficient_Find1.str400 = edt400.Text; clsAbsorptionCoefficient_Find1.str500 = edt500.Text; clsAbsorptionCoefficient_Find1.str630 = edt630.Text; clsAbsorptionCoefficient_Find1.str800 = edt800.Text; clsAbsorptionCoefficient_Find1.str1000 = edt1000.Text; clsAbsorptionCoefficient_Find1.str1250 = edt1250.Text; clsAbsorptionCoefficient_Find1.str1600 = edt1600.Text; clsAbsorptionCoefficient_Find1.str2000 = edt2000.Text; clsAbsorptionCoefficient_Find1.str3150 = edt3150.Text; clsAbsorptionCoefficient_Find1.str4000 = edt4000.Text; clsAbsorptionCoefficient_Find1.str5000 = edt5000.Text; clsAbsorptionCoefficient_Find1.str6300 = edt6300.Text; clsAbsorptionCoefficient_Find1.str8000 = edt8000.Text; clsAbsorptionCoefficient_Find1.str10000 = edt10000.Text; this.Close(); }
private string TransmissionLossCheck(DataSet ds,clsAbsorptionCoefficient_FindDetail cls) { string strIDs = ""; string strFreq = ""; string strY = ""; string [] arrFreq; string [] arrY; string Y_400 = ""; string Y_500 = ""; string Y_630 = ""; string Y_800 = ""; string Y_1000 = ""; string Y_1250 = ""; string Y_1600 = ""; string Y_2000 = ""; string Y_3150 = ""; string Y_4000 = ""; string Y_5000 = ""; string Y_6300 = ""; string Y_8000 = ""; string Y_10000 = ""; pSeries_Search = new DataPlotter.DataSeries(); double [] dimdf_X = new double[14]; double [] dimdf_Y = new double[14]; pSeries_Search.Color = Color.SkyBlue; pSeries_Search.Name = "Search Axis"; for(int i = 0 ; i < ds.Tables[0].Rows.Count ; i++) { bool bResult = true; strFreq = ds.Tables[0].Rows[i]["X_Axis"].ToString(); strY = ds.Tables[0].Rows[i]["Y_TransmissionLoss"].ToString(); if(strFreq != "" && strY != "") { arrFreq = strFreq.Split(",".ToCharArray()); arrY = strY.Split(",".ToCharArray()); if(arrFreq.Length == arrY.Length) { for(int j = 0 ; j < arrFreq.Length ; j++) { #region DB ���� �� ���ļ����� Y �� ������ ���� switch(arrFreq[j].ToString()) { case "400" : Y_400 = arrY[j].ToString(); break; case "500" : Y_500 = arrY[j].ToString(); break; case "630" : Y_630 = arrY[j].ToString(); break; case "800" : Y_800 = arrY[j].ToString(); break; case "1000" : Y_1000 = arrY[j].ToString(); break; case "1250" : Y_1250 = arrY[j].ToString(); break; case "1600" : Y_1600 = arrY[j].ToString(); break; case "2000" : Y_2000 = arrY[j].ToString(); break; case "3150" : Y_3150 = arrY[j].ToString(); break; case "4000" : Y_4000 = arrY[j].ToString(); break; case "5000" : Y_5000 = arrY[j].ToString(); break; case "6300" : Y_6300 = arrY[j].ToString(); break; case "8000" : Y_8000 = arrY[j].ToString(); break; case "10000" : Y_10000 = arrY[j].ToString(); break; } #endregion } #region ������ ����� üũ ������ ���� �ʴ°� �ϳ��� ������ false double temp_cls = 0.0; double temp_db = 0.0; if(cls.str400 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str400); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(400) + temp_cls; } temp_db = double.Parse(Y_400); if(temp_cls > temp_db) { bResult = false; } dimdf_X[0] = 400; dimdf_Y[0] = temp_cls; } if(cls.str500 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str500); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(500) + temp_cls; } temp_db = double.Parse(Y_500); if(temp_cls > temp_db) { bResult = false; } dimdf_X[1] = 500; dimdf_Y[1] = temp_cls; } if(cls.str630 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str630); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(630) + temp_cls; } temp_db = double.Parse(Y_630); if(temp_cls > temp_db) { bResult = false; } dimdf_X[2] = 630; dimdf_Y[2] = temp_cls; } if(cls.str800 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str800); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(800) + temp_cls; } temp_db = double.Parse(Y_800); if(temp_cls > temp_db) { bResult = false; } dimdf_X[3] = 800; dimdf_Y[3] = temp_cls; } if(cls.str1000 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str1000); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(1000) + temp_cls; } temp_db = double.Parse(Y_1000); if(temp_cls > temp_db) { bResult = false; } dimdf_X[4] = 1000; dimdf_Y[4] = temp_cls; } if(cls.str1250 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str1250); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(1250) + temp_cls; } temp_db = double.Parse(Y_1250); if(temp_cls > temp_db) { bResult = false; } dimdf_X[5] = 1250; dimdf_Y[5] = temp_cls; } if(cls.str1600 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str1600); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(1600) + temp_cls; } temp_db = double.Parse(Y_1600); if(temp_cls > temp_db) { bResult = false; } dimdf_X[6] = 1600; dimdf_Y[6] = temp_cls; } if(cls.str2000 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str2000); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(2000) + temp_cls; } temp_db = double.Parse(Y_2000); if(temp_cls > temp_db) { bResult = false; } dimdf_X[7] = 2000; dimdf_Y[7] = temp_cls; } if(cls.str3150 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str3150); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(3150) + temp_cls; } temp_db = double.Parse(Y_3150); if(temp_cls > temp_db) { bResult = false; } dimdf_X[8] = 3150; dimdf_Y[8] = temp_cls; } if(cls.str4000 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str4000); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(4000) + temp_cls; } temp_db = double.Parse(Y_4000); if(temp_cls > temp_db) { bResult = false; } dimdf_X[9] = 4000; dimdf_Y[9] = temp_cls; } if(cls.str5000 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str5000); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(5000) + temp_cls; } temp_db = double.Parse(Y_5000); if(temp_cls > temp_db) { bResult = false; } dimdf_X[10] = 5000; dimdf_Y[10] = temp_cls; } if(cls.str6300 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str6300); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(6300) + temp_cls; } temp_db = double.Parse(Y_6300); if(temp_cls > temp_db) { bResult = false; } dimdf_X[11] = 6300; dimdf_Y[11] = temp_cls; } if(cls.str8000 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str8000); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(8000) + temp_cls; } temp_db = double.Parse(Y_8000); if(temp_cls > temp_db) { bResult = false; } dimdf_X[12] = 8000; dimdf_Y[12] = temp_cls; } if(cls.str10000 != "") { if(cls.strAlpha == "") { temp_cls = double.Parse(cls.str10000); } else { temp_cls = double.Parse(cls.strAlpha); temp_cls = Math.Log10(10000) + temp_cls; } temp_db = double.Parse(Y_10000); if(temp_cls > temp_db) { bResult = false; } dimdf_X[13] = 10000; dimdf_Y[13] = temp_cls; } #endregion } else { bResult = false; } } else { bResult = false; } if(bResult == true) // ���ǿ� �����ϸ�ID �� �߰��Ѵ� { strIDs = strIDs + ds.Tables[0].Rows[i]["SGID"].ToString() + ","; } } if(strIDs != "") { strIDs = strIDs.Substring(0,strIDs.Length - 1); } pSeries_Search.XData = dimdf_X; pSeries_Search.YData = dimdf_Y; return strIDs; }