protected void TWSave_Click(object sender, EventArgs e) { string bom1 = WebTools.GetExpr("ITEM_1", "PIP_SPOOL_JOINTS", " WHERE JOINT_ID=" + rcbTWJoint.SelectedValue.ToString()); string bom2 = WebTools.GetExpr("ITEM_2", "PIP_SPOOL_JOINTS", " WHERE JOINT_ID=" + rcbTWJoint.SelectedValue.ToString()); string mat_id1 = WebTools.GetExpr("MAT_ID", "PIP_BOM", " WHERE BOM_ID=" + bom1); string mat_id2 = WebTools.GetExpr("MAT_ID", "PIP_BOM", " WHERE BOM_ID=" + bom2); string item_id1 = WebTools.GetExpr("ITEM_ID", "PIP_MAT_STOCK", " WHERE MAT_ID=" + mat_id1); string item_id2 = WebTools.GetExpr("ITEM_ID", "PIP_MAT_STOCK", " WHERE MAT_ID=" + mat_id2); string item_group1 = WebTools.GetExpr("SG_GROUP", "PIP_MAT_ITEM", " WHERE ITEM_ID=" + item_id1); string item_group2 = WebTools.GetExpr("SG_GROUP", "PIP_MAT_ITEM", " WHERE ITEM_ID=" + item_id2); string hn1 = ""; string hn2 = ""; if (item_group1 == "SUPPORT") { hn1 = txtSuppHeatNo1.Text; } else { if (rcbHeatNo1.SelectedIndex < 0) { Master.ShowError("Selected Valid Heat No1"); return; } hn1 = rcbHeatNo1.SelectedValue.ToString(); } if (item_group2 == "SUPPORT") { hn2 = txtSuppHeatNo2.Text; } else { if (rcbHeatNo2.SelectedIndex < 0) { Master.ShowError("Selected Valid Heat No2"); return; } hn2 = rcbHeatNo2.SelectedValue.ToString(); } PIP_SPOOL_JOINTSTableAdapter joint_update = new PIP_SPOOL_JOINTSTableAdapter(); joint_update.UpdateJointTW(txtTWRep.Text, DateTime.Parse(txTWDate.SelectedDate.ToString()), hn1, hn2, int.Parse(rcbTWJoint.SelectedValue)); string sql_heat_no = "UPDATE PIP_BOM SET HEAT_NO = '" + hn1 + "' WHERE HEAT_NO IS NOT NULL AND BOM_ID = " + bom1; WebTools.ExeSql(sql_heat_no); sql_heat_no = "UPDATE PIP_BOM SET HEAT_NO = '" + hn2 + "' WHERE HEAT_NO IS NOT NULL AND BOM_ID = " + bom2; WebTools.ExeSql(sql_heat_no); Master.ShowSuccess("Tack Weld Details Updated Successfully"); }
protected void btnBonding_Click(object sender, EventArgs e) { PIP_SPOOL_JOINTSTableAdapter joint_Bonding = new PIP_SPOOL_JOINTSTableAdapter(); joint_Bonding.UpdateBonding(txtBondingRep.Text, DateTime.Parse(txtBondingDate.SelectedDate.ToString()), txtBondingName.Text, DateTime.Parse(txtCuringDate.SelectedDate.ToString()), int.Parse(rcbBondingJoint.SelectedValue)); string sql_1 = "SELECT JOINT_ID, ISO_TITLE1, ISO_REV, JC_REV, SHEET, SPOOL, WO_NAME, JOINT_NO, JOINT_TYPE, JOINT_SIZE, SCHEDULE, JOINT_THK," + "HEAT_NO1, HEAT_NO2, FITUP_DATE, WELD_DATE, FITUP_REP_NO, WELD_REP_NO, ROOT_HOT_WELDER,FILL_CAP_WELDER,FITUP_INSP,WELD_INSP, CRW_CODE, TRACER," + "DIS_FLG, WPS_NO, CAT_NAME, JNT_REV_CODE AS REV_CODE, COMMODITY1, COMMODITY2,TW_FLG, SPL_SWN_DT, SPL_REL_DT, LINE_CLASS, MAT_TYPE ," + " SPL_REL_DT, SPL_SWN_DT,LAMINAT_REP_NO,LAMINAT_DATE,LAMINAT_THK,BONDING_REP_NO,BONDING_DATE,BONDER_NAME,FITUP_FOREMAN,WELD_FOREMAN " + "FROM VIEW_TOTAL_JOINTS WHERE (JOINT_ID = :JOINT_ID)"; jointDetailsDataSource1.SelectCommand = sql_1; jointDetailsDataSource1.SelectParameters.Add("JOINT_ID", TypeCode.Empty, rcbBondingJoint.SelectedValue.ToString()); jointDetailsView.DataBind(); rcbHeatNo1.Text = ""; rcbHeatNo2.Text = ""; Master.ShowSuccess("Bonding Details Updated Successfully"); }
protected void FitupSave_Click(object sender, EventArgs e) { string bom1 = WebTools.GetExpr("ITEM_1", "PIP_SPOOL_JOINTS", " WHERE JOINT_ID=" + rcbFitupJoint.SelectedValue.ToString()); string bom2 = WebTools.GetExpr("ITEM_2", "PIP_SPOOL_JOINTS", " WHERE JOINT_ID=" + rcbFitupJoint.SelectedValue.ToString()); if (bom1 == "" || bom2 == "") { return; } string mat_id1 = WebTools.GetExpr("MAT_ID", "PIP_BOM", " WHERE BOM_ID=" + bom1); string mat_id2 = WebTools.GetExpr("MAT_ID", "PIP_BOM", " WHERE BOM_ID=" + bom2); string item_id1 = WebTools.GetExpr("ITEM_ID", "AMOGH.PIP_MAT_STOCK", " WHERE MAT_ID=" + mat_id1); string item_id2 = WebTools.GetExpr("ITEM_ID", "AMOGH.PIP_MAT_STOCK", " WHERE MAT_ID=" + mat_id2); if (item_id1 == "" || item_id2 == "") { Master.ShowError("Update Item name for BOM"); return; } string item_group1 = WebTools.GetExpr("SG_GROUP", "AMOGH.PIP_MAT_ITEM", " WHERE ITEM_ID=" + item_id1); string item_group2 = WebTools.GetExpr("SG_GROUP", "AMOGH.PIP_MAT_ITEM", " WHERE ITEM_ID=" + item_id2); string hn1 = ""; string hn2 = ""; if (item_group1 == "SUPPORT") { hn1 = txtSuppHeatNo1.Text; if (hn1 == "") { Master.ShowError("Selected Valid Heat No1"); return; } } else { if (rcbHeatNo1.SelectedIndex < 0) { Master.ShowError("Selected Valid Heat No1"); return; } hn1 = rcbHeatNo1.SelectedValue.ToString(); } if (item_group2 == "SUPPORT") { hn2 = txtSuppHeatNo2.Text; if (hn2 == "") { Master.ShowError("Selected Valid Heat No2"); return; } } else { if (rcbHeatNo2.SelectedIndex < 0 && rcbHeatNo2.SelectedValue.ToString() == string.Empty) { Master.ShowError("Selected Valid Heat No2"); return; } hn2 = rcbHeatNo2.SelectedValue.ToString(); } DateTime Date3 = System.DateTime.Now; string fitup_entry_date = Date3.ToString("dd-MMM-yyyy"); PIP_SPOOL_JOINTSTableAdapter joint_fitup = new PIP_SPOOL_JOINTSTableAdapter(); joint_fitup.UpdateJointFitup(txtFitupRep.Text, DateTime.Parse(txtFitupDate.SelectedDate.ToString()), ddlFitupInspCode.SelectedValue.ToString(), hn1, hn2, DateTime.Parse(fitup_entry_date), txtFitupForeman.Text, int.Parse(rcbFitupJoint.SelectedValue)); string sql_heat_no = "UPDATE PIP_BOM SET HEAT_NO = '" + hn1 + "' WHERE BOM_ID = " + bom1 + " and HEAT_NO IS NULL"; WebTools.ExeSql(sql_heat_no); sql_heat_no = "UPDATE PIP_BOM SET HEAT_NO = '" + hn2 + "' WHERE BOM_ID = " + bom2 + " AND HEAT_NO IS NULL"; WebTools.ExeSql(sql_heat_no); string sql_1 = "SELECT JOINT_ID, ISO_TITLE1, ISO_REV, JC_REV, SHEET, SPOOL, WO_NAME, JOINT_NO, JOINT_TYPE, JOINT_SIZE, SCHEDULE, JOINT_THK," + "HEAT_NO1, HEAT_NO2, FITUP_DATE, WELD_DATE, FITUP_REP_NO, WELD_REP_NO, ROOT_HOT_WELDER,FILL_CAP_WELDER,FITUP_INSP,WELD_INSP, CRW_CODE, TRACER," + "DIS_FLG, WPS_NO, CAT_NAME, JNT_REV_CODE AS REV_CODE, COMMODITY1, COMMODITY2,TW_FLG, SPL_SWN_DT, SPL_REL_DT, LINE_CLASS, MAT_TYPE ," + " SPL_REL_DT, SPL_SWN_DT,LAMINAT_REP_NO,LAMINAT_DATE,LAMINAT_THK,BONDING_REP_NO,BONDING_DATE,BONDER_NAME,FITUP_FOREMAN,WELD_FOREMAN " + "FROM VIEW_TOTAL_JOINTS WHERE (JOINT_ID = :JOINT_ID)"; jointDetailsDataSource1.SelectCommand = sql_1; jointDetailsDataSource1.SelectParameters.Add("JOINT_ID", TypeCode.Empty, rcbWeldIsoJnt.SelectedValue.ToString()); jointDetailsView.DataBind(); rcbHeatNo1.Text = ""; rcbHeatNo2.Text = ""; Master.ShowSuccess("Fitup Details Updated Successfully"); }