protected void btnAddAllPipes_Click(object sender, EventArgs e) { string MAT_SCOPE_CODE = WebTools.GetExpr("MAT_SCOPE_CODE", "PIP_WORK_ORD", "WO_ID=" + Request.QueryString["WO_ID"]); string random_len = ""; decimal?random_len_dec = 0; PIP_WORK_ORD_CUTLEN_RNDLENTableAdapter rnd = new PIP_WORK_ORD_CUTLEN_RNDLENTableAdapter(); try { foreach (ListItem li in cboMat.Items) { if (!string.IsNullOrEmpty(li.Value.ToString()) && li.Value.ToString() != "-1") { random_len = WebTools.GetExpr("PIPE_RL", "PIP_PIPE_RANDOM_LEN", "PIPE_RL > 0 AND PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND MAT_SCOPE_CODE='" + MAT_SCOPE_CODE + "' AND MAT_CODE1='" + li.Text + "'"); if (!string.IsNullOrEmpty(random_len)) { random_len_dec = decimal.Parse(random_len); //random_len_dec = 11; } else { random_len_dec = null; } rnd.InsertQuery(decimal.Parse(Request.QueryString["WO_ID"]), decimal.Parse(li.Value.ToString()), random_len_dec); //rnd.InsertQuery(decimal.Parse(Request.QueryString["WO_ID"]), decimal.Parse(li.Value.ToString()), 0); } } rowsGridView.DataBind(); cboMat.DataBind(); Master.ShowMessage("Saved!"); } catch (Exception ex) { Master.ShowWarn(ex.Message); } finally { rnd.Dispose(); } }
protected void btnInsert_Click(object sender, EventArgs e) { if (cboMat.SelectedValue.ToString() == "-1") { Master.ShowMessage("Select an item code!"); return; } PIP_WORK_ORD_CUTLEN_RNDLENTableAdapter rnd = new PIP_WORK_ORD_CUTLEN_RNDLENTableAdapter(); try { rnd.InsertQuery(decimal.Parse(Request.QueryString["WO_ID"]), decimal.Parse(cboMat.SelectedValue.ToString()), null); rowsGridView.DataBind(); Master.ShowMessage(cboMat.SelectedItem.Text + " material added!"); } catch (Exception ex) { Master.ShowWarn(ex.Message); } finally { rnd.Dispose(); } }