//查询单头单身 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, "查询失败"); } }
//清除查询结果 protected void cleanMassage(object sender, EventArgs e) { ReturnHeaderReater.DataSource = null; ReturnHeaderReater.DataBind(); ReturnLineReater.DataSource = null; ReturnLineReater.DataBind(); }
//确定扣账操作 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, "扣账失败!"); } }