/// <summary> /// 添加修改数据源信息保存界面 /// </summary> /// <param name="fr"></param> /// <returns></returns> public ActionResult InsertDataSourcesPost(FormCollection fr) { string IsUpdate = fr["IsUpdate"]; bll.SystemConfigManagerbll system = new bll.SystemConfigManagerbll(); if (IsUpdate == "true") { model.productsourceConfig pro = system.GetProductsourceConfig(int.Parse(fr["Id"])); pro.SourceCode = fr["SourceCode"] == "" ? pro.SourceCode : fr["SourceCode"]; pro.SourcesAddress = fr["SourcesAddress"] == "" ? pro.SourcesAddress : fr["SourcesAddress"]; pro.UserId = fr["UserId"] == "" ? pro.UserId : fr["UserId"]; pro.UserPwd = fr["UserPwd"] == "" ? pro.UserPwd : fr["UserPwd"]; pro.DataSources = fr["DataSources"] == "" ? pro.DataSources : fr["DataSources"]; pro.DataSourcesLevel = fr["DataSourcesLevel"] == "" ? pro.DataSourcesLevel : fr["DataSourcesLevel"]; pro.TimeStart = fr["TimeStart"] == "" ? pro.TimeStart : int.Parse(fr["TimeStart"]); bool bol = system.UpdateProducesourceConfig(pro, userInfo.User.Id); if (bol) { return(Content("true")); } else { return(Content("false")); } } else { model.productsourceConfig pro = new model.productsourceConfig(); pro.SourceCode = fr["SourceCode"]; pro.SourcesAddress = fr["SourcesAddress"]; pro.UserId = fr["UserId"]; pro.UserPwd = fr["UserPwd"]; pro.DataSources = fr["DataSources"]; pro.DataSourcesLevel = fr["DataSourcesLevel"]; pro.TimeStart = fr["TimeStart"] == "" ? 0 : int.Parse(fr["TimeStart"]); bool isExist; bool bol = system.InsertProductsourceConfig(pro, userInfo.User.Id, out isExist); if (bol) { return(Content("true")); } else if (isExist) { return(Content("Exist")); } else { return(Content("false")); } } }
/// <summary> /// 修改数据源信息 /// </summary> /// <param name="Id">数据源编号</param> /// <returns></returns> public ActionResult UpdateDataSources() { int Id = int.Parse(Request.QueryString[0]); int menuId = int.Parse(Request.QueryString[1]); Dictionary <string, string> dic = GetDataConfig(funName.updateName, menuId);//获取权限 ViewData["dic"] = dic; bll.SystemConfigManagerbll system = new bll.SystemConfigManagerbll(); model.productsourceConfig pro = system.GetProductsourceConfig(Id); ViewData["dic"] = dic; ViewData["Id"] = pro.Id; ViewData["IsUpdate"] = "true"; if (pro != null) { return(View("InsertDataSources", pro)); } else { return(Content("访问的信息已经不存在!")); } }
/// <summary> /// 显示所有数据源信息 /// </summary> /// <returns></returns> public ActionResult DataSourcesConfig() { string str = Request.QueryString["menuId"]; ViewData["menuId"] = str; pbxdata.bll.SystemConfigManagerbll systembll = new bll.SystemConfigManagerbll(); PublicHelpController pub = new PublicHelpController(); bool bol = pub.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), int.Parse(str), funName.selectName); #region 权限查看 if (!bol) { return(View("../NoPermisson/Index")); } if (pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), int.Parse(str), funName.addName)) { ViewData["Insert"] = "true"; } else { ViewData["Insert"] = "false"; } //if (pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), int.Parse(str), funName.updateName)) //{ // ViewData["Update"] = "true"; //} //else //{ // ViewData["Update"] = "false"; //} //if (pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), int.Parse(str), funName.deleteName)) //{ // ViewData["Delete"] = "true"; //} //else //{ // ViewData["Delete"] = "false"; //} //if (pub.isFunPermisson(helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId), int.Parse(str), funName.deleteName)) //{ // ViewData["Delete"] = "true"; //} //else //{ // ViewData["Delete"] = "false"; //} #endregion DataTable dt = systembll.GetProductsourceConfig(userInfo.User.UserId); string[] strt = pub.getFiledPermisson(int.Parse(userInfo.User.personaId.ToString()), int.Parse(str), funName.selectName); if (dt == null) { return(View("../ErrorMsg/Index")); } List <DataColumn> list = new List <DataColumn>(); foreach (DataColumn dc in dt.Columns) { if (strt.Contains(dc.ColumnName)) { if (dc.ColumnName == "Id") { dc.ColumnName = "编号"; } if (dc.ColumnName == "SourceCode") { dc.ColumnName = "数据源编号"; } if (dc.ColumnName == "SourcesAddress") { dc.ColumnName = "服务器地址"; } if (dc.ColumnName == "UserId") { dc.ColumnName = "登陆名"; } if (dc.ColumnName == "UserPwd") { dc.ColumnName = "密码"; } if (dc.ColumnName == "DataSources") { dc.ColumnName = "数据库名称"; } if (dc.ColumnName == "DataSourcesLevel") { dc.ColumnName = "数据源等级"; } if (dc.ColumnName == "TimeStart") { dc.ColumnName = "启动时间间隔(分)"; } if (dc.ColumnName == "Def2") { dc.ColumnName = "更新已启动(分)"; } if (dc.ColumnName == "Def1") { dc.ColumnName = "更新状态"; } if (dc.ColumnName == "Def3") { dc.ColumnName = "更新程序运行Ip"; } } else { if (dc.ColumnName == "Id") { dc.ColumnName = "编号"; } else if (dc.ColumnName == "sourceName" && strt.Contains("SourceCode")) { dc.ColumnName = "数据源名称"; } else { list.Add(dc); } //dt.Columns.Remove(dc); } } foreach (var v in list) { dt.Columns.Remove(v); } dt.Columns.Add(new DataColumn("操作")); bool IsUpdate = pub.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), int.Parse(str), funName.updateName); bool IsDelete = pub.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), int.Parse(str), funName.deleteName); bool IsLog = pub.isFunPermisson(int.Parse(userInfo.User.personaId.ToString()), int.Parse(str), funName.Log); foreach (DataRow dr in dt.Rows) { if (IsUpdate) { dr["操作"] += "修改"; } if (IsDelete) { dr["操作"] += "删除"; } if (IsLog) { dr["操作"] += "该数据源更新日志"; } } return(View(dt)); }