private string LoadLastBillNo()
    {
        string search = DateTime.Now.ToString("yyyyMMdd");
        PaymentInDecreaseAdapter ida = new PaymentInDecreaseAdapter();

        return(ida.getLastBillNo(search));
    }
Exemplo n.º 2
0
    private void setData(string id)
    {
        if (string.IsNullOrEmpty(id))
        {
            return;
        }
        PaymentInDecreaseAdapter ida = new PaymentInDecreaseAdapter();
        DataSet head = ida.getInDecreaseHeadByBillNo(id);

        lbl_customer.Text      = head.Tables[0].Rows[0]["customer"].ToString();
        lbl_indecrease_id.Text = id;
        if (!string.IsNullOrEmpty(head.Tables[0].Rows[0]["currencyID"].ToString()))
        {
            int           currency = Int32.Parse(head.Tables[0].Rows[0]["currencyID"].ToString());
            CommonAdapter ca       = new CommonAdapter();
            lbl_currency.Text = ca.getCurrencyByID(currency);
        }

        lbl_agenter.Text     = head.Tables[0].Rows[0]["agenter"].ToString();
        lbl_agente_date.Text = head.Tables[0].Rows[0]["agent_date"].ToString();

        DataSet list = ida.getInDecreaseInfoByBillNo(id);

        gridviewBind(list);
    }
