Exemple #1
0
        /// <summary>
        /// 进货单审批
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public ActionResult InStockMgt_Audit(Mes_Stock_InStockApproval obj)
        {
            if (obj.InStockID <= 0)
            {
                return(Json(new { IsSuccess = false, Message = "请先选择一个进货单!" }));
            }
            Mes_Stock_InStock dataObj = MesStockInStockDao.Instance.Find <Mes_Stock_InStock, int>(obj.InStockID);

            if (dataObj == null)
            {
                return(Json(new { IsSuccess = false, Message = "选择的进货单不存在,请刷新后重试!" }));
            }
            if (dataObj.AuditStatus == AuditEnum.Yes)
            {
                return(Json(new { IsSuccess = false, Message = "选择的进货单已审批,不允许重复审批!" }));
            }

            obj.ApproverID   = base.CurUser.ID;
            obj.ApproverName = base.CurUser.UserName;
            obj.BillNo       = dataObj.BillNo;
            obj.BillType     = dataObj.BillType;
            obj.Creater      = base.CurUser.UserId;
            obj.CreatedTime  = DateTime.Now;

            string message = MesStockInStockDao.Instance.DoAudit(obj);

            if (!string.IsNullOrEmpty(message))
            {
                return(Json(new { IsSuccess = false, Message = message }));
            }

            return(Json(new { IsSuccess = true, Message = "" }));
        }
Exemple #2
0
        public ActionResult InStockItemMgt_Save(Mes_Stock_InStockItem obj)
        {
            if (obj.InStockID <= 0)
            {
                return(Json(new { IsSuccess = false, Message = "请先选择一个进货单进行操作!" }));
            }
            if (string.IsNullOrEmpty(obj.MaterialProNo))
            {
                return(Json(new { IsSuccess = false, Message = "【物料编码】不能为空!" }));
            }
            Mes_Stock_InStock main = MesStockInStockDao.Instance.Find <Mes_Stock_InStock, int>(obj.InStockID.Value);

            if (main == null)
            {
                return(Json(new { IsSuccess = false, Message = "选择的进货单信息有误!" }));
            }

            Mes_Stock_InStockItem itemObj = null;

            if (obj.ID > 0)
            {
                itemObj = MesStockInStockDao.Instance.Find <Mes_Stock_InStockItem, int>(obj.ID);
                itemObj.CheckItemStatus = obj.CheckItemStatus;
            }
            else
            {
                itemObj                 = new Mes_Stock_InStockItem();
                itemObj.AcceptNum       = 0;
                itemObj.BackNum         = 0;
                itemObj.AcceptStatus    = YesNoType.No;
                itemObj.CheckItemStatus = CheckStatus.No;
                //生成订单行号
                itemObj.ResNum = MesStockInStockDao.Instance.GenResNum(main);
            }
            if (itemObj == null)
            {
                return(Json(new { IsSuccess = false, Message = "进货单明细信息有误,请刷新后重试!" }));
            }

            itemObj.InStockID     = obj.InStockID;
            itemObj.BillType      = main.BillType;
            itemObj.BillNo        = main.BillNo;
            itemObj.MaterialProNo = obj.MaterialProNo;
            itemObj.MaterialCode  = obj.MaterialCode;
            itemObj.Version       = obj.Version;
            itemObj.MaterialSize  = obj.MaterialSize;
            itemObj.Unit          = obj.Unit;
            itemObj.BatchNo       = obj.BatchNo;
            itemObj.AcceptNum     = obj.AcceptNum;
            itemObj.InStockNum    = obj.InStockNum;
            itemObj.AcceptDate    = obj.AcceptDate;
            itemObj.BackNum       = obj.BackNum;
            itemObj.StockID       = obj.StockID;
            int id = MesStockInStockDao.Instance.Save <Mes_Stock_InStockItem>(itemObj);

            return(Json(new { IsSuccess = true, Message = id.ToString() }));
        }
Exemple #3
0
        /// <summary>
        /// 生成行号
        /// </summary>
        /// <returns></returns>
        public int GenResNum(Mes_Stock_InStock obj)
        {
            string sql = "SELECT ISNULL(MAX(ResNum),0) FROM Mes_Stock_InStockItem T1 WITH(NOLOCK) WHERE InStockID = {0}";

            sql = string.Format(sql, obj.ID);
            int resNo = this.CurDbSession.FromSql(sql).ToScalar <int>();

            return(resNo + 1);
        }
Exemple #4
0
        public ActionResult InStockMgt_FindByPage(Mes_Stock_InStock obj, int page, int rows)
        {
            var pager = new PagerBase()
            {
                CurrentPageIndex = page, PageSize = rows
            };
            var list = MesStockInStockDao.Instance.FindByPage(obj, ref pager);

            return(Json(new { total = pager.TotalItemCount, rows = list }, JsonRequestBehavior.AllowGet));
        }
