public bool DBSave_Single(string Measured, string Temperature, string Incidence, string IncAngle, string FreqBand, string Frequency, string Rgraph_RB
, string Rgraph_AT, string Rgraph_TL)
{
bool result = false;
int dSID = 0;
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
if (this.IsMaterialCreate == true)
{
dSID = MPA_DB1.GetMax_ID_SingleMeterial();
MPA_DB1.CreateSingleMeterial(dSID, Name, MID.ToString(), Thick.ToString(), BulkDens.ToString(), FlowRes.ToString(), SFactor.ToString(), Porosity.ToString()
, ViscousCL.ToString(), ThermalCL.ToString(), Ymodulus.ToString(), PoissionR.ToString(), LossFactor.ToString(), "0", "0", "0", "0", "0", "0", "0", "0");
}
if (dSID == 0)
{
dSID = this.SID;
}
int dSGID = MPA_DB1.GetMax_ID_SingleMeterialGraph();
MPA_DB1.CreateSingleMaterialGraph(dSGID, dSID, Name, Measured.ToString(), Temperature.ToString(), Incidence.ToString(), IncAngle.ToString(), FreqBand.ToString(), "1"
, Frequency, Rgraph_RB, "", "");
dSGID = MPA_DB1.GetMax_ID_SingleMeterialGraph();
MPA_DB1.CreateSingleMaterialGraph(dSGID, dSID, Name, Measured.ToString(), Temperature.ToString(), Incidence.ToString(), IncAngle.ToString(), FreqBand.ToString(), "2"
, Frequency, "", Rgraph_AT, "");
dSGID = MPA_DB1.GetMax_ID_SingleMeterialGraph();
MPA_DB1.CreateSingleMaterialGraph(dSGID, dSID, Name, Measured.ToString(), Temperature.ToString(), Incidence.ToString(), IncAngle.ToString(), FreqBand.ToString(), "3"
, Frequency, "", "", Rgraph_TL);
return(result);
}
// private void lnkMaterialInformation_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
// {
// dgMaterial dgMaterial1 = new dgMaterial();
//
// if(dgMaterial1.ShowDialog() == DialogResult.OK)
// {
// strSelectedMaterialType = dgMaterial1.GetSelectedType();
// //strSelectedMaterialValue = dgMaterial1.GetSelectedValue();
// }
// }
//
// private void lnkAcousticPerformance_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)
// {
// dgAcousticPerformance dgAcousticPerformance1 = new dgAcousticPerformance();
//
// if(dgAcousticPerformance1.ShowDialog() == DialogResult.OK)
// {
// strSelectedPerformance = dgAcousticPerformance1.GetSelectedPerformance();
// dSelectedPerformance = dgAcousticPerformance1.GetSelectedPerformance_int();
// }
// }
/// <summary>
/// 데이터 베이스 에서 로드한것인지 사용자가 입력한것인지 체크한다 (이 함수 실행후 진행하려면 true 를 리턴하고 진행하면 안될경우 false 리턴)
/// </summary>
/// <returns></returns>
private bool DataBaseLoadCheck()
{
bool bResult = false;
if (bIsDataBaseLoad == true)
{
bResult = true;
}
else
{
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
if (MPA_DB1.IsExist(true, edtName.Text) == true)
{
MessageBox.Show("이미 같은 이름이 존재합니다.");
bResult = true;
}
else
{
bResult = true;
}
}
return(bResult);
}
public bool DBSave_Multi()
{
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
bool result = false;
int dLID = 0;
IsMaterialCreateCheck(); // 하나라도 있으면 true ->> 고로 다시 생성하여야 함
if (this.IsMaterialCreate == true)
{
dLID = DBSave_MultiMaterial(this.Name, this.TotalThickness.ToString());
}
if (dLID == 0)
{
dLID = this.LID;
}
for (int i = 0; i < MatCollection.Count; i++)
{
int SID = ((MPAMaterial)MatCollection[i]).DBSave_Multi(Measured.ToString(), Temperature.ToString(), Incidence.ToString(), IncAngle.ToString(), FreqBand.ToString());
DBSave_LayerDetail(dLID, SID, i);
}
DBSave_MultiGraph(dLID);
return(result);
}
public int DBSave_LayerDetail(int dLID, int dSID, int dOrder)
{
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
int dDID = MPA_DB1.GetMax_ID_LayerDetail();
MPA_DB1.CreateLayerDetail(dDID, dLID, dSID, dOrder);
return(dLID);
}
public int DBSave_MultiMaterial(string strName, string strTotalThick)
{
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
int dLID = MPA_DB1.GetMax_ID_MultiMeterial();
MPA_DB1.CreateMultiMeterial(dLID, Name, strTotalThick);
return(dLID);
}
public int DBSave_Multi(string Measured, string Temperature, string Incidence, string IncAngle, string FreqBand)
{
int dSID = 0;
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
if (this.IsMaterialCreate == true)
{
dSID = MPA_DB1.GetMax_ID_SingleMeterial();
MPA_DB1.CreateSingleMeterial(dSID, Name, MID.ToString(), Thick.ToString(), BulkDens.ToString(), FlowRes.ToString(), SFactor.ToString(), Porosity.ToString()
, ViscousCL.ToString(), ThermalCL.ToString(), Ymodulus.ToString(), PoissionR.ToString(), LossFactor.ToString(), "0", "0", "0", "0", "0", "0", "0", "0");
}
if (dSID == 0)
{
dSID = this.SID;
}
return(dSID);
}
public int DBSave_MultiGraph(int dLID)
{
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
int LGID = MPA_DB1.GetMax_ID_MultiLayerMaterialGraph();
MPA_DB1.CreateMultiMaterialGraph(LGID, dLID, Name, Measured.ToString(), Temperature.ToString(), Incidence.ToString(), IncAngle.ToString(), FreqBand.ToString(), "1"
, Frequency.GetString(), RigidBacking.GetString(), "", "");
LGID = MPA_DB1.GetMax_ID_MultiLayerMaterialGraph();
MPA_DB1.CreateMultiMaterialGraph(LGID, dLID, Name, Measured.ToString(), Temperature.ToString(), Incidence.ToString(), IncAngle.ToString(), FreqBand.ToString(), "2"
, Frequency.GetString(), "", AnechoicTermination.GetString(), "");
LGID = MPA_DB1.GetMax_ID_MultiLayerMaterialGraph();
MPA_DB1.CreateMultiMaterialGraph(LGID, dLID, Name, Measured.ToString(), Temperature.ToString(), Incidence.ToString(), IncAngle.ToString(), FreqBand.ToString(), "3"
, Frequency.GetString(), "", "", TransmissionLoss.GetString());
return(LGID);
}
public bool DBSave_Single(string Measured,string Temperature,string Incidence,string IncAngle,string FreqBand,string Frequency,string Rgraph_RB
,string Rgraph_AT,string Rgraph_TL)
{
bool result = false;
int dSID = 0;
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
if(this.IsMaterialCreate == true)
{
dSID = MPA_DB1.GetMax_ID_SingleMeterial();
MPA_DB1.CreateSingleMeterial(dSID,Name,MID.ToString(),Thick.ToString(),BulkDens.ToString(),FlowRes.ToString(),SFactor.ToString(),Porosity.ToString()
,ViscousCL.ToString(),ThermalCL.ToString(),Ymodulus.ToString(),PoissionR.ToString(),LossFactor.ToString(),"0","0","0","0","0","0","0","0");
}
if(dSID == 0)
{
dSID = this.SID;
}
int dSGID = MPA_DB1.GetMax_ID_SingleMeterialGraph();
MPA_DB1.CreateSingleMaterialGraph(dSGID,dSID,Name,Measured.ToString(),Temperature.ToString(),Incidence.ToString(),IncAngle.ToString(),FreqBand.ToString(),"1"
,Frequency,Rgraph_RB,"","");
dSGID = MPA_DB1.GetMax_ID_SingleMeterialGraph();
MPA_DB1.CreateSingleMaterialGraph(dSGID,dSID,Name,Measured.ToString(),Temperature.ToString(),Incidence.ToString(),IncAngle.ToString(),FreqBand.ToString(),"2"
,Frequency,"",Rgraph_AT,"");
dSGID = MPA_DB1.GetMax_ID_SingleMeterialGraph();
MPA_DB1.CreateSingleMaterialGraph(dSGID,dSID,Name,Measured.ToString(),Temperature.ToString(),Incidence.ToString(),IncAngle.ToString(),FreqBand.ToString(),"3"
,Frequency,"","",Rgraph_TL);
return result;
}
public int DBSave_Multi(string Measured,string Temperature,string Incidence,string IncAngle,string FreqBand)
{
int dSID = 0;
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
if(this.IsMaterialCreate == true)
{
dSID = MPA_DB1.GetMax_ID_SingleMeterial();
MPA_DB1.CreateSingleMeterial(dSID,Name,MID.ToString(),Thick.ToString(),BulkDens.ToString(),FlowRes.ToString(),SFactor.ToString(),Porosity.ToString()
,ViscousCL.ToString(),ThermalCL.ToString(),Ymodulus.ToString(),PoissionR.ToString(),LossFactor.ToString(),"0","0","0","0","0","0","0","0");
}
if(dSID == 0)
{
dSID = this.SID;
}
return dSID;
}
/// <summary>
/// ������ ���̽� ���� �ε��Ѱ����� ����ڰ� �Է��Ѱ����� üũ�Ѵ� (�� �Լ� ������ �����Ϸ��� true �� �����ϰ� �����ϸ� �ȵɰ�� false ����)
/// </summary>
/// <returns></returns>
private bool DataBaseLoadCheck()
{
bool bResult = false;
if(IsDataBaseLoad == true)
{
bResult = true;
}
else
{
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
if(MPA_DB1.IsExist(false,edtName.Text) == true)
{
MessageBox.Show("�̹� ���� �̸��� �����մϴ�.");
bResult = true;
}
else
{
bResult = true;
}
}
return bResult;
}
public int DBSave_MultiMaterial(string strName,string strTotalThick)
{
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
int dLID = MPA_DB1.GetMax_ID_MultiMeterial();
MPA_DB1.CreateMultiMeterial(dLID,Name,strTotalThick);
return dLID;
}
public int DBSave_MultiGraph(int dLID)
{
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
int LGID = MPA_DB1.GetMax_ID_MultiLayerMaterialGraph();
MPA_DB1.CreateMultiMaterialGraph(LGID,dLID,Name,Measured.ToString(),Temperature.ToString(),Incidence.ToString(),IncAngle.ToString(),FreqBand.ToString(),"1"
,Frequency.GetString(),RigidBacking.GetString(),"","");
LGID = MPA_DB1.GetMax_ID_MultiLayerMaterialGraph();
MPA_DB1.CreateMultiMaterialGraph(LGID,dLID,Name,Measured.ToString(),Temperature.ToString(),Incidence.ToString(),IncAngle.ToString(),FreqBand.ToString(),"2"
,Frequency.GetString(),"",AnechoicTermination.GetString(),"");
LGID = MPA_DB1.GetMax_ID_MultiLayerMaterialGraph();
MPA_DB1.CreateMultiMaterialGraph(LGID,dLID,Name,Measured.ToString(),Temperature.ToString(),Incidence.ToString(),IncAngle.ToString(),FreqBand.ToString(),"3"
,Frequency.GetString(),"","",TransmissionLoss.GetString());
return LGID;
}
public bool DBSave_Multi()
{
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
bool result = false;
int dLID = 0;
IsMaterialCreateCheck(); // �ϳ��� ������ true ->> ��� �ٽ� �����Ͽ��� ��
if(this.IsMaterialCreate == true)
{
dLID = DBSave_MultiMaterial(this.Name,this.TotalThickness.ToString());
}
if(dLID == 0)
{
dLID = this.LID;
}
for(int i = 0 ; i < MatCollection.Count ; i++)
{
int SID = ((MPAMaterial)MatCollection[i]).DBSave_Multi(Measured.ToString(),Temperature.ToString(),Incidence.ToString(),IncAngle.ToString(),FreqBand.ToString());
DBSave_LayerDetail(dLID,SID,i);
}
DBSave_MultiGraph(dLID);
return result;
}
public int DBSave_LayerDetail(int dLID,int dSID,int dOrder)
{
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
int dDID = MPA_DB1.GetMax_ID_LayerDetail();
MPA_DB1.CreateLayerDetail(dDID,dLID,dSID,dOrder);
return dLID;
}
public void Save(MPEData MPEData1)
{
int dID = int.Parse(strSearchResult_Selected_ID);
HONUS.MaterialPerformanceAnalysis.Component.MPA_DB MPA_DB1 = new HONUS.MaterialPerformanceAnalysis.Component.MPA_DB();
if(bIsSingle == true)
{
int dMax_ID_SingleMeterialGraph = MPA_DB1.GetMax_ID_SingleMeterialGraph();
if(GetGraphType().ToString() == "1")
{
MPA_DB1.CreateSingleMaterialGraph(dMax_ID_SingleMeterialGraph,dID,strSelectedName,GetMeasured().ToString(),edtTemperature.Text,GetIncidence().ToString()
,edtAngle.Text,GetFreqBand().ToString(),GetGraphType().ToString(),MPEData1.Frequency.GetString(),MPEData1.MAbsorption.GetString(),"","");
}
else if(GetGraphType().ToString() == "2")
{
MPA_DB1.CreateSingleMaterialGraph(dMax_ID_SingleMeterialGraph,dID,strSelectedName,GetMeasured().ToString(),edtTemperature.Text,GetIncidence().ToString()
,edtAngle.Text,GetFreqBand().ToString(),GetGraphType().ToString(),MPEData1.Frequency.GetString(),"",MPEData1.MAbsorption.GetString(),"");
}
else if(GetGraphType().ToString() == "3")
{
MPA_DB1.CreateSingleMaterialGraph(dMax_ID_SingleMeterialGraph,dID,strSelectedName,GetMeasured().ToString(),edtTemperature.Text,GetIncidence().ToString()
,edtAngle.Text,GetFreqBand().ToString(),GetGraphType().ToString(),MPEData1.Frequency.GetString(),"","",MPEData1.MAbsorption.GetString());
}
}
else
{
int dMax_ID_MultiMeterialGraph = MPA_DB1.GetMax_ID_MultiLayerMaterialGraph();
if(GetGraphType().ToString() == "1")
{
MPA_DB1.CreateMultiMaterialGraph(dMax_ID_MultiMeterialGraph,dID,strSelectedName,GetMeasured().ToString(),edtTemperature.Text,GetIncidence().ToString()
,edtAngle.Text,GetFreqBand().ToString(),GetGraphType().ToString(),MPEData1.Frequency.GetString(),MPEData1.MAbsorption.GetString(),"","");
}
else if(GetGraphType().ToString() == "2")
{
MPA_DB1.CreateSingleMaterialGraph(dMax_ID_MultiMeterialGraph,dID,strSelectedName,GetMeasured().ToString(),edtTemperature.Text,GetIncidence().ToString()
,edtAngle.Text,GetFreqBand().ToString(),GetGraphType().ToString(),MPEData1.Frequency.GetString(),"",MPEData1.MAbsorption.GetString(),"");
}
else if(GetGraphType().ToString() == "3")
{
MPA_DB1.CreateSingleMaterialGraph(dMax_ID_MultiMeterialGraph,dID,strSelectedName,GetMeasured().ToString(),edtTemperature.Text,GetIncidence().ToString()
,edtAngle.Text,GetFreqBand().ToString(),GetGraphType().ToString(),MPEData1.Frequency.GetString(),"","",MPEData1.MAbsorption.GetString());
}
}
}
