private void btnOK_Click(object sender, System.EventArgs e)
{
this.DialogResult = DialogResult.OK;
clsAbsorptionCoefficient_Find1 = new clsAbsorptionCoefficient_Find();
clsAbsorptionCoefficient_Find1.strName = edtName.Text;
clsAbsorptionCoefficient_Find1.strAlpha = edtAlpha.Text;
//clsAbsorptionCoefficient_Find1.str16 = edt16.Text;
clsAbsorptionCoefficient_Find1.str2000 = edt2000.Text;
clsAbsorptionCoefficient_Find1.str4000 = edt4000.Text;
clsAbsorptionCoefficient_Find1.str1000 = edt1000.Text;
clsAbsorptionCoefficient_Find1.str500 = edt500.Text;
//clsAbsorptionCoefficient_Find1.str250 = edt250.Text;
//clsAbsorptionCoefficient_Find1.str125 = edt125.Text;
//clsAbsorptionCoefficient_Find1.str63 = edt63.Text;
//clsAbsorptionCoefficient_Find1.str31_5 = edt31_5.Text;
clsAbsorptionCoefficient_Find1.str8000 = edt8000.Text;
clsAbsorptionCoefficient_Find1.str10000 = edt10000.Text;
this.Close();
}
private string AbsorptionCoefficient_RigidBackingCheck(DataSet ds,clsAbsorptionCoefficient_Find cls)
{
string strIDs = "";
string strFreq = "";
string strY = "";
string [] arrFreq;
string [] arrY;
string Y_16 = ""; // ���ļ��� 16 �϶� Y ��
string Y_31_5 = "";
string Y_63 = "";
string Y_125 = "";
string Y_250 = "";
string Y_500 = "";
string Y_1000 = "";
string Y_2000 = "";
string Y_4000 = "";
string Y_8000 = "";
string Y_10000 = "";
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_RigidBacking"].ToString();
if(strFreq != "")
{
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 "16" :
Y_16 = arrY[j].ToString();
break;
case "31.5" :
Y_31_5 = arrY[j].ToString();
break;
case "63" :
Y_63 = arrY[j].ToString();
break;
case "125" :
Y_125 = arrY[j].ToString();
break;
case "250" :
Y_250 = arrY[j].ToString();
break;
case "500" :
Y_500 = arrY[j].ToString();
break;
case "1000" :
Y_1000 = arrY[j].ToString();
break;
case "2000" :
Y_2000 = arrY[j].ToString();
break;
case "4000" :
Y_4000 = 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.str16 != "")
// {
// temp_cls = double.Parse(cls.str16);
// temp_db = double.Parse(Y_16);
// if(temp_cls > temp_db)
// {
// bResult = false;
// }
// }
// if(cls.str31_5 != "")
// {
// temp_cls = double.Parse(cls.str31_5);
// temp_db = double.Parse(Y_31_5);
// if(temp_cls > temp_db)
// {
// bResult = false;
// }
// }
// if(cls.str63 != "")
// {
// temp_cls = double.Parse(cls.str63);
// temp_db = double.Parse(Y_63);
// if(temp_cls > temp_db)
// {
// bResult = false;
// }
// }
// if(cls.str125 != "")
// {
// temp_cls = double.Parse(cls.str125);
// temp_db = double.Parse(Y_125);
// if(temp_cls > temp_db)
// {
// bResult = false;
// }
// }
// if(cls.str250 != "")
// {
// temp_cls = double.Parse(cls.str250);
// temp_db = double.Parse(Y_250);
// if(temp_cls > temp_db)
// {
// bResult = false;
// }
// }
if(cls.str500 != "")
{
temp_cls = double.Parse(cls.str500);
temp_db = double.Parse(Y_500);
if(temp_cls > temp_db)
{
bResult = false;
}
}
if(cls.str1000 != "")
{
temp_cls = double.Parse(cls.str1000);
temp_db = double.Parse(Y_1000);
if(temp_cls > temp_db)
{
bResult = false;
}
}
if(cls.str2000 != "")
{
temp_cls = double.Parse(cls.str2000);
temp_db = double.Parse(Y_2000);
if(temp_cls > temp_db)
{
bResult = false;
}
}
if(cls.str4000 != "")
{
temp_cls = double.Parse(cls.str4000);
temp_db = double.Parse(Y_4000);
if(temp_cls > temp_db)
{
bResult = false;
}
}
if(cls.str8000 != "")
{
temp_cls = double.Parse(cls.str8000);
temp_db = double.Parse(Y_8000);
if(temp_cls > temp_db)
{
bResult = false;
}
}
if(cls.str10000 != "")
{
if(Y_10000 == "")
{
Y_10000 = "0";
}
temp_cls = double.Parse(cls.str10000);
temp_db = double.Parse(Y_10000);
if(temp_cls > temp_db)
{
bResult = false;
}
}
#endregion
}
else
{
bResult = false;
}
}
else
{
bResult = false;
}
if(bResult == true) // ���ǿ� �����ϸ�ID �� �߰��Ѵ�
{
strIDs = strIDs + ds.Tables[0].Rows[i][0].ToString() + ",";
}
}
if(strIDs != "")
{
strIDs = strIDs.Substring(0,strIDs.Length - 1);
}
return strIDs;
}
/// <summary>
/// ��ȸ �Լ�
/// </summary>
/// <param name="Category"></param>
/// <param name="IncidenceCondition"></param>
/// <param name="MaterialType"></param>
/// <param name="Option"></param>
/// <param name="Frequency">1,Narrow band 2,Octave 3,1/3 Octav</param>
public void Search(string Category,string IncidenceCondition,string MaterialType,string Option,string Frequency,
clsAbsorptionCoefficient_Find clsAbsorptionCoefficient_RB,clsAbsorptionCoefficient_Find clsAbsorptionCoefficient_AT,
clsAbsorptionCoefficient_Find clsAbsorptionCoefficient_TL,clsParameters clsParameters1,clsMultiLayer_Find clsMultiLayer_Find1,string strVendor,
string strProducing,string strDate,int dMeasured)
{
string strIDs = "";
bool bFlag = false;
string strSID_Temp = "";
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_Parameter(Category,IncidenceCondition,MaterialType,"0",clsParameters1.strName,strVendor,strProducing,strDate,dMeasured);
strIDs = ParametersCheck(dsSearchResult,clsParameters1);
bFlag = true;
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;
break;
case "Select":
dsSearchResult = MD_DB1.Search(Category,IncidenceCondition,MaterialType,"0","",strVendor,strProducing,strDate,dMeasured);
bFlag = true;
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")
{
if(strSID_Temp != dsSearchResult.Tables[0].Rows[i]["SID"].ToString())
{
strSID_Temp = dsSearchResult.Tables[0].Rows[i]["SID"].ToString();
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]["FlowRes"].ToString());
item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["LossFactor"].ToString());
item.SubItems.Add(dsSearchResult.Tables[0].Rows[i]["BulkDens"].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());
lstSearchResultList.Items.Add(item);
}
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;
}
private void btnOK_Click(object sender, System.EventArgs e)
{
this.DialogResult = DialogResult.OK;
clsAbsorptionCoefficient_Find1 = new clsAbsorptionCoefficient_Find();
clsAbsorptionCoefficient_Find1.strName = edtName.Text;
clsAbsorptionCoefficient_Find1.strAlpha = edtAlpha.Text;
//clsAbsorptionCoefficient_Find1.str16 = edt16.Text;
clsAbsorptionCoefficient_Find1.str2000 = edt2000.Text;
clsAbsorptionCoefficient_Find1.str4000 = edt4000.Text;
clsAbsorptionCoefficient_Find1.str1000 = edt1000.Text;
clsAbsorptionCoefficient_Find1.str500 = edt500.Text;
//clsAbsorptionCoefficient_Find1.str250 = edt250.Text;
//clsAbsorptionCoefficient_Find1.str125 = edt125.Text;
//clsAbsorptionCoefficient_Find1.str63 = edt63.Text;
//clsAbsorptionCoefficient_Find1.str31_5 = edt31_5.Text;
clsAbsorptionCoefficient_Find1.str8000 = edt8000.Text;
clsAbsorptionCoefficient_Find1.str10000 = edt10000.Text;
this.Close();
}
private string AbsorptionCoefficient_AnechoicTerminationCheck(DataSet ds,clsAbsorptionCoefficient_Find cls)
{
string strIDs = "";
string strFreq = "";
string strY = "";
string [] arrFreq;
string [] arrY;
string Y_16 = ""; // ���ļ��� 16 �϶� Y ��
string Y_31_5 = "";
string Y_63 = "";
string Y_125 = "";
string Y_250 = "";
string Y_500 = "";
string Y_1000 = "";
string Y_2000 = "";
string Y_4000 = "";
string Y_8000 = "";
string Y_10000 = "";
pSeries_Search = new DataPlotter.DataSeries();
double [] dimdf_X = new double[11];
double [] dimdf_Y = new double[11];
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_AnechoicTermination"].ToString();
if(strFreq != "")
{
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 "16" :
Y_16 = arrY[j].ToString();
break;
case "31.5" :
Y_31_5 = arrY[j].ToString();
break;
case "63" :
Y_63 = arrY[j].ToString();
break;
case "125" :
Y_125 = arrY[j].ToString();
break;
case "250" :
Y_250 = arrY[j].ToString();
break;
case "500" :
Y_500 = arrY[j].ToString();
break;
case "1000" :
Y_1000 = arrY[j].ToString();
break;
case "2000" :
Y_2000 = arrY[j].ToString();
break;
case "4000" :
Y_4000 = 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.str500 != "")
{
temp_cls = double.Parse(cls.str500);
temp_db = double.Parse(Y_500);
if(temp_cls > temp_db)
{
bResult = false;
}
dimdf_X[5] = 500;
dimdf_Y[5] = temp_db;
}
if(cls.str1000 != "")
{
temp_cls = double.Parse(cls.str1000);
temp_db = double.Parse(Y_1000);
if(temp_cls > temp_db)
{
bResult = false;
}
dimdf_X[6] = 1000;
dimdf_Y[6] = temp_db;
}
if(cls.str2000 != "")
{
temp_cls = double.Parse(cls.str2000);
temp_db = double.Parse(Y_2000);
if(temp_cls > temp_db)
{
bResult = false;
}
dimdf_X[7] = 2000;
dimdf_Y[7] = temp_db;
}
if(cls.str4000 != "")
{
temp_cls = double.Parse(cls.str4000);
temp_db = double.Parse(Y_4000);
if(temp_cls > temp_db)
{
bResult = false;
}
dimdf_X[8] = 4000;
dimdf_Y[8] = temp_db;
}
if(cls.str8000 != "")
{
temp_cls = double.Parse(cls.str8000);
temp_db = double.Parse(Y_8000);
if(temp_cls > temp_db)
{
bResult = false;
}
dimdf_X[9] = 8000;
dimdf_Y[9] = temp_db;
}
if(cls.str10000 != "")
{
temp_cls = double.Parse(cls.str10000);
temp_db = double.Parse(Y_10000);
if(temp_cls > temp_db)
{
bResult = false;
}
dimdf_X[10] = 10000;
dimdf_Y[10] = temp_db;
}
#endregion
}
else
{
bResult = false;
}
}
else
{
bResult = false;
}
if(bResult == true) // ���ǿ� �����ϸ�ID �� �߰��Ѵ�
{
strIDs = strIDs + ds.Tables[0].Rows[i]["SGID"].ToString() + ",";
}
}
pSeries_Search.XData = dimdf_X;
pSeries_Search.YData = dimdf_Y;
if(strIDs != "")
{
strIDs = strIDs.Substring(0,strIDs.Length - 1);
}
return strIDs;
}
