Ejemplo n.º 1
0
        //查询单头单身
        protected void search(object sender, EventArgs e)
        {
            try
            {
                string Invoice_no = DropDownList_invoice_no.SelectedValue.ToString();

                string   first_time = "2016-07-01 00:00:00";
                DateTime start_time = Convert.ToDateTime(first_time);
                DateTime end_time   = DateTime.Now;

                if (Invoice_no == "--选择退料单号--")
                {
                    Invoice_no = "";
                }

                ReturnHeaderReater.DataSource = invoiceDC.getReturnHeaderBySome(Invoice_no, "", "");
                ReturnLineReater.DataSource   = invoiceDC.getReturnLineBySome(Invoice_no, "", "", start_time, end_time);

                if (ReturnHeaderReater.DataSource == null)
                {
                    PageUtil.showToast(this, "无相关退料单头信息");
                }
                ReturnHeaderReater.DataBind();

                if (ReturnLineReater.DataSource == null)
                {
                    PageUtil.showToast(this, "无相关退料单身信息");
                }
                ReturnLineReater.DataBind();
            }
            catch (Exception e1)
            {
                PageUtil.showToast(this, "查询失败");
            }
        }
Ejemplo n.º 2
0
        //清除查询结果
        protected void cleanMassage(object sender, EventArgs e)
        {
            ReturnHeaderReater.DataSource = null;
            ReturnHeaderReater.DataBind();

            ReturnLineReater.DataSource = null;
            ReturnLineReater.DataBind();
        }
Ejemplo n.º 3
0
        //确定扣账操作
        protected void Debit_action(object sender, EventArgs e)
        {
            try
            {
                //JS通过查询结果,绑定数据
                int    Flag = int.Parse(flag_debit.Value);
                int    Return_line_id_debit = int.Parse(return_line_id_debit.Value);
                string Return_sub_name      = return_sub_name.Value;
                //string Invoice_no = invoice_no.Value;
                string Item_name  = item_name.Value;
                int    Return_qty = int.Parse(return_qty.Value);

                //string Frame_key = frame_key.Value;

                //检验数据完整
                if (datecode.Value == "")
                {
                    PageUtil.showToast(this, "请将数据填写完整");
                    return;
                }

                //用户选择输入数据
                string Datecode_debit   = datecode.Value;
                int    Return_qty_debit = int.Parse(return_qty_debit.Value);
                //int Frame_key = int.Parse(DropDownList_frame.SelectedValue.ToString());
                string Frame_key = frame_key.Value;

                if (frame_key.Value == "")
                {
                    PageUtil.showToast(this, "请输入料架再操作");
                    return;
                }

                if (Flag == 1)
                {
                    PageUtil.showToast(this, "该条退料数据已扣账!请重新选择");
                    return;
                }

                if (Return_qty_debit < 0)
                {
                    PageUtil.showToast(this, "退料量应大于0");
                    return;
                }
                //检验实际退回量是否等于申请退料量
                if (Return_qty_debit != Return_qty)
                {
                    PageUtil.showToast(this, "退料数量应等于申请退料量");
                    return;
                }

                int status = 1;                   //默认为工单退料
                if (return_wo_no.Value == "none") //非工单退料
                {
                    status = 0;
                }

                if (invoiceDC.getSubinventoryByFrame(Frame_key).Tables[0].Rows[0]["subinventory_name"].ToString() != Return_sub_name)
                {
                    PageUtil.showToast(this, "请重新输入料架,该料架不属于该库别下");
                    return;
                }

                //扣账
                int flag = invoiceDC.DebitAction(DateTime.Now, user, Return_line_id_debit, Return_qty_debit, Return_sub_name, Frame_key, Item_name, Datecode_debit, status);
                //扣账成功
                if (flag == 1)
                {
                    PageUtil.showToast(this, "扣账成功!");

                    ReturnHeaderReater.DataSource = null;
                    ReturnHeaderReater.DataBind();

                    ReturnLineReater.DataSource = null;
                    ReturnLineReater.DataBind();
                }
                //扣账失败时,输出详细错误原因
                else
                {
                    if (flag == 2)
                    {
                        PageUtil.showAlert(this, "扣账失败,错误产生可能原因:\\n 1、没有对应数据,请检查料号+库别是否在库存总表有对应数据 ");
                        return;
                    }
                    if (flag == 3)
                    {
                        PageUtil.showAlert(this, "扣账失败,错误产生可能原因:\\n 1、没有对应数据,请检查料号+料架+datecode是否在库存明细表中有对应数据(一般来说就是datecode输错了)");
                        return;
                    }
                }
            }
            catch (Exception e2)
            {
                PageUtil.showToast(this, "扣账失败!");
            }
        }