Exemple #5
0
        public List <Mes_Stock_InStock> FindByPage(Mes_Stock_InStock obj, ref PagerBase pager)
        {
            string sql = @"SELECT T1.* FROM Mes_Stock_InStock T1 WHERE 1=1 ";

            if (TConvertHelper.FormatDBInt(obj.BillType) > 0)
            {
                sql += string.Format(" AND T1.BillType = '{0}'", obj.BillType);
            }
            if (!string.IsNullOrEmpty(obj.BillNo))
            {
                sql += string.Format(" AND T1.BillNo Like '%{0}%'", obj.BillNo);
            }
            if (!string.IsNullOrEmpty(obj.InStockDateStart))
            {
                sql += string.Format(" AND T1.InStockDate >='{0}'", obj.InStockDateStart);
            }
            if (!string.IsNullOrEmpty(obj.InStockDateEnd))
            {
                sql += string.Format(" AND T1.InStockDate <'{0}'", TConvertHelper.FormatDBDate(obj.InStockDateEnd).AddDays(1));
            }
            if (obj.AuditStatus > 0)
            {
                sql += string.Format(" AND T1.AuditStatus = {0}", obj.AuditStatus);
            }
            if (obj.CheckStatus > 0)
            {
                sql += string.Format(" AND T1.CheckStatus = {0}", obj.CheckStatus);
            }
            if (!string.IsNullOrEmpty(obj.SupplierName))
            {
                sql += string.Format(" AND T1.SupplierName Like '%{0}%'", obj.SupplierName);
            }
            if (!string.IsNullOrEmpty(obj.CreatedTimeStart))
            {
                sql += string.Format(" AND T1.CreatedTime >='{0}'", obj.CreatedTimeStart);
            }
            if (!string.IsNullOrEmpty(obj.CreatedTimeEnd))
            {
                sql += string.Format(" AND T1.CreatedTime <'{0}'", TConvertHelper.FormatDBDate(obj.CreatedTimeEnd).AddDays(1));
            }

            string orderBy = pager.OrderBy;

            if (string.IsNullOrEmpty(orderBy))
            {
                orderBy = "CreatedTime DESC";
            }
            string cmdPageSql  = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
            string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));

            //查询总记录数
            pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
            //返回当前页的记录数
            return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Stock_InStock>());
        }
Exemple #6
0
        public ActionResult InStockMgt_Find(int ID)
        {
            if (ID <= 0)
            {
                return(Json(new { IsSuccess = false, Message = "选择的记录有误,请刷新后重试!" }));
            }
            Mes_Stock_InStock obj = MesStockInStockDao.Instance.Find <Mes_Stock_InStock, int>(ID);

            if (obj == null)
            {
                return(Json(new { IsSuccess = false, Message = "信息不存在,请刷新后重试!" }));
            }

            return(Json(new { IsSuccess = true, Message = JsonHelper.SerializeObject(obj) }, JsonRequestBehavior.AllowGet));
        }
Exemple #7
0
        public List <Mes_Stock_InStock> FindByCond(Mes_Stock_InStock obj)
        {
            string sql = @"SELECT T1.* FROM Mes_Stock_InStock T1 WHERE 1=1 ";

            if (TConvertHelper.FormatDBInt(obj.BillType) > 0)
            {
                sql += string.Format(" AND T1.BillType = '{0}'", obj.BillType);
            }
            if (!string.IsNullOrEmpty(obj.BillNo))
            {
                sql += string.Format(" AND T1.BillNo Like '%{0}%'", obj.BillNo);
            }
            if (!string.IsNullOrEmpty(obj.InStockDateStart))
            {
                sql += string.Format(" AND T1.InStockDate >='{0}'", obj.InStockDateStart);
            }
            if (!string.IsNullOrEmpty(obj.InStockDateEnd))
            {
                sql += string.Format(" AND T1.InStockDate <'{0}'", TConvertHelper.FormatDBDate(obj.InStockDateEnd).AddDays(1));
            }
            if (obj.AuditStatus > 0)
            {
                sql += string.Format(" AND T1.AuditStatus = {0}", obj.AuditStatus);
            }
            if (obj.CheckStatus > 0)
            {
                sql += string.Format(" AND T1.CheckStatus = {0}", obj.CheckStatus);
            }
            if (!string.IsNullOrEmpty(obj.SupplierName))
            {
                sql += string.Format(" AND T1.SupplierName Like '%{0}%'", obj.SupplierName);
            }
            if (!string.IsNullOrEmpty(obj.CreatedTimeStart))
            {
                sql += string.Format(" AND T1.CreatedTime >='{0}'", obj.CreatedTimeStart);
            }
            if (!string.IsNullOrEmpty(obj.CreatedTimeEnd))
            {
                sql += string.Format(" AND T1.CreatedTime <'{0}'", TConvertHelper.FormatDBDate(obj.CreatedTimeEnd).AddDays(1));
            }

            sql += " ORDER BY CreatedTime DESC";

            //返回当前页的记录数
            return(this.CurDbSession.FromSql(sql).ToList <Mes_Stock_InStock>());
        }
