branchsale.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 BLL;
using Model;
using System.Data;
namespace WebApplication1
{
    public partial class BranchSale : System.Web.UI.Page
    {
        #region  销售单据,UI层构造函数
        //实例化BLL层
        BLL.Branch.VenditionBll Branchshow;
        BLL.Members.MemberbBll Membershow;
        BLL.Goods.ProductBll productbllshow;
        BLL.Store.StoreBll storeIDshow;
        BLL.Employee.EmployeeBll shopidshow;
        BLL.Employee.EmployeeBll employeebllshow;
        bool x = true;
        List<Model.Branch.VenditionModel> inf = new List<Model.Branch.VenditionModel>();
        public BranchSale()
        {
            Branchshow = new BLL.Branch.VenditionBll();
            Membershow = new BLL.Members.MemberbBll();
            productbllshow = new BLL.Goods.ProductBll();
            storeIDshow = new BLL.Store.StoreBll();
            shopidshow = new BLL.Employee.EmployeeBll();
            employeebllshow = new BLL.Employee.EmployeeBll();
        }
        #endregion

        DataTable dt;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                 //用户权限
                if (Session["employee_id"] == null)
                {
                    Response.Write("<script>alert('请您登陆系统');location.href='../Enter.aspx'</script>");
                }
                else 
                {
                    if (employeebllshow.UserRole(Session["role_id"].ToString(), "53") == true)
                    {
                        ////////////////////////////////Membershow.SelectMembersByID();
                        //查询所有的会员编号
                       List<Model.Members.Memberb> member= Membershow.SelectMembersID("HY");
                       foreach (Model.Members.Memberb item in member)
                       {
                           //在ddlMemberID里显示会员编号
                           this.ddlMemberID.Items.Add(item.Member_ID);
                       }
                        //商品编号在DropDownList里显示
                        List<Model.Branch.VenditionModel> ddlIDshow = Branchshow.SelectMemberID();
                        foreach (var item in ddlIDshow)
                        {
                            this.ddlProductID.Items.Add(item.Product_id);
                        }
                        this.namela.Text = Session["employee_id"].ToString ();
                        //获取当天时间
                        this.lblID.Text = "XS" + DateTime.Now.ToString("yyyyMMddhhmmssfff");
                       List<Model.Employee.EmployeeModel> em= employeebllshow.ShopidSelect(Session["employee_id"].ToString());
                       foreach (Model.Employee.EmployeeModel item in em)
                       {
                           this.lblshowname.Text = item.Shop_id.ToString ();
                       }
                    }
                    else
                    {
                        Response.Write("<script>alert('你无权查看此功能,请与管理员联系');location.href='../Aboutus.aspx'</script>");
                    }
                }
            }
            
        }
        //创建ViewState
        private void adddt()
        {
            dt = new DataTable();
            dt.Columns.Add("商品编号");
            dt.Columns.Add("商品名称");
            dt.Columns.Add("31(M)");
            dt.Columns.Add("32(X)");
            dt.Columns.Add("33(S)");
            dt.Columns.Add("34(XS)");
            dt.Columns.Add("35(L)");
            dt.Columns.Add("36(XL)");
            dt.Columns.Add("37(2XL)");
            dt.Columns.Add("颜色");
            dt.Columns.Add("销售数量");
            dt.Columns.Add("销售单价");
            dt.Columns.Add("金额");
        }

        //提交
        protected void btnadd_Click(object sender, EventArgs e)
        {
            //List<Model.Employee.EmployeeModel> mo1 = shopidshow.SelectShopID(this.lblshowname.Text);
           // foreach (Model.Employee.EmployeeModel item in mo1)
           //{
                //通过商品在库存中的编号，颜色以及库存编号查找尺码是否大于所填写的数据
                Model.Store.StoreModel storemodel = storeIDshow.SelectStoreByProduct(int.Parse (this.lblshowname.Text), this.ddlProductID.Text, this.ddlcolor.Text);
                if (storemodel.store_size1 < int.Parse(this.txtsize1.Text) || storemodel.store_size2 < int.Parse(this.txtsize2.Text) || storemodel.store_size3 < int.Parse(this.txtsize3.Text) || storemodel.store_size4 < int.Parse(this.txtsize4.Text) || storemodel.store_size5 < int.Parse(this.txtsize5.Text) || storemodel.store_size6 < int.Parse(this.txtsize6.Text) || storemodel.store_size7 < int.Parse(this.txtsize7.Text))
                {
                    this.lblShow.Visible = true;
                }
                else
                {
                    
                    if (ViewState["dt"] == null)
                    {
                        adddt();
                    }
                    else
                    {
                        dt = (DataTable)ViewState["dt"];
                    }
                    if (this.ddlProductID.SelectedValue == "未选择商品")
                    {
                        this.lblShowPID.Visible = true;
                    }
                    else
                    {
                        DataRow dr = dt.NewRow();
                        dr[0] = this.ddlProductID.Text;
                        dr[1] = this.txtProductName.Text;
                        dr[2] = this.txtsize1.Text;
                        dr[3] = this.txtsize2.Text;
                        dr[4] = this.txtsize3.Text;
                        dr[5] = this.txtsize4.Text;
                        dr[6] = this.txtsize5.Text;
                        dr[7] = this.txtsize6.Text;
                        dr[8] = this.txtsize7.Text;
                        dr[9] = this.ddlcolor.Text;
                        dr[10] = int.Parse(this.txtsize1.Text) + int.Parse(this.txtsize2.Text) + int.Parse(this.txtsize3.Text) + int.Parse(this.txtsize4.Text) + int.Parse(this.txtsize5.Text) + int.Parse(this.txtsize6.Text) + int.Parse(this.txtsize7.Text);
                        dr[11] = decimal.Parse(this.txtprice.Text);
                        dr[12] = (int.Parse(this.txtsize1.Text) + int.Parse(this.txtsize2.Text) + int.Parse(this.txtsize3.Text) + int.Parse(this.txtsize4.Text) + int.Parse(this.txtsize5.Text) + int.Parse(this.txtsize6.Text) + int.Parse(this.txtsize7.Text)) * decimal.Parse(this.txtprice.Text);
                        int ss1 = int.Parse(this.txtsize1.Text);
                        int ss2 = int.Parse(this.txtsize2.Text);
                        int ss3 = int.Parse(this.txtsize3.Text);
                        int ss4 = int.Parse(this.txtsize4.Text);
                        int ss5 = int.Parse(this.txtsize5.Text);
                        int ss6 = int.Parse(this.txtsize6.Text);
                        int ss7 = int.Parse(this.txtsize7.Text);

                        if (int.Parse(dr[10].ToString()) == 0)
                        {
                            this.lblSum1.Visible = true;
                        }
                        else
                        {
                            //在dt表里的每一行循环
                            foreach (DataRow type in dt.Rows)
                            {
                                //提交的信息，与dt表里存在的信息做对比
                                if (this.ddlProductID.Text.Trim() == type[0].ToString().Trim() && this.ddlcolor.Text.Trim() == type[9].ToString().Trim())
                                {
                                    //开始记录该仓库，该商品，该颜色，在dt表里已存在的尺码数量
                                    ss1 += Convert.ToInt32(type[2]);
                                    ss2 += Convert.ToInt32(type[3]);
                                    ss3 += Convert.ToInt32(type[4]);
                                    ss4 += Convert.ToInt32(type[5]);
                                    ss5 += Convert.ToInt32(type[6]);
                                    ss6 += Convert.ToInt32(type[7]);
                                    ss7 += Convert.ToInt32(type[8]);
                                    //该仓库，该商品，该颜色的信息，是否小于（提交的信息加dt表里所对应的信息）
                                    if (storemodel.store_size1 < ss1 || storemodel.store_size2 < ss2 || storemodel.store_size3 < ss3 || storemodel.store_size4 < ss4 || storemodel.store_size5 < ss5 || storemodel.store_size6 < ss6 || storemodel.store_size7 < ss7)
                                    {
                                        this.lblShow.Visible = true;
                                        //如果小于添加的数额，跳出
                                        return;
                                    }
                                }
                            }
                            //判断每次提交的数量，是否是小于仓库的数量
                            if (storemodel.store_size1 < int.Parse(this.txtsize1.Text) || storemodel.store_size2 < int.Parse(this.txtsize2.Text) || storemodel.store_size3 < int.Parse(this.txtsize3.Text) || storemodel.store_size4 < int.Parse(this.txtsize4.Text) || storemodel.store_size5 < int.Parse(this.txtsize5.Text) || storemodel.store_size6 < int.Parse(this.txtsize6.Text) || storemodel.store_size7 < int.Parse(this.txtsize7.Text))
                            {
                                this.lblShow.Visible = true;
                            }
                            else
                            {
                                
                                //当lable“请检查库存数量”未被显示时
                                if (this.lblShow.Visible == false)
                                {
                                    this.lblSum1.Visible = false;
                                    //当dt为空的时候
                                    if (dt.Rows.Count == 0)
                                    {
                                        dt.Rows.Add(dr);
                                    }
                                    else
                                    {
                                        foreach (DataRow ii in dt.Rows)