memberreturn.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 金利来分销管理系统.Branch
{
    public partial class MemberReturn : 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 MemberReturn()
        {
            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(), "57") == true)
                    {
                        //分店编号在页面显示
                        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();
                        }
                        this.namela.Text = Session["employee_id"].ToString();
                        List<Model.Branch.VenditionModel> list = Branchshow.vendition_idByOKaType_Select("售出","已出库");
                        foreach (Model.Branch.VenditionModel item in list)
                        {
                            this.ddlID.Items.Add(item.vendition_id);
                        }
                       
                        
                    }
                    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)
        {
            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(txtsize1.Text) + int.Parse(txtsize2.Text) + int.Parse(txtsize3.Text) + int.Parse(txtsize4.Text) + int.Parse(txtsize5.Text) + int.Parse(txtsize6.Text) + int.Parse(txtsize7.Text);
                this.lblSum.Text = dr[10].ToString();
                dr[11] = decimal.Parse(this.txtprice.Text);
                dr[12] = (int.Parse(txtsize1.Text) + int.Parse(txtsize2.Text) + int.Parse(txtsize3.Text) + int.Parse(txtsize4.Text) + int.Parse(txtsize5.Text) + int.Parse(txtsize6.Text) + int.Parse(txtsize7.Text)) * decimal.Parse(this.txtprice.Text);
                //int sum =  int.Parse (dr[10].ToString ());
                int size1 = int.Parse(this.txtsize1.Text);
                int size2 = int.Parse(this.txtsize2.Text);
                int size3 = int.Parse(this.txtsize3.Text);
                int size4 = int.Parse(this.txtsize4.Text);
                int size5 = int.Parse(this.txtsize5.Text);
                int size6 = int.Parse(this.txtsize6.Text);
                int size7 = int.Parse(this.txtsize7.Text);

                List<Model.Branch.VenditionModel> member = Branchshow.venditionByIDSelect(this.ddlID.Text);
                foreach (Model.Branch.VenditionModel item in member)
                {
                    if (int.Parse(dr[2].ToString()) > item.info_size1 || int.Parse(dr[3].ToString()) > item.info_size2 || int.Parse(dr[4].ToString()) > item.info_size3 || int.Parse(dr[5].ToString()) > item.info_size4 || int.Parse(dr[6].ToString()) > item.info_size5 || int.Parse(dr[7].ToString()) > item.info_size6 || int.Parse(dr[8].ToString()) > item.info_size7)
                    {
                        this.lblCheck.Visible = true;
                    }
                    else
                    {
                        this.lblCheck.Visible = false;
                    }

                }
                if (this.lblCheck.Visible == false)
                {
                    if (int.Parse(dr[10].ToString()) == 0)
                    {
                        this.lblSum1.Visible = true;
                    }
                    else
                    {
                        if (this.lblshowname.Text == this.txtShop.Text)
                        {
                            //通过商品在销售单中
                            Model.Branch.VenditionModel venditionmodel = Branchshow.venditionByMore_Select(this.ddlID.Text.Trim(), int.Parse(this.lblshowname.Text.Trim()), this.txtMemberID.Text.Trim(), "售出", "已出库");
                            //在dt表里的每一行循环
                            foreach (DataRow item in dt.Rows)
                            {
                                //提交的信息，与dt表里存在的信息做对比
                                if (this.ddlProductID.Text.Trim() == item[0].ToString().Trim() && this.ddlcolor.Text.Trim() == item[9].ToString().Trim())
                                {
                                    //开始记录该仓库，该商品，该颜色，在dt表里已存在的尺码数量
                                    size1 += Convert.ToInt32(item[2]);
                                    size2 += Convert.ToInt32(item[3]);
                                    size3 += Convert.ToInt32(item[4]);
                                    size4 += Convert.ToInt32(item[5]);
                                    size5 += Convert.ToInt32(item[6]);
                                    size6 += Convert.ToInt32(item[7]);
                                    size7 += Convert.ToInt32(item[8]);

                                    int sum = size1 + size2 + size3 + size4 + size5 + size6 + size7;

                                    //该仓库，该商品，该颜色的信息，是否小于（提交的信息加dt表里所对应的信息）
                                    if (venditionmodel.vendition_sum < sum)
                                    {
                                        this.lblCheck.Visible = true;
                                        //如果小于添加的数额，跳出
                                        return;
                                    }
                                }
                            }
                            //判断每次提交的数量，是否是小于仓库的数量
                            if (venditionmodel.vendition_sum < int.Parse(dr[10].ToString()))
                            {
                                this.lblCheck.Visible = true;
                            }
                            else
                            {
                                //当lable“请检查库存数量”未被显示时
                                if (this.lblCheck.Visible == false)
                                {
                                    this.lblSum1.Visible = false;
                                    //当dt为空的时候
                                    if (dt.Rows.Count == 0)
                                    {
                                        dt.Rows.Add(dr);
                                    }
                                    else
                                    {
                                        foreach (DataRow ii in dt.Rows)
                                        {
                                            //当添加信息时，dt是否已有该信息
                                            if (ii[0].ToString().Trim() == this.ddlProductID.Text.Trim() && ii[9].ToString().Trim() == this.ddlcolor.Text.Trim())