invoiceexec.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using Model;
namespace 金利来分销管理系统.Invoice
{
    public partial class InvoiceExec : System.Web.UI.Page
    {
        //实例化BLL层的方法
        BLL.Invoice.InvoiceBll bllshow;
        BLL.Store.StoreBll storeIDshow;
        public InvoiceExec()
        {
            bllshow = new BLL.Invoice.InvoiceBll();
            storeIDshow = new BLL.Store.StoreBll();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                //获得通过审核的总部发（退）货单据放入DropDownList里
                List<Model.Invoice.InvoiceModel> invoiceIDok = bllshow.InvoiceInsetDDLOK();
                foreach (var item in invoiceIDok)
                {
                    this.ddlInvoiceID.Items.Add(item.invoice_id);
                }
            }
        }
        //当选择发生改变时
        protected void ddlInvoiceID_SelectedIndexChanged(object sender, EventArgs e)
        {
            this.lblshow.Visible = false;
            //每次发生改变，首先清空lable里的值
            this.lbltype.Text = "未选择类";
            //显示与单据相符合的信息
            List<Model.Invoice.InvoiceModel> typeshow = bllshow.InvoiceTimeType(this.ddlInvoiceID.Text);
            foreach (var item in typeshow)
            {
                this.lbltype.Text = item.invoice_type_name;
            }
            this.gvshow.DataSource = bllshow.InvoiceSelectList(this.ddlInvoiceID.Text);
            this.gvshow.DataBind();
        }

        protected void btnOK_Click(object sender, EventArgs e)
        {
            if (this.ddlInvoiceID.SelectedValue != "请选择单据号")
            {
                //按单据号，找出单据信息
                List<Model.Invoice.InvoiceModel> invoiceshow = bllshow.InvoiceSelectList(this.ddlInvoiceID.Text);
                //有几行记录，就循环几次,首先比对仓库库存和单据数量
                foreach (Model.Invoice.InvoiceModel item in invoiceshow)
                {
                    //通过商品在库存中
                    Model.Store.StoreModel storemodel = storeIDshow.SelectStoreByProduct(item.invoice_store, item.invoice_list_product_id, item.invoice_list_color);
                    //判断甲方的库存量是否充足
                    if (storemodel.store_size1 < item.invoice_lis_size1 || storemodel.store_size2 < item.invoice_lis_size2 || storemodel.store_size3 < item.invoice_lis_size3 || storemodel.store_size4 < item.invoice_lis_size4 || storemodel.store_size5 < item.invoice_lis_size5 || storemodel.store_size6 < item.invoice_lis_size6 || storemodel.store_size7 < item.invoice_lis_size7)
                    {
                        this.lblshow.Visible = true;
                        return;
                    }
                }
                //通过以上验证，有几行记录，就循环几次
                foreach (Model.Invoice.InvoiceModel item in invoiceshow)
                {
                    //检查乙方仓库，有则修改
                    if (storeIDshow.InsertStoreCheck(item.invoice_list_product_id, item.invoice_storeto, item.invoice_list_color) == 1)
                    {
                        storeIDshow.OutStoreUp(item.invoice_store, item.invoice_list_product_id, item.invoice_list_color, item.invoice_lis_size1, item.invoice_lis_size2, item.invoice_lis_size3, item.invoice_lis_size4, item.invoice_lis_size5, item.invoice_lis_size6, item.invoice_lis_size7, item.invoice_lis_sum);
                        storeIDshow.InsertStoreUp(item.invoice_storeto, item.invoice_list_product_id, item.invoice_list_color, item.invoice_lis_size1, item.invoice_lis_size2, item.invoice_lis_size3, item.invoice_lis_size4, item.invoice_lis_size5, item.invoice_lis_size6, item.invoice_lis_size7, item.invoice_lis_sum);
                    }
                    //检查乙方仓库，无则添加
                    if (storeIDshow.InsertStoreCheck(item.invoice_list_product_id, item.invoice_storeto, item.invoice_list_color) == 0)
                    {
                        storeIDshow.OutStoreUp(item.invoice_store, item.invoice_list_product_id, item.invoice_list_color, item.invoice_lis_size1, item.invoice_lis_size2, item.invoice_lis_size3, item.invoice_lis_size4, item.invoice_lis_size5, item.invoice_lis_size6, item.invoice_lis_size7, item.invoice_lis_sum);
                        storeIDshow.InsertStoreInto(item.invoice_storeto, item.invoice_list_product_id, item.invoice_list_color, item.invoice_lis_size1, item.invoice_lis_size2, item.invoice_lis_size3, item.invoice_lis_size4, item.invoice_lis_size5, item.invoice_lis_size6, item.invoice_lis_size7, item.invoice_lis_sum);
                    }
                }
                storeIDshow.UpstateInvoice(this.ddlInvoiceID.SelectedValue, "已入库");
                this.lblshow.Visible = false;
                this.ddlInvoiceID.Items.Remove(this.ddlInvoiceID.Text);
                this.ddlInvoiceID.SelectedIndex = 0;
                Response.Write("<script>alert('操作成功')</script>");
               
            }
            else
            {
                Response.Write("<script>alert('未选择单据号')</script>");
            }
        }
    }
}