Exemple #8
0
        public ActionResult InStockMgt_Save(Mes_Stock_InStock obj)
        {
            if (string.IsNullOrEmpty(obj.BillType))
            {
                return(Json(new { IsSuccess = false, Message = "请选择进货单单别!" }));
            }
            if (obj.SupplierID <= 0)
            {
                return(Json(new { IsSuccess = false, Message = "请选择供应商!" }));
            }
            Mes_Stock_InStock dataObj = null;

            if (obj.ID > 0)
            {
                dataObj = MesStockInStockDao.Instance.Find <Mes_Stock_InStock, int>(obj.ID);
            }
            else
            {
                dataObj             = new Mes_Stock_InStock();
                dataObj.AuditStatus = AuditEnum.No;
                dataObj.Creater     = base.CurUser.UserId;
                dataObj.CreatedTime = DateTime.Now;
                //生成单号
                dataObj.BillNo = MesStockInStockDao.Instance.GenBillNo();
            }
            if (dataObj == null)
            {
                return(Json(new { IsSuccess = false, Message = "进货单信息有误,请刷新后重试!" }));
            }
            dataObj.BillType        = obj.BillType;
            dataObj.InStockDate     = obj.InStockDate;
            dataObj.SupplierName    = obj.SupplierName;
            dataObj.SupplierID      = obj.SupplierID;
            dataObj.SupBillNo       = obj.SupBillNo;
            dataObj.BillDate        = obj.BillDate;
            dataObj.TotalInStockNum = obj.TotalInStockNum;
            dataObj.TotalAcceptNum  = obj.TotalAcceptNum;
            dataObj.SourceBillType  = obj.SourceBillType;
            dataObj.SourceBillNo    = obj.SourceBillNo;
            dataObj.CheckStatus     = obj.CheckStatus;
            dataObj.Factory         = obj.Factory;
            int id = MesStockInStockDao.Instance.Save(dataObj);

            return(Json(new { IsSuccess = true, Message = id.ToString() }));
        }
Exemple #9
0
        /// <summary>
        /// 导出
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public ActionResult ProductInStockMgt_Export(Mes_Stock_InStock obj)
        {
            var            list         = MesStockInStockDao.Instance.FindByCond(obj);
            BussinessModel bussinessObj = new BussinessModel();

            bussinessObj.BusinessType = "InStockMgt";
            KeyModel        keyObj  = null;
            List <KeyModel> colList = new List <KeyModel>();

            keyObj = new KeyModel("单据状态", "Show_AuditStatus");
            colList.Add(keyObj);
            keyObj = new KeyModel("检验状态", "Show_CheckStatus");
            colList.Add(keyObj);
            keyObj = new KeyModel("进货单别", "Show_BillType");
            colList.Add(keyObj);
            keyObj = new KeyModel("进货单号", "BillNo");
            colList.Add(keyObj);
            keyObj = new KeyModel("进货日期", "Show_InStockDate");
            colList.Add(keyObj);
            keyObj = new KeyModel("总进货数量", "TotalInStockNum");
            colList.Add(keyObj);
            keyObj = new KeyModel("总验收数量", "TotalAcceptNum");
            colList.Add(keyObj);
            keyObj = new KeyModel("供应商", "SupplierName");
            colList.Add(keyObj);
            keyObj = new KeyModel("供应商单号", "SupBillNo");
            colList.Add(keyObj);
            keyObj = new KeyModel("销售单别", "Show_SourceBillType");
            colList.Add(keyObj);
            keyObj = new KeyModel("销售单号", "SourceBillNo");
            colList.Add(keyObj);
            keyObj = new KeyModel("创建人", "Creater");
            colList.Add(keyObj);
            keyObj = new KeyModel("创建时间", "Show_CreatedTime");
            colList.Add(keyObj);
            bussinessObj.ColList = colList;
            string message = SysExportHelper.Export <Mes_Stock_InStock>(ref bussinessObj, list);

            if (!string.IsNullOrEmpty(message))
            {
                return(Json(new { IsSuccess = false, Message = message }));
            }
            return(Json(new { IsSuccess = true, Message = bussinessObj.FileName }));
        }
Exemple #10
0
        public ActionResult InStockMgt_Delete(int ID)
        {
            if (ID <= 0)
            {
                return(Json(new { IsSuccess = false, Message = "选择的记录有误,请刷新后重试!" }));
            }
            Mes_Stock_InStock obj = MesStockInStockDao.Instance.Find <Mes_Stock_InStock, int>(ID);

            if (obj == null)
            {
                return(Json(new { IsSuccess = false, Message = "进货单不存在,请刷新后重试!" }));
            }
            if (obj.AuditStatus != AuditEnum.No)
            {
                return(Json(new { IsSuccess = false, Message = "只能删除未审核的进货单!" }));
            }

            MesStockInStockDao.Instance.DeleteExt(ID);
            return(Json(new { IsSuccess = true, Message = "" }));
        }