public MaterialEditList EditMaterial(string ProductID)
        {
            MaterialEditList product = new MaterialEditList();

            try
            {
                var reader    = _db.QueryMultiple("USP_EDIT_MATERIAL_V2", new { P_PRODUCTID = ProductID }, commandType: CommandType.StoredProcedure);
                var vheader   = reader.Read <HeaderEditList>().ToList();
                var vfactory  = reader.Read <FactoryEditList>().ToList();
                var vvendor   = reader.Read <VendorEditList>().ToList();
                var vcustomer = reader.Read <CustomerEditList>().ToList();
                var vpacksize = reader.Read <PacksizeEditList>().ToList();


                product.HeaderEditList   = vheader;
                product.FactoryEditList  = vfactory;
                product.VendorEditList   = vvendor;
                product.CustomerEditList = vcustomer;
                product.PacksizeEditList = vpacksize;
                reader.Dispose();
            }
            catch (Exception ex)
            {
            }
            return(product);
        }
示例#2
0
        public ActionResult EditMaterial(string ProductID)
        {
            MaterialEditList     material      = new MaterialEditList();
            FactoryMastercontext masterContext = new FactoryMastercontext();

            material = masterContext.EditMaterial(ProductID.Trim());
            var allDataset = new
            {
                varHeader   = material.HeaderEditList,
                varFactory  = material.FactoryEditList,
                varVendor   = material.VendorEditList,
                varCustomer = material.CustomerEditList,
                varPacksize = material.PacksizeEditList,
            };

            return(Json(new
            {
                allDataset,
                JsonRequestBehavior.AllowGet
            }));
        }