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