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