addstocklist.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 金利来分销管理系统
{
    public partial class AddStockList1 : System.Web.UI.Page
    {
        bool x = true;
        //定义DataTable
        DataTable dt;
        //实例化采购明细的Model
        List<Model.Stock.Stock_SetailsModel> show = new List<Model.Stock.Stock_SetailsModel>();

        //实例化的BLL层
        BLL.Stock.Stock_SetailsBll stocksetailbllshow;
        BLL.Goods.ProductBll productbllshow;
        BLL.Stock.StockFormBll stockformbllshow;
        BLL.Goods.ProductTypeBll producttypebllshow;
        BLL.Store.StoreBll storebllshow;
        BLL.Employee.EmployeeBll employeebllshow;
        public AddStockList1()
        {
            stocksetailbllshow = new BLL.Stock.Stock_SetailsBll();
            productbllshow = new BLL.Goods.ProductBll();
            stockformbllshow = new BLL.Stock.StockFormBll();
            producttypebllshow = new BLL.Goods.ProductTypeBll();
            storebllshow = new BLL.Store.StoreBll();
            employeebllshow = new BLL.Employee.EmployeeBll();
        }
        
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                //用户权限
                if (Session["employee_id"] == null)
                {
                    Response.Write("<script>alert('请您登陆系统');location.href='../Enter.aspx'</script>");
                }
                else 
                {
                    if (employeebllshow.UserRole(Session["role_id"].ToString(), "43") == true)
                    {
                        //登陆人
                        this.lblName.Text = Session["employee_id"].ToString();
                        //实例化商品表Model（查询商品编号）
                        List<Model.Goods.ProductModel> productid = productbllshow.SelectProductID();
                        foreach (var item in productid)
                        {
                            //将商品表中所有商品编号添加到DropDownList里
                            ddlProductID.Items.Add(item.product_id);
                        }
                        //自动获取采购单据编号（按照时间）
                       this.lblStockID.Text = "CG" + DateTime.Now.ToString("yyyyMMddhhmmssfff");
                    }
                    else
                    {
                        Response.Write("<script>alert('你无权查看此功能,请与管理员联系');location.href='../Aboutus.aspx'</script>");
                    }
                }
               
            }
        }
        //定义表头名称
        private void createDT()
        {
            dt = new DataTable();
            dt.Columns.Add("商品ID");
            dt.Columns.Add("商品颜色");
            dt.Columns.Add("尺码1");
            dt.Columns.Add("尺码2");
            dt.Columns.Add("尺码3");
            dt.Columns.Add("尺码4");
            dt.Columns.Add("尺码5");
            dt.Columns.Add("尺码6");
            dt.Columns.Add("尺码7");
            dt.Columns.Add("采购单价");
            dt.Columns.Add("品牌");
            dt.Columns.Add("数量");
            dt.Columns.Add("总金额");
        }
        //提交采购单按钮事件
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            if (ViewState["dt"] == null)
            {
                createDT();
            }
            else
            {
                //创建虚拟表
                dt = (DataTable)ViewState["dt"];
            }
            if (this.ddlProductID.SelectedValue == "请选择商品编号")
            {
                this.lblShowPID.Visible = true;
            }
            else
            {
                DataRow dr = dt.NewRow();
                //将值赋给虚拟表的制定列
                dr[0] = this.ddlProductID.Text.Trim();
                dr[1] = this.ddlColor.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.txtPrice.Text;
                dr[10] = this.txtBrand.Text;
                this.lblSum.Text = (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[11] = this.lblSum.Text;
                dr[12] = int.Parse(this.lblSum.Text) * decimal.Parse(this.txtPrice.Text);
                
                this.lblShowPID.Visible = false;
                if (int.Parse(dr[11].ToString()) == 0)
                {
                    this.lblSum1.Visible = true;
                }
                else
                {
                    this.lblSum1.Visible = false;
                    //当dt为空的时候
                    if (dt.Rows.Count==0)
                    {
                        dt.Rows.Add(dr);
                    }
                    else
                    {
                        foreach (DataRow item in dt.Rows)
                        {
                            //当添加信息时，dt是否已有该信息
                            if (item[0].ToString() == this.ddlProductID.Text.Trim() && item[1].ToString() == this.ddlColor.Text.Trim())
                            {
                                //如果存在  x = false;
                                x = false;
                                //修改该信息
                                for (int i = 1; i <= 1; i++)
                                {
                                    int s1 = Convert.ToInt32(item[i + 1]);
                                    int s2 = Convert.ToInt32(item[i + 2]);
                                    int s3 = Convert.ToInt32(item[i + 3]);
                                    int s4 = Convert.ToInt32(item[i + 4]);
                                    int s5 = Convert.ToInt32(item[i + 5]);
                                    int s6 = Convert.ToInt32(item[i + 6]);
                                    int s7 = Convert.ToInt32(item[i + 7]);
                                    decimal allprice = decimal.Parse(item[i+11].ToString());
                                    s1 += int.Parse(txtSize1.Text);
                                    s2 += int.Parse(txtSize2.Text);
                                    s3 += int.Parse(txtSize3.Text);
                                    s4 += int.Parse(txtSize4.Text);
                                    s5 += int.Parse(txtSize5.Text);
                                    s6 += int.Parse(txtSize6.Text);
                                    s7 += int.Parse(txtSize7.Text);
                                    allprice += decimal.Parse (dr[12].ToString());
                                    int ssum = s1 + s2 + s3 + s4 + s5 + s6 + s7;
                                    item[i + 1] = s1;
                                    item[i + 2] = s2;
                                    item[i + 3] = s3;
                                    item[i + 4] = s4;
                                    item[i + 5] = s5;
                                    item[i + 6] = s6;
                                    item[i + 7] = s7;
                                    item[i + 10] = ssum;
                                    item[i + 11] = allprice;
                                }
                                
                            }
                             
                        }
                        //如果不存在 x不变
                        if (x==true)
                        {
                            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"];
            int allsum=0;
            decimal allprice=0;
            Model.Stock.Stock_SetailsModel mo;
            //把虚拟表中的字段取出传给采购明细Model
            foreach (DataRow item in dt.Rows)
            {
                mo= new Model.Stock.Stock_SetailsModel();
                mo.product_id = item[0].ToString();
                mo.stock_setails_color = item[1].ToString();
                mo.stock_setails_s1 = Convert.ToInt32(item[2]);
                mo.stock_setails_s2 = Convert.ToInt32(item[3]);
                mo.stock_setails_s3 = Convert.ToInt32(item[4]);
                mo.stock_setails_s4 = Convert.ToInt32(item[5]);
                mo.stock_setails_s5 = Convert.ToInt32(item[6]);
                mo.stock_setails_s6 = Convert.ToInt32(item[7]);
                mo.stock_setails_s7 = Convert.ToInt32(item[8]);

                mo.stock_setails_tradeprice = decimal.Parse (item[9].ToString());
                
                mo.stock_setails_brand = item[10].ToString();
                mo.stock_setails_sum = Convert.ToInt32(item[11]);
                mo.stockform_tradeprice = decimal.Parse(item[12].ToString());
                allsum += Convert.ToInt32(item[11]);
                allprice += decimal.Parse(item[12].ToString());
                //将Model中的数据添加到List泛型集合
                show.Add(mo);
            }
            this.lblAllSum.Text = allsum.ToString ();
            this.lblAllPrice.Text = allprice.ToString ();

            //Model.Stock.StockFormModel stock = stockformbllshow.StockFormSelect("采购进货");
            //添加采购单据
            stockformbllshow.AddStockForm(this.lblStockID.Text, Session["employee_id"].ToString(), 1, int.Parse(this.lblAllSum.Text), decimal.Parse(this.lblAllPrice.Text), "未通过", DateTime.Now);

             foreach (Model.Stock.Stock_SetailsModel item in show)
             {
                 //添加采购明细
                 stocksetailbllshow.AddStockLists(this.lblStockID.Text, item.product_id, item.stock_setails_s1, item.stock_setails_s2, item.stock_setails_s3, item.stock_setails_s4, item.stock_setails_s5, item.stock_setails_s6, item.stock_setails_s7, item.stock_setails_tradeprice, item.stock_setails_color, item.stock_setails_brand, item.stock_setails_sum);
             }
             Response.Write("<script>alert('该损益申请已提交')</script>");
             ClearMethod();
             this.ddlProductID.Text = "请选择商品编号";
             //自动获取采购单据编号（按照时间）
             this.lblStockID.Text = "CG" + DateTime.Now.ToString("yyyyMMddhhmmssfff");

        }
        //通过商品ID查询该商品信息
        protected void ddlProductID_SelectedIndexChanged(object sender, EventArgs e)
        {

            //获取商品信息(商品名称，单价，品牌)
            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.txtBrand.Text = item.brand_name;
                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.lblShowPID.Visible = false;
    
            this.txtProductName.Text = "";
            this.txtBrand.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 = "";
            this.lblsize1.Text = "32";
            this.lblsize2.Text = "33";
            this.lblsize3.Text = "34";
            this.lblsize4.Text = "35";
            this.lblsize5.Text = "36";
            this.lblsize6.Text = "37";
            this.lblsize7.Text = "38";
            ddlColor.Items.Clear();
            this.btnShowStockForm.Visible = false;
            ViewState["dt"] = null;
            this.gvShow.DataSource = null;
            this.gvShow.DataBind();
        }
        //删除当前行数据
        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();
        }     
    }
}