Esempio n. 1
0
        public JsonResult ExportExcel(ExcelModel eModel)
        {
            var curModel = new T_CGMX();

            if (eModel.SCQYID != null)
            {
                T_SupQY qycp = new T_SupQY();
                qycp.SupID        = (int)eModel.SCQYID;
                curModel.T_SupQY1 = qycp;
            }
            if (eModel.CPID != null)
            {
                curModel.CPID = (int)eModel.CPID;
            }

            int pagesize    = eModel.PageSize;
            int pagecount   = 0;
            int currentPage = eModel.PageNum;
            var DataList    = T_CGMXDomain.GetInstance().PageT_CGMX(curModel, eModel.StartDate, eModel.EndDate, currentPage, pagesize, out pagecount, out resultCount);
            var str         = ExportExcelPR(DataList);

            //调用输出Excel表的方法
            ExportToExcel("application/vnd.ms-excel", "采购汇总.xls", str);
            return(Json("true"));
        }
Esempio n. 2
0
        public JsonResult GetYLCPDetailsByMXID(int mxid)
        {
            var mxModel = T_CGMXDomain.GetInstance().GetModelById(mxid);

            if (mxModel != null)
            {
                T_YLCP cp = T_YLCPDomain.GetInstance().GetCpDetailsById(mxModel.CPID);
                if (cp != null)
                {
                    string resultStr = JsonConvert.SerializeObject(new
                    {
                        CPID    = cp.CPID,
                        CPBH    = cp.CPBH,
                        SCQYMC  = (cp.T_SupQY1 != null && !string.IsNullOrEmpty(cp.T_SupQY1.SupMC)) ? cp.T_SupQY1.SupMC : "",
                        CPGG    = cp.CPGG,
                        CPXH    = cp.CPXH,
                        CPDW    = cp.CPDW,
                        XKZH    = (cp.T_SupQY1 != null && !string.IsNullOrEmpty(cp.T_SupQY1.SupXKZBH)) ? cp.T_SupQY1.SupXKZBH : "",
                        ZCZH    = cp.CPZCZ,
                        SCQYID  = cp.CPSCQYID,
                        CPPrice = cp.CPPrice,
                        SUPQYID = cp.CPGYSID,
                        SUPQYMC = (cp.T_SupQY != null && !string.IsNullOrEmpty(cp.T_SupQY.SupMC)) ? cp.T_SupQY.SupMC : "",
                        XSJG    = cp.XSJG,
                        CPMC    = cp.CPMC,
                        CPNUM   = mxModel.CPNUM
                    });
                    return(Json(resultStr));
                }
            }
            return(Json(""));
        }
Esempio n. 3
0
        public ActionResult Index(T_CGMXModels evalModel, string id)
        {
            try
            {
                evalModel.currentPage = int.Parse(Request["pageNum"].ToString());
            }
            catch { }
            string order = "";

            try
            {
                order = Request["orderField"].ToString();
            }
            catch { }

            if (order.Trim() == "${param.orderField}")
            {
                order = "";
            }
            int pagesize    = Convert.ToInt32(evalModel.pageSize);
            int pagecount   = Convert.ToInt32(evalModel.pagecount);
            int currentPage = Convert.ToInt32(evalModel.currentPage);

            ViewBag.CGDID         = id;
            evalModel.DataModel   = evalModel.DataModel ?? new T_CGMX();
            evalModel.DataList    = T_CGMXDomain.GetInstance().PageT_CGMX(evalModel.DataModel, evalModel.StartTime, evalModel.EndTime, currentPage, pagesize, out pagecount, out resultCount).Where(p => p.CGID == int.Parse(id)).ToList();
            evalModel.resultCount = resultCount;
            return(View("~/Views/T_CGMX/Index.cshtml", evalModel));
        }
Esempio n. 4
0
        public void Save(T_CGMXModels model)
        {
            int    result = 0;
            string guid   = string.Empty;

            try
            {
                if (model.Tag == "Add")
                {
                    model.DataModel.GUID = Guid.NewGuid().ToString("N");
                    guid   = model.DataModel.GUID;
                    result = T_CGMXDomain.GetInstance().AddModelByCgdh(model.DataModel, model.CGDH);
                }
                else if (model.Tag == "Edit")
                {
                    result = T_CGMXDomain.GetInstance().UpdateModel(model.DataModel, model.DataModel.MXID);
                }
            }
            catch { }
            Response.ContentType = "text/json";
            if (result > 0)
            {
                string resultStr = JsonConvert.SerializeObject(new { statusCode = "200", message = "操作成功", guid = guid });
                Response.Write(resultStr);
            }
            else
            {
                Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}");
            }
        }
