public bool InsertModelDetail(ModelDetailInfo mdInfo)
{
try
{
mmTba.InsertMstDetail(
mdInfo.Model_id,
mdInfo.Model_name,
mdInfo.User_edit
);
return(true);
}
catch
{
return(false);
}
}
public bool UpdateModelDetail(ModelDetailInfo mdInfo)
{
try
{
mdTba.UpdateModelDetail(
mdInfo.Rank_id, mdInfo.Part_mid, mdInfo.Part_max,
mdInfo.Part_min, mdInfo.Part_cycletime, mdInfo.User_edit,
mdInfo.Part_status, mdInfo.Model_id,
mdInfo.Part_id, mdInfo.PartType_id
);
return(true);
}
catch
{
return(false);
}
}
private object DataRowToObject(DataRow r, Type t)
{
if (t == typeof(ModelDetailInfo))
{
ModelDetailInfo item = new ModelDetailInfo();
DataSet.etd_model_detailRow dr = (DataSet.etd_model_detailRow)r;
item.Model_id = dr.m_id;
item.Part_id = dr.p_id;
item.PartType_id = dr.pt_id;
item.Rank_id = dr.r_id;
item.Part_mid = dr.p_mid_dimension;
item.Part_max = dr.p_max_dimension;
item.Part_min = dr.p_min_dimension;
item.Part_cycletime = dr.p_cycletime;
item.User_edit = dr.p_user;
item.Part_status = dr.p_status;
return(item);
}
return(null);
}
protected void btnPistonSave_Click(object sender, EventArgs e)
{
ModelDetailInfo _ModelDetailInfo = new ModelDetailInfo();
bufModelID = Request.QueryString["id"];
var bufSplit = bufModelID.Split(',');
ArrayList _data = viModelSer.GetModelDetailDataByModelIDANDPartID(bufSplit[0].ToString(), "2");
foreach (VIModelDetailInfo dataInfo in _data)
{
_ModelDetailInfo.Model_id = bufSplit[0].ToString();
_ModelDetailInfo.Part_id = dataInfo.Part_id;
_ModelDetailInfo.PartType_id = dataInfo.PartType_id;
_ModelDetailInfo.Part_status = true;
_ModelDetailInfo.User_edit = Session["userName"].ToString();
//OD
if (dataInfo.PartType_name == "OD")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtPisODCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtPisODMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisODMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtPisODMin.Text);
_ModelDetailInfo.Rank_id = dropDownPisODRank.SelectedValue;
}
else if (dataInfo.PartType_name == "OD CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisODCylindricMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisODCylindricRank.SelectedValue;
}
else if (dataInfo.PartType_name == "OD ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisODRoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisODRoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "OD PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisODPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisODPerpenRank.SelectedValue;
}
//ID
else if (dataInfo.PartType_name == "ID")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtPisIDCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtPisIDMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisIDMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtPisIDMin.Text);
_ModelDetailInfo.Rank_id = dropDownPisIDRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisIDCylindricMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisIDCylindricRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisIDRoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisIDRoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisIDPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisIDPerpenRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID CONCENTRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisIDConcenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisIDConcenRank.SelectedValue;
}
//HEIGHT
else if (dataInfo.PartType_name == "HEIGHT")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtPisHeightCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtPisHeightMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisHeightMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtPisHeightMin.Text);
_ModelDetailInfo.Rank_id = dropDownPisHeightRank.SelectedValue;
}
else if (dataInfo.PartType_name == "HEIGHT PARALLISM")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisHiParallismMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisHiParallismRank.SelectedValue;
}
//BLADE
else if (dataInfo.PartType_name == "BLADE THICKNESS")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtPisBLCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtBLThicknessMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtBLThicknessMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtBLThicknessMin.Text);
_ModelDetailInfo.Rank_id = dropDownBLThicknessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BLADE PARALLISM")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtBLParallismMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownBLParallismRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BLADE PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtBLPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownBLPerpenRank.SelectedValue;
}
//FLATNESS
else if (dataInfo.PartType_name == "FLATNESS 1")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtPisFLCycleTime.Text);
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisFlatnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisFlatnessRank.SelectedValue;
}
moDetailSer.UpdateModelDetail(_ModelDetailInfo);
}
}
protected void btnPistonSave_Click(object sender, EventArgs e)
{
ModelDetailInfo _ModelDetailInfo = new ModelDetailInfo();
ArrayList _data = viModelSer.GetModelDetailDataByModelIDANDPartID("011", "2");
foreach (VIModelDetailInfo dataInfo in _data)
{
_ModelDetailInfo.Model_id = txtModelNo.Text;
_ModelDetailInfo.Model_name = txtModelName.Text;
_ModelDetailInfo.Part_id = dataInfo.Part_id;
_ModelDetailInfo.PartType_id = dataInfo.PartType_id;
_ModelDetailInfo.Part_status = true;
_ModelDetailInfo.User_edit = Session["userName"].ToString();
//OD
if (dataInfo.PartType_name == "OD")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtPisODCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtPisODMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisODMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtPisODMin.Text);
_ModelDetailInfo.Rank_id = dropDownPisODRank.SelectedValue;
}
else if (dataInfo.PartType_name == "OD CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisODCylindricMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisODCylindricRank.SelectedValue;
}
else if (dataInfo.PartType_name == "OD ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisODRoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisODRoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "OD PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisODPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisODPerpenRank.SelectedValue;
}
//ID
else if (dataInfo.PartType_name == "ID")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtPisIDCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtPisIDMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisIDMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtPisIDMin.Text);
_ModelDetailInfo.Rank_id = dropDownPisIDRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisIDCylindricMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisIDCylindricRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisIDRoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisIDRoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisIDPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisIDPerpenRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID CONCENTRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisIDConcenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisIDConcenRank.SelectedValue;
}
//HEIGHT
else if (dataInfo.PartType_name == "HEIGHT")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtPisHeightCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtPisHeightMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisHeightMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtPisHeightMin.Text);
_ModelDetailInfo.Rank_id = dropDownPisHeightRank.SelectedValue;
}
else if (dataInfo.PartType_name == "HEIGHT PARALLISM")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisHiParallismMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisHiParallismRank.SelectedValue;
}
//BLADE
else if (dataInfo.PartType_name == "BLADE THICKNESS")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtPisBLCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtBLThicknessMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtBLThicknessMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtBLThicknessMin.Text);
_ModelDetailInfo.Rank_id = dropDownBLThicknessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BLADE PARALLISM")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtBLParallismMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownBLParallismRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BLADE PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtBLPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownBLPerpenRank.SelectedValue;
}
//FLATNESS
else if (dataInfo.PartType_name == "FLATNESS 1")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtPisFLCycleTime.Text);
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtPisFlatnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownPisFlatnessRank.SelectedValue;
}
if (!moDetailSer.InsertModelDetail(_ModelDetailInfo))
{
lblErrModelNo.Text = "A Duplicate Model No.";
}
else
{
lblErrModelNo.Text = "";
}
}
if (lblErrModelNo.Text == "")
{
mmDetailSer.InsertModelDetail(_ModelDetailInfo);
proEtdSer.InsertNewProgramDetail(_ModelDetailInfo.Model_id);
Response.Write("<script>alert('SUCCEED!!');</script>");
//Response.Redirect("ModelCS.aspx");
}
}
protected void btnRHSave_Click(object sender, EventArgs e)
{
ModelDetailInfo _ModelDetailInfo = new ModelDetailInfo();
bufModelID = Request.QueryString["id"];
var bufSplit = bufModelID.Split(',');
ArrayList _data = viModelSer.GetModelDetailDataByModelIDANDPartID(bufSplit[0].ToString(), "5");
foreach (VIModelDetailInfo dataInfo in _data)
{
_ModelDetailInfo.Model_id = bufSplit[0].ToString();
_ModelDetailInfo.Part_id = dataInfo.Part_id;
_ModelDetailInfo.PartType_id = dataInfo.PartType_id;
_ModelDetailInfo.Part_status = true;
_ModelDetailInfo.User_edit = Session["userName"].ToString();
if (dataInfo.PartType_name == "ID")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtRHCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtRHIDMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtRHIDMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtRHIDMin.Text);
_ModelDetailInfo.Rank_id = dropDownRHIDRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtRHIDCylindricMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownRHIDCylindricRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtRHIDRoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownRHIDRoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtRHIDPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownRHIDPerpenRank.SelectedValue;
}
//FLATNESS
else if (dataInfo.PartType_name == "FLATNESS 1")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtRHIDFlatnessCycleTime.Text);
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtRHFlatness1Mid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownRHFlatness1Rank.SelectedValue;
}
else if (dataInfo.PartType_name == "FLATNESS 2")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtRHIDFlatnessCycleTime.Text);
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtRHFlatness2Mid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownRHFlatness2Rank.SelectedValue;
}
moDetailSer.UpdateModelDetail(_ModelDetailInfo);
}
}
protected void btnFHSave_Click(object sender, EventArgs e)
{
ModelDetailInfo _ModelDetailInfo = new ModelDetailInfo();
ArrayList _data = viModelSer.GetModelDetailDataByModelIDANDPartID("011", "4");
foreach (VIModelDetailInfo dataInfo in _data)
{
_ModelDetailInfo.Model_id = txtModelNo.Text;
_ModelDetailInfo.Model_name = txtModelName.Text;
_ModelDetailInfo.Part_id = dataInfo.Part_id;
_ModelDetailInfo.PartType_id = dataInfo.PartType_id;
_ModelDetailInfo.Part_status = true;
_ModelDetailInfo.User_edit = Session["userName"].ToString();
if (dataInfo.PartType_name == "ID")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtFHCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtFHIDMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHIDMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtFHIDMin.Text);
_ModelDetailInfo.Rank_id = dropDownFHIDRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHIDCylindricMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownFHIDCylindricRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHIDRoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownFHIDRoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHIDPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownFHIDPerpenRank.SelectedValue;
}
//ROUGH
else if (dataInfo.PartType_name == "FRONT ID ROUGH")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtFHIDRoughCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtFHIDRoughMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHIDRoughMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtFHIDRoughMin.Text);
_ModelDetailInfo.Rank_id = dropDownFHIDRoughRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID ROUGH CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHIDCylindricRoughMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownFHIDCylindricRoughRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID ROUGH ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHIDRoundnessRoughMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownFHIDRoundnessRoughRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID ROUGH PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHIDPerpenRoughMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownFHIDPerpenRoughRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID ROUGH CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHIDRoundnessRoughMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownFHIDRoundnessRoughRank.SelectedValue;
}
else if (dataInfo.PartType_name == "ID ROUGH PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHIDPerpenRoughMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownFHIDPerpenRoughRank.SelectedValue;
}
//FLATNESS
else if (dataInfo.PartType_name == "FLATNESS 1")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtFHCycleTime.Text);
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHFlatness1Mid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownFHFlatness1Rank.SelectedValue;
}
else if (dataInfo.PartType_name == "FLATNESS 2")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtFHCycleTime.Text);
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtFHFlatness2Mid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownFHFlatness2Rank.SelectedValue;
}
if (!moDetailSer.InsertModelDetail(_ModelDetailInfo))
{
lblErrModelNo.Text = "A Duplicate Model No.";
}
else
{
lblErrModelNo.Text = "";
}
}
if (lblErrModelNo.Text == "")
{
mmDetailSer.InsertModelDetail(_ModelDetailInfo);
proEtdSer.InsertNewProgramDetail(_ModelDetailInfo.Model_id);
Response.Write("<script>alert('SUCCEED!!');</script>");
//Response.Redirect("ModelCS.aspx");
}
}
protected void btnCSSave_Click(object sender, EventArgs e)
{
ModelDetailInfo _ModelDetailInfo = new ModelDetailInfo();
bufModelID = Request.QueryString["id"];
var bufSplit = bufModelID.Split(',');
ArrayList _data = viModelSer.GetModelDetailDataByModelIDANDPartID(bufSplit[0].ToString(), "1");
foreach (VIModelDetailInfo dataInfo in _data)
{
_ModelDetailInfo.Model_id = bufSplit[0].ToString();
_ModelDetailInfo.Part_id = dataInfo.Part_id;
_ModelDetailInfo.PartType_id = dataInfo.PartType_id;
_ModelDetailInfo.Part_status = true;
_ModelDetailInfo.User_edit = Session["userName"].ToString();
//FRONT OD.
if (dataInfo.PartType_name == "FRONT OD")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtCSODCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtCSFODMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSFODMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtCSFODMin.Text);
_ModelDetailInfo.Rank_id = dropDownCSFODRank.SelectedValue;
}
else if (dataInfo.PartType_name == "FRONT ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSFODRoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCSFODRoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "FRONT CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSFODCylindricMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCSFODCylindricRank.SelectedValue;
}
//REAR OD
else if (dataInfo.PartType_name == "REAR OD")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtCSODCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtCSRODMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSRODMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtCSRODMin.Text);
_ModelDetailInfo.Rank_id = dropDownCSRODRank.SelectedValue;
}
else if (dataInfo.PartType_name == "REAR ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSRODRoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCSRODRoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "REAR CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSRODCylindricMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCSRODCylindricRank.SelectedValue;
}
//PIN
else if (dataInfo.PartType_name == "PIN OD")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtCSPINCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtCSPinFODMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSPinFODMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtCSPinFODMin.Text);
_ModelDetailInfo.Rank_id = dropDownCSPinFODRank.SelectedValue;
}
else if (dataInfo.PartType_name == "PIN ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSPinFODRoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCSPinFODRoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "PIN CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSPinFODCylindricMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCSPinFODCylindricRank.SelectedValue;
}
//ECC
else if (dataInfo.PartType_name == "ECCENTRICITY")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtCSECCCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtCSEccFMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSEccFMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtCSEccFMin.Text);
_ModelDetailInfo.Rank_id = dropDownCSEccFRank.SelectedValue;
}
//RUN OUT
else if (dataInfo.PartType_name == "FRONT RUN-OUT")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSFRunMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCSFRunRank.SelectedValue;
}
else if (dataInfo.PartType_name == "REAR RUN-OUT")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCSRRunMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCSRRunRank.SelectedValue;
}
moDetailSer.UpdateModelDetail(_ModelDetailInfo);
}
}
protected void btnCylinderSave_Click(object sender, EventArgs e)
{
ModelDetailInfo _ModelDetailInfo = new ModelDetailInfo();
ArrayList _data = viModelSer.GetModelDetailDataByModelIDANDPartID("011", "3");
foreach (VIModelDetailInfo dataInfo in _data)
{
_ModelDetailInfo.Model_id = txtModelNo.Text;
_ModelDetailInfo.Model_name = txtModelName.Text;
_ModelDetailInfo.Part_id = dataInfo.Part_id;
_ModelDetailInfo.PartType_id = dataInfo.PartType_id;
_ModelDetailInfo.Part_status = true;
_ModelDetailInfo.User_edit = Session["userName"].ToString();
//ID BORE
if (dataInfo.PartType_name == "BORE ID")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtCYIDBoreCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtCYIDBOMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBOMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtCYIDBOMin.Text);
_ModelDetailInfo.Rank_id = dropDownCYIDBORank.SelectedValue;
}
else if (dataInfo.PartType_name == "BORE ID CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBOCylindricMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBOCylindricRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BORE ID ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBORoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBORoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BORE ID PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBOPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBOPerpenRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BORE ID CONCENTRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBOConcenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBOConcenRank.SelectedValue;
}
//ID BUSH
if (dataInfo.PartType_name == "BUSH ID")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtCYIDBushCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtCYIDBUMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBUMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtCYIDBUMin.Text);
_ModelDetailInfo.Rank_id = dropDownCYIDBURank.SelectedValue;
}
else if (dataInfo.PartType_name == "BUSH ID ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBURoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBURoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BUSH ID PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBUPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBUPerpenRank.SelectedValue;
}
//HEIGHT
else if (dataInfo.PartType_name == "HEIGHT")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtCYHeightCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtCYHeightMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYHeightMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtCYHeightMin.Text);
_ModelDetailInfo.Rank_id = dropDownCYHeightRank.SelectedValue;
}
else if (dataInfo.PartType_name == "HEIGHT PARALLISM")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYParallismMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYParallismRank.SelectedValue;
}
if (!moDetailSer.InsertModelDetail(_ModelDetailInfo))
{
lblErrModelNo.Text = "A Duplicate Model No.";
}
else
{
lblErrModelNo.Text = "";
}
}
if (lblErrModelNo.Text == "")
{
mmDetailSer.InsertModelDetail(_ModelDetailInfo);
proEtdSer.InsertNewProgramDetail(_ModelDetailInfo.Model_id);
Response.Write("<script>alert('SUCCEED!!');</script>");
//Response.Redirect("ModelCS.aspx");
}
}
protected void btnCylinderSave_Click(object sender, EventArgs e)
{
ModelDetailInfo _ModelDetailInfo = new ModelDetailInfo();
bufModelID = Request.QueryString["id"];
var bufSplit = bufModelID.Split(',');
ArrayList _data = viModelSer.GetModelDetailDataByModelIDANDPartID(bufSplit[0].ToString(), "3");
foreach (VIModelDetailInfo dataInfo in _data)
{
_ModelDetailInfo.Model_id = bufSplit[0].ToString();
_ModelDetailInfo.Part_id = dataInfo.Part_id;
_ModelDetailInfo.PartType_id = dataInfo.PartType_id;
_ModelDetailInfo.Part_status = true;
_ModelDetailInfo.User_edit = Session["userName"].ToString();
//ID BORE
if (dataInfo.PartType_name == "BORE ID")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtCYIDBoreCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtCYIDBOMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBOMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtCYIDBOMin.Text);
_ModelDetailInfo.Rank_id = dropDownCYIDBORank.SelectedValue;
}
else if (dataInfo.PartType_name == "BORE ID CYLINDRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBOCylindricMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBOCylindricRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BORE ID ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBORoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBORoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BORE ID PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBOPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBOPerpenRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BORE ID CONCENTRICITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBOConcenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBOConcenRank.SelectedValue;
}
//ID BUSH
if (dataInfo.PartType_name == "BUSH ID")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtCYIDBushCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtCYIDBUMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBUMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtCYIDBUMin.Text);
_ModelDetailInfo.Rank_id = dropDownCYIDBURank.SelectedValue;
}
else if (dataInfo.PartType_name == "BUSH ID ROUNDNESS")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBURoundnessMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBURoundnessRank.SelectedValue;
}
else if (dataInfo.PartType_name == "BUSH ID PERPENDICULARITY")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYIDBUPerpenMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYIDBUPerpenRank.SelectedValue;
}
//HEIGHT
else if (dataInfo.PartType_name == "HEIGHT")
{
_ModelDetailInfo.Part_cycletime = Convert.ToDouble(txtCYHeightCycleTime.Text);
_ModelDetailInfo.Part_max = Convert.ToDouble(txtCYHeightMax.Text);
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYHeightMid.Text);
_ModelDetailInfo.Part_min = Convert.ToDouble(txtCYHeightMin.Text);
_ModelDetailInfo.Rank_id = dropDownCYHeightRank.SelectedValue;
}
else if (dataInfo.PartType_name == "HEIGHT PARALLISM")
{
_ModelDetailInfo.Part_cycletime = 0;
_ModelDetailInfo.Part_max = 0;
_ModelDetailInfo.Part_mid = Convert.ToDouble(txtCYParallismMid.Text);
_ModelDetailInfo.Part_min = 0;
_ModelDetailInfo.Rank_id = dropDownCYParallismRank.SelectedValue;
}
moDetailSer.UpdateModelDetail(_ModelDetailInfo);
}
}
