using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BLL;
using Acction;
using System.Data;
using PublicClass;

public partial class _Default : System.Web.UI.Page 
{
    Pay pay=new Pay();
    Ac_Pay ac_pay=new Ac_Pay();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            txt_time.Text = DateTime.Now.ToShortDateString();
            txt_dh.Text =ac_pay.GetID ().Rows[0][0].ToString ();
        }
    }

    
    protected void btn_save_Click(object sender, EventArgs e)
    {
        pay.D_ID = txt_dh.Text;
        pay.PayDate = txt_time.Text;
        pay.Name = txt_cgy.Text;
        pay.Sex=RBL_xb.SelectedValue;
        pay.Content=txt_Content.Value;
        pay.Cost = txt_zc.Text;
        DataTable dt = new DataTable();

        dt = ac_pay.Pay_Insert(pay);
        if (Message_Alert_web.IsExecSuccess(dt))
        {
            Message_Alert_web.CommandMessageAndHref("添加成功", "../财务/Default.aspx");
        }
    }



 /// <summary>
        /// 获取单号方法
        /// </summary>
        /// <returns></returns>
        public DataTable GetID()
        {
            string sql = "declare @D_ID int"
                +" select @D_ID=MAX(D_ID)+1 from dbo.Pay"
                +" if @D_ID is  null"
                +" set @D_ID=1 "
                +" select @D_ID";

            return  ob.ExecBusiOrder(sql);

        }