private void btnDataBaseLoad_Click(object sender, System.EventArgs e)
{
HONUS.MaterialDatabase.Form.frmMD_Main2 frmMD = new HONUS.MaterialDatabase.Form.frmMD_Main2();
frmMD.bIsSearchPopup = true;
frmMD.ClosingFlag = true;
frmMD.ucSearchingCondition_SingleMulti_Control(true);
if (frmMD.ShowDialog() == DialogResult.OK)
{
string strSelected_ID = frmMD.strSelectedItem_ID;
HONUS.MaterialDatabase.Component.MD_DB MD_DB1 = new HONUS.MaterialDatabase.Component.MD_DB();
DataSet dsSearchResult = MD_DB1.Search(frmMD.bIsSingle, strSelected_ID);
edtName.Text = dsSearchResult.Tables[0].Rows[0]["Name"].ToString();
cboType_Select(dsSearchResult.Tables[0].Rows[0]["MatType"].ToString());
edtFlowResistivity.Text = dsSearchResult.Tables[0].Rows[0]["FlowRes"].ToString();
edtThickness.Text = dsSearchResult.Tables[0].Rows[0]["Thick"].ToString();
edtLossFactor.Text = dsSearchResult.Tables[0].Rows[0]["LossFactor"].ToString();
edtBulkDensity.Text = dsSearchResult.Tables[0].Rows[0]["BulkDens"].ToString();
edtYoungsModulus.Text = dsSearchResult.Tables[0].Rows[0]["Ymodulus"].ToString();
edtPoissionsRatio.Text = dsSearchResult.Tables[0].Rows[0]["PoissionR"].ToString();
edtProsity.Text = dsSearchResult.Tables[0].Rows[0]["Prosity"].ToString();
edtStructureFactor.Text = dsSearchResult.Tables[0].Rows[0]["Sfactor"].ToString();
edtViscousCharLength.Text = dsSearchResult.Tables[0].Rows[0]["ViscousCL"].ToString();
edtThermalCharLength.Text = dsSearchResult.Tables[0].Rows[0]["ThermalCL"].ToString();
bIsDataBaseLoad = true;
}
else
{
}
}
private void btnDBNameLoad_Click(object sender, System.EventArgs e)
{
HONUS.MaterialDatabase.Form.frmMD_Main2 frmMD = new HONUS.MaterialDatabase.Form.frmMD_Main2();
frmMD.bIsSearchPopup = true;
frmMD.ClosingFlag = true;
frmMD.ucSearchingCondition_SingleMulti_Control(false);
if(frmMD.ShowDialog() == DialogResult.OK)
{
string strSelected_ID = frmMD.strSelectedItem_ID;
HONUS.MaterialDatabase.Component.MD_DB MD_DB1 = new HONUS.MaterialDatabase.Component.MD_DB();
DataSet dsSearchResult = MD_DB1.Search(frmMD.bIsSingle,strSelected_ID);
for(int i = 0 ; i < dsSearchResult.Tables[0].Rows.Count ; i++)
{
edtName.Text = dsSearchResult.Tables[0].Rows[i]["Name"].ToString();
cboType_Select(dsSearchResult.Tables[0].Rows[i]["MatType"].ToString());
edtFlowResistivity.Text = dsSearchResult.Tables[0].Rows[i]["FlowRes"].ToString();
edtThickness.Text = dsSearchResult.Tables[0].Rows[i]["Thick"].ToString();
edtLossFactor.Text = dsSearchResult.Tables[0].Rows[i]["LossFactor"].ToString();
edtBulkDensity.Text = dsSearchResult.Tables[0].Rows[i]["BulkDens"].ToString();
edtYoungsModulus.Text = dsSearchResult.Tables[0].Rows[i]["Ymodulus"].ToString();
edtPoissionsRatio.Text = dsSearchResult.Tables[0].Rows[i]["PoissionR"].ToString();
edtThermalCharLength.Text = dsSearchResult.Tables[0].Rows[i]["ThermalCL"].ToString();
edtViscousCharLength.Text = dsSearchResult.Tables[0].Rows[i]["ViscousCL"].ToString();
edtProsity.Text = dsSearchResult.Tables[0].Rows[i]["Prosity"].ToString();
edtStructureFactor.Text = dsSearchResult.Tables[0].Rows[i]["Sfactor"].ToString();
edtEmp1.Text = dsSearchResult.Tables[0].Rows[i]["EmP1"].ToString();
edtPratiop1.Text = dsSearchResult.Tables[0].Rows[i]["PRatioP1"].ToString();
edthp2.Text = dsSearchResult.Tables[0].Rows[i]["HP2"].ToString();
edtdensityp2.Text = dsSearchResult.Tables[0].Rows[i]["DensityP2"].ToString();
edthp1.Text = dsSearchResult.Tables[0].Rows[i]["HP1"].ToString();
edtdensityp1.Text = dsSearchResult.Tables[0].Rows[i]["DensityP1"].ToString();
edtEmp2.Text = dsSearchResult.Tables[0].Rows[i]["EmP2"].ToString();
edtPratiop2.Text = dsSearchResult.Tables[0].Rows[i]["PRatioP2"].ToString();
if(dsSearchResult.Tables[0].Rows[0]["Occurred_Date"].ToString() != "")
{
dtDate.Value = DateTime.Parse(dsSearchResult.Tables[0].Rows[0]["Occurred_Date"].ToString());
}
edtVendor.Text = dsSearchResult.Tables[0].Rows[0]["Vendor"].ToString();
edtProducing.Text = dsSearchResult.Tables[0].Rows[0]["Producing"].ToString();
btnAdd_Click(null,null);
}
}
else
{
}
}
private void btnDataBaseLoad_Click(object sender, System.EventArgs e)
{
HONUS.MaterialDatabase.Form.frmMD_Main2 frmMD = new HONUS.MaterialDatabase.Form.frmMD_Main2();
frmMD.bIsSearchPopup = true;
frmMD.ClosingFlag = true;
frmMD.ucSearchingCondition_SingleMulti_Control(true);
if(frmMD.ShowDialog() == DialogResult.OK)
{
string strSelected_ID = frmMD.strSelectedItem_ID;
HONUS.MaterialDatabase.Component.MD_DB MD_DB1 = new HONUS.MaterialDatabase.Component.MD_DB();
DataSet dsSearchResult = MD_DB1.Search(frmMD.bIsSingle,strSelected_ID);
edtName.Text = dsSearchResult.Tables[0].Rows[0]["Name"].ToString();
cboType_Select(dsSearchResult.Tables[0].Rows[0]["MatType"].ToString());
edtFlowResistivity.Text = dsSearchResult.Tables[0].Rows[0]["FlowRes"].ToString();
edtThickness.Text = dsSearchResult.Tables[0].Rows[0]["Thick"].ToString();
edtLossFactor.Text = dsSearchResult.Tables[0].Rows[0]["LossFactor"].ToString();
edtBulkDensity.Text = dsSearchResult.Tables[0].Rows[0]["BulkDens"].ToString();
edtYoungsModulus.Text = dsSearchResult.Tables[0].Rows[0]["Ymodulus"].ToString();
edtPoissionsRatio.Text = dsSearchResult.Tables[0].Rows[0]["PoissionR"].ToString();
edtProsity.Text = dsSearchResult.Tables[0].Rows[0]["Prosity"].ToString();
edtStructureFactor.Text = dsSearchResult.Tables[0].Rows[0]["Sfactor"].ToString();
edtViscousCharLength.Text = dsSearchResult.Tables[0].Rows[0]["ViscousCL"].ToString();
edtThermalCharLength.Text = dsSearchResult.Tables[0].Rows[0]["ThermalCL"].ToString();
bIsDataBaseLoad = true;
}
else
{
}
}