示例#1
0
 //private void Gridview7_BL()
 //{
 //    Decimal TotalMoney = 0;
 //    for (int i = 0; i < Gridview7.Rows.Count; i++)
 //    {
 //        TotalMoney += Convert.ToDecimal(this.Gridview7.Rows[i].Cells[11].Text.ToString());
 //    }
 //    this.label_TotalMoney.Text = Convert.ToString(TotalMoney);
 //}
 //重置
 protected void Button_Reset1(object sender, EventArgs e)
 {
     BindGridview1("");
     UpdatePanel_PayBill.Update();
     TextBox_Factory.Text = "";
     TextBox1.Text        = "";
     TextBox2.Text        = "";
     UpdatePanel_SPayBillSearch.Update();
 }
示例#2
0
    protected void Button_Sh2(object sender, EventArgs e)
    {
        string condition = Getcondition();

        BindGridview1(condition);
        UpdatePanel_PayBill.Update();
        Panel_NewPayBill.Visible = false;
        UpdatePanel_NewPayBill.Update();
        Panel_Supply.Visible = false;
        UpdatePanel_Supply.Update();

        Panel_Pay.Visible = false;
        UpdatePanel_Pay.Update();

        Panel_NewPay.Visible = false;
        UpdatePanel_NewPay.Update();
    }
示例#3
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!(Session["UserRole"].ToString().Contains("采购付款")))
     {
         Response.Redirect("~/Default.aspx");
     }
     if (!IsPostBack)
     {
         Title = "采购付款";
         BindGridview1("");
         foreach (GridViewRow item in Gridview1.Rows)
         {
             PMPaymentBillinfo.PMPB_ID = new Guid(Gridview1.DataKeys[item.RowIndex]["PMPB_ID"].ToString());
             PMPaymentBillinfo.PMSI_ID = new Guid(Gridview1.DataKeys[item.RowIndex]["PMSI_ID"].ToString());
             ppb.UpdatePMPaymentBill(PMPaymentBillinfo);
         }
         BindGridview1("");
         UpdatePanel_PayBill.Update();
     }
 }
示例#4
0
    //提交新增
    protected void Button_Rocky(object sender, EventArgs e)
    {
        string    condition = "and PMPaymentBill.PMSI_ID='" + label_SupplyID.Text.ToString() + "'";
        DataSet   ds        = ppb.SelectPMPaymentBill(condition);
        DataTable dt        = ds.Tables[0];

        if (dt.Rows.Count > 0)
        {
            ScriptManager.RegisterClientScriptBlock(UpdatePanel_NewPayBill, GetType(), "aa", "alert('该供应商已存在!')", true);
            return;
        }
        else
        {
            PMPaymentBillinfo.PMSI_ID          = new Guid(label_SupplyID.Text.ToString());
            PMPaymentBillinfo.PMPB_Due         = 0; //应付款
            PMPaymentBillinfo.PMPB_TotalDebt   = 0; //总欠款
            PMPaymentBillinfo.PMPB_TotalBill   = 0; //开票总额
            PMPaymentBillinfo.PMPB_TotalPaided = 0; //已付款
            ppb.InsertPMPaymentBill(PMPaymentBillinfo);

            BindGridview1("");
            foreach (GridViewRow item in Gridview1.Rows)
            {
                PMPaymentBillinfo.PMPB_ID = new Guid(Gridview1.DataKeys[item.RowIndex]["PMPB_ID"].ToString());
                PMPaymentBillinfo.PMSI_ID = new Guid(Gridview1.DataKeys[item.RowIndex]["PMSI_ID"].ToString());
                ppb.UpdatePMPaymentBill(PMPaymentBillinfo);
            }
            BindGridview1("");
            UpdatePanel_PayBill.Update();
            TextBox6.Text            = "";
            Panel_NewPayBill.Visible = false;
            UpdatePanel_NewPayBill.Update();
            ScriptManager.RegisterClientScriptBlock(UpdatePanel_NewPayBill, GetType(), "aa", "alert('新增成功!')", true);
            return;
        }
    }
