/// <summary>
/// 修改数据源信息
/// </summary>
/// <param name="pro"></param>
/// <param name="exx"></param>
/// <returns></returns>
public bool UpdateProductsourceConfig(model.productsourceConfig pro, out Exception exx)
{
try
{
OpenCon();
var temp = from c in pbx.productsourceConfig where c.Id == pro.Id select c;
foreach (var v in temp)
{
v.SourceCode = pro.SourceCode;
v.SourcesAddress = pro.SourcesAddress;
v.UserId = pro.UserId;
v.UserPwd = pro.UserPwd;
v.DataSources = pro.DataSources;
v.DataSourcesLevel = pro.DataSourcesLevel;
}
pbx.SubmitChanges();
exx = null;
return(true);
}
catch (Exception ex)
{
exx = ex;
return(false);
}
finally
{
CloseCon();
}
}
/// <summary>
/// 添加数据源信息
/// </summary>
/// <param name="pro"></param>
/// <param name="exx"></param>
/// <returns></returns>
public bool InsertProductsourceConfig(model.productsourceConfig pro, out Exception exx)
{
try
{
OpenCon();
var temp = (from c in pbx.productsourceConfig where c.SourceCode == pro.SourceCode select c).ToList();
if (temp.Count > 0)
{
exx = null;
return(false);
}
pbx.productsourceConfig.InsertOnSubmit(pro);
pbx.SubmitChanges();
exx = null;
return(true);
}
catch (Exception ex)
{
exx = ex;
return(false);
}
finally
{
CloseCon();
}
}
/// <summary>
/// 添加数据源信息
/// </summary>
/// <param name="pro"></param>
/// <param name="UserId"></param>
/// <returns></returns>
public bool InsertProductsourceConfig(model.productsourceConfig pro, int?UserId, out bool isExist)
{
Exception ex;
bool bol = dal.InsertProductsourceConfig(pro, out ex);
if (ex != null)
{
model.errorlog err = new model.errorlog();
err.operation = 1;
err.errorTime = DateTime.Now;
err.errorSrc = "pbxdata.bll.SystemConfigManagerbll->InsertProductsourceConfig()--->pbxdata.dal.SystemConfigManagerdll->InsertProductsourceConfig()";
err.ErrorMsg = ex.Source;
err.errorMsgDetails = ex.Message;
err.UserId = UserId;
error.InsertErrorlog(err);
isExist = false;
}
else if (bol)
{
model.errorlog err = new model.errorlog();
err.operation = 2;
err.errorTime = DateTime.Now;
err.errorSrc = "pbxdata.bll.SystemConfigManagerbll->InsertProductsourceConfig()--->pbxdata.dal.SystemConfigManagerdll->InsertProductsourceConfig()";
err.ErrorMsg = "添加";
err.errorMsgDetails = "添加一条数据源信息";
err.UserId = UserId;
error.InsertErrorlog(err);
isExist = false;
}
else
{
isExist = true;
}
return(bol);
}
/// <summary>
/// 查询指定数据源信息
/// </summary>
/// <param name="Id"></param>
/// <param name="exx"></param>
/// <returns></returns>
public model.productsourceConfig GetProductsourceConfig(int Id)
{
Exception ex;
model.productsourceConfig pro = dal.GetProductsourceConfig(Id, out ex);
return(pro);
}
/// <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("访问的信息已经不存在！"));
}
}
