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));
}
}
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));
}
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));
}
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));
}
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));
}
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);
}
}
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"));
}