Esempio n. 5
0
        public void Delete(System.Int32 id)
        {
            //var rCode = GetRoleCode();
            //if (rCode != "1")
            //{
            var temp = T_YLCPDomain.GetInstance().GetModelById(id);

            if (temp != null && (temp.CPStatus == 1))
            {
                Response.Write("{\"statusCode\":\"300\", \"message\":\"已审批通过的数据不能删除!\"}");
                return;
            }
            //}
            Expression <Func <T_CGMX, bool> > whereCGD = p => (p.CPID == id);
            var lstCGMX = T_CGMXDomain.GetInstance().GetAllModels <int>(whereCGD);

            if (lstCGMX != null && lstCGMX.Count > 0)
            {
                Response.Write("{\"statusCode\":\"300\", \"message\":\"该产品已存在与采购单,不能删除!\"}");
                return;
            }
            T_YLCPModels model = new T_YLCPModels();

            model.DataModel = new T_YLCP();
            if (id != 0)
            {
                model.DataModel = T_YLCPDomain.GetInstance().GetModelById(id);
            }
            if (!string.IsNullOrEmpty(model.DataModel.CPTP))
            {
                string filePath = Path.Combine(Server.MapPath("~/UploadFiles/"), "供货商产品图片", model.DataModel.CPTP);
                if (System.IO.File.Exists(filePath))
                {
                    System.IO.File.Delete(filePath);
                }
            }
            if (!string.IsNullOrEmpty(model.DataModel.CPFJ))
            {
                string filePath1 = Path.Combine(Server.MapPath("~/UploadFiles/"), "供货商产品附件", model.DataModel.CPFJ);
                if (System.IO.File.Exists(filePath1))
                {
                    System.IO.File.Delete(filePath1);
                }
            }
            int result = T_YLCPDomain.GetInstance().DeleteModelById(id);

            Response.ContentType = "text/json";
            if (result > 0)
            {
                Response.Write("{\"statusCode\":\"200\", \"message\":\"操作成功\",\"callbackType\":\"forward\",\"forwardUrl\":\"/T_YLCP/Index\"}");
            }
            else
            {
                Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}");
            }
        }
Esempio n. 6
0
        public ActionResult Save(System.Int32 id, string tag)
        {
            T_CGDModels model = new T_CGDModels();

            model.DataModel = new T_CGD();
            CurUser         = Session["UserModel"] as SysUser;
            //id是否为0,区分增加和修改功能
            if (id != 0)
            {
                model.CGMXList  = T_CGMXDomain.GetInstance().GetT_CGMXByCgid(id);
                model.DataModel = T_CGDDomain.GetInstance().GetModelById(id);
            }
            else
            {
                model.DataModel.CGDH   = T_CGDDomain.GetInstance().GetCgOrderNum("CP", CurUser);
                model.DataModel.CGCJR  = CurUser.UserAccount;
                model.DataModel.CGCJRQ = DateTime.Now;
            }

            //加载产品列表
            //T_YLCPModels ylcpmode = new T_YLCPModels();

            //ylcpmode.DataModel = ylcpmode.DataModel ?? new T_YLCP();

            //ylcpmode.DataList = T_YLCPDomain.GetInstance().GetAllT_YLCP(ylcpmode.DataModel);

            //ViewData["YLCP"] = new SelectList(ylcpmode.DataList, "CPID", "CPMC");

            //加载企业列表
            T_SupQYModels supmode = new T_SupQYModels();

            supmode.DataModel = supmode.DataModel ?? new T_SupQY();

            supmode.DataList = T_SupQYDomain.GetInstance().GetAllT_SupQY(supmode.DataModel).Where(p => p.SupStatus == 1).ToList();

            ViewData["SupID"] = new SelectList(supmode.DataList, "SupID", "SupMC");

            //获取用户信息(包含单位ID)
            SysUser UserModel = Session["UserModel"] as SysUser;
            //获取本企业下的人员列表
            T_Person person = new T_Person();

            if (UserModel.UserCompanyID != null)
            {
                person.PsQYID = (int)UserModel.UserCompanyID;
            }
            ViewBag.Persons = new SelectList(T_PersonDomain.GetInstance().GetAllT_Person(person), "PsMZ", "PsMZ");
            //Expression<Func<T_PackingUnit, bool>> where = PredicateBuilder.True<T_PackingUnit>();
            //ViewBag.PackingUnit = new SelectList(T_PackingUnitDomain.GetInstance().GetAllModels<int>(where), "PUName", "PUName");
            model.Tag      = tag;
            model.RoleCode = GetRoleCode();
            return(View("~/Views/T_CGD/Save.cshtml", model));
        }
