Exemple #1
0
        private void frmInputBill_Load(object sender, EventArgs e)
        {
            dGV.AutoGenerateColumns = false;
            Dong.BLL.InGoods bInGoods = new Dong.BLL.InGoods();

            dt = bInGoods.getDetial(this.Tag.ToString()).Tables[0];
            BindGrid();
            if (dt.Rows.Count > 0)
            {
                lblCode.Text = dt.Rows[0]["Pcode"].ToString();
                txtOper.Text = dt.Rows[0]["Oper"].ToString();
                lblTime.Text = dt.Rows[0]["IDate"].ToString();
            }
            //计算总体数量和价格
            double cash   = 0;
            int    counts = 0;

            for (int i = 0; i < dGV.Rows.Count; i++)
            {
                double sumPrice = double.Parse(dGV.Rows[i].Cells[5].Value.ToString());
                int    c        = int.Parse(dGV.Rows[i].Cells[4].Value.ToString());
                cash   = cash + sumPrice;
                counts = counts + c;
            }
            lblCount.Text = counts.ToString();
            lblJG.Text    = string.Format("{0:F2}", cash);
        }
Exemple #2
0
        private void fillGVList(string key, int pageSize, int page)
        {
            strSql  = key;
            intPage = page;
            Dong.BLL.InGoods bll = new Dong.BLL.InGoods();
            DataSet          ds  = new DataSet();

            ds = bll.GetListPage(key, pageSize, page);

            gvList.DataSource = ds.Tables[0];
            if (ds.Tables[0].Rows.Count > 0)
            {
                intPages();
            }
        }
Exemple #3
0
        /// <summary>
        /// 进货单保存
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSave_Click(object sender, EventArgs e)
        {
            Dong.BLL.InGoods     bInGoods   = new Dong.BLL.InGoods();
            Dong.Model.InGoods   mInGoods   = new Dong.Model.InGoods();
            Dong.BLL.GoodsInfo   bGoodsInfo = new Dong.BLL.GoodsInfo();
            Dong.Model.GoodsInfo mGoodsInfo = new Dong.Model.GoodsInfo();
            for (int i = 0; i < dGV.Rows.Count; i++)
            {
                //添加进货信息
                mGoodsInfo         = bGoodsInfo.GetModel(dGV.Rows[i].Cells[1].Value.ToString());
                mInGoods.PCode     = lblCode.Text;
                mInGoods.GoodsCode = dGV.Rows[i].Cells[1].Value.ToString();
                mInGoods.Price     = double.Parse(dGV.Rows[i].Cells[3].Value.ToString());
                mInGoods.Counts    = int.Parse(dGV.Rows[i].Cells[4].Value.ToString());
                mInGoods.IDate     = DateTime.Now.Date;
                mInGoods.Oper      = txtOper.Text;
                mInGoods.Supplier  = mGoodsInfo.Supplier;
                mInGoods.Remark    = "";
                bInGoods.Add(mInGoods);

                //修改商品信息
                //进货价格
                double oldPrice1 = (double)mGoodsInfo.Price1;
                mGoodsInfo.Price1 = double.Parse(dGV.Rows[i].Cells[3].Value.ToString());

                //数量
                mGoodsInfo.Counts = mGoodsInfo.Counts + int.Parse(dGV.Rows[i].Cells[4].Value.ToString());

                //成本价
                int    totalCount = (int)mGoodsInfo.Counts + int.Parse(dGV.Rows[i].Cells[4].Value.ToString());
                double totalPrice = (oldPrice1 * (int)mGoodsInfo.Counts) + (double.Parse(dGV.Rows[i].Cells[3].Value.ToString()) * int.Parse(dGV.Rows[i].Cells[4].Value.ToString()));
                double cbPrice    = totalPrice / totalCount;
                mGoodsInfo.Price2 = cbPrice;
                bGoodsInfo.Update(mGoodsInfo);
            }

            frmInput frm = (frmInput)this.Owner;

            frm.refreshData();
            this.Close();
        }
Exemple #4
0
        private void intPages()
        {
            Dong.BLL.InGoods bll = new Dong.BLL.InGoods();
            int counts           = bll.GetRecordCount(strSql);

            lblCounts.Text = counts.ToString();
            if (counts % intPageSize == 0)
            {
                pageCounts = counts / intPageSize;
            }
            else
            {
                pageCounts = (counts / intPageSize) + 1;
            }

            cbPage.Items.Clear();
            for (int i = 1; i <= pageCounts; i++)
            {
                cbPage.Items.Add(i.ToString());
            }
            cbPage.SelectedIndex = intPage - 1;
        }