示例#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 = "";
                }

                IssueHeaderReater.DataSource = invoiceDC.getIssueHeaderBySome(Invoice_no, "", "");
                IssueLineReater.DataSource   = invoiceDC.getIssueLineBySome(Invoice_no, "", "", start_time, end_time);

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

                if (IssueLineReater.DataSource == null)
                {
                    PageUtil.showToast(this, "无相关领料单身信息");
                }
                IssueLineReater.DataBind();
            }
            catch (Exception e1)
            {
                PageUtil.showToast(this, "查询失败");
            }
        }
示例#2
0
        //清除查询结果
        protected void cleanMassage(object sender, EventArgs e)
        {
            IssueHeaderReater.DataSource = null;
            IssueHeaderReater.DataBind();

            IssueLineReater.DataSource = null;
            IssueLineReater.DataBind();
        }
示例#3
0
        //确定扣账操作
        protected void Debit_action(object sender, EventArgs e)
        {
            try
            {
                //JS通过查询结果,绑定数据
                string Flag = flag_debit.Value;
                int    Issue_line_id_debit = int.Parse(issue_line_id_debit.Value);
                string Issued_sub          = issued_sub.Value;

                //string Invoice_no = invoice_no.Value;
                string Item_name  = item_name.Value;
                int    Issued_qty = int.Parse(issued_qty.Value);

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

                //用户选择输入数据
                string Datecode_debit = datecode.Value;
                int    Issued_qty_debit;
                string Frame = frame.Value;
                if (frame.Value == "")
                {
                    PageUtil.showToast(this, "请输入料架后再操作");
                    return;
                }
                //用户非法输入
                try
                {
                    Issued_qty_debit = int.Parse(issued_qty_debit.Value);
                }
                catch (Exception e2)
                {
                    PageUtil.showToast(this, "领料量请不要输入非数字");
                    return;
                }


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

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

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

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

                //扣账
                int flag = invoiceDC.IssueDebitAction(DateTime.Now, user, Issue_line_id_debit, Issued_qty_debit, Issued_sub, Frame, Item_name, Datecode_debit, status);

                //扣账执行成功时
                if (flag == 1)
                {
                    PageUtil.showToast(this, "扣账成功!");

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

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