public JsonResult GetAllParentMenus()
{
var result = new ResultJsonInfo <List <SystemMenuSM> >();
var allParentMenuList = MenuRespository.GetAllParentMenus();
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = allParentMenuList;
return(Json(result));
}
public JsonResult GetMenuTree([FromForm] string roleId = null)
{
var result = new ResultJsonInfo <List <SystemMenuSM> >();
var respositoryResult = MenuRespository.GetMenuTree(string.IsNullOrEmpty(roleId) ? 0 : long.Parse(roleId), UserToken);
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = respositoryResult;
return(Json(result));
}
public JsonResult GetEditMenu([FromForm] AddMenuVm model)
{
var result = new ResultJsonInfo <SystemMenuSM>();
var CurrentMenu = MenuRespository.GetCurrentMenu(model.Tid);
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = CurrentMenu;
return(Json(result));
}
public JsonResult GetControllerActions([FromForm] string roleId = null)
{
var result = new ResultJsonInfo <List <APIDescription> >();
var respositoryResult = APIAttibuteHelper.GetAllDescriptions();
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = respositoryResult;
return(Json(result));
}
public JsonResult GetDbTableColumns(string tableName)
{
var result = new ResultJsonInfo <List <CodeGenField> >();
var respositoryResult = CommonRespository.GetDbTablesColumns(tableName);
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = respositoryResult;
return(Json(result));
}
public JsonResult GetDbTables()
{
var result = new ResultJsonInfo <List <CodeGenTable> >();
var respositoryResult = CommonRespository.GetDbTables();
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = respositoryResult;
return(Json(result));
}
/// <summary>
/// 获取当前所有的action
/// </summary>
/// <returns></returns>
public async Task <JsonResult> GetSystemUserActions()
{
var result = new ResultJsonInfo <SystemAction>();
var respositoryResult = await RoleRespository.GetSystemUserActions(UserToken.Eid, UserToken.RoleTid, base.CurrentMenuTid);
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = respositoryResult;
return(Json(result));
}
public async Task <JsonResult> GetAllRoleList()
{
var result = new ResultJsonInfo <List <SystemRole> >();
var respositoryResult = await RoleRespository.GetAllRoleList(UserToken);
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = respositoryResult;
return(Json(result));
}
public JsonResult GetDbTablesAndColumns()
{
var result = new ResultJsonInfo <string>();
var respositoryResult = CommonRespository.GetDbTablesAndColumns();
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = "var schema = " + respositoryResult;
return(Json(result));
}
public JsonResult GetDbs()
{
var result = new ResultJsonInfo <List <string> >();
List <string> respositoryResult = CommonRespository.GetDbs();
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = respositoryResult;
return(Json(result));
}
public JsonResult GetSubMenu([FromForm] long menuTid)
{
var result = new ResultJsonInfo <List <SystemMenuSM> >();
var respositoryResult = MenuRespository.GetSubMenus(menuTid);
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = respositoryResult;
return(Json(result));
}
public ActionResult AddReply(Reply reply)
{
var list = replyservice.GetList("keys='" + reply.keys + "'");
ResultJsonInfo resultInfo = new ResultJsonInfo();
if (reply.id == 0)
{
if (list.Count > 0)
{
resultInfo.Result = false;
resultInfo.Msg = "关键词已存在";
}
else
{
reply.createtime = DateTime.Now;
int num = replyservice.Insert(reply);
if (num > 0)
{
resultInfo.Result = true;
resultInfo.Msg = "添加成功";
}
else
{
resultInfo.Result = false;
resultInfo.Msg = "添加失败";
}
}
}
else
{
if (list.Count > 1)
{
resultInfo.Result = false;
resultInfo.Msg = "关键词已存在";
}
else
{
reply.createtime = DateTime.Now;
int num = replyservice.Update(reply);
if (num > 0)
{
resultInfo.Result = true;
resultInfo.Msg = "修改成功";
}
else
{
resultInfo.Result = false;
resultInfo.Msg = "修改失败";
}
}
}
return(Json(resultInfo));
}
/// <summary>
/// 权限与接口关联配置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <JsonResult> GetRoleActions(RoleAction model)
{
var result = new ResultJsonInfo <List <APIDescription> >();
var respositoryResult = await RoleRespository.GetRoleActions(model);
var allDescriptions = APIAttibuteHelper.GetAllDescriptions(null, respositoryResult);
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = allDescriptions;
return(Json(result));
}
public async Task <JsonResult> GetLocalRemoteServices()
{
var result = new ResultJsonInfo <List <Service> >();
//RemoteServices
ServiceRepository rep = new ServiceRepository();
var respositoryResult = await rep.GetLocalRemoteServices();
result.Data = respositoryResult;
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ResultJsonInfo <List <Person> > GetPersonList()
{
var result = new ResultJsonInfo <List <Person> >();
result.Data = new List <Person> {
new Person {
Name = "yuzd", Age = 25
}
};
result.Status = ResultConfig.Success;
result.Info = "ok";
return(result);
}
public ActionResult Edit(MerchantDto Merchantdto)
{
ResultJsonInfo resultJsonInfo = new ResultJsonInfo()
{
Data = "", ErrorMsg = "", Success = true
};
if (Merchantdto != null)
{
Merchantdto.UpdateUser = ServiceHelper.GetCurrentUser().UserName;
Merchantdto.UpdateTime = DateTime.Now;
}
return(Json(new { resultJsonInfo }, JsonRequestBehavior.AllowGet));
}
public ActionResult Add(MerchantDto Merchantdto)
{
ResultJsonInfo resultJsonInfo = new ResultJsonInfo()
{
Data = "", ErrorMsg = "", Success = true
};
if (Merchantdto != null)
{
Merchantdto.CreateUser = ServiceHelper.GetCurrentUser().UserName;
Merchantdto.CredateTime = DateTime.Now;
}
return(this.Ajax_JGClose());
}
public ActionResult DelReply(string ids)
{
ResultJsonInfo resultInfo = new ResultJsonInfo();
int num = replyservice.DeleteList(ids);
if (num > 0)
{
resultInfo.Result = true;
resultInfo.Msg = "删除成功";
}
else
{
resultInfo.Result = false;
resultInfo.Msg = "删除失败";
}
return(Json(resultInfo));
}
public ActionResult EditImageText(Reply reply)
{
reply.createtime = DateTime.Now;
int num = replyservice.Update(reply);
ResultJsonInfo resultInfo = new ResultJsonInfo();
if (num > 0)
{
resultInfo.Result = true;
resultInfo.Msg = "修改成功";
}
else
{
resultInfo.Result = false;
resultInfo.Msg = "修改失败";
}
return(Json(resultInfo));
}
public JsonResult SQLTable(string sql)
{
var result = new ResultJsonInfo <DbTablesAndColumnsSM>();
result.Data = new DbTablesAndColumnsSM();
sql = sql.DecodeBase64();
var table = CommonRespository.SelectSqlExcute(sql);
result.Data.columns = table.Columns
.Cast <DataColumn>()
.Select(x => new DynamicColumn(x.ColumnName))
.ToList();
result.Data.data = table.Rows.Cast <DataRow>()
.Select(r => r.ItemArray).ToList();
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
return(Json(result));
}
public JsonResult ExportExcel(string ids)
{
ResultJsonInfo resultJsonInfo = new ResultJsonInfo()
{
Data = "", ErrorMsg = "", Success = true
};
List <GoodsExport> goodsExportModels = new List <GoodsExport>();
List <GoodsDto> list = Service.GetAllGoods();
//if (!string.IsNullOrEmpty(ids))
//{
// list = Service.Find(ids);
//}
//else
//{
//}
foreach (var item in list)
{
goodsExportModels.Add(new GoodsExport()
{
商品名称 = item.GoodsName,
原价 = item.Price,
会员价 = item.VipPrice,
是否上架 = item.IfShelves == 1 ? "是" : "否",
是否促销 = item.IfPromotion == 1 ? "是" : "否",
创建时间 = item.CredateTime.ToString()
});
}
if (list == null || list.Count == 0)
{
resultJsonInfo.Success = false;
resultJsonInfo.ErrorMsg = "暂未数据";
}
else
{
string fileName = "商品导出.xls";
ExportExcelHelper <GoodsExport> .ExportListToExcel_MvcResult(goodsExportModels, ref fileName);
var path = "/Export/Temp/" + fileName;
resultJsonInfo.Data = path;
}
return(Json(resultJsonInfo));
}
public ActionResult Edit(CompanyDto companydto)
{
ResultJsonInfo resultJsonInfo = new ResultJsonInfo()
{
Data = "", ErrorMsg = "", Success = true
};
if (companydto != null)
{
companydto.UpdateUser = ServiceHelper.GetCurrentUser().UserName;
companydto.UpdateTime = DateTime.Now;
if (!Service.Update(companydto))
{
resultJsonInfo.Success = false;
resultJsonInfo.ErrorMsg = "更新失敗";
}
}
return(Json(new { resultJsonInfo }, JsonRequestBehavior.AllowGet));
}
public JsonResult Edit(GoodsDto goods)
{
ResultJsonInfo resultJsonInfo = new ResultJsonInfo()
{
Data = "", ErrorMsg = "", Success = true
};
if (goods != null)
{
goods.UpdateUser = ServiceHelper.GetCurrentUser().UserName;
goods.UpdateTime = DateTime.Now;
if (!Service.Update(goods))
{
resultJsonInfo.Success = false;
resultJsonInfo.ErrorMsg = "更新失敗";
}
}
return(Json(new { resultJsonInfo }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditImageText(Material material)
{
material.createtime = DateTime.Now;
material.type = Types.ImageText;
int num = materialservice.Update(material);
ResultJsonInfo resultInfo = new ResultJsonInfo();
if (num > 0)
{
resultInfo.Result = true;
resultInfo.Msg = "修改成功";
}
else
{
resultInfo.Result = false;
resultInfo.Msg = "修改失败";
}
return(Json(resultInfo));
}
public ActionResult AddUrl(Material material)
{
material.type = Types.Url;
material.createtime = DateTime.Now;
int num = materialservice.Insert(material);
ResultJsonInfo resultInfo = new ResultJsonInfo();
if (num > 0)
{
resultInfo.Result = true;
resultInfo.Msg = "添加成功";
}
else
{
resultInfo.Result = false;
resultInfo.Msg = "添加失败";
}
return(Json(resultInfo));
}
public ActionResult DelUrl(int id)
{
var model = materialservice.GetModel(id);
int num = materialservice.Delete(id);
ResultJsonInfo resultInfo = new ResultJsonInfo();
if (num > 0)
{
System.IO.File.Delete(Server.MapPath(model.topimg));
resultInfo.Result = true;
resultInfo.Msg = "删除成功";
}
else
{
resultInfo.Result = false;
resultInfo.Msg = "删除失败";
}
return(Json(resultInfo));
}
public JsonResult Edit(StoreReportDto storereportdto)
{
ResultJsonInfo resultJsonInfo = new ResultJsonInfo()
{
Data = "", ErrorMsg = "", Success = true
};
if (storereportdto != null)
{
storereportdto.UpdateUser = ServiceHelper.GetCurrentUser().UserName;
storereportdto.UpdateTime = DateTime.Now;
if (!Service.Update(storereportdto))
{
resultJsonInfo.Success = false;
resultJsonInfo.ErrorMsg = "更新失敗";
}
}
return(Json(new { resultJsonInfo }, JsonRequestBehavior.AllowGet));
}
public JsonResult ExportExcel(string ids)
{
ResultJsonInfo resultJsonInfo = new ResultJsonInfo()
{
Data = "", ErrorMsg = "", Success = true
};
List <UserExport> userExportModels = new List <UserExport>();
List <UserDto> list = Service.GetAllUsers();
//if (!string.IsNullOrEmpty(ids))
//{
// list = Service.Find(ids);
//}
//else
//{
//}
foreach (var item in list)
{
userExportModels.Add(new UserExport()
{
用户名 = item.RealName,
账号 = item.LogingName,
邮箱 = item.Email
});
}
if (list == null || list.Count == 0)
{
resultJsonInfo.Success = false;
resultJsonInfo.ErrorMsg = "暂未数据";
}
else
{
string fileName = "用户导出.xls";
ExportExcelHelper <UserExport> .ExportListToExcel_MvcResult(userExportModels, ref fileName);
var path = "/Export/Temp/" + fileName;
resultJsonInfo.Data = path;
}
return(Json(resultJsonInfo));
}
public ActionResult Add(CompanyDto companydto)
{
ResultJsonInfo resultJsonInfo = new ResultJsonInfo()
{
Data = "", ErrorMsg = "", Success = true
};
if (companydto != null)
{
companydto.CreateUser = ServiceHelper.GetCurrentUser().UserName;
companydto.CredateTime = DateTime.Now;
if (!Service.Add(companydto))
{
resultJsonInfo.Success = false;
resultJsonInfo.ErrorMsg = "添加失敗";
return(Content("<script>alert('添加失敗');history.go(-1);</script>"));
}
}
//return Content("<script>alert('添加成功');</script>");
return(this.Ajax_JGClose());
}
public JsonResult SQLExcute(string sql)
{
var result = new ResultJsonInfo <int>();
sql = sql.DecodeBase64();
var respositoryResult = CommonRespository.SQLExcute(sql);
if (string.IsNullOrEmpty(respositoryResult.Item2))
{
result.Status = ResultConfig.Ok;
result.Info = ResultConfig.SuccessfulMessage;
result.Data = respositoryResult.Item1;
}
else
{
result.Status = ResultConfig.Ok;//故意要这样的
result.Info = respositoryResult.Item2;
result.Data = respositoryResult.Item1;
}
return(Json(result));
}
