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