Ejemplo n.º 1
0
        public JsonResult ChangeSignChangeSignadmin(string IDSet)
        {
            //int f
            //=0;

            var catmodle = OPBiz.GetEntity(TF_PersonnelFile_Transmitting_OutSet.SelectAll().Where(TF_PersonnelFile_Transmitting_OutSet.Id.Equal(IDSet)));

            catmodle.States          = 1;
            catmodle.WhereExpression = TF_PersonnelFile_Transmitting_OutSet.Id.Equal(IDSet);

            var            f          = OPBiz.Update(catmodle);
            HttpReSultMode ReSultMode = new HttpReSultMode();

            if (f > 0)
            {
                ReSultMode.Code = 11;
                ReSultMode.Data = f.ToString();
                ReSultMode.Msg  = "提交成功!";
                SysOperateLogBiz.AddSysOperateLog(UserData.Id.ToString(), UserData.UserName, e3net.Mode.OperatEnumName.提交, "档案转出--提交", true, WebClientIP, "档案转出");
                return(Json(ReSultMode, JsonRequestBehavior.AllowGet));
            }
            else
            {
                ReSultMode.Code = -13;
                ReSultMode.Data = "0";
                ReSultMode.Msg  = "提交失败!";
                SysOperateLogBiz.AddSysOperateLog(UserData.Id.ToString(), UserData.UserName, e3net.Mode.OperatEnumName.提交, "档案转出--提交", false, WebClientIP, "档案转出");
                return(Json(ReSultMode, JsonRequestBehavior.AllowGet));
            }
        }