Exemplo n.º 3
0
    private void GridViewBind(int id, int currencyID)
    {
        PaymentInDecreaseAdapter ida = new PaymentInDecreaseAdapter();
        DataSet ds = ida.getUnCheckInDecreaseLists(id, currencyID);

        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "Delete")
        {
            string[]                 args         = e.CommandArgument.ToString().Split(',');
            string                   receipt_id   = args[0];
            string                   receipt_type = args[1];
            PaymentAdapter           raa          = new PaymentAdapter();
            PaymentRequestAdapter    ida          = new PaymentRequestAdapter();
            PaymentDepositAdapter    da           = new PaymentDepositAdapter();
            PaymentInDecreaseAdapter pia          = new PaymentInDecreaseAdapter();
            try
            {
                DataSet ds = raa.getInDecreaseList(receipt_id);
                pia.updateHeadCheckStatus(ds);

                ds = raa.getDepositList(receipt_id);

                if (receipt_type == "B")
                {
                    da.updateHeadIsPayed(ds);
                }
                else
                {
                    da.updateHeadCheckStatus(ds);//更新定金单的check_status值;
                }
                ds = raa.getRequestList(receipt_id);
                ida.updateHeadCheckStatus(ds);

                raa.deleteToDone(receipt_id);
                raa.deleteReceipt(receipt_id);
                GridView3.SelectedIndex = -1;
                GridViewBind();

                Label1.Text = "删除成功";
            }
            catch (Exception ex)
            {
                Label1.Text = ex.Message;
            }
        }
    }
    protected void add_Click(object sender, EventArgs e)
    {
        //表头
        T_PaymentIndecreaseHead head = new T_PaymentIndecreaseHead();

        head.AgentDate   = DateTime.Parse(agent_date.Text);
        head.BillNo      = bill_no.Text;
        head.Customer    = customer.Text;
        head.Agenter     = agent_name.Text;
        head.CheckStatus = 0;
        head.CurrencyID  = ddl_currency.SelectedValue;
        decimal        amount_all = 0;
        PaymentAdapter raa        = new PaymentAdapter();

        DataSet ds = raa.getSupplierInfoByName(head.Customer);

        if (ds.Tables[0].Rows.Count > 0)
        {
            head.CustomerID = Int32.Parse(ds.Tables[0].Rows[0]["FNumber"].ToString());
            head.ItemID     = Int32.Parse(ds.Tables[0].Rows[0]["FItemID"].ToString());
        }
        else
        {
            Label1.Text = "供应商姓名请输入关键字后从下拉框选择!";
            return;
        }
        //表体
        DataTable dt = DefineDataTableSchema(hfRptColumns.Value);

        foreach (RepeaterItem item in rptTest.Items)
        {
            DataRow newRow = dt.NewRow();

            string name = ((TextBox)item.FindControl("txt_name")).Text;
            if (string.IsNullOrEmpty(name))
            {
                //如果项号是空,则过滤此条记录
                continue;
            }
            string amount = ((TextBox)item.FindControl("txt_amount")).Text;
            if (string.IsNullOrEmpty(amount))
            {
                //如果项号是空,则过滤此条记录
                continue;
            }
            string apply_date = ((TextBox)item.FindControl("cb_apply_date")).Text;
            if (string.IsNullOrEmpty(apply_date))
            {
                //如果项号是空,则过滤此条记录
                continue;
            }
            string type = ((DropDownList)item.FindControl("ddl_type")).SelectedValue;
            if (string.IsNullOrEmpty(type))
            {
                //如果项号是空,则过滤此条记录
                continue;
            }
            newRow["g_no"]       = ((TextBox)item.FindControl("txt_g_no")).Text;
            newRow["name"]       = name;
            newRow["amount"]     = amount;
            newRow["apply_date"] = apply_date;
            newRow["type"]       = type;
            if (type == "R")
            {
                amount_all += Decimal.Parse(amount) * -1;
            }
            else
            {
                amount_all += Decimal.Parse(amount);
            }
            newRow["note"]    = ((TextBox)item.FindControl("txt_note")).Text;;
            newRow["bill_no"] = bill_no.Text;
            dt.Rows.Add(newRow);
        }

        head.AmountAll = amount_all;
        try
        {
            PaymentInDecreaseAdapter ida = new PaymentInDecreaseAdapter();
            ida.insertInDecreaseList(dt);
            ida.addInDecreaseHead(head);
            clean();
            Label1.Text = "哟,小伙子,不错,被你录入成功了";
        }
        catch (Exception ex)
        {
            Label1.Text = ex.Message;
        }
    }
    protected void updateUser_Click(object sender, EventArgs e)
    {
        Label1.Text = "";
        T_PaymentReceiptHead head = new T_PaymentReceiptHead();

        head.CustomerName = txt_customer.Text;

        head.ReceiptId   = txt_recetpt_no.Text;
        head.ReceiptDate = DateTime.Parse(d_date.Text);
        head.ReceiptType = ddl_receipt_type.SelectedValue;
        //货款时供应商才从金蝶里读取
        if (head.ReceiptType == "A" || head.ReceiptType == "B")
        {
            if (!string.IsNullOrEmpty(head.CustomerName))
            {
                head.CustomerCode = getCusIDByName(head.CustomerName);
                if (string.IsNullOrEmpty(head.CustomerCode))
                {
                    Label1.Text = "输入的公司名称不对,请输入关键字然后从下拉框中选择!";
                    return;
                }
            }
        }
        head.AccountId = ddl_account.SelectedValue;
        if (!String.IsNullOrEmpty(txt_amount.Text) && Decimal.Parse(txt_amount.Text) > 0)
        {
            head.Amount = Decimal.Parse(txt_amount.Text);
        }
        else
        {
            Label1.Text = "该付款单金额不能为0。";
            return;
        }
        head.Currency = ddl_currency.SelectedValue;
        if (!string.IsNullOrEmpty(txt_receipt_charge.Text))
        {
            head.ReceiptCharge = Decimal.Parse(txt_receipt_charge.Text);
        }

        head.FPreparer    = Int32.Parse(ddl_preparer.SelectedValue);
        head.FChecker     = Int32.Parse(ddl_checker.SelectedValue);
        head.FCheckDate   = DateTime.Parse(check_date.Text);
        head.Note         = txt_note.Text;
        head.FCheckStatus = (int)2;
        head.AuditStatus  = 1;

        CommonAdapter ca = new CommonAdapter();
        List <T_PaymentReceiptList> lists = new List <T_PaymentReceiptList>();

        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            T_PaymentReceiptList list = new T_PaymentReceiptList();
            list.ReceiptId = head.ReceiptId;
            list.ReceiptNo = Int32.Parse((GridView1.Rows[i].Cells[0].FindControl("lbl_gno") as Label).Text);
            string fbillno = (GridView1.Rows[i].Cells[1].FindControl("txt_bill_no") as TextBox).Text;
            if (string.IsNullOrEmpty(fbillno))
            {
                continue;
            }
            list.FBillNo            = fbillno;
            list.FDate              = DateTime.Parse((GridView1.Rows[i].Cells[2].FindControl("lbl_fdate") as Label).Text);
            list.FPurchaseAmountFor = Decimal.Parse((GridView1.Rows[i].Cells[3].FindControl("lbl_amountfor") as Label).Text);
            list.FPayAmountFor      = Decimal.Parse((GridView1.Rows[i].Cells[4].FindControl("lbl_fpayamountfor") as Label).Text);
            list.FUnPayAmountFor    = Decimal.Parse((GridView1.Rows[i].Cells[5].FindControl("lbl_funpayamountfor") as Label).Text);
            string fcheckamountfor = (GridView1.Rows[i].Cells[6].FindControl("txt_fcheckamountfor") as TextBox).Text;
            if (string.IsNullOrEmpty(fcheckamountfor))
            {
                Label1.Text = "核销金额不能为空";
                return;
            }
            list.FCheckAmountFor = Decimal.Parse(fcheckamountfor);
            list.FCurrencyID     = ca.getIDByCurrency((GridView1.Rows[i].Cells[7].FindControl("lbl_fcurrencyid") as Label).Text);
            list.FNote           = (GridView1.Rows[i].Cells[8].FindControl("txt_note") as TextBox).Text;
            if (list.FUnPayAmountFor - list.FCheckAmountFor == 0)
            {
                list.FCheckStatus = 2;
            }
            else
            {
                list.FCheckStatus = 1;
                head.FCheckStatus = 1;
            }
            lists.Add(list);
        }
        for (int i = 0; i < GridView2.Rows.Count; i++)
        {
            T_PaymentReceiptList list = new T_PaymentReceiptList();
            list.ReceiptId = head.ReceiptId;

            list.ReceiptNo = GridView1.Rows.Count + Int32.Parse((GridView2.Rows[i].Cells[0].FindControl("lbl_gno") as Label).Text);
            string indecreaseno = (GridView2.Rows[i].Cells[1].FindControl("txt_bill_no") as TextBox).Text;
            if (string.IsNullOrEmpty(indecreaseno))
            {
                continue;
            }
            list.IndecreaseNo       = indecreaseno;
            list.FPurchaseAmountFor = Decimal.Parse((GridView2.Rows[i].Cells[3].FindControl("lbl_amount_all") as Label).Text);
            lists.Add(list);
        }

        List <T_PaymentReceiptList> listsFromDeposit = new List <T_PaymentReceiptList>();

        foreach (GridViewRow gvr in GridView3.Rows)
        {
            T_PaymentReceiptList list = new T_PaymentReceiptList();
            list.ReceiptId = head.ReceiptId;
            list.ReceiptNo = GridView1.Rows.Count + GridView4.Rows.Count + Int32.Parse((gvr.Cells[0].FindControl("lbl_gno") as Label).Text);
            string deposit_id = (gvr.Cells[1].FindControl("txt_deposit_id") as TextBox).Text;
            if (string.IsNullOrEmpty(deposit_id))
            {
                continue;
            }
            list.DepositId          = deposit_id;
            list.FDate              = DateTime.Parse((gvr.Cells[2].FindControl("lbl_agent_date") as Label).Text);
            list.FNote              = (gvr.Cells[9].FindControl("txt_note") as TextBox).Text;
            list.FCurrencyID        = ca.getIDByCurrency((gvr.Cells[7].FindControl("lbl_fcurrencyid") as Label).Text);
            list.FPurchaseAmountFor = Decimal.Parse((gvr.Cells[3].FindControl("lbl_amount_all") as Label).Text);
            list.FPayAmountFor      = Decimal.Parse((gvr.Cells[4].FindControl("lbl_fpayamountfor") as Label).Text);
            list.FUnPayAmountFor    = Decimal.Parse((gvr.Cells[5].FindControl("lbl_funpayamountfor") as Label).Text);
            string str_deposit_checkamountfor = (gvr.Cells[6].FindControl("txt_deposit_checkamountfor") as TextBox).Text;
            if (string.IsNullOrEmpty(str_deposit_checkamountfor))
            {
                Label1.Text = "核销金额不能为空";
                return;
            }
            list.FCheckAmountFor = Decimal.Parse(str_deposit_checkamountfor);
            if (list.FUnPayAmountFor - list.FCheckAmountFor == 0)
            {
                list.FCheckStatus = 2;
            }
            else
            {
                list.FCheckStatus = 1;
                head.FCheckStatus = 1;
            }
            listsFromDeposit.Add(list);
        }
        for (int i = 0; i < GridView4.Rows.Count; i++)
        {
            T_PaymentReceiptList list = new T_PaymentReceiptList();
            list.ReceiptId = head.ReceiptId;

            list.ReceiptNo = GridView1.Rows.Count + Int32.Parse((GridView4.Rows[i].Cells[0].FindControl("lbl_gno") as Label).Text);
            string requestID = (GridView4.Rows[i].Cells[1].FindControl("txt_bill_no") as TextBox).Text;
            if (string.IsNullOrEmpty(requestID))
            {
                continue;
            }
            list.RequestID          = requestID;
            list.FPurchaseAmountFor = Decimal.Parse((GridView4.Rows[i].Cells[3].FindControl("lbl_amount_all") as Label).Text);
            lists.Add(list);
        }
        List <T_PaymentReceiptList> addtodonelists   = addBillNoToDone(lists, head);
        List <T_PaymentReceiptList> checkStatusLists = addInDecreaseNoToDone(lists);

        try
        {
            //保存数据
            PaymentAdapter           raa = new PaymentAdapter();
            PaymentRequestAdapter    pra = new PaymentRequestAdapter();
            PaymentDepositAdapter    da  = new PaymentDepositAdapter();
            PaymentInDecreaseAdapter ida = new PaymentInDecreaseAdapter();
            raa.addReceiptHead(head);
            raa.insertReceiptList(lists);
            raa.insertReceiptList(listsFromDeposit);

            raa.addToDone(addtodonelists);//把采购发票号加入已做列表中
            if (ddl_receipt_type.SelectedValue == "B")
            {
                da.updateHeadIsPayed(listsFromDeposit);
            }
            else
            {
                da.updateHeadCheckStatus(listsFromDeposit);//更新定金单的check_status值;
            }

            ida.updateHeadCheckStatus(checkStatusLists); //更新增减单的check_status值为2;
            pra.updateHeadCheckStatus(lists);            //更新付款通知书的isUserd值为1(true);
            Label1.Text = "哟,小伙子,不错,被你录入成功了";
        }
        catch (Exception ex)
        {
            Label1.Text = ex.Message;
        }
    }