Esempio n. 7
0
        public ActionResult Save(System.Int32 id, string tag)
        {
            T_CGMXModels model = new T_CGMXModels();

            model.DataModel = new T_CGMX();
            Int32 did = id;

            if (tag != "Add")
            {
                model.DataModel = T_CGMXDomain.GetInstance().GetModelById(id);
                did             = model.DataModel.CGID;
            }

            //加载产品列表
            T_YLCPModels ylcpmode = new T_YLCPModels();

            ylcpmode.DataModel = ylcpmode.DataModel ?? new T_YLCP();

            ylcpmode.DataList = T_YLCPDomain.GetInstance().GetAllT_YLCP(ylcpmode.DataModel);

            ViewData["YLCP"] = new SelectList(ylcpmode.DataList, "CPID", "CPMC");

            //加载企业列表
            T_SupQYModels supmode = new T_SupQYModels();

            supmode.DataModel = supmode.DataModel ?? new T_SupQY();

            supmode.DataList = T_SupQYDomain.GetInstance().GetAllT_SupQY(supmode.DataModel).Where(p => p.SupStatus == 1).ToList();

            ViewData["SupID"] = new SelectList(supmode.DataList, "SupID", "SupMC");

            //加载采购单列表
            T_CGDModels cgdQymode = new T_CGDModels();

            cgdQymode.DataModel = cgdQymode.DataModel ?? new T_CGD();
            T_CGD cgd = T_CGDDomain.GetInstance().GetModelById(did);

            cgdQymode.DataList = new List <T_CGD>();
            cgdQymode.DataList.Add(cgd);
            ViewData["CGD"] = new SelectList(cgdQymode.DataList, "CGID", "CGDMC");



            //if (id != 0)
            //{
            //    model.DataModel = T_CGMXDomain.GetInstance().GetModelById(id);
            //}
            model.Tag = tag;
            return(View("~/Views/T_CGMX/Save.cshtml", model));
        }
Esempio n. 8
0
        public void Delete(string Guid)
        {
            int result = T_CGMXDomain.GetInstance().DeleteModelByGuid(Guid);

            Response.ContentType = "text/json";
            if (result > 0)
            {
                Response.Write("{\"statusCode\":\"200\", \"message\":\"操作成功\",\"callbackType\":\"forward\",\"forwardUrl\":\"/T_CGD/Index\"}");
            }
            else
            {
                Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}");
            }
        }
Esempio n. 9
0
        public ActionResult CGMXTable(System.Int32 id, string cgdh, int canEdit, int isSH)
        {
            T_CGDModels model = new T_CGDModels();

            model.DataModel      = new T_CGD();
            model.DataModel.ISSH = isSH;
            if (id != 0)
            {
                model.CGMXList = T_CGMXDomain.GetInstance().GetT_CGMXByCgid(id);
            }
            else
            {
                model.CGMXList = T_CGMXDomain.GetInstance().GetT_YSMXByCgdh(cgdh);
            }
            ViewBag.canEdit = canEdit;
            model.RoleCode  = GetRoleCode();
            return(View("~/Views/T_CGMX/CGMXTable.cshtml", model));
        }
Esempio n. 10
0
        public ActionResult CGDSPIndex(System.Int32 id, string tag)
        {
            T_CGDModels model = new T_CGDModels();

            model.DataModel = new T_CGD();
            T_CGMX cgmodel = new T_CGMX();

            if (id != 0)
            {
                model.DataModel = T_CGDDomain.GetInstance().GetModelById(id);
                model.CGMXList  = T_CGMXDomain.GetInstance().GetAllT_CGMX(cgmodel);
                if (model.CGMXList.Count > 0)
                {
                    model.CGMXList = model.CGMXList.Where(p => p.CGID == id).ToList();
                }
            }
            model.Tag = tag;
            return(View("~/Views/T_CGD/CGDSPIndex.cshtml", model));
        }
Esempio n. 11
0
        public void Delete(System.Int32 id)
        {
            //var rCode = GetRoleCode();
            //if (rCode != "1")
            //{
            var temp = T_SupQYDomain.GetInstance().GetModelById(id);

            if (temp != null && (temp.SupStatus == 1))
            {
                Response.Write("{\"statusCode\":\"300\", \"message\":\"已审批通过的数据不能删除!\"}");
                return;
            }
            //}
            Expression <Func <T_YLCP, bool> > where = p => (p.CPGYSID == id || p.CPSCQYID == id);
            var list = T_YLCPDomain.GetInstance().GetAllModels <int>(where);

            if (list != null && list.Count > 0)
            {
                Response.Write("{\"statusCode\":\"300\", \"message\":\"该企业下已有产品,不能删除!\"}");
                return;
            }
            Expression <Func <T_CGMX, bool> > whereCGD = p => (p.SupID == id || p.CPSCQYID == id);
            var lstCGMX = T_CGMXDomain.GetInstance().GetAllModels <int>(whereCGD);

            if (lstCGMX != null && lstCGMX.Count > 0)
            {
                Response.Write("{\"statusCode\":\"300\", \"message\":\"该企业下已有采购单,不能删除!\"}");
                return;
            }
            int result = T_SupQYDomain.GetInstance().Delete(id);

            Response.ContentType = "text/json";
            if (result > 0)
            {
                Response.Write("{\"statusCode\":\"200\", \"message\":\"操作成功\",\"callbackType\":\"forward\",\"forwardUrl\":\"/T_SupQY/Index\"}");
            }
            else
            {
                Response.Write("{\"statusCode\":\"300\", \"message\":\"操作失败\"}");
            }
        }
