private void cboMeterialType_Bind() { // cboMeterialType.Items.Add("Limp porous material"); // cboMeterialType.Items.Add("Rigid porous material"); // cboMeterialType.Items.Add("Elastic porous material"); // // cboMeterialType.SelectedIndex = 0; cboMeterialType.Items.Clear(); MPE_DB MPE_DB1 = new MPE_DB(); MaterialTypeds = MPE_DB1.GetMaterialType(1); // cboMeterialType.DataSource = ds; // cboMeterialType.DisplayMember = "MatType"; // cboMeterialType.ValueMember = "MID"; for(int i = 0 ; i < MaterialTypeds.Tables[0].Rows.Count ; i++) { MaterialType MaterialType1 = new MaterialType(); MaterialType1.Name = MaterialTypeds.Tables[0].Rows[i]["MatType"].ToString(); MaterialType1.ID = MaterialTypeds.Tables[0].Rows[i]["MID"].ToString(); cboMeterialType.Items.Add(MaterialType1.Name); } cboMeterialType.SelectedIndex = 0; }
/// <summary> /// DB ���� �⺻���� �͵��� �����´� /// </summary> private void lstDBList_Load() { ListViewItem list; MPE_DB MPE_DB1 = new MPE_DB(); dsDataBaseLoad = MPE_DB1.GetDBDefault_Load(); for(int i = 0 ; i < dsDataBaseLoad.Tables[0].Rows.Count ; i++) { list = new ListViewItem(); list.Text = dsDataBaseLoad.Tables[0].Rows[i]["Name"].ToString(); lstDBList.Items.Add(list); } }
public void Save(string MID,string Measured,string Temperature,string Incidence,string IncAngle,string FreqBand) { if(edtName.Text != "") { if(mpeClass != null) { MPE_DB MPE_DB1 = new MPE_DB(); if(MPE_DB1.ISNameSame(edtName.Text) > 0) { MessageBox.Show("�̹� ���� �̸��� �����մϴ�."); int dMax_ID_SingleMeterial = MPE_DB1.GetMax_ID_SingleMeterial(); MPE_DB1.CreateSingleMeterial(dMax_ID_SingleMeterial,edtName.Text,MID,mpeClass.Thickness.ToString(),mpeClass.BulkDensity.ToString(), mpeClass.FResist.ToString(),mpeClass.SFactor.ToString(),mpeClass.Porosity.ToString(),mpeClass.ViscousCL.ToString(),mpeClass.ThermalCL.ToString(), mpeClass.Ymodulus.ToString(),mpeClass.PoissonR.ToString(),mpeClass.LossFactor.ToString(),"0","0","0","0","0","0","0","0"); int dMax_ID_SingleMeterialGraph = MPE_DB1.GetMax_ID_SingleMeterialGraph(); string GraphType = GetGraphType(); // MPE_DB1.CreateSingleMaterialGraph(dMax_ID_SingleMeterialGraph,dMax_ID_SingleMeterial,"",Measured,Temperature,Incidence,IncAngle,FreqBand,"1", // mpeClass.Frequency.GetString(),mpeClass.CAbsorption.GetString(),mpeClass.CSurfaceImpedance.GetString(),""); MPE_DB1.CreateSingleMaterialGraph(dMax_ID_SingleMeterialGraph,dMax_ID_SingleMeterial,edtName.Text,Measured,Temperature,Incidence,IncAngle,FreqBand,"1", mpeClass.Frequency.GetString(),mpeClass.MAbsorption.GetString(),"",""); MessageBox.Show("����Ǿ����ϴ�.","����"); } else { int dMax_ID_SingleMeterial = MPE_DB1.GetMax_ID_SingleMeterial(); MPE_DB1.CreateSingleMeterial(dMax_ID_SingleMeterial,edtName.Text,MID,mpeClass.Thickness.ToString(),mpeClass.BulkDensity.ToString(), mpeClass.FResist.ToString(),mpeClass.SFactor.ToString(),mpeClass.Porosity.ToString(),mpeClass.ViscousCL.ToString(),mpeClass.ThermalCL.ToString(), mpeClass.Ymodulus.ToString(),mpeClass.PoissonR.ToString(),mpeClass.LossFactor.ToString(),"0","0","0","0","0","0","0","0"); int dMax_ID_SingleMeterialGraph = MPE_DB1.GetMax_ID_SingleMeterialGraph(); string GraphType = GetGraphType(); // MPE_DB1.CreateSingleMaterialGraph(dMax_ID_SingleMeterialGraph,dMax_ID_SingleMeterial,"",Measured,Temperature,Incidence,IncAngle,FreqBand,"1", // mpeClass.Frequency.GetString(),mpeClass.CAbsorption.GetString(),mpeClass.CSurfaceImpedance.GetString(),""); MPE_DB1.CreateSingleMaterialGraph(dMax_ID_SingleMeterialGraph,dMax_ID_SingleMeterial,edtName.Text,Measured,Temperature,Incidence,IncAngle,FreqBand,"1", mpeClass.Frequency.GetString(),mpeClass.MAbsorption.GetString(),"",""); MessageBox.Show("����Ǿ����ϴ�.","����"); } } } else { MessageBox.Show("Name �� �Է��Ͽ� �ֽʽÿ�"); } }
private void DB_Load(MPEData MPEData1) { MPE_DB MPE_DB1 = new MPE_DB(); DataSet ds = MPE_DB1.GetSingleMaterialGraph(lblDataBaseLoad_ID.Text); string strGraphType = ds.Tables[0].Rows[0]["GraphType"].ToString(); string strX_Axis = ds.Tables[0].Rows[0]["X_Axis"].ToString(); string strY_RigidBacking = ds.Tables[0].Rows[0]["Y_RigidBacking"].ToString(); string strY_AnechoicTermination = ds.Tables[0].Rows[0]["Y_AnechoicTermination"].ToString(); if(strX_Axis != "") { string [] dstrX_Axis = strX_Axis.Split(",".ToCharArray()); string [] dstrY_RigidBacking = strY_RigidBacking.Split(",".ToCharArray()); string [] dstrY_AnechoicTermination = strY_AnechoicTermination.Split(",".ToCharArray()); if(strGraphType == "1") { for(int i = 0 ; i < dstrX_Axis.Length ; i++) { MPEData1.Frequency.AddData(double.Parse(dstrX_Axis[i].ToString())); MPEData1.MAbsorption.AddData(double.Parse(dstrY_RigidBacking[i].ToString())); } } // else if(strGraphType == "2") // { // for(int i = 0 ; i < dstrX_Axis.Length ; i++) // { // MPEData1.Frequency.AddData(double.Parse(dstrX_Axis[i].ToString())); // MPEData1.MSurfaceImpedance.AddData(double.Parse(dstrY_AnechoicTermination[i].ToString())); // } // } } }