invoiceinfroselect.aspx.cs

c#三层架构项目开发的全过程

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace 金利来分销管理系统.Invoice
{
    public partial class InvoiceInfroSelect : System.Web.UI.Page
    {
          //实例化BLL
        BLL.Invoice.InvoiceBll invoicebllshow;
        BLL.Goods.ProductBll productbllshow;
        public InvoiceInfroSelect()
        {
            invoicebllshow = new BLL.Invoice.InvoiceBll();
            productbllshow = new BLL.Goods.ProductBll();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //实例化商品泛型集合
                List<Model.Goods.ProductModel> productid = productbllshow.SelectProductID();
                //查询商品编号
                foreach (var item in productid)
                {
                    this.ddlProductID.Items.Add(item.product_id);
                }
                //显示所有总部发货单据
                this.gvShow.DataSource = invoicebllshow.InvoiceSetailSelectByWhere();
                this.gvShow.DataBind();
            }
            
        }
        //按时间查找发货单据按钮事件（获取该天单据）
        protected void btnSele_Click(object sender, EventArgs e)
        {
            //清空总部发货单据编号
            this.ddlStockFormID.Items.Clear();
            this.ddlStockFormID.Items.Add("请选择单据号");
            //未选择时间时
            if (this.txtTime.Text == "")
            {
                //‘请选择时间’，lable显示
                this.lblTime.Visible = true;
            }
            else
            {

                this.lblTime.Visible = false;
                    
                //实例化总部发货明细（通过时间）
                List<Model.Invoice.InvoiceModel> stockid = invoicebllshow.SelectInvoiceIDByTime(DateTime.Parse(this.txtTime.Text));
                //查询所有总部发货单据编号
                foreach (var item in stockid)
                {
                    this.ddlStockFormID.Items.Add(item.invoice_id);
                }
            }
        }
        //查询总部发货单据信息按钮事件（查看）
        protected void btnSelect_Click(object sender, EventArgs e)
        {
            //实例化总部发货单据泛型集合
            List<Model.Invoice.InvoiceModel> mo = invoicebllshow.InvoiceSetailSelectByWhere();
            //按总部发货单据编号查找
            if (ddlStockFormID.SelectedValue != "请选择单据号")
            {
                mo = mo.FindAll(o => o.invoice_id == this.ddlStockFormID.Text.Trim());
            }
            //按商品编号
            if (ddlProductID.SelectedIndex != 0)
            {
                mo = mo.FindAll(o => o.invoice_list_product_id == this.ddlProductID.Text.Trim());
            }
            this.gvShow.DataSource = mo;
            this.gvShow.DataBind();
        }
        //当单据选择项发生改变时
        protected void ddlStockFormID_SelectedIndexChanged(object sender, EventArgs e)
        {
            //清空商品编号选择项的值
            this.ddlProductID.Items.Clear();
            this.ddlProductID.Items.Add("请选择商品编号");
            if (this.ddlStockFormID.SelectedValue == "请选择单据号")
            {
                //实例化商品泛型集合
                List<Model.Goods.ProductModel> productid = productbllshow.SelectProductID();
                //查询商品编号
                foreach (var item in productid)
                {
                    this.ddlProductID.Items.Add(item.product_id);
                }
            }
            else
            {
                //将选择的单据里包含的不重复的商品编号，添加到商品编号选择项里
                List<Model.Invoice.InvoiceModel> mo = invoicebllshow.InvoiceSelectListPid(this.ddlStockFormID.SelectedValue);
                foreach (var item in mo)
                {
                    this.ddlProductID.Items.Add(item.invoice_list_product_id);
                }
            }
            
            
        }
    }
}