public static int Update(ServerConfig config) { string sql = "Update MSCS_Server_Config Set Name = @Name, ClientRootPath=@ClientRootPath, ServerAddress=@ServerAddress, ServerRootPath=@ServerRootPath, SvnPath=@SvnPath Where Id = @Id"; return(SqlServerHelper.Execute(sql, config)); }
public static int Insert(UpdateHistory history) { string sql = "INSERT INTO MSCS_Update_History(ServerConfigId, ServerConfigName, FileCount) Values(@ServerConfigId, @ServerConfigName, @FileCount)"; return(SqlServerHelper.Execute(sql, history)); }
public static int Insert(ServerConfig config) { string sql = "INSERT INTO MSCS_Server_Config(Name, ClientRootPath, ServerAddress, ServerRootPath, GroupId, SvnPath) Values(@Name, @ClientRootPath, @ServerAddress, @ServerRootPath, @GroupId, @SvnPath)"; return(SqlServerHelper.Execute(sql, config)); }
public static int Delete(int id) { string sql = "Delete From MSCS_Weixin_Robot where Id = @Id"; return(SqlServerHelper.Execute(sql, new { Id = id })); }
public static int Insert(WeixinRobot robot) { string sql = "INSERT INTO MSCS_Weixin_Robot(Name, Url) Values(@Name, @Url)"; return(SqlServerHelper.Execute(sql, robot)); }
public static int Update(ServerGroup group) { string sql = "Update MSCS_Server_Group Set Name = @Name Where Id = @Id"; return(SqlServerHelper.Execute(sql, group)); }
public static int Insert(ServerGroup group) { string sql = "INSERT INTO MSCS_Server_Group(Name) Values(@Name)"; return(SqlServerHelper.Execute(sql, group)); }