bigcustomerbranchsale.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 Model;
using BLL;
using System.Data;

namespace WebApplication1
{
    public partial class BigCustomerBranchSale : System.Web.UI.Page
    {
        DataTable dt;
        //实例化的BLL层

        BLL.Goods.ProductBll productbllshow;
        BLL.Members.MemberbBll bigidbllshow;
        BLL.BigCustomers.bigclientBll bigclientbllshow;
        BLL.BigCustomers.bigclient_listBll bigclient_listbllshow;
        BLL.Employee.EmployeeBll employeebllshow;

        //实例化大客户明细Model
        List<Model.BigCustomers.bigclient_listModel> show = new List<Model.BigCustomers.bigclient_listModel>();
        public BigCustomerBranchSale()
        {
            productbllshow = new BLL.Goods.ProductBll();
            bigclientbllshow = new BLL.BigCustomers.bigclientBll();
            bigidbllshow = new BLL.Members.MemberbBll();
            bigclient_listbllshow = new BLL.BigCustomers.bigclient_listBll();
            employeebllshow = new BLL.Employee.EmployeeBll();

        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                 //用户权限
                if (Session["employee_id"] == null)
                {
                    Response.Write ("请您登陆系统");
                }
                else 
                {
                    if (employeebllshow.UserRole(Session["role_id"].ToString(), "1") == true)
                    {
                       //实例化商品表的泛型集合（查询所有商品名称）
                        List<Model.Goods.ProductModel> productid = productbllshow.SelectProductID();
                        foreach (var item in productid)
                        {
                            //将商品表中所有商品编号添加到DropDownList里
                            ddlProductID.Items.Add(item.product_id);
                        }

                        //获取当天时间（大客户销售单据）
                        this.lblSellID.Text = "BS" + DateTime.Now.ToString("yyyyMMddhhmmssfff");
                        //实例化会员表的泛型集合（通过性别为零查询大客户编号）
                        List<Model.Members.Memberb> bigid = bigclientbllshow.SelectBigClientID("0");
                        foreach (var item in bigid)
                        {
                            //将大客户编号添加到DropDownList里
                            this.ddlBigID.Items.Add(item.Member_ID);
                        }
                    }
                    else
                    {
                        Response.Write("<script>alert('你无权查看此功能,请与管理员联系');location.href='../Aboutus.aspx'</script>");
                    }
                }
            }
        }
        //创建表
        private void createDT()
        {
            dt = new DataTable();
            dt.Columns.Add("商品ID");
            dt.Columns.Add("31");
            dt.Columns.Add("32");
            dt.Columns.Add("33");
            dt.Columns.Add("34");
            dt.Columns.Add("35");
            dt.Columns.Add("36");
            dt.Columns.Add("37");
            dt.Columns.Add("商品颜色");
            dt.Columns.Add("零售价");
            dt.Columns.Add("折扣价");
            dt.Columns.Add("数量");
            dt.Columns.Add("总金额");
        }
       //通过商品编号查找商品信息
        protected void ddlProductID_SelectedIndexChanged(object sender, EventArgs e)
        {
            //清空数据
            ClearMethod();

            //获取商品信息(商品名称，单价，品牌)
            List<Model.Goods.ProductModel> p = productbllshow.SelectProductByID(this.ddlProductID.Text);
            foreach (Model.Goods.ProductModel item in p)
            {
                ddlColor.Items.Add(item.producttype_color);
                this.txtProductName.Text = item.product_name;
                this.txtPrice.Text = item.Product_tradeprice.ToString();
                this.lblsize1.Text = item.producttype_s1.ToString();
                this.lblsize2.Text = item.producttype_s2.ToString();
                this.lblsize3.Text = item.producttype_s3.ToString();
                this.lblsize4.Text = item.producttype_s4.ToString();
                this.lblsize5.Text = item.producttype_s5.ToString();
                this.lblsize6.Text = item.producttype_s6.ToString();
                this.lblsize7.Text = item.producttype_s7.ToString();
                //默认每个尺码的数量为“0”
                this.txtSize1.Text = "0";
                this.txtSize2.Text = "0";
                this.txtSize3.Text = "0";
                this.txtSize4.Text = "0";
                this.txtSize5.Text = "0";
                this.txtSize6.Text = "0";
                this.txtSize7.Text = "0";
            }
        }
        //清空数据
        private void ClearMethod()
        {
            this.txtProductName.Text = "";
            this.tbSellPrice.Text = "";
            this.txtSize1.Text = "";
            this.txtSize2.Text = "";
            this.txtSize3.Text = "";
            this.txtSize4.Text = "";
            this.txtSize5.Text = "";
            this.txtSize6.Text = "";
            this.txtSize7.Text = "";
            this.txtPrice.Text = "";
            ddlColor.Items.Clear();
            this.lblShowPID.Visible = false;
            this.gvShow.DataSource = null;
            this.gvShow.DataBind();
        }
        //提交销售单
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            if (ViewState["dt"] == null)
            {
                createDT();
            }
            else
            {
                dt = (DataTable)ViewState["dt"];
            }
            if (this.ddlBigID.SelectedValue == "请选择大客户编号")
            {
                this.lblBigID.Visible = true;
            }
            else
            {
                if (this.ddlProductID.SelectedValue == "请选择商品编号")
                {
                    this.lblShowPID.Visible = true;
                }
                else
                {
                    DataRow dr = dt.NewRow();
                    dr[0] = this.ddlProductID.Text.Trim();
                    dr[1] = this.txtSize1.Text;
                    dr[2] = this.txtSize2.Text;
                    dr[3] = this.txtSize3.Text;
                    dr[4] = this.txtSize4.Text;
                    dr[5] = this.txtSize5.Text;
                    dr[6] = this.txtSize6.Text;
                    dr[7] = this.txtSize7.Text;
                    dr[8] = this.txtPrice.Text;
                    dr[9] = this.ddlColor.Text;
                    dr[10] = this.tbSellPrice.Text + ".00";
                    dr[11] = (Convert.ToInt32(this.txtSize1.Text) + Convert.ToInt32(this.txtSize2.Text) + Convert.ToInt32(this.txtSize3.Text) + Convert.ToInt32(this.txtSize4.Text) + Convert.ToInt32(this.txtSize5.Text) + Convert.ToInt32(this.txtSize6.Text) + Convert.ToInt32(this.txtSize7.Text)).ToString();
                    dr[12] = int.Parse(dr[11].ToString()) * decimal.Parse(this.tbSellPrice.Text) + ".00";
                    if (int.Parse(dr[11].ToString()) == 0)
                    {
                        this.lblSum1.Visible = true;
                    }
                    else
                    {
                        dt.Rows.Add(dr);
                        ViewState["dt"] = dt;
                        gvShow.DataSource = dt;
                        gvShow.DataBind();
                        this.btnShowStockForm.Visible = true;
                    }
                }
            }
        }
        //生成大客户销售单据
        protected void btnShowStockForm_Click(object sender, EventArgs e)
        {
            dt = (DataTable)ViewState["dt"];
            //实例化大客户表的泛型集合（保存销售记录）
            Model.BigCustomers.bigclient_listModel mo = new Model.BigCustomers.bigclient_listModel();
            foreach (DataRow item in dt.Rows)
            {
                //将显示的数据赋值给mo
                mo.Product_id = item[0].ToString();
                mo.bigclient_lis_size1 = Convert.ToInt32(item[1]);
                mo.bigclient_lis_size2 = Convert.ToInt32(item[2]);
                mo.bigclient_lis_size3 = Convert.ToInt32(item[3]);
                mo.bigclient_lis_size4 = Convert.ToInt32(item[4]);
                mo.bigclient_lis_size5 = Convert.ToInt32(item[5]);
                mo.bigclient_lis_size6 = Convert.ToInt32(item[6]);
                mo.bigclient_lis_size7 = Convert.ToInt32(item[7]);

                mo.bigclient_list_color = item[9].ToString();
                mo.bigclient_list_price = decimal.Parse(item[10].ToString());
                mo.bigclient_lis_sum = Convert.ToInt32(item[11]);
                mo.bigclient_lis_pricesum = decimal.Parse(item[12].ToString());
                //将保存到mo里的数据添加到show
                show.Add(mo);
            }
            //添加大客户销售单据
            bigclientbllshow.AddBigSell(this.lblSellID.Text, this.lblName.Text, "3", mo.bigclient_lis_pricesum, mo.bigclient_lis_sum, DateTime.Now, this.ddlBigID.Text, "未通过");
            foreach (Model.BigCustomers.bigclient_listModel item in show)
            {
                //添加大客户销售明细
                bigclient_listbllshow.Addbigclient_list(this.lblSellID.Text, item.Product_id, item.bigclient_list_color, item.bigclient_list_price, item.bigclient_lis_size1, item.bigclient_lis_size2, item.bigclient_lis_size3, item.bigclient_lis_size4, item.bigclient_lis_size5, item.bigclient_lis_size6, item.bigclient_lis_size7);
            }
            Response.Write("<script>alert('大客户销售申请已提交')</script>");
            this.btnShowStockForm.Visible = false;
            this.gvShow.DataSource = null;
            this.gvShow.DataBind();
            ViewState["dt"] = null;
            this.ddlProductID.Text = "请选择商品编号";
            //自动获取采购单据编号（按照时间）
            this.lblSellID.Text = "BS" + DateTime.Now.ToString("yyyyMMddhhmmssfff");
            //清空数据
            ClearMethod();

           
        }
        //删除当前行数据
        protected void lbtnCancel_Click(object sender, EventArgs e)
        {
            dt = (DataTable)ViewState["dt"];
            DataRow x = dt.Rows[this.dt.Rows.Count - 1];
            dt.Rows.Remove(x);
            ViewState["dt"] = dt;
            gvShow.DataSource = ViewState["dt"];
            gvShow.DataBind();
        }
    }
}