Ejemplo n.º 2
0
        string userId = "a3e8f66f-3552-4626-9ee2-f7ddd8b106d8";  //GetUData.User_Id;
        public ActionResult Index()
        {
            ViewBag.RuteUrl = RuteUrl();
            VipShopModel vshopMode = new VipShopModel();
            var          mql       = TT_ShopSet.SelectAll().Where(TT_ShopSet.UserId.Equal(userId));
            TT_Shop      item      = OPBiz.GetEntity(mql);

            if (item != null)
            {
                item.UserId = new Guid();//不显示给前端 安全考虑
                var mqlimg = TT_FilesTransactSet.SelectAll().Where(TT_FilesTransactSet.SourceTable.Equal("TT_Shop").And(TT_FilesTransactSet.ToId.Equal(item.ShopId.ToString())));
                List <TT_FilesTransact> listImg = OPFileBiz.GetOwnList(mqlimg);
                //List<FileJson> img = OPFileBiz.GetFList(listImg);
                //vshopMode.ImgList = img;

                vshopMode.ShopItem        = item;
                ViewBag.listImgJson       = OPFileBiz.GetJson(listImg);
                vshopMode.TransactionList = Transaction();

                //ViewData.Model = item;
                return(View(vshopMode));
            }
            else
            {
                return(RedirectToAction("Index", "User"));
            }
        }
        public JsonResult GetInfo(string ID)
        {
            var             mql2   = TF_LifeCommentsSet.SelectAll().Where(TF_LifeCommentsSet.Id.Equal(ID));
            TF_LifeComments Rmodel = OPBiz.GetEntity(mql2);

            return(Json(Rmodel, JsonRequestBehavior.AllowGet));
        }
        public JsonResult GetInfo(string ID)
        {
            var mql2 = TF_EntryAndExitRegistrationSet.SelectAll().Where(TF_EntryAndExitRegistrationSet.Id.Equal(ID));
            TF_EntryAndExitRegistration Rmodel = OPBiz.GetEntity(mql2);

            return(Json(Rmodel, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 5
0
        public JsonResult GetInfo(string ID)
        {
            var mql2 = TF_PersonnelFileSet.SelectAll().Where(TF_PersonnelFileSet.Id.Equal(ID));
            TF_PersonnelFile Rmodel = OPBiz.GetEntity(mql2);

            //  groupsBiz.Add(rol);
            return(Json(Rmodel, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 6
0
        public JsonResult GetInfo(string ID)
        {
            var      mql2   = RMS_UserSet.SelectAll().Where(RMS_UserSet.Id.Equal(ID));
            RMS_User Rmodel = OPBiz.GetEntity(mql2);

            //  groupsBiz.Add(rol);
            return(Json(Rmodel, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 7
0
        public JsonResult GetInfo(string ID)
        {
            var mql2 = TF_PersonnelFile_Transmitting_OutSet.SelectAll().Where(TF_PersonnelFile_Transmitting_OutSet.Id.Equal(ID));
            TF_PersonnelFile_Transmitting_Out Rmodel = OPBiz.GetEntity(mql2);
            var mql3      = TF_PersonnelFile_Transmitting_Out_ItemSet.SelectAll().Where(TF_PersonnelFile_Transmitting_Out_ItemSet.OwnerId.Equal(ID));
            var ItemBlist = OPItemBiz.GetEntities(mql3);
            var df        = new { inmode = Rmodel, InItem = ItemBlist };

            //  groupsBiz.Add(rol);
            return(Json(df, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 8
0
        public FileContentResult GetImage(string id)
        {
            var df  = TF_PersonnelFile_Transmitting_OutSet.SelectAll().Where(TF_PersonnelFile_Transmitting_OutSet.Id.Equal(id));
            var dfw = OPBiz.GetEntity(df);


            if (dfw != null)
            {
                return(File(dfw.signatureimage, "jpg"));
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 9
0
        public FileResult CommonExportNewport(string Title, string Columns, string Data)
        {
            string ChildCategoryTableID = "";

            if (Request.Form["ChildCategoryTableID"] != null)
            {
                ChildCategoryTableID = Request.Form["ChildCategoryTableID"];
            }
            string CategoryTableID = "";

            if (Request.Form["CategoryTableID"] != null)
            {
                CategoryTableID = Request.Form["CategoryTableID"];
            }
            DataTable _datatable = new DataTable();

            if (Request.Form["dataGetter"] != null)
            {
                _datatable = JsonConvert.DeserializeObject <DataTable>(Request.Form["dataGetter"]);
            }

            var sqlc2 = MainAssociationSet.SelectAll().Where(MainAssociationSet.CategoryTableID.Equal(CategoryTableID).And(MainAssociationSet.ChildCategoryTableID.Equal(ChildCategoryTableID)));

            var newmodle = Mabiz.GetEntity(sqlc2);

            var sqlc = VcorrelateColumnsSet.SelectAll().Where(VcorrelateColumnsSet.MainAssociationID.Equal(newmodle.ID));
            var dic  = Vcbiz.GetEntities(sqlc);

            var ddsql = CategoryTableSet.SelectAll().Where(CategoryTableSet.ID.Equal(ChildCategoryTableID));
            var CategoryTablemodle = OPBiz.GetEntity(ddsql);

            var       list = CCBiz.ExecuteSqlToOwnList("select * from ColumnCharts where CategoryTableID='" + ChildCategoryTableID + "'  and IsEnable=1 and MergeHeader<>1 and (title<>'ck')  ORDER BY  SortNo");
            DataTable dt2  = new DataTable();

            dt2.Columns.Add("ID");
            for (int i = 0; i < list.Count; i++)
            {
                dt2.Columns.Add(list[i].field);
            }
            UniteDataTable(_datatable, dt2, dic);
            string filename = Guid.NewGuid().ToString() + ".xlsx";
            var    ff       = Exporter.NewInstance(Server.MapPath("~/temp/" + filename), dt2, CategoryTablemodle.ChineseName).Download();

            return(File(Server.MapPath("~/temp/" + filename), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", string.Format("{0}.xlsx", Title)));
            // return File(ff, "application/ms-excel", string.Format("{0}.xls", "czc"));
        }