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); } }