//提交所有的退料单单身到数据库
        protected void Commit_All_Return_Line(object sender, EventArgs e)
        {
            string Invoice_no = invoice_no.Value;

            DataTable table = new DataTable();

            table = GetGridViewData(table);

            if (table.Rows.Count == 0)
            {
                PageUtil.showToast(this, "请将单身添加到右方表格,再操作");
                return;
            }

            try
            {
                bool flag = invoiceDC.insertReturn_line(table, Invoice_no);
                if (flag == true)
                {
                    PageUtil.showToast(this, "成功提交所有单身!");

                    //清空框框,避免用户重复提交
                    GridView1.DataSource = null;
                    GridView1.DataBind();

                    //提交单个单身数据成功时,清除用户已填写的单身数据,方便用户填写下一个单身
                    DropDownList_return_wo_no.SelectedValue      = "--选择工单--";
                    DropDownList_item_name.SelectedValue         = "--选择料号--";
                    DropDownList_operation_seq_num.SelectedValue = "--选择制程--";
                    //DropDownList_frame_key.SelectedValue = "--选择料架--";
                    DropDownList_return_sub_key.SelectedValue = "--选择库别--";

                    return_qty.Value   = "";
                    return_limit.Value = "";

                    //提交单个单身数据成功时,清除用户已填写的单身数据,方便用户填写下一个单身
                    item_name2.Value    = "";
                    subinventory2.Value = "";
                    //frame2.Value = "";
                    operation_seq_num2.Value = "";
                    return_qty2.Value        = "";
                }
                else
                {
                    PageUtil.showToast(this, "信息提交失败!");
                }
            }
            catch (Exception)
            {
                PageUtil.showToast(this, "信息提交失败!");
                return;
            }
        }