示例#5
0
    //提交付款
    protected void Button_Kity(object sender, EventArgs e)
    {
        if (TextBox3.Text != "")
        {
            PMPaymentBillinfo.PMPD_Pay = Convert.ToDecimal(TextBox3.Text.ToString());
        }
        else
        {
            ScriptManager.RegisterClientScriptBlock(UpdatePanel_NewPay, GetType(), "alert", "alert('请填写付款金额!')", true);
            return;
        }
        if (DropDownList1.SelectedValue != "请选择")
        {
            PMPaymentBillinfo.PMPD_PayWay = DropDownList1.SelectedValue.ToString();
        }
        else
        {
            ScriptManager.RegisterClientScriptBlock(UpdatePanel_NewPay, GetType(), "alert", "alert('请选择付款方式!')", true);
            return;
        }
        if (TextBox5.Text != "")
        {
            PMPaymentBillinfo.PMPD_PayTime = Convert.ToDateTime(TextBox5.Text.ToString());
        }
        else
        {
            ScriptManager.RegisterClientScriptBlock(UpdatePanel_NewPay, GetType(), "alert", "alert('请填写付款日期!')", true);
            return;
        }


        bool    temp = false;
        Decimal dl   = 0;

        Decimal dml = Convert.ToDecimal(TextBox3.Text.ToString());

        //foreach (GridViewRow item in Gridview5.Rows)
        //{
        //CheckBox rb = item.FindControl("CheckBoxMarry") as CheckBox;
        //if (rb.Checked)
        //{
        dl   = Convert.ToDecimal(Gridview7.Rows[Gridview7.SelectedIndex].Cells[6].Text.ToString());
        temp = true;

        if (dml == dl)        //金额相等
        {
            label_PurchaseOrderID.Text             = Gridview7.DataKeys[Gridview7.SelectedIndex].Value.ToString();
            PMPaymentBillinfo.PMPO_PurchaseOrderID = new Guid(label_PurchaseOrderID.Text);
            PMPaymentBillinfo.PMPO_AlreadyPay      = "是";
            PMPaymentBillinfo.PMPO_ResidueMoney    = 0;
            ppb.UpdatePMPO_AlreadyPay(PMPaymentBillinfo);
        }
        if (dml < dl)        //付款金额小于勾选订单的剩余付款
        {
            label_PurchaseOrderID.Text             = Gridview7.DataKeys[Gridview7.SelectedIndex].Value.ToString();
            PMPaymentBillinfo.PMPO_PurchaseOrderID = new Guid(label_PurchaseOrderID.Text);
            PMPaymentBillinfo.PMPO_AlreadyPay      = "否";
            PMPaymentBillinfo.PMPO_ResidueMoney    = dl - dml;
            ppb.UpdatePMPO_AlreadyPay(PMPaymentBillinfo);
        }
        if (dml > dl)        //付款金额大于采购订单的剩余付款
        {
            ScriptManager.RegisterClientScriptBlock(Page, GetType(), "aa", "alert('付款金额大于采购订单剩余付款金额!')", true);
            return;
        }
        //dml = dml - dl;
        //}
        //}
        string    stg = "and PMPO_PurchaseOrderID='" + new Guid(Gridview7.DataKeys[Gridview7.SelectedIndex].Value.ToString()) + "'";
        DataSet   dss = ppb.SelectPMPurchaseOrder(stg);
        DataTable dtt = dss.Tables[0];

        if (dtt.Rows.Count > 0)
        {
            label_SupplyID.Text = dtt.Rows[0][1].ToString();
        }
        string    condition = "and PMPaymentBill.PMSI_ID='" + new Guid(label_SupplyID.Text) + "'";
        DataSet   ds        = ppb.SelectPMPaymentBill(condition);
        DataTable dt        = ds.Tables[0];

        if (dt.Rows.Count > 0)
        {
            label_PayBillID.Text = dt.Rows[0][0].ToString();
        }

        PMPaymentBillinfo.PMPB_ID = new Guid(label_PayBillID.Text);
        if (label_Pay.Text == "新增")
        {
            //if (!temp)
            //{
            //    ScriptManager.RegisterClientScriptBlock(this.UpdatePanel_NewPay, this.GetType(), "aa", "alert('请选择采购订单')", true);
            //    return;
            //}
            //else
            //{
            ppb.UpdatePMPaymentBill_Payment(PMPaymentBillinfo);
            PMPaymentBillinfo.PMPD_Man = Session["UserName"].ToString();
            ppb.InsertPMPaymentIDetail(PMPaymentBillinfo);
            //}
        }
        if (label_Pay.Text == "修改")
        {
            PMPaymentBillinfo.PMPD_ID = new Guid(label_PayID.Text);

            PMPaymentBillinfo.PMPB_ID = new Guid(label_PayBillID.Text);
            BindGridview2(PMPaymentBillinfo);
            UpdatePanel_Pay.Update();
            PMPaymentBillinfo.PMPD_Pay = Convert.ToDecimal(Convert.ToDecimal(TextBox3.Text.ToString()) - Convert.ToDecimal(label_PayMoney.Text));
            ppb.UpdatePMPaymentIDetail(PMPaymentBillinfo);
        }

        TextBox3.Text = "";
        DropDownList1.SelectedValue = "请选择";
        TextBox5.Text        = "";
        Panel_NewPay.Visible = false;
        UpdatePanel_NewPay.Update();
        BindGridview1("");
        UpdatePanel_PayBill.Update();
        BindGridview7("");
        UpdatePanel3.Update();
    }