protected void btnSubmit_Click(object sender, EventArgs e) { //string ADD_SPL = InsertSpoolsCheckBox.Checked == true ? "Y" : "N"; //if (ddEntryType.SelectedValue.ToString() == "1") //{ // try // { // string RET_CODE = WebTools.GetExpr( // "FNC_SITE_JC_SAVE_ALL(" + // Request.QueryString["JC_ID"] + ",'" + txtIsome.Text + // "','" + ddSheetNo.SelectedValue.ToString() + "','" + // ADD_SPL + "','" + ddAvailable.SelectedValue.ToString() + "')", "DUAL", ""); // itemsGridView.DataBind(); // Master.ShowMessage("Saved!"); // } // catch (Exception ex) // { // Master.ShowWarn(ex.Message); // } // return; //} VIEW_SITE_JC_DETAILTableAdapter loose = new VIEW_SITE_JC_DETAILTableAdapter(); try { foreach (RadComboBoxItem item in cboBOM.Items) { if (item.Checked) { string net_qty = WebTools.GetExpr("NET_QTY", "PIP_BOM", " WHERE BOM_ID='" + item.Value.ToString() + "'"); loose.InsertQuery(Decimal.Parse(Request.QueryString["JC_ID"]), Decimal.Parse(item.Value.ToString()), Decimal.Parse(net_qty), txtRemarks.Text); } } Master.ShowMessage("Saved."); itemsGridView.DataBind(); loose.Dispose(); } catch (Exception ex) { Master.ShowWarn(ex.Message); loose.Dispose(); } }
protected void btnYes_Click(object sender, EventArgs e) { try { GridDataItem item = (GridDataItem)itemsGridView.SelectedItems[0]; //JC_ID,BOM_ID string jc_id = item.GetDataKeyValue("JC_ID").ToString(); string bom_id = item.GetDataKeyValue("BOM_ID").ToString(); dsErectionTableAdapters.VIEW_SITE_JC_DETAILTableAdapter r = new VIEW_SITE_JC_DETAILTableAdapter(); r.DeleteQuery(decimal.Parse(jc_id), decimal.Parse(bom_id)); Master.ShowMessage("Selected row deleted."); itemsGridView.Rebind(); } catch (Exception ex) { Master.ShowWarn(ex.Message); } }