public ActionResult LoadDataTransferInfo(int ID)
{
string strJson = "";
t_CM_DataTransfer DataTransfer = bll.t_CM_DataTransfer.Where(c => c.ID == ID).First();
if (DataTransfer != null)
{
strJson = JsonConvert.SerializeObject(DataTransfer);
}
return(Content(strJson));
}
public ActionResult getDataTransfer(string SysCode)
{
string strJson = "";
try
{
List <t_CM_DataTransfer> list = bll.t_CM_DataTransfer.Where(r => r.SysCode == SysCode).ToList();
if (list.Count > 0)
{
t_CM_DataTransfer Info = list.First();
strJson = JsonConvert.SerializeObject(Info);
}
}
catch (Exception ex)
{
string error = ex.ToString();
strJson = "error";
}
return(Content(strJson));
}
public ActionResult SaveDataTransferInfo(t_CM_DataTransfer info)
{
string result = "OK";
try
{
List <t_CM_DataTransfer> list = bll.t_CM_DataTransfer.Where(p => p.SysCode == info.SysCode && p.ID != info.ID).ToList();
if (list.Count > 0)
{
result = "此子站名称已存在，请重新录入！ ";
}
else
{
if (info.ID > 0)
{
t_CM_DataTransfer DataTransferInfo = bll.t_CM_DataTransfer.Where(r => r.ID == info.ID).First();
DataTransferInfo.SysCode = info.SysCode;
DataTransferInfo.SysName = info.SysName;
DataTransferInfo.address = info.address;
DataTransferInfo.SetupDate = info.SetupDate;
DataTransferInfo.CommStatus = info.CommStatus;
DataTransferInfo.UploadDate = info.UploadDate;
DataTransferInfo.SysVersion = info.SysVersion;
DataTransferInfo.SysUpdateDate = info.SysUpdateDate;
DataTransferInfo.pointLimit = info.pointLimit;
DataTransferInfo.timeLimit = info.timeLimit;
DataTransferInfo.CenterIP = info.CenterIP;
DataTransferInfo.CenterPort = info.CenterPort;
DataTransferInfo.UserName = info.UserName;
DataTransferInfo.Pwd = info.Pwd;
DataTransferInfo.DBType = info.DBType;
DataTransferInfo.DBName = info.DBName;
DataTransferInfo.ConnectString = info.ConnectString;
if (info.Remarks != null)
{
DataTransferInfo.Remarks = Server.HtmlEncode(info.Remarks).Replace("\n", "<br>");
}
else
{
DataTransferInfo.Remarks = info.Remarks;
}
bll.ObjectStateManager.ChangeObjectState(DataTransferInfo, EntityState.Modified);
bll.SaveChanges();
Common.InsertLog("子站管理", CurrentUser.UserName, "编辑子站管理信息[" + DataTransferInfo.SysCode + "]");
}
else
{
if (info.Remarks != null)
{
info.Remarks = info.Remarks.Replace("\n", "<br>");
}
else
{
info.Remarks = info.Remarks;
}
info.UseState = "0";
bll.t_CM_DataTransfer.AddObject(info);
bll.SaveChanges();
Common.InsertLog("子站管理", CurrentUser.UserName, "新增子站管理信息[" + info.SysCode + "]");
}
}
}
catch (Exception ex)
{
result = ex.ToString();
result = "出错了！";
}
return(Content(result));
}