lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/InventoryManagement/Receipt/FrmWarehousing.cs

using LYFZ.ComponentLibrary;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace LYFZ.Software.MainBusiness.InventoryManagement.Receipt
{
    public partial class FrmWarehousing : LYFZ.Software.UI.InventoryManagement.Receipt.FrmWarehousing
    {
        private delegate void UpdateControl();
        Boolean bl = false;
        public FrmWarehousing()
        {
            this.ucPagerEx1.EventPaging += ucPagerEx1_EventPaging;
            this.FormClosed += FrmWarehousing_FormClosed;
            this.dgv1.CellMouseDown += dgv1_CellMouseDown;
            this.dgv1.DataGridViewConMenu_ItemClicked += dgv1_DataGridViewConMenu_ItemClicked;

        }

        void FrmWarehousing_FormClosed(object sender, FormClosedEventArgs e)
        {
            if (bl)
            {
                this.DialogResult = DialogResult.OK;
            }
        }

        #region 加载
        protected override void FrmWarehousing_Shown(object sender, EventArgs e)
        {
            try
            {
                bind();
                SelectGoods();
                BindVendor();
            }
            catch (Exception ex)
            {
                MessageBoxCustom.Show(ex.Message);
            }
        }

        #region 获取所有商品
        /// <summary>
        /// 获取所有商品
        /// </summary>
        public void bind()
        {
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.PageSize = 80;// LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();//3;分页条数
            this.ucPagerEx1.Bind();


        }
        #endregion
        #endregion

        #region 保存
        protected override void btnWarehousing_Click(object sender, EventArgs e)
        {
            if (dgv1.Rows.Count > 0)
            {
                if (dgv1.SelectedRows.Count == 0)
                {
                    MessageBoxCustom.Show("请选择你要入库的商品！");
                    return;
                }
                for (int i = 0; i < dgv1.SelectedRows.Count; i++)
                {
                    string Pis_PurchaseVendor = dgv1.SelectedRows[i].Cells["Pis_PurchaseVendor"].Value.ToString();
                    string Pis_PurchaseQuantity = dgv1.SelectedRows[i].Cells["Pis_PurchaseQuantity"].Value.ToString();
                    if (string.IsNullOrEmpty(Pis_PurchaseVendor))
                    {
                        MessageBoxCustom.Show("商品厂商不能为空！");
                        return;
                    }
                    if (Pis_PurchaseQuantity == "0")
                    {
                        MessageBoxCustom.Show("商品入库数量不能为0！");
                        return;
                    }
                }

                #region 新增入库记录表
                for (int i = 0; i < dgv1.SelectedRows.Count; i++)
                {

                    LYFZ.Model.Model_ErpProductIntStorage ProductIntStorageModel = new Model.Model_ErpProductIntStorage();
                    LYFZ.BLL.BLL_ErpProductIntStorage ProductIntStorageBll = new BLL.BLL_ErpProductIntStorage();
                    ProductIntStorageModel.Pis_DividedShop = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetCompanyInfoID();
                    ProductIntStorageModel.Pis_ProductCategory = dgv1.SelectedRows[i].Cells["Pis_ProductCategory"].Value.ToString();
                    ProductIntStorageModel.Pis_ProductNumber = dgv1.SelectedRows[i].Cells["Pis_ProductNumber"].Value.ToString();
                    ProductIntStorageModel.Pis_PurchaseQuantity = Convert.ToInt32(dgv1.SelectedRows[i].Cells["Pis_PurchaseQuantity"].Value);
                    ProductIntStorageModel.Pis_PurchaseVendor = dgv1.SelectedRows[i].Cells["Pis_PurchaseVendor"].Value.ToString();
                    ProductIntStorageModel.Pis_PurchasePrice = Convert.ToDecimal(dgv1.SelectedRows[i].Cells["Pis_PurchasePrice"].Value);
                    ProductIntStorageModel.Pis_Remark = dgv1.SelectedRows[i].Cells["Pis_Remark"].Value.ToString();
                    ProductIntStorageModel.Pis_CreateDatetime = Convert.ToDateTime( LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetServerDateTime().ToString("yyyy-MM-dd"));
                    ProductIntStorageModel.Pis_CreateName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                    ProductIntStorageBll.Add(ProductIntStorageModel);

                    #region 更新商品库存数量
                    string Prod_Number = dgv1.SelectedRows[i].Cells["Pis_ProductNumber"].Value.ToString();
                    int Pis_PurchaseQuantity = Convert.ToInt32(dgv1.SelectedRows[i].Cells["Pis_PurchaseQuantity"].Value);
                    LYFZ.BLL.BLL_ErpProduct ProductBll = new BLL.BLL_ErpProduct();
                    DataTable dt = ProductBll.GetList("Prod_Number='" + Prod_Number + "'").Tables[0];
                    int sumQuantity = Pis_PurchaseQuantity + Convert.ToInt32(dt.Rows[0]["Prod_Quantity"]);
                    ProductBll.UpdateProduct("Prod_Quantity=" + sumQuantity + "", Prod_Number);
                    #endregion
                }
                #endregion

                bl = true;
                MessageBoxCustom.Show("入库成功！");
                this.Close();
            }
        }
        #endregion

        #region 关闭
        protected override void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        #endregion

        #region 绑定查询商品类别
        /// <summary>
        /// 绑定查询商品类别
        /// </summary>
        public void SelectGoods()
        {
            CtvSelect.TreeView.Nodes.Clear();
            #region 绑定二级商品类别
            LYFZ.BLL.BLL_ErpSystemCategory BLLSystemCategory = new BLL.BLL_ErpSystemCategory();
            DataTable tbl = BLLSystemCategory.GetList("Sc_ClassParentID='1'").Tables[0];
            if (tbl.Rows.Count > 0)
            {
                TreeNode root = null;

                for (int i = 0; i < tbl.Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        root = new TreeNode("全部");
                        this.CtvSelect.TreeView.Nodes.Add(root);
                    }
                    root = new TreeNode();
                    root.Text = tbl.Rows[i]["Sc_ClassName"].ToString();
                    root.Tag = tbl.Rows[i]["Sc_ClassCode"].ToString();
                    this.CreateTreeViewShop(root.Nodes, tbl.Rows[i]["ID"].ToString());
                    this.CtvSelect.TreeView.Nodes.Add(root);
                }
            }
            #endregion
        }
        #endregion

        #region 绑定三级商品类别
        #region 绑定第三级商品类别
        /// <summary>
        /// 绑定第三级商品类别
        /// </summary>
        /// <param name="nodes">TreeView的节点集合</param>
        /// <param name="dataSource">数据源</param>
        /// <param name="parentid"></param>
        private void CreateTreeViewShop(TreeNodeCollection nodes, string ClassCode)
        {
            if (ClassCode != "")
            {
                LYFZ.BLL.BLL_ErpSystemCategory BLLSystemCategory = new BLL.BLL_ErpSystemCategory();
                DataTable tbl = BLLSystemCategory.GetList("Sc_ClassParentID=" + ClassCode + "").Tables[0];
                if (tbl.Rows.Count > 0)
                {
                    TreeNode node;
                    for (int i = 0; i < tbl.Rows.Count; i++)
                    {
                        node = new TreeNode();
                        node.Text = tbl.Rows[i]["Sc_ClassName"].ToString();
                        node.Tag = tbl.Rows[i]["Sc_ClassCode"].ToString();
                        nodes.Add(node);
                    }
                }
            }
        }
        #endregion
        #endregion

        #region 商品查询
        protected override void CtvSelect_ComboBoxTreeViewEx_TextChanged(object sender, TreeViewEventArgs e)
        {

            try
            {
                bind();

            }
            catch (Exception ex)
            {
                MessageBoxCustom.Show(ex.Message);
            }
        }
        #endregion

        #region 绑定商品厂商
        //<summary>
        //绑定商品厂商
        //</summary>
        public void BindVendor()
        {
            //DataTable dt = new DataTable();
            //LYFZ.BLL.BLL_ErpVendor Vendorbll = new BLL.BLL_ErpVendor();
            //dt = Vendorbll.GetList("Vd_Category='1'").Tables[0];
            //this.cmbFactory.DataSource = dt;
            //this.cmbFactory.ValueMember = "ID";
            //this.cmbFactory.DisplayMember = "Vd_Name";
            ////DataRow dr = dt.NewRow();
            ////dr["ID"] = "-1";
            ////dr["Vd_Name"] = "";
            ////dt.Rows.InsertAt(dr, 0);
            //cmbFactory.SelectedIndex = -1;
            LYFZ.BLL.BLL_ErpOrder Orderbll = new BLL.BLL_ErpOrder();
            DataTable dt = Orderbll.GetView_Custom("tb_ErpVendor", StrWhere: "", ShowColumnName: "distinct Vd_Name").Tables[0];
            if (dt.Rows.Count > 0)
            {
                this.cmbFactory.DataSource = dt;
                this.cmbFactory.ValueMember = "Vd_Name";
                this.cmbFactory.DisplayMember = "Vd_Name";
                cmbFactory.SelectedIndex = -1;
            }
        }
        #endregion
        /// <summary>
        /// 选择商品厂商
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void cmbFactory_SelectedIndexChanged(object sender, EventArgs e)
        {
            for (int i = 0; i < dgv1.SelectedRows.Count; i++)
            {
                dgv1.SelectedRows[i].Cells["Pis_PurchaseVendor"].Value = cmbFactory.Text;
            }
        }

        #region dgv控件里面塞下拉框
        /// <summary
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>

        protected override void dgv1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (this.dgv1.Rows.Count > 0)
            {
                if (this.dgv1.CurrentCell.ColumnIndex == this.dgv1.Columns["Pis_PurchaseVendor"].Index)
                {
                    DataGridViewCell cell = this.dgv1.Rows[e.RowIndex].Cells[e.ColumnIndex];
                    Rectangle rect = this.dgv1.GetCellDisplayRectangle(cell.ColumnIndex, cell.RowIndex, true);
                    this.cmbFactory.Location = new Point(rect.Location.X + 11, rect.Location.Y + 58);
                    this.cmbFactory.Size = rect.Size;
                    if (cell.Value != null)
                    { this.cmbFactory.Text = (string)cell.Value; }
                    this.cmbFactory.Visible = true;
                    this.cmbFactory.Focus();
                }
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void cmbFactory_Leave(object sender, EventArgs e)
        {
            this.dgv1.CurrentRow.Cells["Pis_PurchaseVendor"].Value = this.cmbFactory.Text.Trim();
            this.cmbFactory.Visible = false;
        }
        #endregion

        #region 输入框限制
        #region 只能输入数字
        protected override void dgv1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                if (dgv1.Rows.Count > 0)
                {
                    if (dgv1.CurrentRow.Cells["Pis_PurchaseQuantity"].Value == null)
                    {
                        MessageBoxCustom.Show("入库数量不能为空！");
                        dgv1.CurrentRow.Cells["Pis_PurchaseQuantity"].Value = "0";
                        return;
                    }
                    if (dgv1.CurrentRow.Cells["Pis_PurchasePrice"].Value == null)
                    {
                        MessageBoxCustom.Show("商品单价不能为空！");
                        string Prod_Number = dgv1.CurrentRow.Cells["Pis_ProductNumber"].Value.ToString();
                        LYFZ.BLL.BLL_ErpProduct Productbll = new BLL.BLL_ErpProduct();
                        dgv1.CurrentRow.Cells["Pis_PurchasePrice"].Value = Productbll.GetList("Prod_Number='" + Prod_Number + "'").Tables[0].Rows[0]["Prod_CostPrice"].ToString();
                        return;
                    }
                    if (Command.Command_Validate.IsNumber(dgv1.CurrentRow.Cells["Pis_PurchaseQuantity"].Value.ToString()) == false)
                    {
                        MessageBoxCustom.Show("只能输入纯数字！");
                        //  int id = Convert.ToInt32(dgv1.CurrentRow.Cells["ID"].Value);
                        //  LYFZ.BLL.BLL_ErpPurchaseProduct bll = new BLL.BLL_ErpPurchaseProduct();
                        dgv1.CurrentRow.Cells["Pis_PurchaseQuantity"].Value = "0";// bll.GetList("ID=" + id + "").Tables[0].Rows[0]["Ppt_PurchaseQuantity"].ToString();
                        return;
                    }

                    if (Command.Command_Validate.IsNumeric(dgv1.CurrentRow.Cells["Pis_PurchasePrice"].Value.ToString()) == false)
                    {
                        MessageBoxCustom.Show("只能输入数字或者小数！");
                        string Prod_Number = dgv1.CurrentRow.Cells["Pis_ProductNumber"].Value.ToString();
                        LYFZ.BLL.BLL_ErpProduct Productbll = new BLL.BLL_ErpProduct();
                        dgv1.CurrentRow.Cells["Pis_PurchasePrice"].Value = Productbll.GetList("Prod_Number='" + Prod_Number + "'").Tables[0].Rows[0]["Prod_CostPrice"].ToString();
                        return;
                    }

                }
            }
            catch (Exception ex)
            {

                MessageBoxCustom.Show(ex.Message);
            }

        }
        #endregion
        #endregion

        #region 画分页
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx1_EventPaging(UCPager.EventPagingArg e)
        {
            dgv1.Rows.Clear();
            DataTable dt = new DataTable();
            StringBuilder str = new StringBuilder();

            if (CtvSelect.Text == "" || CtvSelect.Tag == null || CtvSelect.Text == "全部")
            {
                str.Append(" 1=1 and  Prod_IsEnabled='1' and Prod_DividedShop='" + LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetCompanyInfoID() + "' and  Prod_Availability=1");
            }
            if (CtvSelect.Tag != null)
            {
                str.Append(" 1=1 and Prod_IsEnabled='1' and Prod_Class='" + CtvSelect.Tag.ToString() + "' and Prod_DividedShop='" + LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetCompanyInfoID() + "' and  Prod_Availability=1");
            }

            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                pageData.TableName = "View_tb_ErpProduct";
                pageData.PageIndex = this.ucPagerEx1.PageCurrent;
                pageData.PageSize = this.ucPagerEx1.PageSize;
                pageData.QueryCondition = str.ToString();
                pageData.QueryFieldName = "ID,Prod_Number,Prod_DividedShop,Prod_Name,Prod_Class,Prod_Unit,Prod_CostPrice,Prod_SalesPrice,Prod_SpecialPrice,Prod_AlarmQuantity,Prod_IsEnabled,Prod_Quantity,Prod_Expedited,Prod_CreateDatetime,Prod_PreSaleQuantity,Prod_Batch,Prod_ClassName,Sc_ClassCode,Prod_ClassName2,Prod_IsEnabledName,Prod_Availability";
                pageData.OrderStr = " ID desc ";

                DataSet da = pageData.QueryDataTable();
                dt = da.Tables[0];
                if (dt.Rows.Count > 0)
                {
                    this.Invoke(new UpdateControl(delegate()
                    {
                        #region
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["ID"].ToString().Trim();
                            dgvr.Cells.Add(cell);


                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Prod_Name"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Prod_Quantity"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Prod_ClassName"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Prod_AlarmQuantity"].ToString().Trim();
                            dgvr.Cells.Add(cell);


                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Prod_PreSaleQuantity"].ToString().Trim();
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Prod_CostPrice"].ToString().Trim();
                            dgvr.Cells.Add(cell);


                            cell = new DataGridViewTextBoxCell();
                            cell.Value = "";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = "0";
                            dgvr.Cells.Add(cell);

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = "";
                            dgvr.Cells.Add(cell);


                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Prod_Class"].ToString().Trim();
                            dgvr.Cells.Add(cell);


                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt.Rows[t]["Prod_Number"].ToString().Trim();
                            dgvr.Cells.Add(cell);



                            this.dgv1.Rows.Add(dgvr);
                            dgv1.ClearSelection();
                        }
                        #endregion
                    }));
                }

                #region 单元格变色
                for (int i = 0; i < dgv1.Rows.Count; i++)
                {
                    int Prod_Quantity = Convert.ToInt32(dgv1.Rows[i].Cells["Prod_Quantity"].Value);
                    int Prod_AlarmQuantity = Convert.ToInt32(dgv1.Rows[i].Cells["Prod_AlarmQuantity"].Value);
                    if (Prod_Quantity <= Prod_AlarmQuantity)
                    {
                        this.dgv1.Rows[i].DefaultCellStyle.ForeColor = Color.Red;
                    }
                }
                #endregion

            });
            try
            {
                this.ucPagerEx1.TbDataSource = dt;
            }
            catch { }
            return pageData.TotalCount;

        }
        #endregion
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgv1_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e)
        {
            if (e.Button == MouseButtons.Right)
            {
                ToolStripMenuItem item = null;
                item = new ToolStripMenuItem();
                item.Text = "查看商品图片";
                item.Tag = "View";
                this.dgv1.conMenu.Items.Add(item);

                item = new ToolStripMenuItem();
                item.Text = "选择商品厂商";
                item.Tag = "Select";
                this.dgv1.conMenu.Items.Add(item);
            }
        }

        void dgv1_DataGridViewConMenu_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            ToolStripItem item = e.ClickedItem;
            if (item.Tag.ToString().Trim() == "View")
            {
                LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.ProductViewPhoto(this.dgv1.CurrentRow.Cells["Pis_ProductNumber"].Value.ToString().Trim());
            }
            else if (item.Tag.ToString().Trim() == "View")
            {
                LYFZ.Software.MainBusiness.InventoryManagement.PurchasingManagement.FrmSelectManufacturer set = new PurchasingManagement.FrmSelectManufacturer();
                set.ShowDialog();
                if (!string.IsNullOrEmpty(set.NumberSjName))
                {
                    for (int i = 0; i < dgv1.SelectedRows.Count; i++)
                    {
                        dgv1.SelectedRows[i].Cells["Pis_PurchaseVendor"].Value = set.NumberSjName;
                    }
                }
            }
        }

    }
}