Esempio n. 12
0
        public ActionResult Details(ExcelModel eModel)
        {
            var curModel = new T_CGMX();

            if (eModel.SCQYID != null)
            {
                T_SupQY qycp = new T_SupQY();
                qycp.SupID        = (int)eModel.SCQYID;
                curModel.T_SupQY1 = qycp;
            }
            if (eModel.CPID != null)
            {
                curModel.CPID = (int)eModel.CPID;
            }

            int pagesize    = eModel.PageSize;
            int pagecount   = 0;
            int currentPage = eModel.PageNum;
            var DataList    = T_CGMXDomain.GetInstance().PageT_CGMX(curModel, eModel.StartDate, eModel.EndDate, currentPage, pagesize, out pagecount, out resultCount);


            ViewData["ParaStr"] = ExportExcelPR(DataList);
            return(View("~/Views/T_CGHZ/Details.cshtml", eModel));
        }
Esempio n. 13
0
        public int resultCount = 0; // 总条数
        // GET: T_CGHZ
        public ActionResult Index(T_CGMXModels evalModel)
        {
            try
            {
                evalModel.currentPage = int.Parse(Request["pageNum"].ToString());
            }
            catch { }
            string order = "";
            string qyid  = "";

            try
            {
                order = Request["orderField"].ToString();
            }
            catch { }
            if (order.Trim() == "${param.orderField}")
            {
                order = "";
            }
            evalModel.DataModel = evalModel.DataModel ?? new T_CGMX();

            //加载产品生产企业
            T_SupQYModels qymode = new T_SupQYModels();

            qymode.DataModel = qymode.DataModel ?? new T_SupQY();
            qymode.DataList  = T_SupQYDomain.GetInstance().GetAllT_SupQY(qymode.DataModel);
            ViewData["QY"]   = new SelectList(qymode.DataList, "SupID", "SupMC");
            if (Request["QYList"] != null)
            {
                qyid = Request["QYList"].ToString();
                if (!String.IsNullOrEmpty(qyid))
                {
                    T_SupQY qycp = new T_SupQY();
                    qycp.SupID = int.Parse(qyid);
                    evalModel.DataModel.T_SupQY1 = qycp;
                }
            }
            ViewData["QYList"] = qyid;

            Expression <Func <T_YLCP, bool> > where = PredicateBuilder.True <T_YLCP>();
            var lst = T_YLCPDomain.GetInstance().GetAllModels <int>(where);

            ViewData["CGHZ_YLCP"] = new SelectList(lst, "CPID", "CPMC");

            var cpid = "";

            if (Request["CGHZ_CPID"] != null)
            {
                cpid = Request["CGHZ_CPID"].ToString();
                if (!String.IsNullOrEmpty(cpid))
                {
                    evalModel.DataModel.CPID = int.Parse(cpid);
                }
            }
            ViewData["CGHZ_CPID"] = cpid;

            int pagesize    = Convert.ToInt32(evalModel.pageSize);
            int pagecount   = Convert.ToInt32(evalModel.pagecount);
            int currentPage = Convert.ToInt32(evalModel.currentPage);

            evalModel.DataModel   = evalModel.DataModel ?? new T_CGMX();
            evalModel.DataList    = T_CGMXDomain.GetInstance().PageT_CGMX(evalModel.DataModel, evalModel.StartTime, evalModel.EndTime, currentPage, pagesize, out pagecount, out resultCount);
            evalModel.resultCount = resultCount;

            var totalNum = 0;

            if (evalModel.DataList != null && evalModel.DataList.Count > 0)
            {
                evalModel.DataList.ForEach(p =>
                {
                    totalNum += p.CPNUM == null ? 0 : (int)p.CPNUM;
                });
            }
            ViewBag.TotalNum = totalNum;
            return(View("~/Views/T_CGHZ/Index.cshtml", evalModel));
        }