public static SelectResult <ServerManagerEditModel> GetServerByID(int id)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@ID", SqlDbType.Int),
};
paras[0].Value = id;
string sql = @"SELECT [ID],[ServerCode],[ServerName],[LinkedServerName],IP,WCFAddress
FROM [dbo].[ServerInfo] WHERE ID = @ID";
List <ServerManagerEditModel> list = ConvertToList <ServerManagerEditModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray()));
ServerManagerEditModel data = null;
string msg = string.Empty;
if (list == null)
{
msg = PromptInformation.DBError;
}
else if (list.Count == 0)
{
msg = PromptInformation.NotExists;
}
else
{
data = list[0];
}
return(new SelectResult <ServerManagerEditModel>()
{
DataResult = data,
Message = msg
});
}
public static OperationResult EditServer(ServerManagerEditModel model)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@ServerCode", SqlDbType.VarChar),
new SqlParameter("@ServerName", SqlDbType.NVarChar),
new SqlParameter("@LinkedServerName", SqlDbType.VarChar),
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@IP", SqlDbType.VarChar),
new SqlParameter("@WCFAddress", SqlDbType.VarChar),
new SqlParameter("@UpdateUserID", SqlDbType.Int)
};
paras[0].Value = model.ServerCode.Trim();
paras[1].Value = model.ServerName.Trim();
paras[2].Value = model.LinkedServerName.Trim();
paras[3].Value = model.ID;
paras[4].Value = model.IP.Trim();
paras[5].Value = model.WCFAddress.Trim();
paras[6].Value = model.UpdateUserID;
#region SQL
string sql = @"UPDATE dbo.ServerInfo
SET ServerCode = @ServerCode ,
ServerName = @ServerName ,IP = @IP,
LinkedServerName = @LinkedServerName,
WCFAddress = @WCFAddress,
UpdateUserID = @UpdateUserID,
UpdateDate = GETDATE()
WHERE ID = @ID";
#endregion
int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray());
string msg = string.Empty;
switch (result)
{
case 1:
msg = PromptInformation.OperationSuccess;
break;
case 0:
msg = PromptInformation.NotExists;
break;
case -1:
msg = PromptInformation.DBError;
break;
}
return(new OperationResult()
{
Success = result > 0,
Message = msg
});
}
public ActionResult AddServer(ServerManagerEditModel model)
{
if (ModelState.IsValid)
{
model.CreateUserID = base.CurrentUserID;
var result = ServerManagerBLL.AddServer(model);
base.DoLog(OperationTypeEnum.Add, result, "ServerName:" + model.ServerName);
return(Json(result));
}
else
{
return(PartialView("_AddServer", model));
}
}
public ActionResult EditServer(ServerManagerEditModel model)
{
if (ModelState.IsValid)
{
model.UpdateUserID = base.CurrentUserID;
var result = ServerManagerBLL.EditServer(model);
base.DoLog(OperationTypeEnum.Edit, result, "ID:" + model.ID);
return(Json(result));
}
else
{
return(PartialView("_EditServer", model));
}
}
public static OperationResult AddServer(ServerManagerEditModel model)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@ServerCode", SqlDbType.VarChar),
new SqlParameter("@ServerName", SqlDbType.NVarChar),
new SqlParameter("@LinkedServerName", SqlDbType.VarChar),
new SqlParameter("@IP", SqlDbType.VarChar),
new SqlParameter("@WCFAddress", SqlDbType.VarChar),
new SqlParameter("@CreateUserID", SqlDbType.Int)
};
paras[0].Value = model.ServerCode.Trim();
paras[1].Value = model.ServerName.Trim();
paras[2].Value = model.LinkedServerName.Trim();
paras[3].Value = model.IP.Trim();
paras[4].Value = model.WCFAddress.Trim();
paras[5].Value = model.CreateUserID;
#region SQL
string sql = @"INSERT INTO dbo.ServerInfo
( ServerCode ,
ServerName ,
LinkedServerName,IP,WCFAddress,CreateUserID
)VALUES ( @ServerCode ,
@ServerName,
@LinkedServerName ,@IP,@WCFAddress,@CreateUserID
)";
#endregion
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
public PartialViewResult AddServer()
{
ServerManagerEditModel model = new ServerManagerEditModel();
return(PartialView("_AddServer", model));
}
