コード例 #1
0
        protected void btSave_Click(object sender, EventArgs e)
        {
            MoveStockBill info = new MoveStockBill();
            MoveStockBLL  bll  = null;

            try
            {
                UIBindHelper.BindModelByControls(this.Page, info);
                info.FromWarehouse = this.ToWarehouse.SelectedValue;
                info.ToWarehouse   = this.ToWarehouse.SelectedValue;
                info.Details       = LAF.Common.Serialization.JsonConvertHelper.DeserializeObject <List <MoveStockDetail> >(this.hiMatList.Value);

                foreach (MoveStockDetail detail in info.Details)
                {
                    if (detail.IDCode == null)
                    {
                        detail.IDCode = "";
                    }
                }

                bll = BLLFactory.CreateBLL <MoveStockBLL>();

                if (this.hiID.Value == "")
                {
                    bll.InsideMoveStock(info);
                }

                ClientScript.RegisterStartupScript(this.GetType(), "myjs", "MSA('提示', '移库完成', function () { window.location.href='InsideMoveByMobile.aspx'; });", true);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #2
0
ファイル: MoveStockDAL.cs プロジェクト: 48401298/efp
        /// <summary>
        /// 插入信息(单表)
        /// </summary>
        /// <param name="">信息</param>
        /// <returns>插入行数</returns>
        public int Insert(MoveStockBill model)
        {
            int count = 0;

            try
            {
                //插入基本信息
                count = Session.Insert <MoveStockBill>(model);
                Session.Insert <MoveStockDetail>(model.Details);
                return(count);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #3
0
        /// <summary>
        /// 库内移动
        /// </summary>
        /// <param name="bill">移动信息</param>
        public void InsideMoveStock(MoveStockBill bill)
        {
            MoveStockDAL msDal = new MoveStockDAL();
            StockDAL     sDal  = new StockDAL();

            bill.ID            = Guid.NewGuid().ToString();
            bill.BillNO        = this.GetNewBillNO();
            bill.FromWarehouse = bill.ToWarehouse;
            bill.FromWHHeader  = this.LoginUser.UserID;
            bill.ToWHHeader    = this.LoginUser.UserID;
            bill.MoveMode      = "1";
            bill.CREATEUSER    = this.LoginUser.UserID;
            bill.CREATETIME    = DateTime.Now;
            bill.UPDATEUSER    = bill.CREATEUSER;
            bill.UPDATETIME    = bill.CREATETIME;

            foreach (MoveStockDetail detail in bill.Details)
            {
                detail.ID           = Guid.NewGuid().ToString();
                detail.FromSaveSite = detail.ToSaveSite;
                detail.BillID       = bill.ID;
            }

            List <MoveStockRecord> records = bill.Details.Select(p => new MoveStockRecord()
            {
                IDCode = p.IDCode, MatID = p.MatID, ToSaveSite = p.ToSaveSite, ToWarehouse = bill.ToWarehouse
            }).ToList();

            using (IDataSession session = AppDataFactory.CreateMainSession())
            {
                session.OpenTs();
                msDal.Session = session;
                sDal.Session  = session;

                msDal.Insert(bill);
                sDal.MoveStock(records);

                session.CommitTs();
            }
        }
コード例 #4
0
ファイル: MoveStockDAL.cs プロジェクト: 48401298/efp
        /// <summary>
        /// 获取库存移动单列表
        /// </summary>
        /// <param name="condition"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public DataPage GetList(MoveStockBill condition, DataPage page)
        {
            DataTable            dt         = new DataTable();
            List <DataParameter> parameters = new List <DataParameter>();
            StringBuilder        sqlBuiler  = new StringBuilder();

            try
            {
                page.KeyName = "ID";

                sqlBuiler.Append(@"select t1.ID,t1.BillNO,t1.BillDate,t1.ToWHHeader,u3.USERNAME as ToWHHeaderName,
                                    t1.Remark,t2.Description as ToWarehouseName
                                   from T_WH_MoveStockBill t1
                                    inner join T_WH_Warehouse t2 on t1.Warehouse=t2.ID
                                    left outer join T_USER u3 on t1.ToWHHeader=u3.USERID
                                    left outer join T_WH_InMode t4 on t1.InStockMode=t4.ID
                                    where t1.MoveMode = @MoveMode");

                parameters.Add(new DataParameter("MoveMode", condition.MoveMode));

                if (!string.IsNullOrEmpty(condition.BillNO))
                {
                    sqlBuiler.Append(" and t1.BillNO like @BillNO");
                    parameters.Add(new DataParameter("BillNO", "%" + condition.BillNO + "%"));
                }

                if (!string.IsNullOrEmpty(condition.ToWarehouse))
                {
                    sqlBuiler.Append(" and t1.ToWarehouse = @ToWarehouse");
                    parameters.Add(new DataParameter("ToWarehouse", condition.ToWarehouse));
                }

                if (!string.IsNullOrEmpty(condition.StartDate))
                {
                    sqlBuiler.Append(" and t1.BillDate >= @StartDate");
                    parameters.Add(new DataParameter("StartDate", DateTime.Parse(condition.StartDate)));
                }

                if (!string.IsNullOrEmpty(condition.EndDate))
                {
                    sqlBuiler.Append(" and t1.BillDate < @EndDate");
                    parameters.Add(new DataParameter("EndDate", DateTime.Parse(condition.EndDate + " 23:59:59")));
                }
                if (!string.IsNullOrEmpty(condition.CREATEUSER))
                {
                    sqlBuiler.Append(" and t1.CREATEUSER = @CREATEUSER");
                    parameters.Add(new DataParameter("CREATEUSER", condition.CREATEUSER));
                }
                //分页关键字段及排序
                page.KeyName = "ID";
                if (string.IsNullOrEmpty(page.SortExpression))
                {
                    page.SortExpression = "t1.BillDate DESC";
                }

                using (IDataSession session = AppDataFactory.CreateMainSession())
                {
                    page = session.GetDataPage <MoveStockBill>(sqlBuiler.ToString(), parameters.ToArray(), page);
                }

                return(page);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
コード例 #5
0
        /// <summary>
        /// 获取库内移动单列表
        /// </summary>
        /// <param name="condition"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public DataPage GetInsideList(MoveStockBill condition, DataPage page)
        {
            condition.MoveMode = "1";

            return(new MoveStockDAL().GetList(condition, page));
        }